QUALITY_SYSTEM

205 rows


Description

This is a table for Quality System. Stores Quality Certification of MET Entity and Administration Entity.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
QUALITY_SYSTEM_ID NUMBER 18 null
QUALITY_SYSTEM_DOCUMENT.QUALITY_SYSTEM_ID QUALITY_SYSTEM_DOCUMENT_Q_FK1R

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

LEGAL_ENTITY_ID NUMBER 18 null
LEGAL_ENTITY.LEGAL_ENTITY_ID QUALITY_SYSTEM_LEGAL_ENTI_FK1R

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

Relationships