edu_erd

Tables (5)

Class (class)

  • Class Id (class_id) — INT(11) — Primary key — NOT NULL
  • Consultant Id (cons_id) — INT(11) — Foreign key → Consultant.Consultant Id — NOT NULL
  • Coach Id (coach_id) — INT(11) — Foreign key → Coach.Coach Id — NOT NULL
  • Region (region) — VARCHAR(255)
  • Number (number) — INT(1)

Coach (coach)

  • Coach Id (coach_id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Job (job) — VARCHAR(255)

Consultant (consultant)

  • Consultant Id (cons_id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Job (job) — VARCHAR(255)

Student (student)

  • Student Id (stu_id) — INT(11) — Primary key — NOT NULL
  • Class Id (class_id) — INT(11) — Foreign key → Class.Class Id — NOT NULL
  • Consultant Id (cons_id) — INT(11) — Foreign key → Class.Consultant Id — NOT NULL
  • Coach Id (coach_id) — INT(11) — Foreign key → Class.Coach Id — NOT NULL
  • Period (period) — INT(10)
  • Major (major) — TINYINT
  • Retirement (retire) — TINYINT

Track (track)

  • Track Name (track_name) — VARCHAR(10) — Primary key — NOT NULL