Schema Q2DBA
Table MORATORIUM
|
Column Summary
|
|
Name
|
SqlType
|
Length
|
Precision
|
Scale
|
Nullable
|
Unique
|
|
MOR_ID
|
NUMBER(18)
|
255
|
19
|
2
|
false
|
false
|
|
MOR_DC
|
VARCHAR2(255)
|
255
|
19
|
2
|
false
|
false
|
|
MOR_IS_GLOBAL
|
VARCHAR2(1)
|
255
|
19
|
2
|
true
|
false
|
|
MOR_CREATION_DT
|
DATE
|
255
|
19
|
2
|
true
|
false
|
|
UPDATE_DT
|
TIMESTAMP
|
255
|
19
|
2
|
false
|
false
|
|
PROG_CD
|
VARCHAR2(40)
|
255
|
19
|
2
|
false
|
false
|
|
Primary Key
|
|
Name
|
Columns
|
|
MORATORIUMPK
|
MOR_ID
|
|
Foreign Keys
|
|
Name
|
Referenced Table
|
Columns
|
|
MORATORIUM_PROG_CDC
|
PROGRAMME
|
PROG_CD
|
Column Detail
MOR_ID
-
Type: NUMBER(18)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
MOR_DC
-
Type: VARCHAR2(255)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
MOR_IS_GLOBAL
-
Type: VARCHAR2(1)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
MOR_CREATION_DT
-
Type: DATE
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
UPDATE_DT
-
Type: TIMESTAMP
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
PROG_CD
-
Type: VARCHAR2(40)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
