Person
Description:
Name Null? Type
------------------------------- -------- ----
PERSON_ID NOT NULL NUMBER
LAST_NAME VARCHAR2(30)
FIRST_NAME VARCHAR2(30)
INITIALS VARCHAR2(10)
GENERATION VARCHAR2(10)
NAME_ORDER VARCHAR2(1)
- Primary Key:
- Person_ID
- Foreign Key:
- Person_ID references AGENT(Agent_ID)
Here is where you can store all the personal information you'd like about
an individual person. Obviously, we are recording only a minimum at this point.
Person_ID is the same number as Agent_ID in the Agent
table. The initials field is used to facilitate constructing typical bibliographic
references. Generation contains text that is appended to a name such as Jr., III, Filho, etc.
The Name_Order field is used to distinguish between cases in which the given names are followed
by the surname (W for Western style) as opposed to a surname followed by given names (C for
Chinese style).
Last updated: 20 November, 1997 by nfj.