erd

Tables (4)

class (반)

  • id (학생번호) — NOT NULL — Foreign key → student.id — NOT NULL
  • id (컨설턴트) — NOT NULL — Foreign key → consl.id — NOT NULL
  • id (코치) — NOT NULL — Foreign key → coach.id — NOT NULL
  • location (지역) — NOT NULL
  • class (반) — NOT NULL

coach (코치)

  • id (코치) — NOT NULL — Primary key — NOT NULL
  • work (담당업무) — NOT NULL

consl (컨설턴트)

  • id (컨설턴트) — NOT NULL — Primary key — NOT NULL
  • work (담당업무) — NOT NULL

student (교육생)

  • id (학생번호) — NOT NULL — Primary key — NOT NULL
  • th (기수) — NOT NULL
  • major (전공여부) — NOT NULL
  • exit (퇴소여부) — NOT NULL
  • course (교육과정) — NOT NULL