INSPECTION

122 rows


Description

This is a table for Inspections. Stores Inspections.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
INSPECTION_ID NUMBER 18 null
INSPECTION_LEGAL_ENTITY.INSPECTION_ID INSPECTION_LEGAL_ENTITY_FK2R
INSPECTION_TEAM.INSPECTION_ID INSPECTION_TEAM_INSPECTIO_FK1R
NEW_STAT_COUNT_BASE.INSPECTION_ID Implied ConstraintR
VIEW_FINDING_AUX.INSPECTION_ID Implied ConstraintR
VIEW_INSPECTION_FINDING.INSPECTION_ID Implied ConstraintR
VIEW_INSPECTIONS.INSPECTION_ID Implied ConstraintR
VIEW_INSPECTIONS_ENTITY.INSPECTION_ID Implied ConstraintR
VIEW_INSPECTIONS_LEGAL_ENTITY.INSPECTION_ID Implied ConstraintR
VIEW_INSPECTIONS_TEAM.INSPECTION_ID Implied ConstraintR
VIEW_STAT_COUNT_DIRECT.INSPECTION_ID Implied ConstraintR
VIEW_STATISTICS_ALL_FINDING_LR.INSPECTION_ID Implied ConstraintR
VIEW_STATISTICS_ALL_FINDING_P.INSPECTION_ID Implied ConstraintR
VIEW_STATISTICS_ALL_P.INSPECTION_ID Implied ConstraintR
VIEW_STATISTICS_COUNT_FIND_LR.INSPECTION_ID Implied ConstraintR
VIEW_STATISTICS_FINDING_AUX.INSPECTION_ID Implied ConstraintR

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
ENUM_STATUS.ENUM_STATUS_ID INSPECTION_ENUM_STATUS_FK1R

Field Status. Stores the status of the record, foreign key to table enum_status.

PROCESS_COLLECTION_ID NUMBER 18 null
PROCESS_COLLECTION.PROCESS_COLLECTION_ID INSPECTION_PROCESS_COLLEC_FK1R

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
PROCESS_COLLECTION.PROCESS_COLLECTION_ID INSPECTION_PROCESS_COLLEC_FK2R

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

Relationships