selt_pjt_erd

Tables (6)

Untitled (교육생)

  • Key (학번) — INT(11) — Primary key — NOT NULL
  • Key (코치번호) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (반번호) — INT(11) — Foreign key → Untitled.Key — NOT NULL
  • Key (컨설턴트번호) — INT(11) — Foreign key → Untitled.Key — NOT NULL
  • Field (기수) — INT(11)
  • Field (전공여부) — BOOLEAN
  • Field (퇴소여부) — BOOLEAN

Untitled (컨설턴트)

  • Key (컨설턴트번호) — INT(11) — Primary key — NOT NULL
  • Field (담당업무) — STR

Untitled (코치)

  • Key (코치번호) — INT — Primary key — NOT NULL
  • Field (담당업무) — STR

Untitled (반)

  • Key (반번호) — INT(11) — Primary key — NOT NULL
  • Key (컨설턴트번호) — INT(11) — Foreign key → Untitled.Key — NOT NULL
  • Key (코치번호) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (지역명) — STR — NOT NULL

Untitled (교육과정)

  • Key (교육과정) — STR — Primary key — NOT NULL

Untitled (교육생 교육과정)

  • Key (교육과정) — STR — Foreign key → Untitled.Key — NOT NULL
  • Key (학번) — INT(11) — Foreign key → Untitled.Key — NOT NULL