Article
Description:
Name Null? Type
------------------------------- -------- ----
ARTICLE_ID NOT NULL NUMBER
JOURNAL_ID NUMBER
SERIES VARCHAR2(5)
VOLUME VARCHAR2(10)
VOLUME_NUMBER VARCHAR2(5)
START_PAGE VARCHAR2(10)
END_PAGE VARCHAR2(10)
TITLE VARCHAR2(250)
- Primary Key:
- Article_ID
- Foreign Key:
- Article_ID references
PUBLICATION(Publication_ID)
- Journal_ID references
JOURNAL(Journal_ID)
Here are the title and bibliographic information for articles published
in periodicals. This table structure does not
accomodate those articles that are published in a number of
non-contiguous series of pages. Although usually numerical,
series, volume, numbers, and pages are sometimes letters, hence the
VARCHAR2 data types. Authors are stored in the
Ref_Work
table, publication dates in the
Publication table.
Last updated: 20 November, 1997 by nfj.