필수PJT_02
테이블 (4)
Coach (coach)
- Coach_id — int(11) — 기본 키 — NOT NULL
- Last_Name (last_name) — varchar(255) — NOT NULL
- First_Name (first_name) — varchar(255) — NOT NULL
- Task (task) — varchar(255)
- Student_id (student_id) — int(11) — 외래 키 → Student.Student_id — NOT NULL
- Class_id (Class_id2) — int(2) — 외래 키 → Student.Class_id — NOT NULL
Consultant (consultant)
- Consultant_id (consultant_id) — int(11) — 기본 키 — NOT NULL
- Last_name (last_name) — varchar(255) — NOT NULL
- First_name (first_name) — varchar(255) — NOT NULL
- Task (task) — varchar(255)
- Student_id (student_id) — int(11) — 외래 키 → Student.Student_id — NOT NULL
- Class_id — int(2) — 외래 키 → Student.Class_id — NOT NULL
Curriculum (curriculum)
- Class_id — int(2) — 기본 키 — NOT NULL
- Class (class) — int(2) — NOT NULL
Student (student)
- Student_id (student_id) — int(11) — 기본 키 — NOT NULL
- Class_id — int(2) — 외래 키 → Curriculum.Class_id — NOT NULL
- Year (year) — int(2) — NOT NULL
- Last_Name (last_name) — varchar(255) — NOT NULL
- First_Name (first_name) — varchar(255) — NOT NULL
- Major (major) — bool — NOT NULL
- Enrollment (enrollment) — bool — NOT NULL
- Project (project) — varchar(255) — NOT NULL
- Area (area) — varchar(255) — NOT NULL