Schema PUBLIC

Table EVENT

Column Summary
Name SqlType Length Precision Scale Nullable Unique
EVENT_ID integer 255 19 2 false false
EVENT_DC VARCHAR(255) 255 19 2 false false
EVENT_CM VARCHAR(2000) 255 19 2 true false
EVENT_START_DT TIMESTAMP 255 19 2 false false
EVENT_END_DT TIMESTAMP 255 19 2 true false
EVENT_POSITION_CM VARCHAR(2000) 255 19 2 true false
EVENT_CREATION_DT TIMESTAMP 255 19 2 true false
UPDATE_DT TIMESTAMP 255 19 2 true false
REMOTE_ID integer 255 19 2 true false
EVENT_TYPE_ID integer 255 19 2 false false
POS_SYSTEM_ID integer 255 19 2 true false
REC_DEP_ID integer 255 19 2 false false
Primary Key
Name Columns
EVENTPK EVENT_ID
Foreign Keys
Name Referenced Table Columns
EVENT_EVENT_TYPE_IDC EVENT_TYPE EVENT_TYPE_ID
EVENT_POS_SYSTEM_IDC POSITIONNING_SYSTEM POS_SYSTEM_ID
EVENT_REC_DEP_IDC DEPARTMENT REC_DEP_ID

Column Detail

EVENT_ID

EVENT_DC

EVENT_CM

EVENT_START_DT

EVENT_END_DT

EVENT_POSITION_CM

EVENT_CREATION_DT

UPDATE_DT

REMOTE_ID

EVENT_TYPE_ID

POS_SYSTEM_ID

REC_DEP_ID