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