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