Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
ROW_ID | NUMBER | 0 | √ | null |
|
|
||||
COUNTRY_GROUP_ID | NUMBER | 18 | null |
|
|
|||||
COUNTRY_GROUP_NAME | VARCHAR2 | 500 | null |
|
|
|||||
COUNTRY_ID | NUMBER | 18 | null |
|
|
|||||
COUNTRY_NAME | VARCHAR2 | 250 | null |
|
|
|||||
ENTITY_TYPE_ID | NUMBER | 18 | null |
|
|
|||||
ENTITY_TYPE_NAME | VARCHAR2 | 500 | null |
|
|
|||||
ENTITY_ID | NUMBER | 18 | null |
|
|
|||||
ENTITY_NAME | VARCHAR2 | 1000 | null |
|
|
|||||
FINDING_TYPE_ID | NUMBER | 0 | null |
|
|
|||||
FINDING_TYPE_NAME | VARCHAR2 | 500 | null |
|
|
|||||
INSPECTION_ID | NUMBER | 18 | null |
|
|
|||||
START_DATE | VARCHAR2 | 4 | √ | null |
|
|
||||
END_DATE | VARCHAR2 | 4 | √ | null |
|
|
||||
DIRECT_LD_ID | NUMBER | 18 | null |
|
|
|||||
DIRECT_LD | VARCHAR2 | 1000 | null |
|
|
|||||
DIRECT_LR | VARCHAR2 | 1000 | null |
|
|
|||||
DIRECT_LR_ID | NUMBER | 18 | null |
|
|
|||||
CORRELATED_LR_ID | NUMBER | 18 | √ | null |
|
|
||||
NUMBER_FINDING | NUMBER | 0 | √ | null |
|
|