Ref_Work
Description:
Name Null? Type
------------------------------- -------- ----
REF_WORK_ID NOT NULL NUMBER
REF_WORK_TYPE VARCHAR2(2)
AUTHOR1_ID NUMBER
AUTHOR2_ID NUMBER
AUTHOR3_ID NUMBER
- Primary Key:
- Ref_Work_ID
- Foreign Key:
- Author1_ID references AGENT(Agent_ID)
- Author2_ID references AGENT(Agent_ID)
- Author3_ID references AGENT(Agent_ID)
Our handling of the literature data differs rather markedly from the
initial version proposed in the ASC model. Instead of the single table
named Reference_Work, we are using nine tables (and this may well increase).
Ref_Work basically
assigns a unique number to each reference work and divides them into
two categories: publications (PB) and non-published works (LB).
The only type of unpublished work we are documenting now are labels;
as more are added it will be necessary to create a table analogous
with Publication. Both published and
unpublished reference works may have authors,
hence these fields show up in this initial
table. We have opted to limit the number of authors for any work to
three; if there are more we use "et al." as an author. Because either
people or organizations can "author" a work, the AuthorX_ID references
Agent_ID in the Agent table.
Last updated: 20 November, 1997 by nfj.