Schema PUBLIC
Table PROGRAMME
Primary Key
|
Name
|
Columns
|
PROGRAMMEPK
|
PROG_CD
|
Foreign Keys
|
Name
|
Referenced Table
|
Columns
|
PROGRAMME_STATUS_CDC
|
STATUS
|
STATUS_CD
|
Column Detail
PROG_CD
-
Type: VARCHAR(40)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
PROG_NM
-
Type: VARCHAR(100)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
PROG_DC
-
Type: VARCHAR(255)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
PROG_CREATION_DT
-
Type: TIMESTAMP
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
UPDATE_DT
-
Type: TIMESTAMP
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
IS_DEPARTMENT_HERMETIC
-
Type: VARCHAR(1)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
STATUS_CD
-
Type: VARCHAR(40)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment: