LEGAL_REQUIREMENT

2089 rows


Description

This is a table for Legal Requirements. Stores Legal requirements of a document.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
LEGAL_REQUIREMENT_ID NUMBER 18 null
FINDING_LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID FINDING_LEGAL_REQUIREMENT_FK1R
LEGAL_REQUIREMENT.CHILD_OF_ID LEGAL_REQUIREMENT_LEGAL_R_FK2R
LEGAL_REQUIREMENT_ASSOCIATION.LEGAL_REQUIREMENT_ID LEGAL_REQUIREMENT_ASSOCIA_FK1R
LEGAL_REQUIREMENT_ASSOCIATION.LEGAL_REQUIREMENT_PARENT_ID LEGAL_REQUIREMENT_ASSOCIA_FK2R
LEGAL_REQUIREMENT_CORRELATION.LEGAL_REQUIREMENT_ID LEGAL_REQUIREMENT_CORRELA_FK1R
LEGAL_REQUIREMENT_CORRELATION.REQUIREMENT_CORRELATED_ID LEGAL_REQUIREMENT_CORRELA_FK2R
LEGAL_REQUIREMENT_PROCESS.LEGAL_REQUIREMENT_ID LEGAL_REQUIREMENT_PROCESS_FK2R
VIEW_FINDING_AUX.LEGAL_REQUIREMENT_ID Implied ConstraintR
VIEW_FINDINGS.LEGAL_REQUIREMENT_ID Implied ConstraintR
VIEW_INSPECTION_FINDING.LEGAL_REQUIREMENT_ID Implied ConstraintR
VIEW_LEGAL_REQUIREMENT_AUX.LEGAL_REQUIREMENT_ID Implied ConstraintR
VIEW_STATISTICS_FINDING_AUX.LEGAL_REQUIREMENT_ID Implied ConstraintR

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

NUM NUMBER 18 null

Field Num. Stores the number of the legal requirement.

CONTENT VARCHAR2 4000 null

Field Content. Stores the content of the legal requirement.

LEGAL_REQUIREMENT_TYPE_ID NUMBER 18 null
LEGAL_REQUIREMENT_TYPE.LEGAL_REQUIREMENT_TYPE_ID LEGAL_REQUIREMENT_LEGAL_R_FK1R

Field Legal Requirement Type ID. Stores the type of the legal requirement, foreign key to table legal_requirement_type.

LEGAL_DOCUMENT_ID NUMBER 18 null
LEGAL_DOCUMENT.LEGAL_DOCUMENT_ID LEGAL_REQUIREMENT_LEGAL_D_FK1R

Field Legal Document ID. Stores foreign key to table legal_document.

NAME VARCHAR2 1000 null

Field Name. Stores the name given to this record.

CHILD_OF_ID NUMBER 18 null
LEGAL_REQUIREMENT.LEGAL_REQUIREMENT_ID LEGAL_REQUIREMENT_LEGAL_R_FK2R

Field Child Of Id. Stores the parent of the legal requirement, id of a legal requirement already created.

ENUM_STATUS_ID NUMBER 18 null
ENUM_STATUS.ENUM_STATUS_ID Implied ConstraintR

Field Status. Stores the status of the record, foreign key to table enum_status.

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.

HIERARCHY_CODE VARCHAR2 4000 null

Field Hierarchy Code. Stores the hierarchy of the legal requirement.

Indexes

Constraint Name Type Sort Column(s)
LEGALREQUIREMENT_PK Primary key Asc LEGAL_REQUIREMENT_ID
L_REQ_CHILD_ID_IDX Performance Asc CHILD_OF_ID
L_REQ_STATUS_ID_IDX Performance Asc ENUM_STATUS_ID
LEGAL_REQ_IDX_DOC_ID_IDX Performance Asc LEGAL_DOCUMENT_ID

Relationships