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