CodingTest
Tables (4)
Classes (class)
- Class Id (class_id) — INT — Primary key — NOT NULL
- Area (area) — Enum
- Class (class) — Enum
- Curriculum (curriculum) — Enum
Coaches (coaches)
- Coach Id (coach_id) — INT — Primary key — NOT NULL
- Class Id (class_id2) — INT — Foreign key → Classes.Class Id — NOT NULL
- Class Id (class_id) — INT
- Work (word) — Work
Consultants (consultants)
- Consultants Id (consultants_id) — INT — Primary key — NOT NULL
- Class Id (class_id2) — INT — Foreign key → Classes.Class Id — NOT NULL
- Class Id (class_id) — INT
- Work (work) — Work
Student (students)
- Student Id (student_id) — INT(7) — Primary key — NOT NULL
- Class Id (class_id2) — INT — Foreign key → Classes.Class Id — NOT NULL
- Cardinal Number (cardinal_number) — DECIMAL(10,2)
- Major (major) — DECIMAL(10,2)
- Retire (retire) — DECIMAL(10,2)
- Class Id (class_id) — INT