E-commerce Database ER Diagram Template

erDiagram
    CUSTOMER ||--o{ ORDER : places
    CUSTOMER ||--o{ ADDRESS : has
    ORDER ||--|{ ORDER_ITEM : contains
    PRODUCT ||--o{ ORDER_ITEM : "appears in"
    CATEGORY ||--o{ PRODUCT : groups
    ORDER ||--o| PAYMENT : "is paid by"
    CUSTOMER {
        string customer_id PK
        string phone
        string display_name
        datetime created_at
    }
    ADDRESS {
        string address_id PK
        string customer_id FK
        string recipient
        string street_address
    }
    ORDER {
        string order_no PK
        string customer_id FK
        string address_id FK
        decimal total
        string status
        datetime created_at
    }
    ORDER_ITEM {
        string item_id PK
        string order_no FK
        string product_id FK
        int quantity
        decimal unit_price
    }
    PRODUCT {
        string product_id PK
        string category_id FK
        string name
        decimal price
        int stock
    }
    CATEGORY {
        string category_id PK
        string name
    }
    PAYMENT {
        string transaction_id PK
        string order_no FK
        decimal amount
        string channel
    }

Draw an e-commerce database ER diagram in Mermaid erDiagram syntax with entities CUSTOMER, ADDRESS, ORDER, ORDER_ITEM, PRODUCT, CATEGORY and PAYMENT. A customer places many orders and has many addresses; an order contains one or more order items; a product appears in many order items; a category groups many products; an order is paid by zero or one payment. List the main fields of each entity with PK and FK markers. Output only the mermaid code block.