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