ssafy
Tables (6)
Area (area)
- Area_Id (area_id) — int — Primary key — NOT NULL
- Area_Name (area_name) — VARCHAR(255)
ClassRoom (classroom)
- ClassRoom_Id (ClassRoom_id) — int — Primary key — NOT NULL
- Consultant_Id (consultant_id2) — int — Foreign key → Consultant.Consultant_Id — NOT NULL
- Area_Id (area_id) — int — Foreign key → Area.Area_Id — NOT NULL
- Coach_Id (coach_id2) — int — Foreign key → Coach.Coach_Id — NOT NULL
Coach (coach)
- Coach_Id (coach_id) — int — Primary key — NOT NULL
- Coach_Work (coach_work) — VARCHAR(255)
- Coach_Class (coach_class) — VARCHAR(255)
Consultant (consultant)
- Consultant_Id (consultant_id) — int — Primary key — NOT NULL
- Consultant_Work (consultant_work) — VARCHAR(255)
- Consultant_Class (consultant_class) — VARCHAR(255)
Curriculum (curriculum)
- Curriculum_Id (curriculum_id) — int — Primary key — NOT NULL
- Curriculum_Name (curriculum_name) — VARCHAR(255)
Student (student)
- Student_Id (student_id) — int — Primary key — NOT NULL
- Curriculum_Id (curriculum_id2) — int — Foreign key → Curriculum.Curriculum_Id — NOT NULL
- ClassRoom_Id (ClassRoom_id) — int — Foreign key → ClassRoom.ClassRoom_Id — NOT NULL
- Consultant_Id (consultant_id2) — int — Foreign key → ClassRoom.Consultant_Id — NOT NULL
- Area_Id (area_id) — int — Foreign key → ClassRoom.Area_Id — NOT NULL
- Major (major) — int
- Remain (remain) — int
- Year (year) — int