SSAFY

Tables (5)

Class (Entity4)

  • Class ID (class_id) — INT(7) — Primary key — NOT NULL
  • Location (location) — VARCHAR(10)
  • Class Number (class_number) — INT(3)

Coach (Entity3)

  • Coach ID (coach_id) — INT(7) — Primary key — NOT NULL
  • Class ID (class_id) — INT(7) — Foreign key → Class.Class ID — NOT NULL
  • Name (name) — VARCHAR(20)
  • Task (task) — VARCHAR(255)

Consultant (Entity2)

  • Consultant ID (consultant_id) — INT(7) — Primary key — NOT NULL
  • Class ID (class_id) — INT(7) — Foreign key → Class.Class ID — NOT NULL
  • Name (name) — VARCHAR(20)
  • Task (task) — VARCHAR(255)

Course (Entity5)

  • Course ID (course_id) — INT(10) — Primary key — NOT NULL
  • Course (course) — VARCHAR(20)

Student (Entity1)

  • Student ID (student_id) — INT(7) — Primary key — NOT NULL
  • Class ID (class_id) — INT(7) — Foreign key → Class.Class ID — NOT NULL
  • Course ID (course_id) — INT(10) — Foreign key → Course.Course ID — NOT NULL
  • Name (name) — VARCHAR(20)
  • Ordinal Numbers (ordinal_numbers) — INT(2)
  • Major (major) — CHAR(1)
  • Retire (retire) — CHAR(1)