Schema SIH2_ADAGIO_DBA
Table METHOD
|
Column Summary
|
|
Name
|
SqlType
|
Length
|
Precision
|
Scale
|
Nullable
|
Unique
|
|
ID
|
NUMBER(10)
|
255
|
19
|
2
|
false
|
false
|
|
NAME
|
VARCHAR2(100)
|
255
|
19
|
2
|
false
|
false
|
|
DESCRIPTION
|
VARCHAR2(255)
|
255
|
19
|
2
|
true
|
false
|
|
CONDITIONING
|
VARCHAR2(2000)
|
255
|
19
|
2
|
true
|
false
|
|
PREPARATION
|
VARCHAR2(2000)
|
255
|
19
|
2
|
true
|
false
|
|
CONSERVATION
|
VARCHAR2(2000)
|
255
|
19
|
2
|
true
|
false
|
|
REFERENCE
|
VARCHAR2(2000)
|
255
|
19
|
2
|
true
|
false
|
|
RANK
|
VARCHAR2(100)
|
255
|
19
|
2
|
false
|
false
|
|
HANDBOOK_PATH
|
VARCHAR2(255)
|
255
|
19
|
2
|
true
|
false
|
|
CREATION_DATE
|
DATE
|
255
|
19
|
2
|
false
|
false
|
|
UPDATE_DATE
|
TIMESTAMP
|
255
|
19
|
2
|
false
|
false
|
|
STATUS_FK
|
VARCHAR2(1)
|
255
|
19
|
2
|
false
|
false
|
|
Primary Key
|
|
Name
|
Columns
|
|
METHODPK
|
ID
|
|
Foreign Keys
|
|
Name
|
Referenced Table
|
Columns
|
|
METHOD_STATUS_FKC
|
STATUS
|
STATUS_FK
|
Column Detail
ID
-
Type: NUMBER(10)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
NAME
-
Type: VARCHAR2(100)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
DESCRIPTION
-
Type: VARCHAR2(255)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
CONDITIONING
-
Type: VARCHAR2(2000)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
PREPARATION
-
Type: VARCHAR2(2000)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
CONSERVATION
-
Type: VARCHAR2(2000)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
REFERENCE
-
Type: VARCHAR2(2000)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
RANK
-
Type: VARCHAR2(100)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
HANDBOOK_PATH
-
Type: VARCHAR2(255)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: true
-
Unique: false
-
Comment:
CREATION_DATE
-
Type: DATE
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
UPDATE_DATE
-
Type: TIMESTAMP
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
STATUS_FK
-
Type: VARCHAR2(1)
-
Length: 255
-
Precision: 19
-
Scale: 2
-
Nullable: false
-
Unique: false
-
Comment:
