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 |
|
|
Field Legal Requirement ID. Stores original legal requirement, foreign key to table legal_requirement. |
|||
REQUIREMENT_CORRELATED_ID | NUMBER | 18 | √ | null |
|
|
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 |