Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
QUALITY_SYSTEM_ID | NUMBER | 18 | null |
|
|
Field Quality System ID. Stores primary key for this table. |
||||
LEGAL_ENTITY_ID | NUMBER | 18 | null |
|
|
Field Legal Entity ID. Stores the met instituion of this record, foreign key to table legal_entity. |
||||
IN_PLACE | NUMBER | 1 | √ | null |
|
|
Field In Place. Stores if this quality system is in place. |
|||
CERTIFIED | NUMBER | 1 | √ | null |
|
|
Field Certified. Stores if this quality system is certified. |
|||
ORIGINAL_CERTIFICATION_DATE | DATE | 7 | √ | null |
|
|
Field Original Cerification Date. Stores when this quality system was certified. |
|||
CERTIFICATION_BODY | VARCHAR2 | 4000 | √ | null |
|
|
Field Certification Body. Stores description of the certification of this quality system. |
|||
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. |
||||
OBSERVATIONS | VARCHAR2 | 4000 | √ | null |
|
|
Field Observations. Stores observations of the quality system. |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
QUALITY_SYSTEM_PK | Primary key | Asc | QUALITY_SYSTEM_ID |
QUALITY_SYSTEM_UK1 | Must be unique | Asc | LEGAL_ENTITY_ID |