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