erd-practice

테이블 (3)

과목 (subject)

  • cor_id (course id) — INT UNSIGNED — 기본 키
  • sub_name (Key) — VARCHAR(50) — NOT NULL
  • sub_room (subject room) — VARCHAR(10)
  • sub_day (day) — ENUM('Monday', 'Tuesday', 'Wendesday', 'Thursday', 'Friday')
  • sub_pro (subject professor) — VARCHAR(30)

수강 (course)

  • cor_id (course id2) — INT UNSIGNED — 외래 키 → 과목.cor_id
  • std_id (student id) — INT UNSIGNED — 외래 키 → 학생.std_id — NOT NULL
  • cor_term (course term) — ENUM('1학기', '계절(여름)', '2학기', '계절(겨울)') — NOT NULL
  • cor_score (course score) — ENUM('A', 'B', 'C', 'D', 'F')

학생 (student)

  • std_id (student id) — INT UNSIGNED — 기본 키 — NOT NULL
  • std_name (student name) — VARCHAR(50)
  • std_major (student major) — VARCHAR(30)
  • std_grade (student grade) — ENUM('1', '2', '3', '4', '그 외')