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