shop

Tables (5)

cart

  • id — bigint — Primary key — NOT NULL
  • purchase_date — timestamp(6)
  • customer_id — bigint

cart_products

  • cart_id — bigint — NOT NULL
  • products_id — bigint — NOT NULL

customer

  • id — bigint — Primary key — NOT NULL
  • address — varchar(255)
  • name — varchar(255)
  • phone_number — varchar(255)
  • points — integer

product

  • id — bigint — Primary key — NOT NULL
  • category — varchar(255)
  • name — varchar(255)
  • price — float(53)
  • rating — float(53)
  • stock — integer

review

  • id — bigint — Primary key — NOT NULL
  • rating — integer
  • review — varchar(255)
  • customer_id — bigint
  • product_id — bigint