10기_서울12반_김성수_ERD.PNG
테이블 (5)
classes (Untitled3)
- class_id (pk) — INT — 기본 키 — NOT NULL
- choach_id (pk2) — INT — 외래 키 → coaches.choach_id — NOT NULL
- consultant_id (pk3) — INT — 외래 키 → consultants.consultant_id — NOT NULL
- region (field) — varchar
- class_num (Field2) — INT
coaches (Untitled2)
- choach_id (pk) — INT — 기본 키 — NOT NULL
- class_id (fk) — INT
consultants (Untitled)
- consultant_id (pk) — INT — 기본 키 — NOT NULL
- class_id (fk) — INT
student_courses (Untitled4)
- course_id (pk) — INT — 기본 키 — NOT NULL
- student_id (pk2) — INT — 외래 키 → students.studentId — NOT NULL
- course_type (Field) — ENUM('공통','특화','자율')
students (교육생테이블)
- studentId (pk) — INT — 기본 키 — NOT NULL
- magor_status (Field) — ENUM('전공','비전공')
- withdrawal_status (Field2) — ENUM('재학','퇴소')
- year_status(기수) (기수) — INT
- course_id (fk) — varchar