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