sample1

Tables (4)

Class (class)

  • Class_Id (class_id) — INT(11) — Primary key — NOT NULL
  • Consultant_Id (consultant_id) — INT(11) — Foreign key → Consultant.Consultant_Id — NOT NULL
  • Coach_Id (coach_id) — INT(11) — Foreign key → Coach.Coach_Id — NOT NULL
  • Area (area) — VARCHAR(15)
  • Class (class) — VARCHAR(15)

Coach (coach)

  • Coach_Id (coach_id) — INT(11) — Primary key — NOT NULL
  • Task (task) — VARCHAR(15)

Consultant (consultant)

  • Consultant_Id (consultant_id) — INT(11) — Primary key — NOT NULL
  • Task (task) — VARCHAR(15)

Students (students)

  • Student_Id (student_id) — INT(11) — Primary key — NOT NULL
  • Class_Id (class_id) — INT(11) — Foreign key → Class.Class_Id — NOT NULL
  • Stage (stage) — INT(2)
  • On_Field (on_field) — Boolean
  • Curriculum (curriculum) — CHAR(2)
  • Discharged (discharged) — Boolean