CERTIFICATE_ENDORSEMENT

549 rows


Description

This is a table for Certificates and Endorsements. Stores the Certificates of a Entity.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
CERTIFICATE_ENDORSEMENT_ID NUMBER 18 null
CERT_ENDORSEMENT_DOCUMENT.CERTIFICATE_ENDORSEMENT_ID CERT_ENDORSEMENT_DOCUMENT_FK1R

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

ENUM_CERTIFICATE_TYPE_ID NUMBER 18 null
ENUM_CERTIFICATE_TYPE.ENUM_CERTIFICATE_TYPE_ID CERTIFICATE_ENDORSEMENT_E_FK1R

Field Enumeration Certificate Type ID. Stores the type of certificate of the record, foreign key to table enum_certificate_type.

LEGAL_ENTITY_ID NUMBER 18 null
LEGAL_ENTITY.LEGAL_ENTITY_ID CERTIFICATE_ENDORSEMENT_L_FK1R

Field Legal Entity ID. Stores the administration entity of this record, foreign key to table legal_entity.

DOCUMENT_ID NUMBER 18 null
DOCUMENT.DOCUMENT_ID CERTIFICATE_ENDORSEMENT_D_FK1R

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

NAME VARCHAR2 1000 null

Field Name. Stores the national name given to this record.

STCW_REFERENCE_ID_1 NUMBER 18 null
STCW_REFERENCE.STCW_REFERENCE_ID CERTIFICATE_ENDORSEMENT_S_FK1R

Field Stcw Reference 1 ID. Stores foreign key to table stcw_reference 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.

ENGLISH_TRANSLATION VARCHAR2 1000 null

Field English Translation. Stores the english translation given to this record.

STCW_REFERENCE_ID_2 NUMBER 18 null
STCW_REFERENCE.STCW_REFERENCE_ID CERTIFICATE_ENDORSEMENT_S_FK2R

Field Stcw Reference 2 ID. Stores foreign key to table stcw_reference of this record.

STCW_REFERENCE_ID_3 NUMBER 18 null
STCW_REFERENCE.STCW_REFERENCE_ID CERTIFICATE_ENDORSEMENT_S_FK3R

Field Stcw Reference 3 ID. Stores foreign key to table stcw_reference of this record.

Indexes

Constraint Name Type Sort Column(s)
CERTIFICATE_ENDORSEMENT_PK Primary key Asc CERTIFICATE_ENDORSEMENT_ID
ENDORSEMENT_CERT_TYPE_ID_IDX Performance Asc ENUM_CERTIFICATE_TYPE_ID
ENDORSEMENT_DOCUMENT_ID_IDX Performance Asc DOCUMENT_ID
ENDORSEMENT_ENTITY_ID_IDX Performance Asc LEGAL_ENTITY_ID
ENDORSEMENT_NAME_IDX Performance Asc NAME
ENDORSEMENT_STCW_REF_ID_IDX Performance Asc STCW_REFERENCE_ID_1

Relationships