Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
CERTIFICATE_ENDORSEMENT_ID | NUMBER | 18 | null |
|
|
Field Certificate Endorsement ID. Stores primary key for this table. |
||||
ENUM_CERTIFICATE_TYPE_ID | NUMBER | 18 | √ | null |
|
|
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 |
|
|
Field Legal Entity ID. Stores the administration entity of this record, foreign key to table legal_entity. |
|||
DOCUMENT_ID | NUMBER | 18 | √ | null |
|
|
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 |
|
|
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 |
|
|
Field Stcw Reference 2 ID. Stores foreign key to table stcw_reference of this record. |
|||
STCW_REFERENCE_ID_3 | NUMBER | 18 | √ | null |
|
|
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 |