Database Structure: Collecting_Unit

Collecting_Unit_Association

Description:

 Name                            Null?    Type
 ------------------------------- -------- ----
 COLLECTING_UNIT_ID              NOT NULL VARCHAR2(15)
 ASSOCIATED_COLLECTING_UNIT_ID   NOT NULL VARCHAR2(15)
 ASSOCIATION_TYPE_ID                      NUMBER
 COMMENTS                                 VARCHAR2(100)

Primary Key:: Collecting_Unit_ID; Associated_Collecting_Unit_ID
Foreign Keys:: Association_Type_ID references ASSOCIATION_TYPE(Association_Type_ID); Collecting_Unit_ID references COLLECTING_UNIT(Collecting_Unit_ID); Associated_Collecting_Unit_ID references COLLECTING_UNIT(Collecting_Unit_ID)

Documentation of the observed biological association between two different collecting units. Only tangible specimens, lots, etc. are documented here, e.g., the predator specimen and the prey specimen are both stored in a collection (somewhere). The primary key makes the implicit assumption that there is only one possible relationship between the two entities.

Last updated: 20 November, 1997 by nfj.

Return to the Collecting_Unit Cluster page.
Return to the first list of database table clusters.
Return to the OSU Insect Collection home page.