daily1_1
Tables (9)
ClassCoaches
- coach_id — INT — Foreign key → Coaches.coach_id
- class_id — INT — Foreign key → Classes.class_id
ClassConsultants
- consultant_id — INT — Foreign key → Consultants.consultant_id
- class_id — INT — Foreign key → Classes.class_id
Classes
- class_id — INT — Primary key
- region — ENUM('서울', '대전', '구미', '광주', '부울경')
- class_number — INT
Coaches
- coach_id — INT — Primary key
- name — VARCHAR(100)
- task — VARCHAR(255)
Consultants
- consultant_id — INT — Primary key
- name — VARCHAR(100)
- task — VARCHAR(255)
Courses
- course_id — INT — Primary key
- course_type — ENUM('공통', '특화', '자율')
TraineeClasses
- trainee_id — INT — Foreign key → Trainees.trainee_id
- class_id — INT — Foreign key → Classes.class_id
TraineeCourses
- trainee_id — INT — Foreign key → Trainees.trainee_id
- course_id — INT — Foreign key → Courses.course_id
Trainees
- trainee_id — INT — Primary key
- name — VARCHAR(100)
- batch — INT
- major — ENUM('전공자', '비전공자')
- status — ENUM('재학', '퇴소')