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