event
The event table contains a list of events. Multiple origins may be defined for anyone event in the
origin table. The column prefor points to the preferred origin.
|
FIELD |
COLUMN |
STORAGE |
EXTERNAL |
CHARACTER |
DESCRIPTION |
|
NUMBER |
TYPE |
FORMAT |
POSITION |
||
|
1 |
evid |
number(9) |
i9 |
1-9 |
event identifier |
|
2 |
evname |
varchar2(32) |
a32 |
11-42 |
event name |
|
3 |
prefor |
number(9) |
i9 |
44-51 |
preferred origin |
|
4 |
auth |
varchar2( 15) |
a15 |
53-67 |
source/originator |
|
5 |
commid |
number(9) |
i9 |
69-77 |
comment identifier |
|
6 |
Iddate |
date |
a19 |
79-97 |
load date |
|
Keys: |
Primary |
evid |
|
|
Foreign |
prefor, commid |
|
Data: |
Descriptive |
evname, prefor |
|
|
Administrative |
auth, lddate |