ERDPractice

Tables (5)

Classes (Untitled4)

  • Class ID (class_id) — int — Primary key — NOT NULL
  • Education ID (education_id) — int — Foreign key → Educations.Education ID — NOT NULL
  • Location (location) — VARCHAR(255)
  • Section (section) — INT

Coaches (Untitled3)

  • Coach ID (coach_id) — int — Primary key — NOT NULL
  • Class ID (class_id2) — int — Foreign key → Classes.Class ID — NOT NULL
  • Education ID (education_id) — int — Foreign key → Classes.Education ID — NOT NULL
  • Rule (rule) — VARCHAR(255)

Cosultants (Untitled2)

  • Consultant ID (consultant_id) — int — Primary key — NOT NULL
  • Class ID (class_id) — int — Foreign key → Classes.Class ID — NOT NULL
  • Education ID (education_id) — int — Foreign key → Classes.Education ID — NOT NULL
  • Rule (rule) — VARCHAR(255)

Educations (Untitled5)

  • Education ID (education_id) — int — Primary key — NOT NULL
  • Education (education) — int

Students (Untitled)

  • Student ID (student_id) — int — Primary key — NOT NULL
  • Class ID (class_id) — int — Foreign key → Classes.Class ID — NOT NULL
  • Education ID (education_id) — int — Foreign key → Classes.Education ID — NOT NULL
  • Student Generation (student_generation) — INT
  • Major (is_major) — BOOLEAN
  • Entirement (is_entirement) — BOOLEAN