ssafy

Tables (6)

class (반)

  • id (반 id) — varchar(10) — Primary key — NOT NULL
  • regname (지역명) — varchar(20) — Foreign key → region.name — NOT NULL
  • name (과정 이름) — varchar(10) — Foreign key → curriculum.name — NOT NULL
  • classno (반 번호) — int

coach (코치)

  • id (코치 id) — varchar(10) — Primary key — NOT NULL
  • job (담당 업무) — varchar(100)
  • id (반 id) — varchar(10) — Foreign key → class.id — NOT NULL
  • regname (지역명) — varchar(20) — Foreign key → class.regname — NOT NULL
  • name (과정 이름) — varchar(10) — Foreign key → class.name — NOT NULL

consultant (컨설턴트)

  • id (컨설턴트 id) — varchar(10) — Primary key — NOT NULL
  • id (반 id) — varchar(10) — Foreign key → class.id — NOT NULL
  • regname (지역명) — varchar(20) — Foreign key → class.regname — NOT NULL
  • name (과정 이름) — varchar(10) — Foreign key → class.name — NOT NULL
  • job (담당 업무) — varchar(100)

curriculum (교육과정)

  • name (과정 이름) — varchar(10) — Primary key — NOT NULL

region (지억)

  • name (지역명) — varchar(20) — Primary key — NOT NULL

student (교육생)

  • id (학번) — varchar(10) — Primary key — NOT NULL
  • id (반 id) — varchar(10) — Foreign key → class.id — NOT NULL
  • regname (지역명) — varchar(20) — Foreign key → class.regname — NOT NULL
  • name (과정 이름) — varchar(10) — Foreign key → class.name — NOT NULL
  • semester (기수) — int
  • major (전공) — boolean
  • discharged (퇴소) — boolean
  • Field