ssafy_free1
Tables (5)
Class (반)
- PK (class_id) — int — Primary key — NOT NULL
- FK (consultant_id) — int — Foreign key → Consultant.PK — NOT NULL
- FK (coach_id) — int — Foreign key → Coach.PK — NOT NULL
- Field (region) — varchar
- Field2 (class_number) — int
Coach (코치)
- PK (coach_id) — int — Primary key — NOT NULL
- Field (name) — varchar
- Field2 (role) — varchar
Consultant (컨설턴트)
- PK (consultant_id) — int — Primary key — NOT NULL
- Field (name) — varchar
- Field2 (role) — varchar
Course (교육 과정)
- PK (course_id) — int — Primary key — NOT NULL
- Field (course_type) — varchar
Student (교육생)
- PK (student_id) — int — Primary key — NOT NULL
- FK (class_id) — int — Foreign key → Class.PK — NOT NULL
- Field (name) — varchar
- Field2 (is_major) — boolean
- Field3 (is_graduated) — boolean
- Field4 (batch) — int