test

Tables (13)

chart_snapshot

  • sort_id — VARCHAR(64) — Primary key — NOT NULL
  • universe_id — BIGINT — Primary key — NOT NULL
  • chart_rank — INT — NOT NULL
  • snapshot_at — DATETIME — NOT NULL

collect_queue

  • universe_id — BIGINT — Primary key — NOT NULL
  • reason — VARCHAR(32) — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

game_cofavorite

  • seed_universe_id — BIGINT — Primary key — NOT NULL
  • related_universe_id — BIGINT — Primary key — NOT NULL
  • overlap_count — INT — NOT NULL
  • sample_size — INT — NOT NULL
  • computed_at — DATETIME — NOT NULL

game_media

  • sort_order — SMALLINT — Primary key — NOT NULL
  • universe_id — BIGINT — Foreign key → games.universe_id — NOT NULL
  • asset_type — VARCHAR(32) — NOT NULL
  • image_id — BIGINT
  • video_asset_id — BIGINT
  • fetched_at — DATETIME — NOT NULL

game_recommendations

  • from_universe_id — BIGINT — Primary key — NOT NULL
  • to_universe_id — BIGINT — Primary key — NOT NULL
  • rec_rank — SMALLINT — NOT NULL
  • fetched_at — DATETIME — NOT NULL

game_videos

  • universe_id — BIGINT — Primary key — NOT NULL
  • youtube_video_id — VARCHAR(20) — Primary key — NOT NULL
  • title — VARCHAR(200)
  • thumbnail_url — TEXT
  • display_order — SMALLINT — NOT NULL
  • fetched_at — DATETIME — NOT NULL

games

  • universe_id — BIGINT — Primary key — NOT NULL
  • place_id — BIGINT — NOT NULL
  • name — TEXT — NOT NULL
  • description — TEXT
  • genre_l1 — VARCHAR(64)
  • genre_l2 — VARCHAR(64)
  • playing — INT
  • visits — BIGINT
  • favorited_count — BIGINT
  • created — DATETIME
  • up_votes — INT
  • down_votes — INT
  • creator_type — VARCHAR(8)
  • creator_group_id — BIGINT
  • minimum_age — SMALLINT
  • icon_url — TEXT
  • fan_cacheable — BOOLEAN
  • updated_at — DATETIME — NOT NULL

group_cursors

  • group_id — BIGINT — Primary key — NOT NULL
  • member_count — BIGINT
  • sort_order — VARCHAR(4) — NOT NULL
  • anchor_cursor — TEXT
  • progress_cursor — TEXT
  • users_collected — INT — NOT NULL
  • collection_status — VARCHAR(16) — NOT NULL
  • updated_at — DATETIME — NOT NULL

system_heartbeat

  • name — VARCHAR(40) — Primary key — NOT NULL
  • expires_at — DATETIME — NOT NULL

tier_entries

  • universe_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • tier — VARCHAR(4) — NOT NULL
  • position — SMALLINT — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_favorites

  • user_id — BIGINT — Primary key — NOT NULL
  • fav_universe_id — BIGINT — Primary key — NOT NULL
  • recorded_at — DATETIME — NOT NULL
  • name — VARCHAR(255)

user_recommendations

  • universe_id — BIGINT — Primary key — NOT NULL
  • section — VARCHAR(10) — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • score — DOUBLE — NOT NULL
  • rec_rank — SMALLINT — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • display_name — VARCHAR(50)
  • fav_fetched_at — DATETIME
  • last_seen_at — DATETIME — NOT NULL