NFT프로젝트

테이블 (5)

Assets (Untitled5)

  • asset_id (Key) — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → User.user_id — NOT NULL
  • image_url (Field) — varchar(200)
  • token_id (Field2) — int
  • asset_name (Field3) — varchar(100)

Contract (Untitled2)

  • contract_id (Key) — int — 기본 키 — NOT NULL
  • cA (Field) — varchar(60)
  • network_id (Field2) — tinyint(4)
  • abiType (Field3) — tinyint(4)

Donation (Untitled3)

  • donation_id (Key) — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → User.user_id — NOT NULL
  • price (Field2) — varchar(50)
  • profile_image_url (Field3) — varchar(200)
  • nickname (Field4) — varchar(20)
  • date (Field) — timestamp

Market (Untitled4)

  • market_id (Key) — int — 기본 키 — NOT NULL
  • asset_id (Key2) — int — 외래 키 → Assets.asset_id — NOT NULL
  • price (Field) — varchar(50)

User (Untitled)

  • user_id — int — 기본 키 — NOT NULL
  • email — varchar(50)
  • wallet_address (Field2) — varchar(100)
  • nickname (Field3) — varchar(20)
  • profile_image_url (Field4) — varchar(200)
  • bio (Field5) — varchar(100)