er

Tables (5)

customers

  • customer_id — int — Primary key — NOT NULL
  • customer_name — varchar(255)
  • email — varchar(255)

order_items

  • order_item_id — int — Primary key — NOT NULL
  • order_id — int — Foreign key → orders.order_id
  • product_id — int — Foreign key → products.product_id
  • quantity — int

orders

  • order_id — int — Primary key — NOT NULL
  • customer_id — int — Foreign key → customers.customer_id
  • order_date — date

products

  • product_id — int — Primary key — NOT NULL
  • product_name — varchar(255)
  • price — decimal(10,2)

reviews

  • review_id — int — Primary key — NOT NULL
  • product_id — int — Foreign key → products.product_id
  • customer_id — int — Foreign key → customers.customer_id
  • rating — int
  • comment — text