Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MET_PROGRAMM_ID | NUMBER | 18 | null |
|
|
Field Met Programm ID. Stores primary key for this table. |
||||||||||
NAME | VARCHAR2 | 1000 | √ | null |
|
|
Field Name. Stores the name given to this record. |
|||||||||
DURATION | VARCHAR2 | 1000 | √ | null |
|
|
Field Duration. Stores the duration of the programm. |
|||||||||
ENUM_UNIT_ID | NUMBER | 18 | √ | null |
|
|
Field Enumeration Unit ID. Stores unit used for the duration of this programm, foreign key to table enum_unit. |
|||||||||
APPROVED_BY | VARCHAR2 | 1000 | √ | null |
|
|
Field Approved By. Stores who approves this programm. |
|||||||||
STCW_REFERENCE_ID_1 | NUMBER | 18 | null |
|
|
Field Stcw Reference 1 ID. Stores foreign key to table stcw_reference in this record. |
||||||||||
LEGAL_ENTITY_ID | NUMBER | 18 | null |
|
|
Field Legal Entity ID. Stores the met instituion of this record, foreign key to table legal_entity. |
||||||||||
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. |
||||||||||
ACADEMIC_DEGREE | NUMBER | 1 | √ | null |
|
|
Field Academic Degree. Stores if the programm give a academic degree. |
|||||||||
STCW_REFERENCE_ID_2 | NUMBER | 18 | √ | null |
|
|
Field Stcw Reference 2 ID. Stores foreign key to table stcw_reference in this record. |
|||||||||
STCW_REFERENCE_ID_3 | NUMBER | 18 | √ | null |
|
|
Field Stcw Reference 3 ID. Stores foreign key to table stcw_reference in this record. |
|||||||||
DETAILS | VARCHAR2 | 2000 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
MET_PROGRAMM_PK | Primary key | Asc | MET_PROGRAMM_ID |