Education

Tables (7)

Charge (charge)

  • Charge Id (charge_id) — INT(11) — Primary key — NOT NULL
  • Consultant Id (consultant_id) — INT(11) — Foreign key → Consultant.Consultant Id — NOT NULL
  • Class Id (class_id) — INT(11) — Foreign key → Consultant.Class Id — NOT NULL
  • Coach Id (coach_id) — INT(11) — Foreign key → Coach.Coach Id — NOT NULL
  • Class Id (class_id2) — INT(11) — Foreign key → Coach.Class Id — NOT NULL

Class Room (class_room)

  • Class Id (class_id) — INT(11) — Primary key — NOT NULL
  • Area (area) — VARCHAR(20)
  • Class Num (class_num) — INT(11)

Coach (coach)

  • Coach Id (coach_id) — INT(11) — Primary key — NOT NULL
  • Class Id (class_id) — INT(11) — Foreign key → Class Room.Class Id — NOT NULL
  • Name (name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)

Consultant (consultant)

  • Consultant Id (consultant_id) — INT(11) — Primary key — NOT NULL
  • Class Id (class_id) — INT(11) — Foreign key → Class Room.Class Id — NOT NULL
  • Name (name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)

Curriculum (curriculum)

  • Curriculum Id (curriculum_id) — INT(11) — Primary key — NOT NULL
  • Process (process) — ENUM('공통', '특화', '자율'))

Responsibilities (responsibilities)

  • Responsibilities Id (responsibilities_id) — INT(11) — Primary key — NOT NULL
  • Charge Id (charge_id) — INT(11) — Foreign key → Charge.Charge Id — NOT NULL
  • Coach Id (coach_id) — INT(11) — Foreign key → Charge.Coach Id — NOT NULL
  • Class Id (class_id2) — INT(11) — Foreign key → Charge.Class Id — NOT NULL
  • Task Name (task_name) — VARCHAR(255)

Student (student)

  • Student Id (student_id) — INT(11) — Primary key — NOT NULL
  • Class Id (class_id) — INT(11) — Foreign key → Class Room.Class Id — NOT NULL
  • Cardinal Number (cardinal_number) — INT(11)
  • Is Major (is_major) — ENUM('1', '0')
  • Is Discharge (is_discharge) — ENUM('1', '0')
  • Name (name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)