26s-w1-c3-09
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_fans
- seed_universe_id — BIGINT — Primary key — NOT NULL
- fan_user_id — BIGINT — Primary key — NOT NULL
- favorite_count — INT — NOT NULL
- recorded_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
- 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
- fans_collected — INT — NOT NULL
- collection_status — VARCHAR(16) — NOT NULL
- updated_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
user_recommendations
- universe_id — BIGINT — 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)
- last_seen_at — DATETIME — NOT NULL