땅땅
테이블 (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