땅땅

테이블 (7)

auction_info

  • auction_id — BIGINT — 기본 키 — NOT NULL — PK
  • product_id — BIGINT — 외래 키 → product.product_id — NOT NULL — 상품 1개당 경매정보 1개
  • start_price — BIGINT — NOT NULL
  • winning_price — BIGINT — NOT NULL — 현재 최고가 (반정규화)
  • winning_bidder_id — BIGINT — 외래 키 → member.member_id — 낙찰자 ID
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • state — VARCHAR(20) — PREPARE, PROCEEDING, ENDED

bid

  • bid_id — BIGINT — 기본 키 — NOT NULL — PK
  • auction_id — BIGINT — 외래 키 → auction_info.auction_id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL — 입찰자
  • price — BIGINT — NOT NULL
  • created_at — DATETIME
  • INDEX — `idx_auction_price`

drop_info

  • drop_id — BIGINT — 기본 키 — NOT NULL — PK
  • product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
  • stock_quantity — INT — NOT NULL
  • open_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL

member

  • member_id — BIGINT — 기본 키 — NOT NULL — PK
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • user_role — VARCHAR(45) — NOT NULL — ROLE_USER, ROLE_SELLER
  • ban_status — TINYINT — NOT NULL
  • ban_expires_at — DATETIME
  • created_at — DATETIME
  • modified_at — DATETIME
  • refresh_token — VARCHAR(255)

orders

  • order_id — BIGINT — 기본 키 — NOT NULL — PK
  • order_no — VARCHAR(100) — NOT NULL — 주문번호(UUID)
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL — 구매자
  • product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
  • final_price — BIGINT — NOT NULL
  • order_status — VARCHAR(50) — NOT NULL
  • created_at — DATETIME

payment

  • pay_id — BIGINT — 기본 키 — NOT NULL — PK
  • order_id — BIGINT — 외래 키 → orders.order_id — NOT NULL
  • pg_tid — VARCHAR(255) — NOT NULL — PG사 거래번호
  • amount — BIGINT — NOT NULL
  • paid_at — DATETIME
  • pay_status — VARCHAR(20)

product

  • product_id — BIGINT — 기본 키 — NOT NULL — PK
  • seller_id — BIGINT — 외래 키 → member.member_id — NOT NULL — 판매자(Member) ID
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • sale_type — VARCHAR(20) — NOT NULL — AUCTION, DROP
  • created_at — DATETIME
  • modified_at — DATETIME