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