Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
ROW_ID | NUMBER | 0 | √ | null |
|
|
||||
COUNTRY_GROUP | VARCHAR2 | 4000 | √ | null |
|
|
||||
COUNTRY_GROUP_ID | NUMBER | 18 | null |
|
|
|||||
COUNTRY_ID | NUMBER | 18 | 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 |
|
|
||||
STUDENT_YEAR | NUMBER | 18 | null |
|
|
|||||
STUDENT_N_GRADUATE | NUMBER | 18 | √ | null |
|
|
||||
STUDENT_N_ADMITTED | NUMBER | 18 | √ | null |
|
|
||||
MET_PROGRAM_NAME | VARCHAR2 | 1000 | √ | null |
|
|
||||
MET_PROGRAM_DURATION | VARCHAR2 | 1000 | √ | null |
|
|
||||
STCW_REFERENCE_ID_1 | NUMBER | 18 | null |
|
|
|||||
STCW_REFERENCE_REGULATION_1 | VARCHAR2 | 250 | √ | null |
|
|
||||
STCW_CERT_COMPETENCY_1 | VARCHAR2 | 4000 | √ | null |
|
|
||||
STCW_REFERENCE_TYPE_1 | VARCHAR2 | 4000 | √ | null |
|
|
||||
STCW_REFERENCE_ID_2 | NUMBER | 18 | √ | null |
|
|
||||
STCW_REFERENCE_REGULATION_2 | VARCHAR2 | 250 | √ | null |
|
|
||||
STCW_CERT_COMPETENCY_2 | VARCHAR2 | 4000 | √ | null |
|
|
||||
STCW_REFERENCE_TYPE_2 | VARCHAR2 | 4000 | √ | null |
|
|
||||
STCW_REFERENCE_ID_3 | NUMBER | 18 | √ | null |
|
|
||||
STCW_REFERENCE_REGULATION_3 | VARCHAR2 | 250 | √ | null |
|
|
||||
STCW_CERT_COMPETENCY_3 | VARCHAR2 | 4000 | √ | null |
|
|
||||
STCW_REFERENCE_TYPE_3 | VARCHAR2 | 4000 | √ | null |
|
|