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', '그 외')