shopping

Tables (7)

cart_list

  • cart_id — INT — Primary key — NOT NULL
  • customer_id — INT — Foreign key → customers.customer_id — NOT NULL
  • product_id — INT — Foreign key → product.product_id — NOT NULL
  • cart_qt — INT

customers

  • customer_id — INT — Primary key — NOT NULL
  • customer_pw — VARCHAR(45)
  • customer_name — VARCHAR(45)
  • customer_email — VARCHAR(45)
  • customer_address — VARCHAR(45)
  • customer_phonenum — VARCHAR(45)

item_order

  • order_id — INT — Primary key — NOT NULL
  • customer_id — INT — Foreign key → customers.customer_id — NOT NULL
  • order_date — DATE

order_detail

  • order_id — INT — Foreign key → item_order.order_id — NOT NULL
  • product_id — INT — Foreign key → product.product_id — NOT NULL
  • order_qt — INT
  • order_status — VARCHAR(100)

product

  • product_id — INT — Primary key — NOT NULL
  • product_name — VARCHAR(45) — NOT NULL
  • product_price — INT
  • product_dealer — VARCHAR(45)

product_review

  • review_id — INT — Primary key — NOT NULL
  • product_id — INT — Foreign key → product.product_id — NOT NULL
  • order_id — INT — Foreign key → item_order.order_id — NOT NULL
  • product_rating — INT
  • product_review — VARCHAR(1000)

stock (Untitled)

  • product_id — INT — Foreign key → product.product_id — NOT NULL
  • stock_qt — INT
  • stock_supply — VARCHAR(45)