e-commerce
Tables (7)
Cart
- Key — Primary key — NOT NULL
- Field
CartItem
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Cart.Key — NOT NULL
- Field
- Field2
- Field3
Category
- Key — Primary key — NOT NULL
- Field — NOT NULL
Order
- Key — Primary key — NOT NULL
- Field — NOT NULL
- Field3 — NOT NULL
- Field4
- Field5 — NOT NULL
OrderItem
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Order.Key — NOT NULL
- Field
- Field2
- Field3
Products
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Category.Key — NOT NULL
- Field — NOT NULL
- Field2 — NOT NULL
- Field3 — NOT NULL
- Field4
- Field5 — NOT NULL
- Field6
USER (User)
- Key — binint(20) — Primary key — NOT NULL
- Field
- Field2 — NOT NULL
- Field3
- Field6
- Field4 — NOT NULL
- Field5
- Field7
- Field8
- Field9
- Field10