STUDENT

1227 rows


Description

This is a table for Students. Stores Number of admitted and graduated students per MET Program.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
STUDENT_ID NUMBER 18 null

Field Student ID. Stores primary key for this table.

YEAR NUMBER 18 null

Field Year. Stores year of the students in a programm.

N_GRADUATE NUMBER 18 null

Field Number Graduate. Stores number of graduated students in a programm.

N_ADMITTED NUMBER 18 null

Field Number Admitted. Stores number of admitted students in a programm.

LEGAL_ENTITY_ID NUMBER 18 null
LEGAL_ENTITY.LEGAL_ENTITY_ID STUDENT_LEGAL_ENTITY_FK1R

Field Legal Entity ID. Stores the met instituion of this record, foreign key to table legal_entity.

ACADEMIC_DEGREE NUMBER 1 null

Field Academic Degree. Stores if the students have academic degree.

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.

MET_PROGRAMM_ID NUMBER 18 null
MET_PROGRAMM.MET_PROGRAMM_ID STUDENT_MTP_FK2R

Field Met Programm ID. Stores the met programm of these students, foreign key to table met_programm.

Indexes

Constraint Name Type Sort Column(s)
STUDENT_PK Primary key Asc STUDENT_ID

Relationships