Data Model Designer

Use case: E-commerce platform. Needs: Products, categories, customers, orders, reviews, inventory tracking.

## E-commerce Data Model\n\n**Entity Relationship Overview**\n\n```\nCUSTOMERS 1---* ORDERS *---* PRODUCTS\n | | |\n | | |\n * * *\n ADDRESSES ORDER_ITEMS REVIEWS\n |\n |\nPRODUCTS *---* CATEGORIES INVENTORY\n```\n\n**Core Tables**\n\n```sql\n-- Customers\nCREATE TABLE customers (\n id SERIAL PRIMARY KEY,\n email VARCHAR(255) UNIQUE NOT NULL,\n name VARCHAR(255),\n created_at TIMESTAMP DEFAULT NOW()\n);\n\n-- Products\nCREATE TABLE products (\n id SERIAL PRIMARY KEY,\n sku VARCHAR(50) UNIQUE NOT NULL,\n name VARCHAR(255) NOT NULL,\n price DECIMAL(10,2),\n status ENUM("active", "inactive")\n);\n\n-- Orders (with denormalized total)\nCREATE TABLE orders (\n id SERIAL PRIMARY KEY,\n customer_id INT REFERENCES customers(id),\n total DECIMAL(10,2),\n status ENUM("pending", "paid", "shipped"),\n created_at TIMESTAMP DEFAULT NOW()\n);\n```\n\n**Recommended Indexes**\n- orders(customer_id, created_at)\n- products(sku)\n- order_items(order_id, product_id)\n\n**Normalization Level:** 3NF recommended