Syllaverse

Tables (5)

course

  • course_id — INT
  • course_code — VARCHAR(10)
  • course_name — VARCHAR(50)
  • entity_type — ENUM('교양', '전공')

course_offering

  • course_offering_id — INT
  • year — INT
  • semester — ENUM('1학기', '여름학기', '2학기', '겨울학기')
  • professor_id — INT — Foreign key → professor.professor_id
  • course_id — INT — Foreign key → course.course_id

enrollment

  • enrollment_id — INT
  • student_id — INT — Foreign key → student.student_id
  • course_offering_id — INT — Foreign key → course_offering.course_offering_id

professor

  • professor_id — INT
  • name — VARCHAR(50)
  • email — VARCHAR(50)
  • department — VARCHAR(50)

student

  • student_id — INT
  • name — VARCHAR(50)
  • email — VARCHAR(50)
  • major — VARCHAR(50)