test

Tables (4)

coach (코치)

  • Cno — INT — Primary key — NOT NULL
  • Glocation — VARCHAR — Foreign key → group.Glocation — NOT NULL
  • Gno — INT — Foreign key → group.Gno — NOT NULL
  • task — VARCHAR

consultant (컨설턴트)

  • Cno — INT — Primary key — NOT NULL
  • Glocation — VARCHAR — Foreign key → group.Glocation — NOT NULL
  • Gno — INT — Foreign key → group.Gno — NOT NULL
  • task — VARCHAR

group (학급)

  • Glocation — VARCHAR — Primary key — NOT NULL
  • Gno — INT — Primary key — NOT NULL
  • edu_track — VARCHAR — NOT NULL — 공통, 특화, 자율

student (교육생)

  • Sno — INT — Primary key — NOT NULL
  • Glocation — VARCHAR — Foreign key → group.Glocation — NOT NULL
  • Gno — INT — Foreign key → group.Gno — NOT NULL
  • Sname — VARCHAR
  • gisoo — INT
  • major — INT
  • exit — INT