The demo shown below was taken from the official Mermaid documentation.

erDiagram
    CUSTOMER ||--o{ ORDER : places
    ORDER ||--|{ LINE-ITEM : contains
    CUSTOMER }|..|{ DELIVERY-ADDRESS : uses

Textual representation

erDiagram
    CUSTOMER ||--o{ ORDER : places
    ORDER ||--|{ LINE-ITEM : contains
    CUSTOMER }|..|{ DELIVERY-ADDRESS : uses

The code above is rendered by "Prism Syntax Highlighter for Confluence" which supports highlighting Mermaid syntax.

👉 Check out the official Mermaid documentation here https://mermaid.js.org/syntax/entityRelationshipDiagram.html.