ERD_Practice_SSAFY

Tables (6)

Class (class)

  • Class Id (class_id) — INT(7) — Primary key — NOT NULL

Coach (coach)

  • Coach Id (coach_id) — INT(7) — Primary key — NOT NULL
  • Coach Task (coach_task) — VARCHAR(255)

Consultant (consultant)

  • Consultant Id (consultant_id) — INT(7) — Primary key — NOT NULL
  • Consultant Task (consultant_task) — VARACHAR(255)

Curriculum (curriculum)

  • Curriculum Id (curriculum_id) — INT(7) — Primary key — NOT NULL

Location (location)

  • Location Id (location_id) — INT(7) — Primary key — NOT NULL

Student (student)

  • Student id (student_id) — INT(7) — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Location (location) — VARCHAR(255)
  • Order (order) — INT(4)
  • Major (major) — VARCHAR(255)
  • Retirement (retirement) — INT(2)
  • Consultant Id (consultant_id) — INT(7) — Foreign key → Consultant.Consultant Id — NOT NULL
  • Coach Id (coach_id) — INT(7) — Foreign key → Coach.Coach Id — NOT NULL
  • Location Id (location_id) — INT(7) — Foreign key → Location.Location Id — NOT NULL
  • Class Id (class_id) — INT(7) — Foreign key → Class.Class Id — NOT NULL
  • Curriculum Id (curriculum_id) — INT(7) — Foreign key → Curriculum.Curriculum Id — NOT NULL