Schema PUBLIC

Table DELETED_ITEM_HISTORY

Column Summary
Name SqlType Length Precision Scale Nullable Unique
DEL_ITEM_HIST_ID integer 255 19 2 false false
OBJECT_ID BIGINT 255 19 2 true false
OBJECT_CD VARCHAR(40) 255 19 2 true false
DEL_ITEM_HIST_CM VARCHAR(2000) 255 19 2 true false
UPDATE_DT TIMESTAMP 255 19 2 true false
REMOTE_ID integer 255 19 2 true false
OBJECT_TYPE_CD VARCHAR(40) 255 19 2 false false
REC_DEP_ID integer 255 19 2 true false
REC_QUSER_ID integer 255 19 2 true false
Primary Key
Name Columns
DELETED_ITEM_PK DEL_ITEM_HIST_ID
Foreign Keys
Name Referenced Table Columns
DELETED_ITEM_HISTORY_OBJECT_TC OBJECT_TYPE OBJECT_TYPE_CD
DELETED_ITEM_HISTORY_REC_DEP_C DEPARTMENT REC_DEP_ID
DELETED_ITEM_HISTORY_REC_QUSEC QUSER REC_QUSER_ID

Column Detail

DEL_ITEM_HIST_ID

OBJECT_ID

OBJECT_CD

DEL_ITEM_HIST_CM

UPDATE_DT

REMOTE_ID

OBJECT_TYPE_CD

REC_DEP_ID

REC_QUSER_ID