project erd
Tables (3)
CARD table (Untitled2)
- cid (Key) — int — Primary key — NOT NULL
- cname (Field) — varchar(100)
- cprice (Field2) — varchar(50)
- ckind (Field3) — varchar(20)
- cgrade (Field4) — varchar(30)
- cnt (Field5) — int
- cimage (Field6) — varchar(500)
Cart (Table)
- fid (Key) — int — Primary key — NOT NULL
- cid (FK) — int — Foreign key → CARD table.cid — NOT NULL
- mid (FK2) — varchar(100) — Foreign key → Customer.mid — NOT NULL
- amount (Field) — int
- mname (Field2) — varchar(50)
- cprice (Field3) — varchar(50)
- point (Field4) — int
Customer (Untitled3)
- mid (PK) — varchar(100) — Primary key — NOT NULL
- pw (Field) — varchar(100)
- mname (Field2) — varchar(50)
- phone (Field3) — varchar(100)
- point (Field4) — int
- role (Field5) — varchar(50)
- address (Field6) — varchar(150)