LEGAL_ENTITY_DOCUMENT

16 rows


Description

This is a table for Legal Entities Documents. Stores Administration entities and Met Instituions with documents.

Columns

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

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

DOCUMENT_ID NUMBER 18 null
DOCUMENT.DOCUMENT_ID LEGAL_ENTITY_DOCUMENT_DOC_FK1R

Field Document ID. Stores foreign key to table documents in this record.

LEGAL_ENTITY_ID NUMBER 18 null
LEGAL_ENTITY.LEGAL_ENTITY_ID LEGAL_ENTITY_DOCUMENT_LEG_FK1R

Field Legal Entity ID. Stores foreign key to table legal_entity.

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_STATUS_ID NUMBER 18 null
ENUM_STATUS.ENUM_STATUS_ID Implied ConstraintR

Indexes

Constraint Name Type Sort Column(s)
LEGAL_ENTITY_DOCUMENT_PK Primary key Asc LEGAL_ENTITY_DOCUMENT_ID
L_ENT_DOC_ENT_ID_IDX Performance Asc LEGAL_ENTITY_ID
L_ENTITY_DOC_ID_IDX Performance Asc DOCUMENT_ID

Relationships