NFT_Auction

Tables (10)

Auction

  • auctionId — number — Primary key — NOT NULL
  • NFTtoken — string — Foreign key → Item.NFTtoken — NOT NULL
  • 소유자 (owner) — string — Foreign key → Item.소유자 — NOT NULL
  • 시작가 (price) — number
  • 현재입찰가 (bidding Price) — number
  • timestamps (timestemps) — date

Chating

  • chatingId — number — Primary key — NOT NULL
  • auctionId — number — Foreign key → Auction.auctionId — NOT NULL
  • 닉네임 (nickname) — string — Foreign key → User.닉네임 — NOT NULL
  • message — string
  • timestemps — date

Collection (collection)

  • 컬렉션아이디 (collectionId) — number — Primary key — NOT NULL
  • 컬렉션이름 (name) — string — Primary key
  • 닉네임 (nickname) — string — Foreign key → User.닉네임 — NOT NULL
  • NFTtoken — string — Foreign key → Item.NFTtoken — NOT NULL
  • 아이템이름 (name2) — string — Foreign key → Item.아이템이름 — NOT NULL
  • 소유자 (owner) — string — Foreign key → Item.소유자 — NOT NULL
  • 컬렉션 소개 (description) — string
  • 수수료 (earning) — number
  • 배너이미지 (bennerImage) — string
  • 컬렉션 로고 이미지 (logoImage) — string
  • 컬렉션이미지 (fearuredImage) — string
  • timestemps — date

Item

  • NFTtoken — string — Primary key — NOT NULL
  • 아이템이름 (name) — string — Primary key — NOT NULL
  • 소유자 (owner) — string — Primary key — NOT NULL
  • 제작자 (nickname) — string — Foreign key → User.닉네임 — NOT NULL
  • 아이템설명 (description) — string
  • 아이템갯수 (supply) — number
  • 블록체인종류 (Blockchain) — string
  • timestemps — date

SellComplete

  • completeId — number — Primary key — NOT NULL
  • auctionId — number — Foreign key → Auction.auctionId — NOT NULL
  • 소유자 (owner) — string — Foreign key → Auction.소유자 — NOT NULL
  • timestemps (timestepms) — date

SellCount

  • sellCountId — number — Primary key — NOT NULL
  • completeId — number — Foreign key → SellComplete.completeId — NOT NULL
  • 소유자 (owner) — string — Foreign key → SellComplete.소유자 — NOT NULL
  • startdate — date
  • enddate — date

User

  • 월렛아이디 (walletId) — string — Primary key — NOT NULL
  • 닉네임 (nickname) — string — Primary key — NOT NULL
  • 프로필이미지 (profileImge) — string
  • 배너이미지 (bennerImage) — string
  • 유저소개 (description) — string
  • 블록 (block) — string
  • timestemps — date
  • Field

favorites

  • relationId — number — Primary key — NOT NULL
  • NFTtoken — string — Foreign key → Item.NFTtoken — NOT NULL
  • 닉네임 (nickname) — string — Foreign key → User.닉네임 — NOT NULL
  • 좋아요 (isLike) — number

favoritesCount

  • countId (conuntId) — number — Primary key — NOT NULL
  • NFTtoken — string — Foreign key → Item.NFTtoken — NOT NULL
  • 좋아요 숫자 (likeCount) — number

offer

  • chatingId — number — Primary key — NOT NULL
  • auctionId — number — Foreign key → Auction.auctionId — NOT NULL
  • 월렛아이디 (walletId) — string — Foreign key → User.월렛아이디 — NOT NULL
  • 닉네임 (nickname) — string — Foreign key → User.닉네임 — NOT NULL
  • 입찰가 (biddingPrice) — number
  • timestemps — date