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)