homework
Tables (7)
Class (class)
- Class Id (class_id) — INT — Primary key — NOT NULL
- Area (area) — VARCHAR(200)
- Class Num (class_num) — INT
Coach (coach)
- Coach Id (coach_id) — INT — Primary key — NOT NULL
- Class Id (class_id) — INT — Foreign key → Class.Class Id — NOT NULL
Consultant (consultant)
- Consultant Id (consultant_id) — INT — Primary key — NOT NULL
- Class Id (class_id) — INT — Foreign key → Class.Class Id — NOT NULL
Education (education)
- Education Id (education_id) — INT — Primary key — NOT NULL
- Class Id (class_id) — INT — Foreign key → Class.Class Id — NOT NULL
- Course (course) — VARCHAR(200)
Students (students)
- Student Id (Key) — Primary key — NOT NULL
- Class Id (class_id) — INT — Foreign key → Class.Class Id — NOT NULL
- School (school) — INT
- Is Majored (is_majored) — BOOLEAN
- Is Leaved (is_leaved) — BOOLEAN
Tasks By Coach (tasks_by_coach)
- Task Id (task_id) — INT — Primary key — NOT NULL
- Coach Id (coach_id) — INT — Foreign key → Coach.Coach Id — NOT NULL
- Class Id (class_id) — INT — Foreign key → Coach.Class Id — NOT NULL
Tasks By Consultant (tasks_by_consultant)
- Task Id (task_id) — INT — Primary key — NOT NULL
- Consultant Id (consultant_id) — INT — Foreign key → Consultant.Consultant Id — NOT NULL
- Class Id (class_id) — INT — Foreign key → Consultant.Class Id — NOT NULL