Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
INSPECTION_ID | NUMBER | 18 | null |
|
|
|||||
LEGAL_ENTITY_ID | NUMBER | 18 | null |
|
|
|||||
LEGAL_REQUIREMENT_ID | NUMBER | 18 | √ | null |
|
|
||||
FINDING_ID | NUMBER | 18 | null |
|
|
|||||
FINDING_COMMENT | VARCHAR2 | 4000 | √ | null |
|
|
||||
SECTION_REPORT | VARCHAR2 | 1000 | √ | null |
|
|
||||
FINDING_TYPE_ID | NUMBER | 0 | null |
|
|
|||||
FINDING_TYPE_NAME | VARCHAR2 | 500 | null |
|
|
|||||
PROCESS_ID | NUMBER | 18 | null |
|
|
|||||
PROCESS_LEGAL_ENTITY_ID | NUMBER | 18 | √ | null |
|
|
||||
PROCESS_NAME | VARCHAR2 | 1000 | null |
|
|
|||||
COUNTRY_ID | NUMBER | 18 | null |
|
|
|||||
COUNTRY_NAME | VARCHAR2 | 250 | null |
|
|
|||||
COUNTRY_GROUP_ID | NUMBER | 18 | null |
|
|
|||||
COUNTRY_GROUP_NAME | VARCHAR2 | 500 | null |
|
|
|||||
LEGAL_ENTITY_NAME | VARCHAR2 | 1000 | null |
|
|
|||||
LEGAL_ENTITY_TYPE_ID | NUMBER | 18 | null |
|
|
|||||
LEGAL_ENTITY_TYPE_NAME | VARCHAR2 | 500 | null |
|
|
|||||
INSPECTION_START_DATE | DATE | 7 | null |
|
|
|||||
INSPECTION_END_DATE | DATE | 7 | null |
|
|
|||||
PROCESS_ADMIN_COLLECTION_ID | NUMBER | 18 | null |
|
|
|||||
PROCESS_MET_COLLECTION_ID | NUMBER | 18 | null |
|
|