LEGAL_REQUIREMENT_ASSOCIATION

0 rows


Description

This is a table for Legal Requirements with Associations. Stores Association of a legal requirement with another one.

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
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID LEGAL_REQUIREMENT_ASSOCIA_FK1R

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

LEGAL_REQUIREMENT_PARENT_ID NUMBER 18 null
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID LEGAL_REQUIREMENT_ASSOCIA_FK2R

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

Relationships