E-commerce Database ER Diagram

The prompt behind this diagram

An entity-relationship diagram for an e-commerce database with these tables: users (id, email, name, created_at), products (id, name, price, stock, category_id), categories (id, name), orders (id, user_id, status, total, created_at), order_items (id, order_id, product_id, quantity, unit_price), payments (id, order_id, provider, amount, status), reviews (id, user_id, product_id, rating, comment). Show primary keys, foreign keys and 1-N relationships.

Paste your own description (or Terraform / docker-compose / SQL schema) into draft1 and get a diagram like this for your exact system.