DISPENSATION

292 rows


Description

This is a table for Dispensations. Stores list of Dispensations issued by the country.

Columns

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

Field Dispensation ID. Stores primary key for this table.

COUNTRY_ID NUMBER 18 null
COUNTRY.COUNTRY_ID DISPENSATION_COUNTRY_FK1R

Field Country ID. Stores foreign key to table country of this record.

YEAR NUMBER 18 null

Field Year. Stores the year when this dispensation occurs.

N_DISPENSATIONS NUMBER 18 null

Field Number of Dispensations. Stores the number of dispensations for the year and the Stcw convention in related.

STCW_REFERENCE_ID NUMBER 18 null
STCW_REFERENCE.STCW_REFERENCE_ID DISPENSATION_STCW_REFEREN_FK1R

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

ENUM_STATUS_ID NUMBER 18 null
ENUM_STATUS.ENUM_STATUS_ID Implied ConstraintR

Field Status. Stores the status of the record, foreign key to table enum_status.

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)
DISPENSATIONS_PK Primary key Asc DISPENSATION_ID
DISP_COUNTRY_YEAR_IDX Performance Asc/Asc COUNTRY_ID + YEAR
DISPENSATION_COUNTRY_ID_IDX Performance Asc COUNTRY_ID
DISPENSATION_STATUS_IDX Performance Asc ENUM_STATUS_ID
DISPENSATION_STCW_REF_ID_IDX Performance Asc STCW_REFERENCE_ID

Relationships