PROCESS_PROCESS_COLLECTION

121 rows


Description

This is a table for Process with Collection of Process. Stores Assignment of multiple processes to a collection.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PROCESS_PROCESS_COLLECTION_ID NUMBER 18 null

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

PROCESS_ID NUMBER 18 null
PROCESS.PROCESS_ID PROCESS_PROCESS_COLLECTIO_FK1R

Field Process ID. Stores the process of the record, foreign key to table process.

PROCESS_COLLECTION_ID NUMBER 18 null
PROCESS_COLLECTION.PROCESS_COLLECTION_ID PROCESS_PROCESS_COLLECTIO_FK2R

Field Process Collection ID. Stores the collection of the record, foreign key to table process_collection.

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)
PROCESSES_PK Primary key Asc PROCESS_PROCESS_COLLECTION_ID
PROCESS_PROCESS_COLLECTIO_UK1 Must be unique Asc/Asc PROCESS_ID + PROCESS_COLLECTION_ID

Relationships