FYN

Tables (5)

Cart

  • cartId (Key) — int — Primary key — NOT NULL
  • memId (Key2) — varchar(50) — Foreign key → Member.memId — NOT NULL
  • nftId (Key3) — int — Foreign key → NFT.nftId — NOT NULL
  • memName (Field2) — varchar(50)
  • nftTitle (Field5) — varchar(200)
  • nftPrice (Field7) — int

Member (Untitled)

  • memId (Key) — varchar(50) — Primary key — NOT NULL
  • memPassword — varchar(50)
  • memName (Field2) — varchar(50)
  • memEmail (Field3) — varchar(200)
  • memPhone (Field4) — varchar(50)
  • memMoney (Field) — int
  • memRank (Field6) — int

NFT (Untitled2)

  • nftId (Key) — int — Primary key — NOT NULL
  • nftTitle (Field) — varchar(200)
  • nftDate (Field2) — Date
  • nftPrice (Field3) — int
  • nftPic (Field4) — varchar(200)
  • Key2 — int(default 0) — NOT NULL

Notice (CopyOfUntitled2)

  • notId (Key) — int — Primary key — NOT NULL
  • notTitle (memPassword) — varchar(100)
  • notContent (Field2) — varchar(900)
  • notDate (Field3) — Date

Reply (CopyOfUntitled3)

  • repId (Key) — int — Primary key — NOT NULL
  • memId (Key2) — varchar(50) — Foreign key → Member.memId — NOT NULL
  • nftId (Key3) — int — Foreign key → NFT.nftId — NOT NULL
  • memName (Field2) — varchar(50)
  • repTitle (Field6) — varchar(100)
  • repContent (Field) — varchar(500)
  • repDate (Field3) — Date