Peekle
Tables (15)
league_groups
- id — BIGINT — PK
- tier — VARCHAR(20) — NOT NULL — League Tier Enum
- season_week — INT — NOT NULL — YYYYWW
- created_at — DATETIME(6) — NOT NULL
league_history
- id — BIGINT — PK
- user_id — BIGINT — Foreign key → users.id — NOT NULL — FK to Users
- league — VARCHAR(20) — NOT NULL — League Tier Enum
- final_point — INT — NOT NULL
- result — VARCHAR(20) — NOT NULL — PROMOTED, DEMOTED, STAY
- season_week — INT — NOT NULL — YYYYWW
- closed_at — DATETIME(6) — NOT NULL
- rank_value — INT
- league_group_id — BIGINT — Foreign key → league_groups.id — FK to LeagueGroups
- is_viewed — BOOLEAN — NOT NULL
point_logs
- id — BIGINT — PK
- user_id — BIGINT — Foreign key → users.id — NOT NULL — FK to Users
- category — VARCHAR(255) — NOT NULL — PROBLEM, GAME
- amount — INT — NOT NULL
- description — VARCHAR(255)
- metadata — TEXT — JSON
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
problem_tags
- problem_id — BIGINT — Foreign key → problems.id — NOT NULL
- tag_id — BIGINT — Foreign key → tags.id — NOT NULL
problems
- id — BIGINT — PK
- source — VARCHAR(255) — NOT NULL — Source (BOJ, SWEA)
- external_id — VARCHAR(255) — NOT NULL — Problem ID within source
- title — VARCHAR(255) — NOT NULL
- tier — VARCHAR(255) — NOT NULL — Difficulty Tier
- url — TEXT — NOT NULL
study_chat_logs
- id — BIGINT — PK
- study_room_id — BIGINT — Foreign key → study_rooms.id — NOT NULL — FK to StudyRooms
- user_id — BIGINT — Foreign key → users.id — NOT NULL — FK to Users
- message — TEXT — NOT NULL
- type — VARCHAR(255) — NOT NULL — TALK, CODE, SYSTEM, SUBMISSION
- parent_id — BIGINT — Foreign key → study_chat_logs.id — FK to self (Reply)
- metadata — TEXT — JSON metadata
- created_at — DATETIME(6) — NOT NULL
study_members
- id — BIGINT — PK
- study_room_id — BIGINT — Foreign key → study_rooms.id — NOT NULL — FK to StudyRooms
- user_id — BIGINT — Foreign key → users.id — NOT NULL — FK to Users
- role — VARCHAR(255) — NOT NULL — OWNER, MEMBER
- joined_at — DATETIME(6) — NOT NULL
study_problems
- id — BIGINT — PK
- study_room_id — BIGINT — Foreign key → study_rooms.id — NOT NULL — FK to StudyRooms
- problem_id — BIGINT — Foreign key → problems.id — NOT NULL — FK to Problems (Logically)
- problem_date — DATE — NOT NULL
- created_by — BIGINT — Foreign key → users.id — NOT NULL — FK to Users
- created_at — DATETIME(6) — NOT NULL
study_rooms
- id — BIGINT — PK
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- owner_id — BIGINT — Foreign key → users.id — NOT NULL — FK to Users (Owner)
- is_active — BOOLEAN — NOT NULL
- ranking_point — INT
- created_at — DATETIME(6) — NOT NULL
submission_logs
- id — BIGINT — PK
- user_id — BIGINT — Foreign key → users.id — NOT NULL — FK to Users
- problem_id — BIGINT — Foreign key → problems.id — NOT NULL — FK to Problems
- source_type — VARCHAR(255)
- problem_title — VARCHAR(255)
- room_id — BIGINT
- external_id — VARCHAR(255)
- problem_tier — VARCHAR(255)
- code — TEXT
- memory — INT
- execution_time — INT
- is_success — BOOLEAN
- tag — VARCHAR(255)
- result — VARCHAR(50)
- language — VARCHAR(255)
- submitted_at — DATETIME(6)
tags
- id — BIGINT — PK
- tag_key — VARCHAR(255) — NOT NULL — Tag Key (e.g. math)
- name — VARCHAR(255) — NOT NULL — Tag Name (e.g. 수학)
users
- id — BIGINT — PK
- social_id — VARCHAR(255) — NOT NULL — Social Login ID
- provider — VARCHAR(255) — NOT NULL — KAKAO, NAVER, GOOGLE
- nickname — VARCHAR(255) — User Nickname
- boj_id — VARCHAR(255) — Baekjoon ID
- extension_token — VARCHAR(100) — Extension Token
- extension_token_updated_at — DATETIME(6)
- profile_img — VARCHAR(255)
- profile_img_thumb — VARCHAR(255)
- league — VARCHAR(255) — Current League Tier
- league_point — INT
- league_group_id — BIGINT — Assigned League Group ID
- streak_current — INT
- streak_max — INT
- max_league — VARCHAR(255)
- is_deleted — BOOLEAN
- last_solved_date — DATE
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
workbook_bookmarks
- id — BIGINT — PK
- workbook_id — BIGINT — Foreign key → workbooks.id — NOT NULL — FK to Workbooks
- user_id — BIGINT — Foreign key → users.id — NOT NULL — FK to Users
- created_at — DATETIME(6) — NOT NULL
workbook_problems
- id — BIGINT — PK
- workbook_id — BIGINT — Foreign key → workbooks.id — NOT NULL — FK to Workbooks
- problem_id — BIGINT — Foreign key → problems.id — NOT NULL — FK to Problems
- order_index — INT — NOT NULL — Order in workbook
workbooks
- id — BIGINT — PK
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- creator_id — BIGINT — Foreign key → users.id — NOT NULL — FK to Users
- bookmark_count — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)