DOCUMENT

1052 rows


Description

This is a table for Documents. Stores Documents/Files for all needed tables. Save BLOB binary, content type, extension and other information.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
DOCUMENT_ID NUMBER 18 null
CERT_ENDORSEMENT_DOCUMENT.DOCUMENT_ID CERT_ENDORSEMENT_DOCUMENT_FK2R
CERTIFICATE_ENDORSEMENT.DOCUMENT_ID CERTIFICATE_ENDORSEMENT_D_FK1R
COUNTRY.DOCUMENT_ID COUNTRY_DOCUMENT_FK1R
FRAUDULENT_CERTIFICATE_DOC.DOCUMENT_ID FRAUDULENT_CERTIFICATE_DO_FK1R
LEGAL_ENTITY_DOCUMENT.DOCUMENT_ID LEGAL_ENTITY_DOCUMENT_DOC_FK1R
MET_PROGRAMM_DOCUMENT.DOCUMENT_ID MET_PROGRAMM_DOCUMENT_FK2R
METC_SYSTEM.DOCUMENT_ID METC_SYSTEM_DOCUMENT_FK1R
QUALITY_SYSTEM_DOCUMENT.DOCUMENT_ID QUALITY_SYSTEM_DOCUMENT_D_FK1R
TRAINING_FACILITY_DOCUMENT.DOCUMENT_ID TRAINING_FACILITY_DOCUMEN_FK2R
VIEW_LEGAL_DOCUMENT.CORRELATED_DOCUMENT_ID Implied ConstraintR
VIEW_LEGAL_DOCUMENT.DOCUMENT_ID Implied ConstraintR
VIEW_LEGAL_REQUIREMENT.DOCUMENT_ID Implied ConstraintR
VIEW_STATISTICS_ALL_LR.CORRELATED_DOCUMENT_ID Implied ConstraintR
VIEW_STATISTICS_ALL_LR.DIRECT_DOCUMENT_ID Implied ConstraintR

Field Document ID. Stores primary key for this table.

NAME VARCHAR2 500 null

Field Name. Stores the name given to this record.

EXTENSION VARCHAR2 100 null

Field Extension. Stores the extension of the file.

DESCRIPTION VARCHAR2 4000 null

Field Description. Stores the description given to this record.

CONTENT_TYPE VARCHAR2 250 null

Field Content Type. Stores content type of the file.

BINARY BLOB 4000 null

Field Extension. Stores the binary of the file, BLOB data type

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)
DOCUMENT_PK Primary key Asc DOCUMENT_ID

Relationships