studyhalp
Tables (13)
member
- id — BIGINT — Primary key — NOT NULL
- role — VARCHAR(20)
- provider — VARCHAR(50)
- provider_id — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- handle — VARCHAR(100)
- is_verified — TINYINT(1) — NOT NULL
- last_login_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- modified_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- id (id2) — BIGINT — Foreign key → member_solved_problem.id — NOT NULL
member_recommendation
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- recommendation_id — BIGINT — NOT NULL
- team_id — BIGINT — 스냅샷 (DB FK 없음)
- team_name — VARCHAR(255) — 스냅샷
- email_send_status — VARCHAR(16) — NOT NULL
- email_sent_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- modified_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- id (id2) — BIGINT — Foreign key → recommendation.id — NOT NULL
- id (id3) — BIGINT — Foreign key → member.id — NOT NULL
member_solved_problem
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- problem_id — BIGINT — NOT NULL
- solved_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- modified_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- id (id2) — BIGINT — Foreign key → problem.id — NOT NULL — 백준 문제 번호
notification
- id — BIGINT — Primary key — NOT NULL
- recipient_id — BIGINT — NOT NULL
- type — VARCHAR(50) — NOT NULL
- metadata — TEXT
- read_at — DATETIME
- created_at — DATETIME — NOT NULL
- modified_at — DATETIME — NOT NULL
- deleted_at — DATETIME
- INDEX — idx_recipient
- id (id2) — BIGINT — Foreign key → member.id — NOT NULL
problem
- id — BIGINT — Primary key — NOT NULL — 백준 문제 번호
- title — VARCHAR(255) — NOT NULL
- title_ko — VARCHAR(255)
- level — INT
- accepted_user_count — INT
- average_tries — DOUBLE
problem_tag
- id — BIGINT — NOT NULL
- problem_id — BIGINT — NOT NULL — 문제 ID
- tag_key — VARCHAR(64) — NOT NULL — Tag 참조
- INDEX — idx_problem_tag_problem
- INDEX — idx_problem_tag_tag
recommendation
- id — BIGINT — Primary key — NOT NULL
- type — VARCHAR(16) — NOT NULL — SCHEDULED, MANUAL
- team_id — BIGINT — 스냅샷 (DB FK 없음)
- created_at — DATETIME(6) — NOT NULL
- modified_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
recommendation_problem
- id — BIGINT — Primary key — NOT NULL
- recommendation_id — BIGINT — NOT NULL
- problem_id — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- modified_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- id (id2) — BIGINT — Foreign key → recommendation.id — NOT NULL
tag
- tag_key — VARCHAR(64) — Primary key — NOT NULL — solved.ac 태그 키 (dp, greedy 등)
- name_ko — VARCHAR(100) — NOT NULL — 한글 태그명
- name_en — VARCHAR(100) — NOT NULL — 영문 태그명
team
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- is_private — TINYINT(1) — NOT NULL
- recommendation_status — VARCHAR(16) — NOT NULL
- recommendation_days — INT — NOT NULL
- problem_difficulty_preset — VARCHAR(16)
- min_problem_level — INT
- max_problem_level — INT
- problem_count — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- modified_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
team_include_tag
- id — BIGINT — NOT NULL
- team_id — BIGINT — NOT NULL — Team 참조
- tag_key — VARCHAR(64) — NOT NULL — Tag 참조
- INDEX — idx_team_include_tag_team
- INDEX — idx_team_include_tag_tag
team_join
- id — BIGINT — NOT NULL
- team_id — BIGINT — NOT NULL
- type — VARCHAR(16) — NOT NULL
- requester_id — BIGINT — NOT NULL
- target_member_id — BIGINT
- status — VARCHAR(16) — NOT NULL
- processed_at — DATETIME(6)
- expires_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- modified_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- INDEX — idx_target_status
- INDEX — idx_team_status
- INDEX — idx_requester_status
team_member
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- modified_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- id (id2) — BIGINT — Foreign key → member.id — NOT NULL
- team_id — BIGINT — NOT NULL
- id (id3) — BIGINT — Foreign key → team.id — NOT NULL