ERD

Tables (5)

class (Untitled4)

  • area (지역) — varchar(100) — Primary key — NOT NULL
  • coach_id (코치아이디) — varchar(100) — Foreign key → coach.coach_id — NOT NULL
  • cnsultant_id (컨설턴트아이디) — varchar(100) — Foreign key → consultant.cnsultant_id — NOT NULL
  • class (반) — int(10000)

coach (Untitled3)

  • coach_id (코치아이디) — varchar(100) — Primary key — NOT NULL
  • task (업무) — varchar(100)

consultant (Untitled2)

  • cnsultant_id (컨설턴트아이디) — varchar(100) — Primary key — NOT NULL
  • task (업무) — varchar(100)

process (Untitled5)

  • subject (과정) — varchar(100) — Primary key — NOT NULL

student (Untitled)

  • student_id (학생아이디) — int(10000) — Primary key — NOT NULL
  • area (지역) — varchar(100) — Foreign key → class.area — NOT NULL
  • coach_id (코치아이디) — varchar(100) — Foreign key → class.coach_id — NOT NULL
  • cnsultant_id (컨설턴트아이디) — varchar(100) — Foreign key → class.cnsultant_id — NOT NULL
  • subject (과정) — varchar(100) — Foreign key → process.subject — NOT NULL
  • major (전공) — boolean
  • address (주소) — varchar(100)
  • stay (퇴소여부) — boolean
  • cardinal (기수) — int(10000)