LEGAL_DOCUMENT

33 rows


Description

This is a table for Legal Documents. Stores Legal documents.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
LEGAL_DOCUMENT_ID NUMBER 18 null
LEGAL_DOCUMENT.PARENT_ID LEGAL_DOCUMENT_LEGAL_DOCU_FK1R
LEGAL_REQUIREMENT.LEGAL_DOCUMENT_ID LEGAL_REQUIREMENT_LEGAL_D_FK1R

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

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.

ENUM_STATUS_ID NUMBER 18 null
ENUM_STATUS.ENUM_STATUS_ID LEGAL_DOCUMENT_ENUM_STATU_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 this document was created.

PARENT_ID NUMBER 18 null
LEGAL_DOCUMENT.LEGAL_DOCUMENT_ID LEGAL_DOCUMENT_LEGAL_DOCU_FK1R

Field Parent ID. Stores the document that this record depends, foreign key to table legal_document.

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)
LEGALDOCUMENTS_PK Primary key Asc LEGAL_DOCUMENT_ID
L_DOC_STATUS_IDX Performance Asc ENUM_STATUS_ID
L_DOCUMENT_PARENT_ID_IDX Performance Asc PARENT_ID

Relationships