Auction

Tables (3)

auction_item (등록된 아이템)

  • id (Key) — integer — Primary key — NOT NULL
  • name (아이템 이름) — varchar(100)
  • created_at (등록된 시간) — datetime
  • reg_player (등록자) — integer — Foreign key → auction_player.id — NOT NULL

auction_item_bidders (아이템과 입찰희망유저)

  • id (Key) — integer — Primary key — NOT NULL
  • player_id (입찰희망유저 id) — integer — Foreign key → auction_player.id — NOT NULL
  • item_id (등록아이템 id) — integer — Foreign key → auction_item.id — NOT NULL

auction_player (디스코드 유저)

  • id (Key) — integer — Primary key — NOT NULL
  • name (유저 이름) — varchar(100)