SSAFY

Tables (5)

Class (class)

  • Class_ID (cl_id) — INT(10) — Primary key — NOT NULL
  • Consultent_ID (c_id) — INT(10) — Primary key
  • Coach_ID (co_id) — INT(10) — Foreign key → Coach.Coach_ID — NOT NULL
  • Class_ID (cl_id2) — INT(10) — Foreign key → Coach.Class_ID — NOT NULL
  • Consultent_ID (c_id2) — INT(10) — Foreign key → Consultent.Consultent_ID — NOT NULL
  • Area (area) — VARCHAR(20)
  • ClassNum (classnum) — VARCHAR(20)
  • Field

Coach (coach)

  • Coach_ID (co_id) — INT(10) — Primary key — NOT NULL
  • Class_ID (cl_id) — INT(10) — Primary key — NOT NULL
  • Task (task) — VARCHAR(10)

Consultent (consultent)

  • Consultent_ID (c_id) — INT(10) — Primary key — NOT NULL
  • Task (task) — VARCHAR(10)

Curriculum (curriculum)

  • Curriculum_ID (cu_id) — INT(10) — Primary key — NOT NULL

Student (student)

  • Student_ID (s_id) — INT(10) — Primary key — NOT NULL
  • Class_ID (cl_id2) — INT(10) — Foreign key → Class.Class_ID — NOT NULL
  • Consultent_ID (c_id) — INT(10) — Foreign key → Class.Consultent_ID
  • Coach_ID (co_id) — INT(10) — Foreign key → Class.Coach_ID — NOT NULL
  • Class_ID (cl_id22) — INT(10) — Foreign key → Class.Class_ID — NOT NULL
  • Consultent_ID (c_id2) — INT(10) — Foreign key → Class.Consultent_ID — NOT NULL
  • Generate (generate) — INT(10)
  • Major (major) — VARCHAR(20)
  • Exit (exit) — VARCHAR(10)