E-commerce Database Schema

erDiagram
    USER ||--o{ ORDER : places
    USER {
        string id PK
        string email
        string name
        datetime created_at
    }
    ORDER ||--|{ ORDER_ITEM : contains
    ORDER {
        string id PK
        string user_id FK
        float total
        string status
    }
    ORDER_ITEM }o--|| PRODUCT : references
    PRODUCT {
        string id PK
        string name
        float price
        int stock
    }