SCrank

Tables (3)

Auction (auctions)

  • auctionId (id) — BIGINT — Primary key — NOT NULL
  • itemName (아이템이름) — VARCHAR(255)
  • startPrice (시작가격) — BIGINT
  • currentPrice (현재가) — BIGINT
  • bidHistory (입찰내역)
  • startedAt (시작시각) — TIMESTAMP
  • deleteAt (삭제시각) — TIMESTAMP
  • closeAt (종료시각) — TIMESTAMP
  • Field
  • auctionUserID (id2) — BIGINT — Foreign key → AuctionUser.auctionUserID — NOT NULL

AuctionUser (auctionusers)

  • auctionUserID (id) — BIGINT — Primary key — NOT NULL
  • username (유저이름) — VARCHAR(255)
  • points (포인트) — BIGINT
  • Field

Bid (bids)

  • bidId (id) — BIGINT — Primary key — NOT NULL
  • amount (가격?) — BIGINT
  • Field
  • auctionId (id2) — BIGINT — Foreign key → Auction.auctionId — NOT NULL
  • auctionUserID (id3) — BIGINT — Foreign key → AuctionUser.auctionUserID — NOT NULL