ssafy

Tables (6)

Class

  • Class_id (class_id) — INT(11) — Primary key — NOT NULL
  • Consultant_id (consultant_id) — INT(11) — Foreign key → Consultant.Consultant_id — NOT NULL
  • Coach_id (coach_id) — INT(11) — Foreign key → Coach.Coach_id — NOT NULL
  • Course_id (course_id) — INT(11) — Foreign key → Course.Course_id — NOT NULL
  • region
  • class_num

Coach

  • Coach_id (coach_id) — INT(11) — Primary key — NOT NULL
  • name — VARCHAR(20)
  • task — VARCHAR(20)

Consultant

  • Consultant_id (consultant_id) — INT(11) — Primary key — NOT NULL
  • name — VARCHAR(20)
  • task — VARCHAR(20)

Course

  • Course_id (course_id) — INT(11) — Primary key — NOT NULL
  • name — VARCHAR(20)

Student

  • Student_id (student_id) — INT(11) — Primary key — NOT NULL
  • name — VARCHAR(20)
  • generation — INT(11)
  • major — BOOLEAN
  • exit — BOOLEAN

Student_Class

  • PK — INT(11) — Primary key — NOT NULL
  • Class_id (class_id) — INT(11) — Foreign key → Class.Class_id — NOT NULL
  • Consultant_id (consultant_id) — INT(11) — Foreign key → Class.Consultant_id — NOT NULL
  • Coach_id (coach_id) — INT(11) — Foreign key → Class.Coach_id — NOT NULL
  • Student_id (student_id) — INT(11) — Foreign key → Student.Student_id — NOT NULL
  • Course_id (course_id) — INT(11) — Foreign key → Class.Course_id — NOT NULL