SW#7
Tables (6)
Untitled (Student(교육생))
- Key (student_id) — INT — Primary key — NOT NULL
- Field2 (name) — VARCHAR(50)
- Field3 (is_major) — BOOLEAN
- Field (is_dropout) — BOOLEAN
- Field (generation) — INT
Untitled (Course(교육과정))
- Key (course_id) — INT — Primary key — NOT NULL
- Field (course_type) — ENUM('공통', '특화', '자율') 또는 VARCHAR
Untitled (Classroom(반))
- Key (classroom_id) — INT — Primary key — NOT NULL
- Field (classroom_nm) — VARCHAR(20)
Untitled (Consultant(컨설턴트))
- Key (consultant_id) — INT — Primary key — NOT NULL
- Field2 (name) — VARCHAR(50)
- Field (task) — VARCHAR(100)
Untitled (Coach(코치))
- Key (coach_id) — INT — Primary key — NOT NULL
- Field2 (name) — VARCHAR(50)
- Field (task) — VARCHAR(100)
Untitled (Assignment(반배정))
- Key (Assignment_id) — INT — Primary key — NOT NULL
- Key (student_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (consultant_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (coach_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (classroom_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (course_id) — INT — Foreign key → Untitled.Key — NOT NULL