STCW_REFERENCE

76 rows


Description

This is a table for Stcw References. Stores Certificates of competency for officers according with STCW convention.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
STCW_REFERENCE_ID NUMBER 18 null
CERTIFICATE_ENDORSEMENT.STCW_REFERENCE_ID_1 CERTIFICATE_ENDORSEMENT_S_FK1R
CERTIFICATE_ENDORSEMENT.STCW_REFERENCE_ID_2 CERTIFICATE_ENDORSEMENT_S_FK2R
CERTIFICATE_ENDORSEMENT.STCW_REFERENCE_ID_3 CERTIFICATE_ENDORSEMENT_S_FK3R
DISPENSATION.STCW_REFERENCE_ID DISPENSATION_STCW_REFEREN_FK1R
FRAUDULENT_CERTIFICATE.STCW_REFERENCE_ID FRAUDULENT_CERTIFICATE_ST_FK1R
MET_PROGRAMM.STCW_REFERENCE_ID_1 MET_PROGRAMM_STCW_REFEREN_FK1R
MET_PROGRAMM.STCW_REFERENCE_ID_2 MET_PROGRAMM_S_FK2R
MET_PROGRAMM.STCW_REFERENCE_ID_3 MET_PROGRAMM_S_FK3R
VIEW_CERTIFICATE_MATRIX.STCW_REFERENCE_ID Implied ConstraintR
VIEW_CERTIFICATE_MATRIX_INT.STCW_REFERENCE_ID Implied ConstraintR
VIEW_COUNT_MET_PROGRAMANS.STCW_REFERENCE_ID Implied ConstraintR
VIEW_STATISTICS_MET_PROGRAMANS.STCW_REFERENCE_ID Implied ConstraintR

Field Stcw Reference ID. Stores primary key for this table.

ENUM_STCW_REFERENCE_TYPE_ID NUMBER 18 null
ENUM_STCW_REFERENCE_TYPE.ENUM_STCW_REFERENCE_TYPE_ID STCW_REFERENCE_ENUM_STCW__FK1R

Field Enumeration Stcw Reference Type ID. Stores the type of certificates of competence in the record, foreign key to table enum_stcw_reference_type.

CERTIFICATE_OF_COMPETENCY VARCHAR2 4000 null

Field Certificate Of Competency. Stores long description of STCW convention.

STCW_REGULATION VARCHAR2 250 null

Field Stcw Regulation. Stores short description of STCW convention.

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.

EXT_INFO NUMBER 1 0
RANK_LEVEL NUMBER 18 0

Indexes

Constraint Name Type Sort Column(s)
STCW_REFERENCE_PK Primary key Asc STCW_REFERENCE_ID
STCW_REFERENCE_UK1 Must be unique Asc/Asc/Asc ENUM_STCW_REFERENCE_TYPE_ID + CERTIFICATE_OF_COMPETENCY + STCW_REGULATION

Relationships