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