SW#7_1334343
Tables (6)
Class
- class_id — INT — Primary key — NOT NULL
- region — ENUM('서울', '대전', '구미', '광주', '부울경') — NOT NULL
- class_number — INT — NOT NULL
- curriculum_type — ENUM('공통', '특화', '자율') — NOT NULL
- UNIQUE(region, — class_number)
- consultant_id — INT — Foreign key → Consultant.consultant_id — NOT NULL
- coach_id — INT — Foreign key → Coach.coach_id — NOT NULL
- student_id — INT — Foreign key → Student.student_id — NOT NULL
Coach
- coach_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- task — VARCHAR(100)
- class_id — INT — Foreign key → Class.class_id — NOT NULL
Coach_Assign
- class_id — INT
- coach_id — INT
Consultant
- consultant_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- task — VARCHAR(100)
Consultant_Assign
- class_id — INT
- consultant_id — INT
Student
- student_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- is_major — BOOLEAN — NOT NULL
- is_dropout — BOOLEAN — NOT NULL
- cohort — INT — NOT NULL
- class_id — INT