test

Tables (7)

Batches

  • batch_id — INT
  • batch_name — VARCHAR(50) — NOT NULL

ClassCoaches

  • class_coach_id — INT
  • class_id — INT — NOT NULL
  • coach_id — INT — NOT NULL

Classes

  • batch_id — INT — NOT NULL
  • class_id — INT
  • region — ENUM('서울', '대전', '구미', '광주', '부울경') — NOT NULL

Coaches

  • coach_id — INT
  • name — VARCHAR(100) — NOT NULL
  • task_description — TEXT

Consultants

  • consultant_id — INT
  • name — VARCHAR(100) — NOT NULL
  • task_description — TEXT

Courses

  • course_id — INT
  • course_type — ENUM('공통', '특화', '자율') — NOT NULL

Students

  • student_id — INT
  • name — VARCHAR(100) — NOT NULL
  • is_major — BOOLEAN — NOT NULL
  • is_graduated — BOOLEAN — NOT NULL
  • class_id — INT — NOT NULL