ssssaffy
Tables (7)
class
- class_id — INT
- gisu_id — INT — Foreign key → gisu.gisu_id — NOT NULL
- region — VARCHAR(6) — NOT NULL
- class_number — INT — NOT NULL
- consultant_id — INT — Foreign key → consultant.consultant_id — NOT NULL
- coach_id — INT — Foreign key → coach.coach_id
coach
- coach_id — INT
- work_id — INT — Foreign key → work.work_id — NOT NULL
- work_detail — VARCHAR(250) — NOT NULL
consultant
- consultant_id — INT
- work_id — INT — Foreign key → work.work_id — NOT NULL
- work_detail — VARCHAR(250) — NOT NULL
course
- course_id — INT
- course_name — VARCHAR(10) — NOT NULL
gisu
- gisu_id — INT
- course_id — INT — Foreign key → course.course_id — NOT NULL
- gisu — INT — NOT NULL
student
- student_id — INT
- class_id — INT — Foreign key → class.class_id — NOT NULL
- is_major — TINYINT(1) — NOT NULL
- is_out — INT — NOT NULL
work
- work_id — INT
- work_detail — VARCHAR(250) — NOT NULL