Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
FINDING_ID | NUMBER | 18 | null |
|
|
Field Finding ID. Stores primary key for this table. |
||||||||||||||||||||||
COMENT | VARCHAR2 | 4000 | √ | null |
|
|
Field Coment. Stores the description of the finding. |
|||||||||||||||||||||
ENUM_FINDING_TYPE_ID | NUMBER | 18 | null |
|
|
Field Enumeration Finding Type ID. Stores type of the finding, foreign key to table enum_finding_type of this record. |
||||||||||||||||||||||
CORRECTED | NUMBER | 1 | √ | null |
|
|
Field Corrected. Stores if this finding was already corrected or not. |
|||||||||||||||||||||
CORRECTIVE_ACTIONS | VARCHAR2 | 4000 | √ | null |
|
|
Field Corrective Actions. Stores wich actions are taken to correct this finding. |
|||||||||||||||||||||
MEASURE | VARCHAR2 | 4000 | √ | null |
|
|
Field Measure. Stores the measures taken. |
|||||||||||||||||||||
DEADLINE | TIMESTAMP(6) | 11,6 | √ | null |
|
|
Field Deadline. Stores the deadline to have this finding corrected. |
|||||||||||||||||||||
SECTION_REPORT | VARCHAR2 | 1000 | √ | null |
|
|
Field Section Report. Stores the section in report of this finding. |
|||||||||||||||||||||
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. |
||||||||||||||||||||||
MDATE | TIMESTAMP(6) | 11,6 | SYSTIMESTAMP |
|
|
Field Modified Date. Stores when the record was modified. |
||||||||||||||||||||||
MUSER | VARCHAR2 | 75 | null |
|
|
Field Modified User. Stores who modified the record. |
||||||||||||||||||||||
LEGAL_REQUIREMENT_PROCESS_ID | NUMBER | 0 | √ | null |
|
|
Field Legal Requirement Process ID. Stores the legal requirement in the process where this finding occurs, foreign key to table legal_requirement_process of this record. |
|||||||||||||||||||||
INSPECTION_LEGAL_ENTITY_ID | NUMBER | 18 | 0 |
|
|
Field Inspection Legal Entity ID. Stores in wich inspection of a entity this finding occurs, foreign key to table legal_requirement_process of this record. |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
REPORT_FINDINGS_PK | Primary key | Asc | FINDING_ID |
FINDING_FINDING_TYPE_ID_IDX | Performance | Asc | ENUM_FINDING_TYPE_ID |
FINDING_STATUS_ID_IDX | Performance | Asc | ENUM_STATUS_ID |