Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
LEGAL_REQ_ASSOCIATION_ID | NUMBER | 18 | null |
|
|
Field Legal Requirement Association 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. |
|||
LEGAL_REQUIREMENT_PARENT_ID | NUMBER | 18 | √ | null |
|
|
Field Legal Requirement Parent ID. Stores associated legal requirement, foreign key to table legal_requirement. |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
LEGAL_REQUIREMENT_ASSOCIA_PK | Primary key | Asc | LEGAL_REQ_ASSOCIATION_ID |