20221227

Tables (7)

campus (캠퍼스)

  • campus_id — LONG — Primary key — NOT NULL
  • name — ENUM

class (학급)

  • class_id — LONG — Primary key — NOT NULL
  • campus_id — LONG — Foreign key → campus.campus_id — NOT NULL
  • consultant_id — LONG — Foreign key → consultant.consultant_id — NOT NULL
  • coach_id — LONG — Foreign key → coach.coach_id — NOT NULL
  • ban — INT

coach (코치)

  • coach_id — LONG — Primary key — NOT NULL
  • name — VARCHAR

consultant (컨설턴트)

  • consultant_id — LONG — Primary key — NOT NULL
  • name — VARCHAR

curriculum (교육과정)

  • curriculum_id — LONG — Primary key — NOT NULL
  • type — ENUM

student (교육생)

  • student_id — LONG — Primary key — NOT NULL
  • curriculum_id — LONG — Foreign key → curriculum.curriculum_id — NOT NULL
  • campus_id — LONG — Foreign key → campus.campus_id — NOT NULL
  • class_id — LONG — Foreign key → class.class_id — NOT NULL
  • campus_id (campus_id2) — LONG — Foreign key → class.campus_id — NOT NULL
  • consultant_id — LONG — Foreign key → class.consultant_id — NOT NULL
  • coach_id — LONG — Foreign key → class.coach_id — NOT NULL
  • name — VARCHAR
  • number — VARCHAR
  • order — INT

task (업무)

  • task_id — LONG — Primary key — NOT NULL
  • consultant_id — LONG — Foreign key → consultant.consultant_id — NOT NULL
  • coach_id — LONG — Foreign key → coach.coach_id — NOT NULL
  • task_number — LONG
  • task_name — VARCHAR
  • content — VARCHAR