steam lite

Tables (9)

friend_requests

  • request_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — VARCHAR(40) — Foreign key → users.user_id — NOT NULL
  • requester_id — BIGINT
  • addressee_id — BIGINT
  • status — VARCHAR(10) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • responded_at — TIMESTAMPTZ

friends

  • user_id — VARCHAR(40) — Foreign key → users.user_id — NOT NULL
  • friend_id — VARCHAR(40) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

game_categories

  • category_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(40) — NOT NULL

games

  • game_id — BIGSERIAL — Primary key — NOT NULL
  • title — VARCHAR(120) — NOT NULL
  • description — TEXT
  • category_id — BIGINT — Foreign key → game_categories.category_id — NOT NULL
  • price — NUMERIC(10,2) — NOT NULL
  • download_url — TEXT
  • thumbnail_url — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

purchases

  • purchase_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — VARCHAR(40) — Foreign key → users.user_id — NOT NULL
  • game_id — BIGSERIAL — Foreign key → games.game_id — NOT NULL
  • amount — INT — NOT NULL
  • currency — CHAR(3) — NOT NULL
  • provider — VARCHAR(40)
  • paid_at — TIMESTAMPTZ — NOT NULL
  • payment_status — VARCHAR(10) — NOT NULL

reviews

  • review_id — BIGINT — Primary key — NOT NULL
  • game_id — BIGSERIAL — Foreign key → games.game_id — NOT NULL
  • user_id — BIGINT
  • rating — SMALLINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ
  • is_deleted — BOOLEAN — NOT NULL

user_library

  • user_id — VARCHAR(40) — Foreign key → users.user_id — NOT NULL
  • game_id — BIGSERIAL — Foreign key → games.game_id — NOT NULL
  • added_at — TIMESTAMPTZ — NOT NULL

user_sessions

  • session_id — UUID — Primary key — NOT NULL
  • user_id — VARCHAR(40) — Foreign key → users.user_id — NOT NULL
  • issued_at — TIMESTAMPTZ — NOT NULL
  • last_activity_at — TIMESTAMPTZ — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • user_agent — TEXT
  • ip_addr — INET

users

  • user_id — VARCHAR(40) — Primary key — NOT NULL
  • username — VARCHAR(40) — NOT NULL
  • email — VARCHAR(120) — NOT NULL
  • pw_hash — VARCHAR(128) — NOT NULL
  • display_name — VARCHAR(60)
  • avatar_url — TEXT
  • role — VARCHAR(10) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ