Schema Q2DBA

Table PROGRAMME

Column Summary
Name SqlType Length Precision Scale Nullable Unique
PROG_CD VARCHAR2(40) 255 19 2 false false
PROG_NM VARCHAR2(100) 255 19 2 false false
PROG_DC VARCHAR2(255) 255 19 2 true false
PROG_CREATION_DT DATE 255 19 2 true false
UPDATE_DT TIMESTAMP 255 19 2 false false
IS_DEPARTMENT_HERMETIC VARCHAR2(1) 255 19 2 true false
STATUS_CD VARCHAR2(40) 255 19 2 false false
Primary Key
Name Columns
PROGRAMMEPK PROG_CD
Foreign Keys
Name Referenced Table Columns
PROGRAMME_STATUS_CDC STATUS STATUS_CD

Column Detail

PROG_CD


PROG_NM


PROG_DC


PROG_CREATION_DT


UPDATE_DT


IS_DEPARTMENT_HERMETIC


STATUS_CD