Unvouchered_Record_Association
Description:
Name Null? Type
------------------------------- -------- ----
UNVREC_ID NOT NULL NUMBER
ASSOCIATED_UNVREC_ID NOT NULL NUMBER
ASSOCIATION_TYPE_ID NUMBER
- Primary Key:
- Unvrec_ID
- Associated_Unvrec_ID
- Foreign Keys:
- Association_Type_ID references
ASSOCIATION_TYPE(Association_Type_ID)
- Unvrec_ID references
UNVOUCHERED_RECORD(Unvouchered_Record_ID)
- Associated_Unvrec_ID references
UNVOUCHERED_RECORD(Unvouchered_Record_ID)
Documentation of the observed biological association between two
unvouchered records. This table was created primarily to deal with
literature records of, e.g., host-parasite relationships.
The primary key
makes the implicit assumption that there is only one possible relationship
between the two entities. This may prove to be untenable. If so, the easiest
work-around may be to create a surrogate key, Unvrec_Assoc_ID, or possible a
tripartite key.
Last updated: 20 November, 1997 by nfj.