classify2
Tables (6)
class_timetable_junction
- # — many
- timetable_id — INT — NOT NULL
- class_id — INT — NOT NULL
lesson
- class_id — INT
- class_name — VARCHAR(10) — NOT NULL
- teacher_id — MEDIUMINT
- classroom — VARCHAR(20)
- weekday — TINYINT — NOT NULL
- # — 1이
- 2가 — 화요일... — NOT NULL
school
- school_id — SMALLINT
- school_name — VARCHAR(21) — NOT NULL
student
- student_id — MEDIUMINT
- # — DB상 — NOT NULL
- #교육청 — ID
- 처리 — 속도를 — NOT NULL
- # — 학교
- 학교별로 — 중복되므로
teacher
- teacher_id — MEDIUMINT — NOT NULL
- teacher_name — VARCHAR(50) — NOT NULL
- school_id — SMALLINT
timetable
- timetable_id — MEDIUMINT
- student_id — MEDIUMINT — NOT NULL