Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
STCW_REFERENCE_ID | NUMBER | 18 | null |
|
|
Field Stcw Reference ID. Stores primary key for this table. |
||||||||||||||||||||||||||
ENUM_STCW_REFERENCE_TYPE_ID | NUMBER | 18 | √ | null |
|
|
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 |