Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
INSPECTION_ID | NUMBER | 18 | null |
|
|
Field Inspection ID. Stores primary key for this table. |
||||||||||||||||||||||||||||||||
START_DATE | DATE | 7 | null |
|
|
Field Start Date. Stores when the inspection start. |
||||||||||||||||||||||||||||||||
END_DATE | DATE | 7 | null |
|
|
Field End Date. Stores when the inspection end. |
||||||||||||||||||||||||||||||||
FINAL_REPORT_DATE | DATE | 7 | null |
|
|
Field Final Report Date. Stores when the inspection have a final report. |
||||||||||||||||||||||||||||||||
ENUM_STATUS_ID | NUMBER | 18 | null |
|
|
Field Status. Stores the status of the record, foreign key to table enum_status. |
||||||||||||||||||||||||||||||||
PROCESS_COLLECTION_ID | NUMBER | 18 | null |
|
|
Field Process Collection ID. Stores collection type administration of this inspection, foreign key to table process_collection. |
||||||||||||||||||||||||||||||||
ASSESSMENT | TIMESTAMP(6) | 11,6 | √ | null |
|
|
Field Assessment. Stores assessment date of the inspection. |
|||||||||||||||||||||||||||||||
VERSION_ID | NUMBER | 18 | 0 |
|
|
Field Version. Stores the version of the record. |
||||||||||||||||||||||||||||||||
CUSER | VARCHAR2 | 75 | null |
|
|
Field Create User. Stores who create the record. |
||||||||||||||||||||||||||||||||
CDATE | TIMESTAMP(6) | 11,6 | SYSTIMESTAMP |
|
|
Field Create Date. Stores when the record was created. |
||||||||||||||||||||||||||||||||
MUSER | VARCHAR2 | 75 | null |
|
|
Field Modified User. Stores who modified the record. |
||||||||||||||||||||||||||||||||
MDATE | TIMESTAMP(6) | 11,6 | SYSTIMESTAMP |
|
|
Field Modified Date. Stores when the record was modified. |
||||||||||||||||||||||||||||||||
COUNTRY_ID | NUMBER | 0 | √ | null |
|
|
Field Country ID. Stores country of the inspection, foreign key to table country in this record. |
|||||||||||||||||||||||||||||||
PROCESS_COLLECTION_MET_ID | NUMBER | 18 | null |
|
|
Field Process Collection MET ID. Stores collection type met of this inspection, foreign key to table process_collection. |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
INSPECTION_PK | Primary key | Asc | INSPECTION_ID |
INSPECTION_P_COLLECTION_ID_IDX | Performance | Asc | PROCESS_COLLECTION_ID |
INSPECTION_STATUS_ID_IDX | Performance | Asc | ENUM_STATUS_ID |