HomeDiagramsER diagramER: Mixed Identifying & Non-Identifying

ER: Mixed Identifying & Non-Identifying

Both solid and dashed lines in the same diagram.

er-mixed-identifying-non-identifying.mmd
erDiagram
  ORDER ||--|{ LINE_ITEM : contains
  ORDER ||..o{ SHIPMENT : ships-via
  PRODUCT ||--o{ LINE_ITEM : includes
  PRODUCT ||..o{ REVIEW : receives
Output
ER diagram, Zombie Mermaid ORDER (no attributes) LINE_ITEM (no attributes) SHIPMENT (no attributes) PRODUCT (no attributes) REVIEW (no attributes) contains ships-via includes receives

More ER diagram examples

ER diagram, Zombie Mermaid CUSTOMER (no attributes) ORDER (no attributes) places
ER: Basic Relationship
ER diagram, Zombie Mermaid CUSTOMER PK int id string name UK string email date created_at
ER: Entity with Attributes
ER diagram, Zombie Mermaid ORDER PK int id FK int customer_id UK string invoice_number decimal total date order_date string status
ER: Attribute Keys (PK, FK, UK)
ER diagram, Zombie Mermaid PERSON (no attributes) PASSPORT (no attributes) has
ER: Exactly One to Exactly One (||--||)
ER diagram, Zombie Mermaid CUSTOMER (no attributes) ORDER (no attributes) places
ER: Exactly One to Zero-or-Many
ER diagram, Zombie Mermaid SUPERVISOR (no attributes) EMPLOYEE (no attributes) manages
ER: Zero-or-One to One-or-Many