shop
Tables (11)
Untitled (product)
- Key (product_id) — NOT NULL — Primary key — NOT NULL
- Field (sku) — NOT NULL
- Field (name) — NOT NULL
- Field (price) — NOT NULL
- Field (offerEnd) — NOT NULL
- Field (new) — NOT NULL
- Field (saleCount) — NULL
- Field (thumbnail) — NULL
- Key (variation) — KEY — Foreign key → Untitled.Key — NOT NULL
- Key (category_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Key (review+id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
Untitled (variation)
- Key (variation) — KEY — Primary key — NOT NULL
- Field (color) — NOT NULL
- Field (image) — NOT NULL
- Field (size) — NOT NULL
Untitled (cart)
- Key (cart_id) — NOT NULL — Primary key — NOT NULL
- Key (customer_id) — NOT NULL — Foreign key → customer.Key — NOT NULL
- Key (product_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Key (wishlist_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
Untitled (coupon)
- Key (coupon_id) — NOT NULL — Primary key — NOT NULL
- Field (discount_rate) — NOT NULL
- Field (expiration_date) — NOT NULL
- Field (coupon_name) — NOT NULL
- Key (product_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Key (customer_id) — NOT NULL — Foreign key → customer.Key — NOT NULL
- Key — Foreign key — NOT NULL
Untitled (checkout)
- Key (checkout_id) — NOT NULL — Primary key — NOT NULL
- Key (product_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Key (customer_id) — NOT NULL — Foreign key → customer.Key — NOT NULL
- Key (cart_id) — NULL — Foreign key → Untitled.Key — NOT NULL
Untitled (category)
- Key (category_id) — NOT NULL — Primary key — NOT NULL
- Field (category_name) — NOT NULL
Untitled (Contact)
- Key (customer_id) — NOT NULL — Foreign key → customer.Key — NOT NULL
- Field (content) — NOT NULL
- Field — NULL
Untitled (orderdata)
- Key (data_id) — NOT NULL — Primary key — NOT NULL
- Key (product_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Key (customer_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Key (coupon_id) — NOT NULL — Foreign key — NOT NULL
- Key (checkout_id) — NOT NULL — Foreign key — NOT NULL
Untitled (wishlist)
- Key (wishlist_id) — NOT NULL — Primary key — NOT NULL
- Key (customer_id) — NOT NULL — Foreign key → customer.Key — NOT NULL
- Key (product_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
Untitled (review)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Field (rating) — NOT NULL
- Field (content) — NOU NULL
customer
- Key (customer_id) — NOT NULL — Primary key — NOT NULL
- Field (address) — NULL
- Field2 (credit_info) — NULL
- Field (phone_num) — NOT NULL
- Field (password) — NOT NULL
- Key (data_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Key (coupon_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Field (name) — NOT NULL