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