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)