WebRTC ERD
Tables (10)
bid
- id — BIGSERIAL — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → room.id — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- amount — DECIMAL(15,2) — NOT NULL
- submitted_at — TIMESTAMP — NOT NULL
deal
- id — BIGSERIAL — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → room.id — NOT NULL
- winner_id — BIGINT — Foreign key → user.id — NOT NULL
- final_price — DECIMAL(15,2) — NOT NULL
- decision_basis — VARCHAR(20) — NOT NULL
- snapshot_url — VARCHAR(500)
- deal_chat_room_id — BIGINT
- created_at — TIMESTAMP — NOT NULL
point_ledger
- id — BIGSERIAL — Primary key — NOT NULL
- wallet_id — BIGINT — Foreign key → point_wallet.id — NOT NULL
- currency_type — VARCHAR(10) — NOT NULL
- entry_type — VARCHAR(20) — NOT NULL
- amount — DECIMAL(15,2) — NOT NULL
- ref_type — VARCHAR(30)
- ref_id — BIGINT
- created_at — TIMESTAMP — NOT NULL
point_wallet
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- trade_balance — DECIMAL(15,2) — NOT NULL
- trade_hold — DECIMAL(15,2) — NOT NULL
- betting_balance — DECIMAL(15,2) — NOT NULL
- betting_hold — DECIMAL(15,2) — NOT NULL
prediction
- id — BIGSERIAL — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → room.id — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- section_id — BIGINT — Foreign key → prediction_section.id — NOT NULL
- amount — DECIMAL(15,2) — NOT NULL
- settled — BOOLEAN — NOT NULL
- payout — DECIMAL(15,2)
prediction_section
- id — BIGSERIAL — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → room.id — NOT NULL
- range_from — DECIMAL(15,2) — NOT NULL
- range_to — DECIMAL(15,2) — NOT NULL
- system_generated — BOOLEAN — NOT NULL
product
- id — BIGSERIAL — Primary key — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- category — VARCHAR(50)
- photos — JSONB
- condition_checklist — JSONB
room
- id — BIGSERIAL — Primary key — NOT NULL
- host_id — BIGINT — Foreign key → user.id
- product_id — BIGINT — Foreign key → product.id — NOT NULL
- room_type — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- reserve_price — DECIMAL(15,2) — NOT NULL
- end_at — TIMESTAMP
- extend_count — INT — NOT NULL
- moderation_status — VARCHAR(20) — NOT NULL
- scheduled_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
room_event
- id — BIGSERIAL — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → room.id — NOT NULL
- type — VARCHAR(30) — NOT NULL
- payload — JSONB
- created_at — TIMESTAMP — NOT NULL
user
- id — BIGSERIAL — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL