Collecting_Unit
Description:
Name Null? Type
------------------------------- -------- ----
COLLECTING_UNIT_ID NOT NULL VARCHAR2(15)
COLLECTING_EVENT_ID NUMBER
COLLECTING_UNIT_TYPE_CODE VARCHAR2(18)
NUMBER_OF_ITEMS_COUNT NUMBER
COMMENTS VARCHAR2(70)
- Primary Key:
- Collecting_Unit_ID
- Foreign Key:
- Collecting_Event_ID references
COLLECTING_EVENT(Collecting_Event_ID)
The Collecting_Unit_ID is a combination of a four letter acronym for
the collection, a space, and a number (e.g., "OSUC 17645"). In our applications these two elements are
entered separately and, therefore, leading zeros on the number are eliminated.
Sorting on Collecting_Unit_ID alone gives results in
alphabetical order. This identifier provides entry into the
Determination and
Storage_Regime tables (the latter through
the Uses_Storage_Regime table).
Acronyms follow as closely as possible those published in Arnett &
Samuelson.
The Collecting_Unit_Type_Code must be one of the following:
These lead to further data in tables of the same name. We do not begin entering
data until our material has been identified at least to family.
Last updated: 20 November, 1997 by nfj.