SSAFY

Tables (7)

City (city)

  • City ID (city_id) — INT(1) — Primary key — NOT NULL
  • City Name (city_name) — VARCHAR(10)

Class (classes)

  • Class ID (class_id) — INT(2) — Primary key — NOT NULL
  • City ID (city_id) — INT(1) — Foreign key → City.City ID — NOT NULL
  • Consultant ID (consultant_id) — VARCHAR(15) — Foreign key → Consultant.Consultant ID — NOT NULL
  • Coach ID (coach_id) — VARCHAR(15) — Foreign key → Coach.Coach ID — NOT NULL
  • Class Number (class_num) — INT(2)

Coach (coach)

  • Coach ID (coach_id) — VARCHAR(15) — Primary key — NOT NULL
  • Coach Name (coach_name) — VARCHAR(40)
  • Task ID (task_id) — INT(2) — Foreign key → Task.Task ID — NOT NULL

Consultant (consultant)

  • Consultant ID (consultant_id) — VARCHAR(15) — Primary key — NOT NULL
  • Consultant Name (consultant_name) — VARCHAR(40)
  • Task ID (task_id) — INT(2) — Foreign key → Task.Task ID — NOT NULL

Course (course)

  • Course ID (course_id) — INT(1) — Primary key — NOT NULL
  • Course Name (course_name) — VARCHAR(10)

Students (students)

  • Student Id (student_id) — VARCHAR(10) — Primary key — NOT NULL
  • Class ID (class_id) — INT(2) — Foreign key → Class.Class ID — NOT NULL
  • City ID (city_id) — INT(1) — Foreign key → Class.City ID — NOT NULL
  • Consultant ID (consultant_id) — VARCHAR(15) — Foreign key → Class.Consultant ID — NOT NULL
  • Coach ID (coach_id) — VARCHAR(15) — Foreign key → Class.Coach ID — NOT NULL
  • Course ID (course_id) — INT(1) — Foreign key → Course.Course ID — NOT NULL
  • Major (major) — TYPEINT(1)
  • Discharge (discharge) — TYPEINT(1)

Task (task)

  • Task ID (task_id) — INT(2) — Primary key — NOT NULL
  • Task Name (task_name) — VARCHAR(40)
  • Description (description) — VARCHAR(1000)
  • Complete (complete) — TYPEINT(1)