Skip to content
PlantUML templates

PlantUML — Information Engineering ER

Information Engineering (crow's-foot) ER notation — the most common ER style in industry.

Template previewPlantUML
Rendering…

Make it your own.

@startuml
!define table(x) entity x << (T,#FFAAAA) >>
hide circle
skinparam linetype ortho

entity "Customer" as cust {
  * id : number <<PK>>
  --
  * name : text
  email : text
}
entity "Order" as ord {
  * id : number <<PK>>
  --
  * customer_id : number <<FK>>
  total : number
  status : text
}
entity "Line Item" as li {
  * id : number <<PK>>
  --
  * order_id : number <<FK>>
  * sku : text <<FK>>
  qty : number
  price : number
}
entity "Product" as prod {
  * sku : text <<PK>>
  --
  title : text
  price : number
}

cust ||--o{ ord : "places"
ord  ||--|{ li  : "contains"
prod ||--o{ li  : "appears in"
@enduml