CERT_ENDORSEMENT_DOCUMENT

5 rows


Description

This is a table for Certificates and Endorsements with Documents. Stores the relation between certificates and documents.

Columns

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

Field Certificate Endorsement Document ID. Stores primary key for this table.

DOCUMENT_ID NUMBER 18 null
DOCUMENT.DOCUMENT_ID CERT_ENDORSEMENT_DOCUMENT_FK2R

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

CERTIFICATE_ENDORSEMENT_ID NUMBER 18 null
CERTIFICATE_ENDORSEMENT.CERTIFICATE_ENDORSEMENT_ID CERT_ENDORSEMENT_DOCUMENT_FK1R

Field Certificate Endorsement ID. Stores foreign key to table certificate_endorsement of 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)
CERT_ENDORSEMENT_DOCUMENT_PK Primary key Asc CERT_ENDORSEMENT_DOCUMENT_ID
CERT_ENDORSEMENT_DOCUMENT_UK1 Must be unique Asc/Asc DOCUMENT_ID + CERTIFICATE_ENDORSEMENT_ID

Relationships