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