ERDPractice
Tables (5)
Classes (Untitled4)
- Class ID (class_id) — int — Primary key — NOT NULL
- Education ID (education_id) — int — Foreign key → Educations.Education ID — NOT NULL
- Location (location) — VARCHAR(255)
- Section (section) — INT
Coaches (Untitled3)
- Coach ID (coach_id) — int — Primary key — NOT NULL
- Class ID (class_id2) — int — Foreign key → Classes.Class ID — NOT NULL
- Education ID (education_id) — int — Foreign key → Classes.Education ID — NOT NULL
- Rule (rule) — VARCHAR(255)
Cosultants (Untitled2)
- Consultant ID (consultant_id) — int — Primary key — NOT NULL
- Class ID (class_id) — int — Foreign key → Classes.Class ID — NOT NULL
- Education ID (education_id) — int — Foreign key → Classes.Education ID — NOT NULL
- Rule (rule) — VARCHAR(255)
Educations (Untitled5)
- Education ID (education_id) — int — Primary key — NOT NULL
- Education (education) — int
Students (Untitled)
- Student ID (student_id) — int — Primary key — NOT NULL
- Class ID (class_id) — int — Foreign key → Classes.Class ID — NOT NULL
- Education ID (education_id) — int — Foreign key → Classes.Education ID — NOT NULL
- Student Generation (student_generation) — INT
- Major (is_major) — BOOLEAN
- Entirement (is_entirement) — BOOLEAN