Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
ROW_ID | NUMBER | 0 | √ | null |
|
|
||||
INSPECTION_ID | NUMBER | 18 | 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 | NUMBER | 18 | √ | null |
|
|
||||
ENTITY_TYPE_NAME | VARCHAR2 | 500 | √ | null |
|
|
||||
ENTITY_ID | NUMBER | 18 | √ | null |
|
|
||||
ENTITY_NAME | VARCHAR2 | 1000 | √ | null |
|
|
||||
ASSESSMENT_DATE | DATE | 8 | √ | null |
|
|
||||
REPORT_DATE | DATE | 7 | null |
|
|
|||||
START_DATE | DATE | 7 | null |
|
|
|||||
END_DATE | DATE | 7 | null |
|
|
|||||
MET_COLLECTION | NUMBER | 18 | null |
|
|
|||||
MET_COLLECTION_NAME | VARCHAR2 | 1000 | √ | null |
|
|
||||
ADMIN_COLLECTION | NUMBER | 18 | null |
|
|
|||||
ADMIN_COLLECTION_NAME | VARCHAR2 | 1000 | √ | null |
|
|
||||
INSPECTION_TEAM_NAME | VARCHAR2 | 4000 | √ | null |
|
|