temp
Tables (7)
Class
- class_id — INT — Primary key
- region — VARCHAR(10) — NOT NULL
- class_number — INT — NOT NULL
- consultant_id — INT — NOT NULL
- coach_id — INT
Class_Course
- class_id — INT — Primary key
- course_id — INT — Primary key
- class_id (class_id2) — INT — Foreign key → Class.class_id
Coach
- coach_id — INT — Primary key
- class_id — INT — Foreign key → Class.class_id
- name — VARCHAR(50) — NOT NULL
- duty — VARCHAR(100) — NOT NULL
Consultant
- consultant_id — INT — Primary key
- class_id — INT — Foreign key → Class.class_id
- name — VARCHAR(50) — NOT NULL
- duty — VARCHAR(100) — NOT NULL
Course
- course_id — INT — Primary key
- class_id — INT — Foreign key → Class_Course.class_id
- course_id (course_id2) — INT — Foreign key → Class_Course.course_id
- class_id (class_id2) — INT — Foreign key → Class_Course.class_id
- type — VARCHAR(10) — NOT NULL
Generation
- generation_id — INT — Primary key
- name — VARCHAR(50) — NOT NULL
Student
- student_id — INT — Primary key
- class_id (class_id2) — INT — Foreign key → Class.class_id
- generation_id (generation_id2) — INT — Foreign key → Generation.generation_id
- name — VARCHAR(50) — NOT NULL
- is_major — BOOLEAN — NOT NULL
- is_dropped — BOOLEAN — NOT NULL
- generation_id — INT — NOT NULL
- class_id — INT — NOT NULL