PROCESS_ENUM_LEGAL_ENTITY

52 rows


Description

This is a table for Process with Legal Entity enumeration. Stores Type of Legal Entity in a Process.

Columns

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

Field Process Legal Entity ID. Stores primary key for this table.

PROCESS_ID NUMBER 18 null
PROCESS.PROCESS_ID PROCESS_LEGAL_ENTITY_PROC_FK1R

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

ENUM_LEGAL_ENTITY_ID NUMBER 18 null
ENUM_LEGAL_ENTITY.ENUM_LEGAL_ENTITY_ID PROCESS_LEGAL_ENTITY_ENUM_FK1R

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

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_ENTITY_PK Primary key Asc PROCESS_LEGAL_ENTITY_ID
PROCESS_ENUM_LEGAL_ENTITY_UK1 Must be unique Asc/Asc PROCESS_ID + ENUM_LEGAL_ENTITY_ID

Relationships