test

Tables (4)

Coach (Untitled3)

  • coach_id — INT(10) — Primary key — NOT NULL
  • Task (task) — CHAR(100)

Consultant (Untitled2)

  • Consultant_Id (consultant_id) — INT(10) — Primary key — NOT NULL
  • Task (task) — CHAR(100)

Group (Untitled4)

  • Group_Id (group_id) — INT(10) — Primary key — NOT NULL
  • Consultant_Id (consultant_id) — INT(10) — Foreign key → Consultant.Consultant_Id — NOT NULL
  • coach_id — INT(10) — Foreign key → Coach.coach_id — NOT NULL

Student (Untitled)

  • Student_id (student_id) — INT(10) — Primary key — NOT NULL
  • Major (major) — BOOLEAN
  • Completion (completion) — BOOLEAN
  • Ordinal Number (ordinal Number) — INT(10)
  • Location (location) — CHAR(100)
  • Course (course) — CHAR(10)
  • Group_Id (group_id) — INT(10) — Foreign key → Group.Group_Id — NOT NULL