QUALITY_SYSTEM_DOCUMENT

134 rows


Description

This is a table for Quality System with Documents. Stores Documents that certificate the Quality Standart System.

Columns

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

Field Quality System Document ID. Stores primary key for this table.

DOCUMENT_ID NUMBER 18 null
DOCUMENT.DOCUMENT_ID QUALITY_SYSTEM_DOCUMENT_D_FK1R

Field Document ID. Stores foreign key to table documents in this record.

QUALITY_SYSTEM_ID NUMBER 18 null
QUALITY_SYSTEM.QUALITY_SYSTEM_ID QUALITY_SYSTEM_DOCUMENT_Q_FK1R

Field Quality System ID. Stores foreign key to table quality_system 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.

ENUM_STATUS_ID NUMBER 18 null
ENUM_STATUS.ENUM_STATUS_ID Implied ConstraintR

Indexes

Constraint Name Type Sort Column(s)
QUALITY_SYSTEM_DOCUMENT_PK Primary key Asc QUALITY_SYSTEM_DOCUMENT_ID

Relationships