jpmp

Tables (6)

image (Untitled2)

  • image_id (Key) — AI, NOT NULL — Primary key — NOT NULL
  • nft_id (Key2) — AI, NOT NULL — Foreign key → nft.nft_id — NOT NULL
  • image_src (Field) — Not Null
  • Field2

interest (관심)

  • user_no (Key) — AI — Foreign key → user.user_no — NOT NULL
  • nft_id (Key2) — AI, Not Null, Unique — Foreign key → nft.nft_id — NOT NULL

nft (아이템)

  • nft_id (Key) — AI, NOT NULL — Primary key — NOT NULL
  • nft_name (Field) — Not Null
  • nft_description (Field2) — Not Null
  • created (Field3) — Not Null
  • updated (Field4) — Not Null
  • status (Field5) — Not Null
  • auther_name (Field6) — Not Null
  • owner_address (Field7) — Not Null
  • on_sale_yn (Field8) — Not Null

nft_count (Untitled3)

  • nft_count_id (Key2) — Not Null — Primary key — NOT NULL
  • nft_id (Key) — Foreign key → nft.nft_id — NOT NULL
  • max_count (Field) — Not Null
  • count (Field2) — Not Null

sale_contract (Untitled)

  • sale_id (Key3) — AI, NOT NULL — Primary key — NOT NULL
  • user_no (Key) — Foreign key → user.user_no — NOT NULL
  • nft_id (Key2) — Foreign key → nft.nft_id — NOT NULL
  • start_date (Field) — Not Null
  • end_date (Field2) — Not Null
  • owner_id (Field3) — Not Null

user (유저)

  • user_no (Key) — AI, NOT NULL — Primary key — NOT NULL
  • id (Field) — Not Null, Unique
  • password (Field2) — Not Null
  • name (Field3) — Not Null
  • nickname (Field4) — Not Null, Unique
  • role (Field5) — Not Null
  • walletAddress (Field6) — null, Uinque
  • phone (Field7)
  • address (Field8)
  • address2 (Field9)
  • zip (Field10)
  • link (Field11)