SSAFY
Tables (5)
class (Untitled)
- class_id (Key) — int — Primary key — NOT NULL
- coach_id (Key2) — int — Foreign key → coach.coach_id — NOT NULL
- region (Field) — varchar
- class_number (Field2) — int
- generation (Field3) — int
coach (Untitled3)
- coach_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
- position (Field2) — varchar
consultant (Untitled2)
- consultant_id (Key) — int — Primary key — NOT NULL
- class_id (Key2) — int — Foreign key → class.class_id — NOT NULL
- coach_id (Key22) — int — Foreign key → class.coach_id — NOT NULL
- name (Field) — varchar
- position (Field2) — varchar
course (Untitled4)
- course_id (Key) — int — Primary key — NOT NULL
- class_id (Key2) — int — Foreign key → class.class_id — NOT NULL
- coach_id (Key22) — int — Foreign key → class.coach_id — NOT NULL
- course_type (Field) — varchar
student (Student)
- student_id (Key) — int — Primary key — NOT NULL
- class_id (Key2) — int — Foreign key → class.class_id — NOT NULL
- coach_id (Key22) — int — Foreign key → class.coach_id — NOT NULL
- name (Field) — varchar
- generation (Field2) — int
- is_major (Field3) — boolean
- is_joined (Field4) — boolean