WORK

Tables (4)

CART

  • USERID (Key) — Foreign key → USER.USERID — NOT NULL
  • ITEMNAME (Key2) — Foreign key → PRODUCT.ITEMID — NOT NULL
  • ITEMCOUNT (Field)
  • TOTALPRICE (Field2)
  • Field3

ORDER (Untitled4)

  • ORDERNUM (Key) — Primary key — NOT NULL
  • USERNAME (Key2) — Foreign key → CART.USERID — NOT NULL
  • ITEMNAME (Key22) — Foreign key → CART.ITEMNAME — NOT NULL
  • ORDERDATE (Field)
  • ORDERPRICE (Field2)

PRODUCT (Untitled2)

  • ITEMID (Key) — Primary key — NOT NULL
  • ITEMNUM (Field)
  • ITEMSTOCK (Field3)
  • ITEMPRICE (Field2)

USER (Untitled)

  • USERID (Key) — Primary key — NOT NULL
  • USERPWD (Field)
  • USERADR (Field2)
  • USERNUM (Field3)
  • USERPT (Field4)