계절

테이블 (7)

Batches

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

ClassCoaches

  • class_id — INT
  • coach_id — INT

Classes

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

Coaches

  • coach_id — INT
  • name — VARCHAR(100) — NOT NULL
  • task — VARCHAR(255) — NOT NULL

Consultants

  • consultant_id — INT
  • name — VARCHAR(100) — NOT NULL
  • task — VARCHAR(255) — NOT NULL

Courses

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

Students

  • student_id — INT
  • name — VARCHAR(100) — NOT NULL
  • major — ENUM('전공자', '비전공자') — NOT NULL
  • status — ENUM('재학중', '퇴소') — NOT NULL
  • batch_id — INT