Collecting_Event

Description:

 Name                            Null?    Type
 ------------------------------- -------- ----
 COLLECTING_EVENT_ID             NOT NULL NUMBER
 LOCALITY_ID                              NUMBER
 STATED_TIME_TEXT                         VARCHAR2(100)
 STATED_LOCALITY_TEXT                     VARCHAR2(100)
 COLLECTING_EVENT_COMMENTS_TEXT           VARCHAR2(100)
 TIME_EXPRESSION_ID                       NUMBER
 COLLECTING_METHOD_ID                     NUMBER
 COLLECTOR1_ID                            NUMBER
 COLLECTOR2_ID                            NUMBER
 COLLECTOR3_ID                            NUMBER

Primary Key:

Collecting_Event_ID

Foreign Keys:

Locality_ID references LOCALITY(Locality_ID)

Time_Expression_ID references TIME_EXPRESSION(Time_Expression_ID)

Collecting_Method_ID references COLLECTING_METHOD(Collecting_Method_ID)

Collector1_ID references AGENT(Agent_ID)

Collector2_ID references AGENT(Agent_ID)

Collector3_ID references AGENT(Agent_ID)

The Collecting Event is a unique combination of time, place, method, and collectors. The Virgin Island Beetle Fauna database goes a couple of steps further, defining it as a unique combination of time, place, method, microhabitat, and collector. Each collecting unit (specimen, etc.) is collected from one and only one collecting event. There is a field for Collecting_Event_ID in the Collecting_Unit table allowing you to associate the two tables.

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