Daelim
Tables (6)
Advisor (student-professor)
- PROFNO (profno) — NUMBER(5) — Foreign key → Professor.PROFNO — NOT NULL
- STUDNO (studno) — NUMBER(5) — Foreign key → Student.STUDNO — NOT NULL
- GRADE (grade) — NUMBER(5)
- SEMESTER (semester) — NUMBER(5)
Course (수강)
- STUDNO (studno) — NUMBER(5) — Foreign key → Student.STUDNO — NOT NULL
- PROFNO (profno) — NUMBER(5) — Foreign key → Professor.PROFNO — NOT NULL
- CLASSNO (classno) — NUMBER(5) — Foreign key → LECTURE.CLASSNO
- ATTENDANCE (attendance) — NUMBER(5)
- MIDTERM (midterm) — NUMBER(5)
- FINAL (final) — NUMBER(5)
- EXTRA (extra) — NUMBER(5)
- TOTAL (total) — NUMBER(5)
- GRADE (grade) — VARCHAR2(20)
Department (department)
- DEPTNO (deptno) — NUMBER(5) — Primary key
- NAME (name) — VARCHAR2(20)
- TEL (tel) — VARCHAR2(13)
LECTURE (lecture)
- CLASSNO (classno) — NUMBER(5) — Primary key
- DEPTNO (deptno) — NUMBER(5) — Foreign key → Department.DEPTNO
- NAME (name) — VARCHAR2(20)
- CREDIT (credit) — NUMBER(5)
- TIME (time) — VARCHAR2(20)
- LOC (loc) — VARCHAR2(20)
- PROFNO (profno) — NUMBER(5) — Foreign key → Professor.PROFNO — NOT NULL
Professor (professor)
- PROFNO (profno) — NUMBER(5) — Primary key — NOT NULL
- NAME (name) — VARCHAR2(20)
- IDNUM (idnum) — VARCHAR2(13)
- ADDRESS (address) — VARCHAR2(20)
- TEL (tel) — VARCHAR2(13)
- EMAIL (email) — VARCHAR2(20)
- PROFILE (profile) — VARCHAR2(255)
- DEPTNO (deptno) — NUMBER(5) — Foreign key → Department.DEPTNO
Student (student)
- STUDNO (studno) — NUMBER(5) — Primary key — NOT NULL
- NAME (name) — VARCHAR2(20)
- IDNUM (idnum) — VARCHAR2(13)
- ADDRESS (address) — VARCHAR2(20)
- TEL (tel) — VARCHAR2(13)
- EMAIL (email) — VARCHAR2(20)
- PROFILE (profile) — VARCHAR2(255)
- DEPTNO (deptno) — NUMBER(5) — Foreign key → Department.DEPTNO
- PROFNO (profno) — NUMBER(5) — Foreign key → Professor.PROFNO — NOT NULL