SSAFY
Tables (5)
Class (class)
- Class_ID (cl_id) — INT(10) — Primary key — NOT NULL
- Consultent_ID (c_id) — INT(10) — Primary key
- Coach_ID (co_id) — INT(10) — Foreign key → Coach.Coach_ID — NOT NULL
- Class_ID (cl_id2) — INT(10) — Foreign key → Coach.Class_ID — NOT NULL
- Consultent_ID (c_id2) — INT(10) — Foreign key → Consultent.Consultent_ID — NOT NULL
- Area (area) — VARCHAR(20)
- ClassNum (classnum) — VARCHAR(20)
- Field
Coach (coach)
- Coach_ID (co_id) — INT(10) — Primary key — NOT NULL
- Class_ID (cl_id) — INT(10) — Primary key — NOT NULL
- Task (task) — VARCHAR(10)
Consultent (consultent)
- Consultent_ID (c_id) — INT(10) — Primary key — NOT NULL
- Task (task) — VARCHAR(10)
Curriculum (curriculum)
- Curriculum_ID (cu_id) — INT(10) — Primary key — NOT NULL
Student (student)
- Student_ID (s_id) — INT(10) — Primary key — NOT NULL
- Class_ID (cl_id2) — INT(10) — Foreign key → Class.Class_ID — NOT NULL
- Consultent_ID (c_id) — INT(10) — Foreign key → Class.Consultent_ID
- Coach_ID (co_id) — INT(10) — Foreign key → Class.Coach_ID — NOT NULL
- Class_ID (cl_id22) — INT(10) — Foreign key → Class.Class_ID — NOT NULL
- Consultent_ID (c_id2) — INT(10) — Foreign key → Class.Consultent_ID — NOT NULL
- Generate (generate) — INT(10)
- Major (major) — VARCHAR(20)
- Exit (exit) — VARCHAR(10)