ENUM_STATUS

6 rows


Description

This is a table for Status enumeration. Stores Status of the Countries, Entities and Legal Documents.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ENUM_STATUS_ID NUMBER 18 null
CERT_ENDORSEMENT_DOCUMENT.ENUM_STATUS_ID Implied ConstraintR
COUNTRY.ENUM_STATUS_ID Implied ConstraintR
COUNTRY_EXTERNAL_LINK.ENUM_STATUS_ID Implied ConstraintR
DISPENSATION.ENUM_STATUS_ID Implied ConstraintR
FINDING.ENUM_STATUS_ID FINDING_ENUM_STATUS_FK1R
FRAUDULENT_CERTIFICATE.ENUM_STATUS_ID Implied ConstraintR
FRAUDULENT_CERTIFICATE_DOC.ENUM_STATUS_ID Implied ConstraintR
INSPECTION.ENUM_STATUS_ID INSPECTION_ENUM_STATUS_FK1R
LEGAL_DOCUMENT.ENUM_STATUS_ID LEGAL_DOCUMENT_ENUM_STATU_FK1R
LEGAL_ENTITY.ENUM_STATUS_ID Implied ConstraintR
LEGAL_ENTITY_DOCUMENT.ENUM_STATUS_ID Implied ConstraintR
LEGAL_REQUIREMENT.ENUM_STATUS_ID Implied ConstraintR
LEGISLATION.ENUM_STATUS_ID LEGISLATION_ENUM_STATUS_FK1R
MET_PROGRAMM_DOCUMENT.ENUM_STATUS_ID Implied ConstraintR
METC_SYSTEM.ENUM_STATUS_ID Implied ConstraintR
PROCESS.ENUM_STATUS_ID PROCESS_ENUM_STATUS_FK1R
PROCESS_COLLECTION.ENUM_STATUS_ID Implied ConstraintR
PROCESS_ENUM_LEGAL_ENTITY.ENUM_STATUS_ID Implied ConstraintR
QUALITY_SYSTEM_DOCUMENT.ENUM_STATUS_ID Implied ConstraintR
RECOGNISED_COUNTRY.ENUM_STATUS_ID Implied ConstraintR
TRAINING_FACILITY_DOCUMENT.ENUM_STATUS_ID Implied ConstraintR
VIEW_ADMINISTRATIONS.ENUM_STATUS_ID Implied ConstraintR
VIEW_LEGAL_DOCUMENT.ENUM_STATUS_ID Implied ConstraintR
VIEW_METS.ENUM_STATUS_ID Implied ConstraintR

Field Enumeration Status ID. Stores primary key for this table.

ENUM_RECORD_TYPE_ID NUMBER 18 null
ENUM_RECORD_TYPE.ENUM_RECORD_TYPE_ID ENUM_STATUS_ENUM_RECORD_T_FK1R

Field Enumeration Record Type ID. Stores type of record, foreign key to table enum_record_type.

NAME VARCHAR2 500 null

Field Name. Stores the name given to this record.

DESCRIPTION VARCHAR2 4000 null

Field Description. Stores the description given to 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.

Indexes

Constraint Name Type Sort Column(s)
STATUS_PK Primary key Asc ENUM_STATUS_ID

Relationships