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)