PROCESS_COLLECTION

37 rows


Description

This is a table for Collection of Process. Stores Collection of Processes.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PROCESS_COLLECTION_ID NUMBER 18 null
INSPECTION.PROCESS_COLLECTION_ID INSPECTION_PROCESS_COLLEC_FK1R
INSPECTION.PROCESS_COLLECTION_MET_ID INSPECTION_PROCESS_COLLEC_FK2R
PROCESS_PROCESS_COLLECTION.PROCESS_COLLECTION_ID PROCESS_PROCESS_COLLECTIO_FK2R

Field Process Collection ID. Stores primary key for this table.

ENUM_LEGAL_ENTITY_ID NUMBER 18 null
ENUM_LEGAL_ENTITY.ENUM_LEGAL_ENTITY_ID PROCESS_COLLECTION_ENUM_L_FK1R

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

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.

START_DATE DATE 7 null

Field Start Date. Stores when the collection was created.

END_DATE DATE 7 null

Field End Date. Stores when the collection ended.

ENUM_STATUS_ID NUMBER 18 null
ENUM_STATUS.ENUM_STATUS_ID Implied ConstraintR

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

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.

Indexes

Constraint Name Type Sort Column(s)
PROCESS_COLLECTION_PK Primary key Asc PROCESS_COLLECTION_ID
PROCESS_COLLECTION_IDX_STATUS Performance Asc ENUM_STATUS_ID

Relationships