shoppingdb

Tables (4)

cart (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • date (Field) — timestamp
  • cnt (Field2) — int
  • pid (Key2) — int — Foreign key → product.id — NOT NULL
  • cid (Key3) — text — Foreign key → cust.id — NOT NULL

cate (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — text
  • cid (Key2) — int — Foreign key → cate.id — NOT NULL

cust (Untitled)

  • id (Key) — text — Primary key — NOT NULL
  • pwd (Field) — text
  • name (Field2) — text

product (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — text
  • price (Field2) — int
  • cid (Key2) — int — Foreign key → cate.id — NOT NULL