auction

경매 MVP V2의 PostgreSQL 스키마. 경매·입찰·검수·결과와 Outbox 이벤트 및 수신 이벤트 중복 처리 기록을 포함한다.

테이블 (10)

artwork_status

  • artwork_id — BIGINT — 기본 키 — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • hidden_reason — VARCHAR(40)
  • version — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

auction

  • id — BIGINT — 기본 키 — NOT NULL
  • artwork_id — BIGINT — NOT NULL
  • seller_id — BIGINT — NOT NULL
  • artist_id — BIGINT — NOT NULL
  • artwork_title — VARCHAR(200) — NOT NULL
  • artwork_thumbnail_key — VARCHAR(1024)
  • artwork_version — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • start_price — BIGINT — NOT NULL
  • bid_increment — BIGINT — NOT NULL
  • scheduled_start_at — TIMESTAMPTZ
  • start_mode — VARCHAR(20) — NOT NULL
  • start_at — TIMESTAMPTZ
  • end_at — TIMESTAMPTZ
  • original_end_at — TIMESTAMPTZ
  • duration_hours — INTEGER — NOT NULL
  • extension_count — INTEGER — NOT NULL
  • current_price — BIGINT
  • highest_bidder_id — BIGINT
  • bid_count — INTEGER — NOT NULL
  • version — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • sale_type — VARCHAR(20) — NOT NULL
  • start_delay_hours — INTEGER
  • snapshot_fixed — BOOLEAN — NOT NULL
  • cancel_reason — VARCHAR(30)
  • material_category — VARCHAR(30)
  • shipping_tier — VARCHAR(20) — NOT NULL
  • shipping_fee — BIGINT — NOT NULL
  • shipping_tier_name — VARCHAR(50)
  • shipping_size_label — VARCHAR(50)
  • demo_seed — BOOLEAN — NOT NULL
  • cancelled_at — TIMESTAMPTZ
  • cancel_note — VARCHAR(200)
  • relisted_from_auction_id — BIGINT — 외래 키 → auction.id

auction_job_heartbeat

  • job — VARCHAR(30) — 기본 키 — NOT NULL — 작업 이름
  • ticked_at — TIMESTAMPTZ — NOT NULL — 마지막 실행 시각

auction_result

  • auction_id — BIGINT — 외래 키 → auction.id — NOT NULL
  • outcome — VARCHAR(20) — NOT NULL
  • winner_id — BIGINT
  • hammer_price — BIGINT
  • closed_at — TIMESTAMPTZ — NOT NULL
  • payment_status — VARCHAR(20)
  • paid_at — TIMESTAMPTZ
  • order_id — BIGINT
  • order_version — BIGINT
  • cancel_reason — VARCHAR(30)
  • hidden_from_public — BOOLEAN — NOT NULL

auction_watch

  • member_id — BIGINT — 기본 키 — NOT NULL
  • auction_id — BIGINT — 외래 키 → auction.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

bid

  • id — BIGINT — 기본 키 — NOT NULL
  • auction_id — BIGINT — 외래 키 → auction.id — NOT NULL
  • sequence_no — INTEGER — NOT NULL
  • bidder_id — BIGINT — 외래 키 → bid_deposit.bidder_id — NOT NULL
  • amount — BIGINT — NOT NULL
  • idempotency_key — VARCHAR(100) — 외래 키 → bid_deposit.idempotency_key — NOT NULL
  • placed_at — TIMESTAMPTZ — NOT NULL
  • accepted_auction_version — BIGINT — NOT NULL
  • resulting_end_at — TIMESTAMPTZ — NOT NULL

bid_deposit

  • bidder_id — BIGINT — 기본 키 — NOT NULL
  • idempotency_key — VARCHAR(100) — 기본 키 — NOT NULL
  • auction_id — BIGINT — 외래 키 → auction.id — NOT NULL
  • bid_amount — BIGINT — NOT NULL
  • deposit_amount — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • hold_id — VARCHAR(100)
  • rejection — VARCHAR(40)
  • requested_at — TIMESTAMPTZ — NOT NULL
  • held_at — TIMESTAMPTZ
  • release_requested_at — TIMESTAMPTZ
  • release_attempts — INTEGER — NOT NULL
  • last_release_attempt_at — TIMESTAMPTZ
  • released_at — TIMESTAMPTZ

bidder_profile

  • member_id — BIGINT — 기본 키 — NOT NULL
  • nickname — VARCHAR(50)
  • fetched_at — TIMESTAMPTZ
  • next_fetch_at — TIMESTAMPTZ — NOT NULL

outbox_event

  • event_id — UUID — 기본 키 — NOT NULL
  • event_type — VARCHAR(100) — NOT NULL
  • aggregate_id — VARCHAR(100) — NOT NULL
  • aggregate_version — BIGINT — NOT NULL
  • idempotency_key — VARCHAR(200) — NOT NULL
  • schema_version — VARCHAR(20) — NOT NULL
  • payload — JSONB — NOT NULL
  • occurred_at — TIMESTAMPTZ — NOT NULL
  • traceparent — VARCHAR(100)
  • attempts — INTEGER — NOT NULL
  • last_attempted_at — TIMESTAMPTZ
  • published_at — TIMESTAMPTZ

processed_event

  • consumer — VARCHAR(100) — 기본 키 — NOT NULL
  • event_id — UUID — 기본 키 — NOT NULL
  • processed_at — TIMESTAMPTZ — NOT NULL