pratice

Tables (6)

Coach (coach)

  • Coach Num (coach_num) — INT(10) — Primary key — NOT NULL
  • Class Num (class_num) — INT(10) — Foreign key → Class.Class Num — NOT NULL
  • Name (name) — VARCHAR(10)
  • Duty (duty) — VARCHAR(10)

Curriculum (curriculum)

  • Curriculum Num (curriculum_num) — INT(10) — Primary key — NOT NULL
  • Name (name) — VARCHAR(10) — NOT NULL

Class (class)

  • Class Num (class_num) — INT(10) — Primary key — NOT NULL
  • Location (location) — VARCHAR(10)
  • Class (class) — INT(10)

Consultant (consultant)

  • Consultant Num (consultant_num) — INT(10) — Primary key — NOT NULL
  • Class Num (class_num) — INT(10) — Foreign key → Class.Class Num — NOT NULL
  • Name (name) — VARCHAR(10)
  • Duty (duty) — VARCHAR(10)

Student (student)

  • Student Num (student_num) — INT(10) — Primary key — NOT NULL
  • Curriculum Num (curriculum_num) — INT(10) — Foreign key → Curriculum.Curriculum Num — NOT NULL
  • Class Num (class_num) — INT(10) — Foreign key → Class.Class Num — NOT NULL
  • Generation (generation) — INT(10)
  • Major (major) — VARCHAR(10)
  • Expulsion (expulsion) — BOOLEAN

Untitled

  • Coach Num (coach_num) — INT(10) — Foreign key → Coach.Coach Num — NOT NULL
  • Class Num (class_num) — INT(10) — Foreign key → Coach.Class Num — NOT NULL