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