course-registration
Tables (6)
COURSE (강의)
- 강의ID (course_id) — INTEGER — Primary key — NOT NULL
- 교수ID (prof_id) — INTEGER — Foreign key → PROFESSOR.교수ID — NOT NULL
- 강의명 (name) — VARCHAR(40)
- 강의시간 (time) — TIME
DEPARTMENT (학부)
- 학부ID (dept_id) — INTEGER — Primary key — NOT NULL
- 학부명 (name) — VARCHAR(30)
ENROLLMENT (수강신청)
- 등록ID (enroll_id) — INTEGER — Primary key — NOT NULL
- 학생ID (student_id) — INTEGER — Foreign key → STUDENT.학생ID
- 강의ID (course_id) — INTEGER — Foreign key → COURSE.강의ID — NOT NULL
- 등록시간 (date) — DATE
MAJOR (학과)
- 전공ID (major_id) — INTEGER — Primary key — NOT NULL
- 학부ID (dept_id) — INTEGER — Foreign key → DEPARTMENT.학부ID — NOT NULL
- 전공명 (name) — VARCHAR(20)
PROFESSOR (교수)
- 교수ID (prof_id) — INTEGER — Primary key — NOT NULL
- 전공ID (major_id) — INTEGER — Foreign key → MAJOR.전공ID — NOT NULL
- 교수명 (name) — VARCHAR(40)
STUDENT (학생)
- 학생ID (student_id) — INTEGER — Primary key
- 전공ID (major_id) — INTEGER — Foreign key → MAJOR.전공ID — NOT NULL
- 학생명 (student_name) — VARCHAR(40) — NOT NULL
- 학년 (grade) — ENUM — NOT NULL
- 상태 (status) — ENUM — NOT NULL