halp

Tables (6)

Group

  • id — bigint — Primary key — NOT NULL
  • 팀명 (name)
  • 팀소개 (description)
  • 추천 주기 (recommend_cycle)

GroupMember

  • id (group_member_id) — bigint — Primary key — NOT NULL
  • group_id — bigint — Foreign key → Group.id — NOT NULL
  • member_id — bigint — Foreign key → Member.id — NOT NULL
  • role

Member

  • id — BIGINT AUTO_INCREMENT — Primary key — NOT NULL
  • provider — VARCHAR(255)
  • 구글_식별자 (provider_id) — VARCHAR(255) NOT NULL UNIQUE
  • 백준ID (handle) — VARCHAR(255)
  • 이메일 (email) — VARCHAR(255) NOT NULL UNIQUE
  • role — ENUM
  • 이메일 수신허용 (is_subscribed) — BOOLEAN

Problem

  • 문제번호 (id) — bigint — Primary key — NOT NULL
  • 문제 제목 (title)
  • 문제난이도 (level)

RecommendProblem

  • id — bigint — Primary key — NOT NULL
  • group_id — bigint — Foreign key → Group.id — NOT NULL
  • problem_id — bigint — Foreign key → Problem.문제번호 — NOT NULL
  • Field (deadline) — timestamp
  • is_auto
  • Field2

UserSolvedProblem

  • id — bigint — Primary key — NOT NULL
  • problem_id — bigint — Foreign key → Problem.문제번호 — NOT NULL
  • member_id — bigint — Foreign key → Member.id — NOT NULL
  • Field