SSAFY
Tables (5)
class (Untitled4)
- Class (class) — int(2) — Primary key — NOT NULL
- Coach_id (coach_id) — int(7) — Foreign key → coaches.Coach_id — NOT NULL
- Consultant_id (consultant_id) — int(7) — Foreign key → consultants.Consultant_id — NOT NULL
- Area (area) — VARCHAR(255)
- Field
coaches (Untitled2)
- Coach_id (coach_id) — int(7) — Primary key — NOT NULL
- Class_in_charge (class_in_charge) — int(2)
- Coach_name (coaches_name) — VARCHAR(255)
- Coaches_task (coach_task) — VARCHAR(255) — NOT NULL
- Field
consultants (CopyOfUntitled2)
- Consultant_id (consultant_id) — int(7) — Primary key — NOT NULL
- Consultant_name (consultant_name) — VARCHAR(255)
- Consultants_task (consultant_task) — VARCHAR(255)
- Class_in_charge (class_in_charge) — int(2)
- Field
section (Untitled3)
- Section_version (section_version) — VARCHAR(255) — Primary key — NOT NULL
- Field
students (Untitled)
- Student_id (student_id) — int(7) — Primary key — NOT NULL
- Consultant_id (consultant_id) — int(7) — Foreign key → consultants.Consultant_id — NOT NULL
- Coach_id (coach_id) — int(7) — Foreign key → coaches.Coach_id — NOT NULL
- Area (area) — VARCHAR(255)
- Class (class) — int(2)
- Student_name (student_name) — VARCHAR(255)
- Student_major (student_major) — boolean
- Students_period (students_period) — int(2)
- Students_finished (student_finished) — boolean
- Field