daily_1_엔티티추출
테이블 (6)
class (Entity5)
- class_id — INT — 기본 키 — NOT NULL
- consultant_id — INT — 외래 키 → consultant.consultant_id — NOT NULL
- region — VARCAHR(50)
- class — VARCHAR(10)
- coach_id — INT — 외래 키 → coach.coach_id — NOT NULL
coach (Entity3)
- coach_id — INT — 기본 키 — NOT NULL
- role — VARCHAR(50)
consultant (Entity2)
- consultant_id — INT — 기본 키 — NOT NULL
- role — VARCHAR(50)
curriculum (Entity4)
- cur_id — INT — 기본 키 — NOT NULL
- course — VARCHAR(50)
student (Entitiy1)
- student_id — INT — 기본 키 — NOT NULL
- class_id — INT — 외래 키 → class.class_id — NOT NULL
- consultant_id — INT — 외래 키 → class.consultant_id — NOT NULL
- session — INT
- is_major — INT
- is_student — INT
student_curriculum (Untitled)
- student_id — INT — 외래 키 → student.student_id — NOT NULL
- class_id — INT — 외래 키 → student.class_id — NOT NULL
- consultant_id — INT — 외래 키 → student.consultant_id — NOT NULL
- cur_id — INT — 외래 키 → curriculum.cur_id — NOT NULL