LEGAL_REQUIREMENT_CORRELATION

906 rows


Description

This is a table for Legal Requirements with Correlations. Stores Correlation of a legal requirement with another one.

Columns

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

Field Legal Requirement Correlation ID. Stores primary key for this table.

LEGAL_REQUIREMENT_ID NUMBER 18 null
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID LEGAL_REQUIREMENT_CORRELA_FK1R

Field Legal Requirement ID. Stores original legal requirement, foreign key to table legal_requirement.

REQUIREMENT_CORRELATED_ID NUMBER 18 null
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID LEGAL_REQUIREMENT_CORRELA_FK2R

Field Legal Requirement Correlated ID. Stores correlated legal requirement, foreign key to table legal_requirement.

VERSION_ID NUMBER 18 null

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)
LG_REQ_CORRELATION_PK Primary key Asc LEGAL_REQ_CORRELATION_ID
LEGAL_REQUIREMENT_CORRELA_UK1 Must be unique Asc/Asc LEGAL_REQUIREMENT_ID + REQUIREMENT_CORRELATED_ID

Relationships