Mermaid-Grammer-Inspector

erDiagram CUSTOMER { string customer_id PK string name string email string phone date created_at } ORDER { string order_id PK string customer_id FK decimal total_amount string status date order_date date delivery_date } ORDER_ITEM { string item_id PK string order_id FK string product_id FK int quantity decimal unit_price decimal subtotal } PRODUCT { string product_id PK string name string description decimal price int stock_quantity string category_id FK } CATEGORY { string category_id PK string name string description } PAYMENT { string payment_id PK string order_id FK decimal amount string payment_method string status date payment_date } CUSTOMER ||--o{ ORDER : "places" ORDER ||--o{ ORDER_ITEM : "contains" PRODUCT ||--o{ ORDER_ITEM : "included in" CATEGORY ||--o{ PRODUCT : "categorizes" ORDER ||--|| PAYMENT : "paid by"