Mermaid Entity Relationship Diagram with MAIDR

Each entity announces its attributes; each relationship is read with its verb and both cardinalities.

erDiagram
  CUSTOMER ||--o{ ORDER : places
  ORDER ||--|{ LINE-ITEM : contains
  PRODUCT ||--o{ LINE-ITEM : "ordered in"
  CUSTOMER {
    string name PK
    string email
  }
  ORDER {
    int number PK
    date placed
  }
  PRODUCT {
    string code PK
    float price
  }