Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LEGAL_REQUIREMENT_ID | NUMBER | 18 | null |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
Field Child Of Id. Stores the parent of the legal requirement, id of a legal requirement already created. |
|||||||||||||||||||||||||
ENUM_STATUS_ID | NUMBER | 18 | √ | null |
|
|
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 |