PROCESS

120 rows


Description

This is a table for Process. Stores Inspection Processes.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PROCESS_ID NUMBER 18 null
LEGAL_REQUIREMENT_PROCESS.PROCESS_ID LEGAL_REQUIREMENT_PROCESS_FK1R
PROCESS_ENUM_LEGAL_ENTITY.PROCESS_ID PROCESS_LEGAL_ENTITY_PROC_FK1R
PROCESS_PROCESS_COLLECTION.PROCESS_ID PROCESS_PROCESS_COLLECTIO_FK1R
VIEW_COLLECTIONS.PROCESS_ID Implied ConstraintR
VIEW_FINAL_STAT_COUNT_P.PROCESS_ID Implied ConstraintR
VIEW_FINDING_AUX.PROCESS_ID Implied ConstraintR
VIEW_FINDINGS.PROCESS_ID Implied ConstraintR
VIEW_INSPECTION_FINDING.PROCESS_ID Implied ConstraintR
VIEW_PROCESS.PROCESS_ID Implied ConstraintR
VIEW_STATISTICS_ALL_FINDING_P.PROCESS_ID Implied ConstraintR
VIEW_STATISTICS_ALL_P.PROCESS_ID Implied ConstraintR
VIEW_STATISTICS_FINDING_AUX.PROCESS_ID Implied ConstraintR

Field Process ID. Stores primary key for this table.

ENUM_STATUS_ID NUMBER 18 null
ENUM_STATUS.ENUM_STATUS_ID PROCESS_ENUM_STATUS_FK1R

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

START_DATE DATE 7 null

Field Start Date. Stores when the process was created.

END_DATE DATE 7 null

Field End Date. Stores when the process ended.

NAME VARCHAR2 1000 null

Field Name. Stores the name given to this record.

DESCRIPTION VARCHAR2 4000 null

Field Description. Stores the description given to this record.

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.

ENUM_LEGAL_ENTITY_ID NUMBER 18 null
ENUM_LEGAL_ENTITY.ENUM_LEGAL_ENTITY_ID PROCESS_ENUM_LEGAL_ENTITY_FKR

Field Enumeration Legal Entity ID. Stores the type of entity of the process, foreign key to table enum_legal_entity.

Indexes

Constraint Name Type Sort Column(s)
PROCESS_PK Primary key Asc PROCESS_ID
PROCESS_STATUS_IDX Performance Asc ENUM_STATUS_ID

Relationships