Schema PUBLIC

Table UPDATED_ITEM_HISTORY

Column Summary
Name SqlType Length Precision Scale Nullable Unique
UPD_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
UPD_ITEM_HIST_CM VARCHAR(2000) 255 19 2 true false
UPDATE_DT TIMESTAMP 255 19 2 true false
COLUMN_NAME VARCHAR(40) 255 19 2 false false
OLD_VALUE VARCHAR(2000) 255 19 2 true false
NEW_VALUE VARCHAR(2000) 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
UPDATED_ITEM_PK UPD_ITEM_HIST_ID
Foreign Keys
Name Referenced Table Columns
UPDATED_ITEM_HISTORY_OBJECT_TC OBJECT_TYPE OBJECT_TYPE_CD
UPDATED_ITEM_HISTORY_REC_DEP_C DEPARTMENT REC_DEP_ID
UPDATED_ITEM_HISTORY_REC_QUSEC QUSER REC_QUSER_ID

Column Detail

UPD_ITEM_HIST_ID

OBJECT_ID

OBJECT_CD

UPD_ITEM_HIST_CM

UPDATE_DT

COLUMN_NAME

OLD_VALUE

NEW_VALUE

REMOTE_ID

OBJECT_TYPE_CD

REC_DEP_ID

REC_QUSER_ID