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