ERD_Practice_SSAFY
Tables (6)
Class (class)
- Class Id (class_id) — INT(7) — Primary key — NOT NULL
Coach (coach)
- Coach Id (coach_id) — INT(7) — Primary key — NOT NULL
- Coach Task (coach_task) — VARCHAR(255)
Consultant (consultant)
- Consultant Id (consultant_id) — INT(7) — Primary key — NOT NULL
- Consultant Task (consultant_task) — VARACHAR(255)
Curriculum (curriculum)
- Curriculum Id (curriculum_id) — INT(7) — Primary key — NOT NULL
Location (location)
- Location Id (location_id) — INT(7) — Primary key — NOT NULL
Student (student)
- Student id (student_id) — INT(7) — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- Location (location) — VARCHAR(255)
- Order (order) — INT(4)
- Major (major) — VARCHAR(255)
- Retirement (retirement) — INT(2)
- Consultant Id (consultant_id) — INT(7) — Foreign key → Consultant.Consultant Id — NOT NULL
- Coach Id (coach_id) — INT(7) — Foreign key → Coach.Coach Id — NOT NULL
- Location Id (location_id) — INT(7) — Foreign key → Location.Location Id — NOT NULL
- Class Id (class_id) — INT(7) — Foreign key → Class.Class Id — NOT NULL
- Curriculum Id (curriculum_id) — INT(7) — Foreign key → Curriculum.Curriculum Id — NOT NULL