MET_PROGRAMM

1855 rows


Description

This is a table for Met Programms. Stores Structure of the courses in Met Institution.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
MET_PROGRAMM_ID NUMBER 18 null
MET_PROGRAMM_DOCUMENT.MET_PROGRAMM_ID MET_PROGRAMM_DOC_FK1R
STUDENT.MET_PROGRAMM_ID STUDENT_MTP_FK2R
VIEW_BUSINESS_STU_PROGR.MET_PROGRAMM_ID Implied ConstraintR
VIEW_BUSINESS_STUDENTS.MET_PROGRAMM_ID Implied ConstraintR

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
ENUM_UNIT.ENUM_UNIT_ID MET_PROGRAMM_ENUM_UNIT_FK1R

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
STCW_REFERENCE.STCW_REFERENCE_ID MET_PROGRAMM_STCW_REFEREN_FK1R

Field Stcw Reference 1 ID. Stores foreign key to table stcw_reference in this record.

LEGAL_ENTITY_ID NUMBER 18 null
LEGAL_ENTITY.LEGAL_ENTITY_ID MET_PROGRAMM_LEGAL_ENTITY_FK1R

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
STCW_REFERENCE.STCW_REFERENCE_ID MET_PROGRAMM_S_FK2R

Field Stcw Reference 2 ID. Stores foreign key to table stcw_reference in this record.

STCW_REFERENCE_ID_3 NUMBER 18 null
STCW_REFERENCE.STCW_REFERENCE_ID MET_PROGRAMM_S_FK3R

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

Relationships