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