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