day1227

Tables (4)

Class (class)

  • Class_Num (class_num) — INT(2) — Primary key — NOT NULL
  • Coach_ID (coach_ID) — INT(10) — Foreign key → Coach.Coach_ID — NOT NULL
  • Area (area) — VARCHAR(10)
  • Curriculum (curriculum) — VARCHAR(10)

Coach (coach)

  • Coach_ID (coach_ID) — INT(10) — Primary key — NOT NULL
  • Task (task) — VARCHAR(30)

Consultant (consultant)

  • Consultant_ID (consultant_ID) — INT(10) — Primary key — NOT NULL
  • Class_Num (class_num) — INT(2) — Foreign key → Class.Class_Num — NOT NULL
  • Coach_ID (coach_ID) — INT(10) — Foreign key → Class.Coach_ID — NOT NULL
  • Task (task) — VARCHAR(30)

Student (student)

  • Student_ID (student_ID) — INT(10) — Primary key — NOT NULL
  • Class_Num (class_num) — INT(2) — Foreign key → Class.Class_Num — NOT NULL
  • Coach_ID (coach_ID) — INT(10) — Foreign key → Class.Coach_ID — NOT NULL
  • Cardinal (cardinal) — INT(2)
  • Discharge (discharge) — BOOLEAN