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