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 |
|
|
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 |
|
|
Field Stcw Reference ID. Stores foreign key to table stcw_reference of this record. |
||||
ENUM_STATUS_ID | NUMBER | 18 | √ | null |
|
|
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 |