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