Publication
Description:
Name Null? Type
------------------------------- -------- ----
PUBLICATION_ID NOT NULL NUMBER
PUBLICATION_TYPE VARCHAR2(10)
PUBLICATION_DATE DATE
DATE_QUALIFIER VARCHAR2(3)
- Primary Key:
- Publication_ID
- Foreign Key:
- Publication_ID references
REF_WORK(Ref_Work_ID)
The Publication_ID is the same number as the
Ref_Work_ID.
Publications can conceivably include journal articles, entire books,
individual chapters within books, CD's, etc. At the moment were are
only concerned with the traditional types of paper publications.
Publication_Type can be an article,
book, bhapter,
bulletin, or a
contribution to a publication.
Further data
concerning the publication are stored in tables by those same names.
All publications have a date of publication. The field Date_Qualifier
offers the (redundant) ability to add one or more letters to the date (e.g., Ashmead
1887c) so that the combination of author(s), date, and date qualifier
are unique.
Last updated: 20 November, 1997 by nfj.