계절2

테이블 (7)

Batches

  • batch_id — INT — 기본 키
  • batch_name — VARCHAR(50) — NOT NULL

ClassCoaches

  • coach_id (coach_id2) — INT — 외래 키 → Coaches.coach_id
  • class_id (class_id2) — INT — 외래 키 → Classes.class_id

Classes

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

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
  • class_id — INT — 외래 키 → Classes.class_id

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
  • class_id — INT — 외래 키 → Classes.class_id
  • batch_id (batch_id2) — INT — 외래 키 → Batches.batch_id
  • course_id — INT — 외래 키 → Courses.course_id