SSAFY

Tables (5)

class (Untitled)

  • class_id (Key) — int — Primary key — NOT NULL
  • coach_id (Key2) — int — Foreign key → coach.coach_id — NOT NULL
  • region (Field) — varchar
  • class_number (Field2) — int
  • generation (Field3) — int

coach (Untitled3)

  • coach_id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • position (Field2) — varchar

consultant (Untitled2)

  • consultant_id (Key) — int — Primary key — NOT NULL
  • class_id (Key2) — int — Foreign key → class.class_id — NOT NULL
  • coach_id (Key22) — int — Foreign key → class.coach_id — NOT NULL
  • name (Field) — varchar
  • position (Field2) — varchar

course (Untitled4)

  • course_id (Key) — int — Primary key — NOT NULL
  • class_id (Key2) — int — Foreign key → class.class_id — NOT NULL
  • coach_id (Key22) — int — Foreign key → class.coach_id — NOT NULL
  • course_type (Field) — varchar

student (Student)

  • student_id (Key) — int — Primary key — NOT NULL
  • class_id (Key2) — int — Foreign key → class.class_id — NOT NULL
  • coach_id (Key22) — int — Foreign key → class.coach_id — NOT NULL
  • name (Field) — varchar
  • generation (Field2) — int
  • is_major (Field3) — boolean
  • is_joined (Field4) — boolean