7기_서울2반_김헤수
테이블 (5)
Class (Untitled3)
- Num (num) — BIGINT(11) — 기본 키 — NOT NULL
- Local (local) — VARCHAR(255)
- ClassNum (class_num) — BIGINT(11)
- CoachID (coach_id2) — BIGINT(11) — 외래 키 → Coach.CoachID — NOT NULL
Coach (Entity2)
- CoachID (coach_id) — BIGINT(11) — 기본 키 — NOT NULL
- FirstName (first_name) — VARCHAR(255)
- LastName (last_name) — VARCHAR(255)
- Work (work) — VARCHAR(255)
Consultant (Untitled2)
- ConsultantID (consultant_id) — BIGINT(11) — 기본 키 — NOT NULL
- Num (num) — BIGINT(11) — 외래 키 → Class.Num — NOT NULL
- FirstName (first_name) — VARCHAR(255)
- LastName (last_name) — VARCHAR(255)
- Work (work) — VARCHAR(255)
Student (Entity1)
- StudentID (student_id) — BIGINT(11) — 기본 키 — NOT NULL
- Num (num) — BIGINT(11) — 외래 키 → Class.Num — NOT NULL
- Generation (generation) — BIGINT(11)
- Major (major) — CHAR(1)
- Exit (exit) — CHAR(1)
교육과정 (Untitled4)
- EduNum (edu_num) — BIGINT(11) — 기본 키 — NOT NULL
- StudentID (student_id) — BIGINT(11) — 외래 키 → Student.StudentID — NOT NULL
- Num (num2) — BIGINT(11) — 외래 키 → Student.Num — NOT NULL
- EduName (edu_name) — VARCHAR(255)
- Edutype (edu_type) — VARCHAR(255)