DeLink
Tables (7)
auction (경매)
- auction_id (action_id) — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → user.user_id — NOT NULL
- 시작가격 (starting_price) — int
- 현재가격 (current_price) — int
- 마감시간 (Field) — DATETIME
- 거래방법 (trade)
auction_history (입찰기록)
- action_history_id — bigint(20) — Primary key — NOT NULL
- auction_id (action_id) — bigint(20) — Foreign key → auction.auction_id — NOT NULL
- user_id — bigint(20) — Foreign key → auction.user_id — NOT NULL
buyer (구매자)
- buyer_id — bigint(20) — Primary key — NOT NULL
product (상품)
- product_id — bigint(20) — Primary key — NOT NULL
- action_id — bigint(20) — Foreign key → auction.auction_id — NOT NULL
- 상품이름 (name) — VARCHAR(255)
product_image (상품이미지)
- product_image_id — bigint(20) — Primary key — NOT NULL
- product_id — bigint(20) — Foreign key → product.product_id — NOT NULL
- 이미지주소 (product_path) — VARCHAR(255)
seller (판매자)
- seller_id — bigint(20) — Primary key — NOT NULL
- 은행 (bank) — VARCHAR(255)
- 계좌 (account) — VARCHAR(255)
- 예금주 (account_name) — VARCHAR(255)
- 연락처 (phone) — VARCHAR(255)
user (회원)
- user_id — bigint(20) — Primary key — NOT NULL