Schema Q2DBA
Table RULE
Primary Key
|
Name
|
Columns
|
RULEPK
|
RULE_CD
|
Column Detail
RULE_CD
-
Type: VARCHAR2(40)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
RULE_CONTROLED_ATTRIBUT
-
Type: VARCHAR2(100)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
RULE_DC
-
Type: VARCHAR2(255)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
RULE_IS_ACTIVE
-
Type: VARCHAR2(1)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
RULE_IS_BLOCKING
-
Type: VARCHAR2(1)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
RULE_ERROR_MSG
-
Type: VARCHAR2(255)
-
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:
RULE_LIST_CD
-
Type: VARCHAR2(40)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
FUNCTION_ID
-
Type: NUMBER(18)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment: