SW#7 1228092
Tables (9)
class
- class_id — INT
- region_id — INT
- class_number — INT
class_coach
- class_id — INT
- coach_id — INT
class_consultant
- class_id — INT
- consultant_id — INT
coach
- coach_id — INT
- name — VARCHAR(50)
- duty — VARCHAR(100)
consultant
- consultant_id — INT
- name — VARCHAR(50)
- duty — VARCHAR(100)
course
- course_id — INT
- type — VARCHAR(20)
generation
- generation_id — INT
- name — VARCHAR(50) — NOT NULL
region
- region_id — INT
- name — VARCHAR(20)
student
- student_id — INT
- name — VARCHAR(50)
- generation_id — INT
- class_id — INT
- is_major — BOOLEAN
- is_dropped — BOOLEAN