practice

Tables (4)

Class (class)

  • Class ID (class_id) — INT — Primary key — NOT NULL
  • Location (location) — ENUM('서울', '대전', '구미', '광주', '부울경'
  • Class Number (class_number) — INT

Coach (coach)

  • Coach ID (coach_id) — INT — Primary key — NOT NULL
  • Class ID (class_id) — INT — Foreign key → Class.Class ID — NOT NULL
  • Name (name) — VARCHAR(15)
  • Task (task) — VARCHAR(100)

Consultant (consultant)

  • Consultant ID (consultant_id) — INT — Primary key — NOT NULL
  • Class ID (class_id) — INT — Foreign key → Class.Class ID — NOT NULL
  • Task (task) — VARCHAR(100)

Student (student)

  • Student_ID (student_id) — INT — Primary key — NOT NULL
  • Class ID (class_id) — INT — Foreign key → Class.Class ID — NOT NULL
  • Name (name) — VARCHAR(15)
  • Major (is_major) — TINYINT(1)
  • Graduated (is_graduated) — TINYINT(1)
  • Generation (generation) — INT
  • Course (course) — ENUM('공통', '특화', '자율')