Schema PUBLIC

Table AUTHOR

Column Summary
Name SqlType Length Precision Scale Nullable Unique
AUTHOR_ID integer 255 19 2 false false
AUTHOR_NM VARCHAR(100) 255 19 2 true false
AUTHOR_LOCAL VARCHAR(256) 255 19 2 true false
AUTHOR_CM VARCHAR(2000) 255 19 2 true false
AUTHOR_CREATION_DT TIMESTAMP 255 19 2 true false
UPDATE_DT TIMESTAMP 255 19 2 true false
STATUS_CD VARCHAR(40) 255 19 2 false false
Primary Key
Name Columns
AUTHORPK AUTHOR_ID
Foreign Keys
Name Referenced Table Columns
AUTHOR_STATUS_CDC STATUS STATUS_CD

Column Detail

AUTHOR_ID


AUTHOR_NM


AUTHOR_LOCAL


AUTHOR_CM


AUTHOR_CREATION_DT


UPDATE_DT


STATUS_CD