01

Tables (5)

Class (class)

  • Class ID (class_id) — Primary key — NOT NULL
  • Region (region)
  • Class Number (class_num)

Coach (coach)

  • Coach ID (coach_id) — Primary key — NOT NULL
  • Class ID (class_id) — Foreign key → Class.Class ID — NOT NULL

Consultant (consultant)

  • Consultant ID (consultant_id) — Primary key — NOT NULL
  • Class ID (class_id) — Foreign key → Class.Class ID — NOT NULL
  • Field

Course (course)

  • Course Name (course_name) — Primary key — NOT NULL
  • Class ID (class_id) — Foreign key → Class.Class ID — NOT NULL

Student (student)

  • ID (id) — Primary key — NOT NULL
  • Year (year)
  • Major (major) — Bool
  • Discharge (discharge)
  • Class ID (class_id) — Foreign key → Class.Class ID — NOT NULL
  • Name (name)