FINDING_LEGAL_REQUIREMENT

63 rows


Description

This is a table for Finding Legal Requirement. Stores Relation between a finding and its legal requirement.

Columns

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

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

LEGAL_REQUIREMENT_ID NUMBER 18 null
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID FINDING_LEGAL_REQUIREMENT_FK1R

Field Legal Requirement ID. Stores foreign key to table legal_requirement in this record.

FINDING_ID NUMBER 18 null
FINDING.FINDING_ID FINDING_LEGAL_REQUIREMENT_FK2R

Field Finding ID. Stores foreign key to table finding in this record.

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)
FINDING_LEGAL_REQUIREMENT_PK Primary key Asc FINDING_LEGAL_REQUIREMENT_ID
FINDING_LEG_REQ_ID_F_IDX Performance Asc FINDING_ID
FINDING_LEG_REQ_ID_R_IDX Performance Asc LEGAL_REQUIREMENT_ID
FINDING_LEGAL_REQUIREMENT_UK1 Must be unique Asc/Asc LEGAL_REQUIREMENT_ID + FINDING_ID

Relationships