sssafy

Tables (6)

class (Untitled)

  • ID — bigint(20) — Primary key — NOT NULL
  • 지역 (location) — varchar(255)
  • 반 (number) — bigint(20)

coach (Untitled2)

  • ID — bigint(20) — Primary key — NOT NULL
  • duty_id — bigint(20) — Foreign key → class.ID — NOT NULL
  • class_id — bigint(20) — Foreign key → duty.ID — NOT NULL

consultant (Untitled3)

  • ID — bigint(20) — Primary key — NOT NULL
  • duty_id — bigint(20) — Foreign key → class.ID — NOT NULL
  • class_id — bigint(20) — Foreign key → duty.ID — NOT NULL

course (Untitled6)

  • ID — bigint(20) — Primary key — NOT NULL
  • 교육과정 (course) — archer(255)

duty (Untitled4)

  • ID — bigint(20) — Primary key — NOT NULL
  • 담당업무 (duty) — varchar(255)

student (Untitled5)

  • ID — bigint(20) — Primary key — NOT NULL
  • class_id — bigint(20) — Foreign key → duty.ID — NOT NULL
  • 기수 (year) — bigint(20)
  • 전공여부 (major) — bit(1)
  • 퇴소여부 (kicked_out) — bit(1)
  • Field