Storage_Location
Description:
Name Null? Type
------------------------------- -------- ----
STORAGE_LOCATION_ID NOT NULL NUMBER
STORAGE_ROOM NUMBER
STORAGE_BUILDING VARCHAR2(25)
STORAGE_INST VARCHAR2(4)
- Primary Key:
- Storage_Location_ID
This table is meant to indicate where a collecting_unit is physically located.
It could have more fields to specify the location down to the individual unit
tray (insect collection jargon), or perhaps even implement a recursive
relationship between Storage_Location_ID and Containing_Storage_Location_ID
(I think I like that idea). Storage_Inst is the 4-letter coden of
Arnett & Samuelson that uniquely identifies insect collections.
Storage_Location_ID is a foreign key in Storage_Regime.
Last updated: 20 November, 1997 by nfj.