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)