ssafy

Tables (4)

ban (Untitled2)

  • 반id (ban_id) — int — Primary key — NOT NULL
  • 지역 (region)
  • 반 (num)

coach (Untitled3)

  • id (coach_id) — Primary key — NOT NULL
  • 업무 (work)

consultant (Untitled4)

  • id (cons_id) — Primary key — NOT NULL
  • 반id (ban_id) — int — Foreign key → ban.반id — NOT NULL
  • 업무 (work)

student (Untitled)

  • 교육생id (std_id) — int — Primary key — NOT NULL
  • 반id (ban_id) — int — Foreign key → ban.반id — NOT NULL
  • 전공,비전공 (isMajor) — boolean
  • 퇴소여부 (ssatal) — boolean
  • 기수 (gisu)
  • 교육과정 (Field)