d_collector 
EntityType  Independent 
Logical Entity Name  d_collector 
Default Table Name  d_collector 
Logical Only  NO 
Definition 
Data collector information
 
Note 
 

d_collector Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
collector_id(PK)  collector_id  INTEGER  NO 
Unique ID for code table, d_collector
 
collector_nm  collector_nm  CHAR(20)  NO 
Geologist's name responsible for collection and submitting the data. A four character alphabetic code precedes the contact. e.g., COGS-STEWART JE
 
collecting_org_id(FK)  collecting_org_id  INTEGER  NO 
Unique ID for code table, d_collecting_org
 

d_collector Keys 
Key Name  Key Type  Keys 
None  PrimaryKey  collector_id 

d_collector Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
d_collecting_org  Non-Identifying  One To Zero or More        collecting_org_id  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
point  Non-Identifying  One To Zero or More          NO 

d_collector Security Types 
Name  Current Value 

d_collector Attachments 
Name  Current Value