Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
ROW_ID | NUMBER | 0 | √ | null |
|
|
||||
COUNTRY_GROUP_ID | NUMBER | 18 | null |
|
|
|||||
COUNTRY_ID | NUMBER | 18 | null |
|
|
|||||
COUNTRY_GROUP | VARCHAR2 | 4000 | √ | null |
|
|
||||
COUNTRY_NAME | VARCHAR2 | 250 | null |
|
|
|||||
LEGAL_ENTITY_ID | NUMBER | 18 | null |
|
|
|||||
LEGAL_ENTITY_NAME | VARCHAR2 | 1000 | null |
|
|
|||||
LEGAL_ENTITY_ADDRESS | VARCHAR2 | 4000 | √ | null |
|
|
||||
LEGAL_ENTITY_PHONE | VARCHAR2 | 50 | √ | null |
|
|
||||
LEGAL_ENTITY_FAX | VARCHAR2 | 50 | √ | null |
|
|
||||
LEGAL_ENTITY_WEB | VARCHAR2 | 500 | √ | null |
|
|
||||
LEGAL_ENTITY_EMAIL | VARCHAR2 | 500 | √ | null |
|
|
||||
MET_PROGRAM_NAME | VARCHAR2 | 1000 | √ | null |
|
|
||||
MET_PROGRAM_DURATION | VARCHAR2 | 1000 | √ | null |
|
|
||||
UNIT | VARCHAR2 | 500 | √ | null |
|
|
||||
MET_PROGRAM_ACADEMIC_DEGREE | VARCHAR2 | 5 | √ | null |
|
|
||||
MET_PROGRAM_APPROVED_BY | VARCHAR2 | 1000 | √ | null |
|
|
||||
REFERENCE_NUMBER | VARCHAR2 | 13 | √ | null |
|
|
||||
STCW_REFERENCE_TYPE | VARCHAR2 | 4000 | √ | null |
|
|
||||
STCW_REFERENCE_REGULATION | VARCHAR2 | 250 | √ | null |
|
|
||||
STCW_CERT_COMPETENCY | VARCHAR2 | 4000 | √ | null |
|
|
||||
STCW_REFERENCE_ID | NUMBER | 18 | √ | null |
|
|