karrot-mini-game

Tables (4)

Untitled (user_rank)

  • Key (leaderboard_week) — text — Primary key — NOT NULL
  • Key (user_id) — text — Foreign key → Untitled.Key — NOT NULL
  • Key (town_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (score) — bigint
  • Field (updated_at) — datetime

Untitled (town_rank)

  • Key (town_id) — text — Primary key — NOT NULL
  • Key (leaderboard_week) — text — Primary key — NOT NULL
  • Field (score) — bigint
  • Field2 (updated_date) — datetime

Untitled (user)

  • Key (user_id) — text — Primary key — NOT NULL
  • Key (town_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (nickname) — text
  • Field (profile_image_url) — text
  • Field (created_at) — datetime
  • Field (region_id) — text

Untitled (town)

  • Key (town_id) — bigint — Primary key — NOT NULL
  • Field (name1) — text
  • Field (name2) — text