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