Auction

Tables (5)

auction

  • 경매id (id) — bigint — Primary key — NOT NULL
  • 위탁자id (cosigner_id) — bigint — Foreign key → user.유저id — NOT NULL
  • 아이템id (item_id) — bigint — Foreign key → item.아이템id — NOT NULL
  • 시작가 (starting_price) — varchar(255)
  • 상태 (status) — enum
  • 호가단위 (bid_increment) — varchar(255)
  • 생성일자 (created_at) — datetime
  • 수정일자 (updated_at) — datetime

bidding

  • 응찰id (id) — bigint — Primary key — NOT NULL
  • 옥션id (auction_id) — bigint — Foreign key → auction.경매id — NOT NULL
  • 응찰자id (bidder_id) — bigint — Foreign key → user.유저id — NOT NULL
  • 응찰가 (bid_price) — varchar(255)
  • 생성일자 (created_at) — datetime
  • 수정일자 (updated_at) — datetime

item

  • 아이템id (id) — bigint — Primary key — NOT NULL
  • 소유주id (owner_id) — bigint — Foreign key → user.유저id — NOT NULL
  • 이름 (name) — varchar(255)
  • 설명 (detail) — varchar(255)
  • 생성일자 (created_at) — datetime
  • 수정일자 (updated_at) — datetime

successful_bidding

  • 낙찰id (id) — bigint — Primary key — NOT NULL
  • 응찰id (bidding_id) — bigint — Foreign key → bidding.응찰id — NOT NULL
  • 경매id (auction_id) — bigint — Foreign key → auction.경매id — NOT NULL
  • 생성일자 (created_at) — datetime
  • 수정일자 (updated_at) — datetime

user

  • 유저id (id) — bigint — Primary key — NOT NULL
  • 닉네임 (nickname) — varchar(255)
  • 이메일 (email) — varchar(255)
  • 생성일자 (created_at) — datetime
  • 수정일자 (updated_at) — datetime