hw_erd

Tables (6)

Batches (Untitled3)

  • batch_id — INT — Primary key — NOT NULL
  • batch_name (Field)

ClassCoaches (Untitled6)

  • class_coach_id — INT — Primary key — NOT NULL
  • class_id — INT — Foreign key → Classes.class_id — NOT NULL
  • batch_id — INT — Foreign key → Classes.batch_id — NOT NULL

Classes (Untitled2)

  • class_id — INT — Primary key — NOT NULL
  • batch_id — INT — Foreign key → Batches.batch_id — NOT NULL
  • region — ENUM('서울', '대전', '구미', '광주', '부울경')

Consultants (Untitled5)

  • consultant_id — INT — Primary key — NOT NULL
  • class_id — INT — Foreign key → Classes.class_id — NOT NULL
  • batch_id — INT — Foreign key → Classes.batch_id — NOT NULL
  • name — VARCHAR(100)
  • task_description — TEXT

Coures (Untitled4)

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

Students (Untitled)

  • student_id — INT — Primary key — NOT NULL
  • class_id — INT — Foreign key → Classes.class_id — NOT NULL
  • batch_id — INT — Foreign key → Classes.batch_id — NOT NULL
  • name (Field) — VARCHAR(100)