self-project

Tables (4)

Class (class)

  • Student id (student_id2) — VARCHAR(11) — Foreign key → Student.Student_id — NOT NULL
  • Coach_id (coach_id) — VARCHAR(11) — Foreign key → Coach.Coach_id — NOT NULL
  • Consultant_id (consultant_id) — VARCHAR(11) — Foreign key → Consultant.Consultant_id — NOT NULL
  • Area (area) — VARCHAR(11)
  • Class (class) — INT(1)

Coach (coach)

  • Coach_id (coach_id) — VARCHAR(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(11)
  • Task (task) — VARCHAR(11)

Consultant (consultant)

  • Consultant_id (consultant_id) — VARCHAR(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(11)
  • Task (task) — VARCHAR(11)
  • Class (class) — INT(1)

Student (student)

  • Student_id (student_id) — VARCHAR(11) — Primary key — NOT NULL
  • Pass (pass) — VARCHAR(11)
  • Name (name) — VARCHAR(11)
  • Th (th) — INT(2)
  • Major (major) — VARCHAR(5)
  • Out (out) — VARCHAR(3)
  • Curriculum (curriculum) — VARCHAR(3)