erd_practice
Tables (4)
CLASS (반)
- CLASSNO (classno) — INT — Primary key — NOT NULL
- AREA (area) — VARCHAR(45) — Primary key — NOT NULL
- STUDENTNO (studentno) — INT — Foreign key → STUDENT.STUDENTNO — NOT NULL
- CONSULTANT (consultant) — VARCHAR(45)
- COACH (coach) — VARCHAR(45)
- PROCESS (process) — VARCHAR(45)
COACH (코치)
- COACHNO (coachno) — INT — Primary key — NOT NULL
- CLASSNO (classno) — INT — Foreign key → CLASS.CLASSNO — NOT NULL
- AREA (area) — VARCHAR(45) — Foreign key → CLASS.AREA — NOT NULL
- STUDENTNO (studentno) — INT — Foreign key → CLASS.STUDENTNO — NOT NULL
- BUSINESS (business) — VARCHAR(45)
CONSULTANT (컨설턴트)
- CONSULTANTNO (consultantno) — INT — Primary key — NOT NULL
- CLASSNO (classno) — INT — Foreign key → CLASS.CLASSNO — NOT NULL
- AREA (area) — VARCHAR(45) — Foreign key → CLASS.AREA — NOT NULL
- STUDENTNO (studentno) — INT — Foreign key → CLASS.STUDENTNO — NOT NULL
- BUSINESS (business) — VARCHAR(45)
STUDENT (교육생)
- STUDENTNO (studentno) — INT — Primary key — NOT NULL
- GENERATION (generation) — INT
- MAJOR (major) — VARCHAR(50)
- LEAVE (leave) — INT
- STUDENTNAME (studentname) — VARCHAR(20)