Unvouchered_Record
Description:
Name Null? Type
------------------------------- -------- ----
UNVOUCHERED_RECORD_ID NOT NULL NUMBER
LOCALITY_ID NUMBER
TIME_EXPRESSION_ID NUMBER
HABITAT_DESCRIPTION_ID NUMBER
TAXON_NAME_ID NUMBER
COLLECTING_METHOD_ID NUMBER
DETERMINER_ID NUMBER
COMMENTS VARCHAR2(70)
COLLR1_ID NUMBER
COLLR2_ID NUMBER
COLLR3_ID NUMBER
- Primary Key:
- Collecting_Unit_ID
- Foreign Keys:
- Locality_ID references
LOCALITY(Locality_ID)
- Time_Expression_ID references
TIME_EXPRESSION(Time_Expression_ID)
- Habitat_Description_ID references
HABITAT_DESCRIPTION(Habitat_Description_ID)
- Taxon_Name_ID references
TAXON_NAME(Taxon_Name_ID)
- Collecting_Method_ID references
COLLECTING_METHOD(Collecting_Method_ID)
- Determiner_ID references
AGENT(Agent_ID)
- Collr1_ID references
AGENT(Agent_ID)
- Collr2_ID references
AGENT(Agent_ID)
- Collr3_ID references
AGENT(Agent_ID)
Our databasing efforts began with collections of insect specimens. These are
tangible units for which we wanted to organize associated information. It eventually
became necessary to find a way to handle entities that had no physical
existence, for example, an observation. For lack of a better term we are
referring to these as unvouchered_records. These records have many of the same
attributes and relationships as collecting_units. Documentation for these
records is found in the table Unvouchered_Record_Citation
which leads to either
published data (through PUBLICATION) or
unpublished data (such as LABEL).
Last updated: 20 November, 1997 by nfj.