Make Your NFT

Tables (16)

Account (account)

  • id (Auto-increment) — BIGINT(20) — Primary key — NOT NULL
  • username (사용자이름) — VARCHAR(255)
  • address (계정주소) — VARCHAR(255) — NOT NULL
  • regdate (생성일) — DATETIME
  • moddate (수정일) — DATETIME
  • email (이메일(아이디)) — VARCHAR(255) — Foreign key → Club Member.id — NOT NULL

Account Image (account_image)

  • inum (이미지번호) — BIGINT(20) — Primary key — NOT NULL
  • img_name (이미지이름) — VARCHAR(255)
  • path (이미지경로) — VARCHAR(255)
  • uuid (UUID) — VARCHAR(255)
  • account_id (Auto-increment) — BIGINT(20) — Foreign key → Account.id — NOT NULL

Asset (=Item) (asset)

  • id (아이디) — BIGINT(20) — Primary key — NOT NULL
  • name (자산이름) — VARCHAR(255)
  • description (자산설명) — VARCHAR(2000)
  • contract_date (Smart Contract) — DATETIME — NOT NULL — 구현 보류 중
  • url (자산URL) — VARCHAR(255)
  • owner_id (Auto-increment) — BIGINT(20) — Foreign key → Account.id — NOT NULL
  • collection_id (Auto-increment2) — BIGINT(20) — Foreign key → Collection.id — NOT NULL

Asset Image (asset_image)

  • id (이미지번호) — BIGINT(20) — Primary key — NOT NULL
  • name (이미지이름) — VARCHAR(255)
  • path (이미지경로) — VARCHAR(255)
  • uuid (UUID) — VARCHAR(255) — NOT NULL
  • regdate (생성일) — DATETIME — NOT NULL
  • moddate (수정일) — DATETIME
  • assets_id (아이디) — BIGINT(20) — Foreign key → Asset (=Item).id — NOT NULL

Auction (nft_sale_auction_type(Enum))

  • id (OpenSea_ID) — BIGINT(20) — Foreign key → NFT Sale.id — NOT NULL — OpenSea API에서 제공되는 Unique Field
  • auction_set (거래방법) — INT — NOT NULL

Club Member (club_member)

  • id (인덱스) — Auto-Increment — Primary key — NOT NULL
  • password (비밀번호) — VARCHAR(255) — NOT NULL
  • phone (전화번호) — VARCHAR(255)
  • address (주소)
  • from_social (소셜가입여부) — BOOLEAN — NOT NULL
  • regdate (생성일) — DATETIME — NOT NULL
  • moddate (수정일) — DATETIME
  • email (이메일) — VARCHAR(255) — NOT NULL

Club Member Role Set (club_member_role_set(Enum))

  • role_set (권한(USER, MEMBER, ADMIN))) — INT — NOT NULL
  • clubMember (인덱스) — Auto-Increment — Foreign key → Club Member.id — NOT NULL

Collection (collection)

  • id (Auto-increment) — BIGINT(20) — Primary key — NOT NULL
  • slug (Slug(키워드를 사용한 URL의 일부)) — VARCHAR(255) — NOT NULL
  • name (컬렉션이름) — VARCHAR(255)
  • url (OpenSea_url) — VARCHAR(255)
  • regdate (생성일) — DATETIME — NOT NULL
  • moddate (수정일) — DATETIME

Member (member)

  • mid (사용자번호) — BIGINT(20) — Primary key — NOT NULL
  • name (사용자이름) — VARCHAR(255)
  • bio (사용자설명) — VARCHAR(255)
  • wallet_address (지갑주소) — VARCHAR(255) — NOT NULL
  • regdate (생성일) — DATETIME — NOT NULL
  • moddate (수정일) — DATETIME
  • password (비밀번호) — VARCHAR(255)
  • from_social (소셜가입여부) — BOOLEAN
  • email (이메일) — VARCHAR(255)

Member Role Set (member_role_set(Enum))

  • mid (회원번호) — BIGINT(20) — Foreign key → Member.mid — NOT NULL
  • role_set (권한(USER, MEMBER, ADMIN))) — INT — NOT NULL

NFT Image (nft_image)

  • inum (이미지번호) — BIGINT(20) — Primary key — NOT NULL
  • img_name (이미지이름) — VARCHAR(255)
  • path (이미지경로) — VARCHAR(255)
  • uuid (UUID) — VARCHAR(255) — NOT NULL
  • nft_num (NFT번호) — BIGINT(20) — Foreign key → NFT Info.num — NOT NULL

NFT Info (nft_info)

  • num (NFT번호) — BIGINT(20) — Primary key — NOT NULL
  • title (NFT이름) — VARCHAR(255) — NOT NULL
  • regdate (생성일) — DATETIME — NOT NULL
  • moddate (수정일) — DATETIME
  • external_link (상세페이지링크) — VARCHAR(255)
  • content (NFT설명) — VARCHAR(255)
  • like (좋아요) — BIGINT(20) — NOT NULL
  • price (가격) — BIGINT(20)

NFT Sale (nft_sale)

  • id (OpenSea_ID) — BIGINT(20) — Primary key — NOT NULL — OpenSea API에서 제공되는 Unique Field
  • time (판매시간) — DATETIME
  • auction_type (경매유형) — VARCHAR(255)
  • contract_address (스마트계약서주소) — VARCHAR(255)
  • quantity (NFT판매수량) — BIGINT(20)
  • payment_symbol (결제기호) — VARCHAR(255)
  • total_price (NFT지불가격) — DOUBLE
  • asset_id (자산아이디) — BIGINT(20) — Foreign key → Asset (=Item).id — NOT NULL
  • seller_account (판매자계정) — BIGINT(20) — Foreign key → Account.id — NOT NULL
  • winner_account (구매자계정) — BIGINT(20) — Foreign key → Account.id — NOT NULL
  • from_account (Transfer_from) — BIGINT(20) — Foreign key → Account.id
  • to_account (Transfer_to) — BIGINT(20) — Foreign key → Account.id
  • collection_id (컬렉션아이디) — BIGINT(20) — Foreign key → Collection.id — NOT NULL

Order (order)

  • oid (주문번호) — BIGINT(20) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • member_mid (사용자번호) — BIGINT(20) — Foreign key → Member.mid — NOT NULL

Payment Symbol (nft_sale_payment_symbol(Enum))

  • id (OpenSea_ID) — BIGINT(20) — Foreign key → NFT Sale.id — NOT NULL — OpenSea API에서 제공되는 Unique Field
  • auction_set (거래방법) — INT — NOT NULL

Use (use)

  • Key — Primary key — NOT NULL
  • Field
  • Field2