ssafy db
Tables (6)
coach (Untitled3)
- Key (coach_id) — int — Primary key — NOT NULL
- Field (assignment) — String
consultant (Untitled2)
- Key (consultant_id) — int — Primary key — NOT NULL
- Key (group_id) — int — Foreign key → group.Key — NOT NULL
- Field (assignment) — String
- Field (group) — int
course (Untitled5)
- Key (course_id) — int — Primary key — NOT NULL
- Key (group_id) — int — Foreign key → group.Key — NOT NULL
- Field (education) — EDUCATION(ENUM)
group (Untitled4)
- Key (group_id) — int — Primary key — NOT NULL
- Field (region) — String
- Field (number) — int
groupcoach (Untitled6)
- Key (groupcoach_id) — int — Primary key — NOT NULL
- Key (coach_id) — int — Foreign key → coach.Key — NOT NULL
- Key (group_id) — int — Foreign key → group.Key — NOT NULL
trainee (Untitled)
- (trainee_id) — int — Primary key
- Key (group_id) — int — Foreign key → group.Key — NOT NULL
- Field2 (major) — boolean
- Field (exit) — boolean