Diagram template
Entity relationship
PowerTwo to eight entity boxes listing their fields with optional data types and primary or foreign key tags, arranged downward and joined by routed relationship links that end in crow's-foot symbols for how many records relate, each link optionally labeled.
Categories
Included in
Power, Max
When to use it
Use for a data model, such as the tables of a shop, a booking system, or a school database, where each entity lists its fields and each relationship states how many relate to how many. Not for services calling each other (use the dependency graph), a hierarchy, processes, or comparisons, and not for an entity related to itself.
Adjust after generating
Change the style, colors, and font, and these options, as often as you like without spending credits.
- Card shape
- Card fill
- Color distribution
- Card border
- Card shadow
- Typography
- Spacing
- Alignment
- Material
- Connectors
- Line weight
What you fill in
Describe your topic in plain words and the AI fills these in. You can edit every field afterwards.
- Entities
- 2 to 8, each with id and name
- Fields
- 2 to 48, each with entity, name, optional data type, and optional kind
- Edges
- 1 to 10, each with from, to, optional label, from cardinality, and to cardinality
Related templates
All architecture templates
Architecture: system contextA C4 system context diagram, a "who uses it and what it depends on" slide, or an integration overview: one system, one to four actors that use it, and one to five external systems it calls or that call it, each link saying what it does.
Architecture: dependency graphThree to twelve components that call or depend on each other with no fixed tiers, such as a microservice call map, a service dependency graph, or data lineage between systems, with links labeled by protocol or what flows (gRPC, REST, events).
Architecture: environmentsOne system shown as two to four copies that are compared side by side: dev, staging, and production environments with promotion between them, region A, region B, and disaster recovery with replication, or blue and green stacks.
Architecture: event hubEvent flows through one broker, bus, or topic hub with one to five producers and one to five consumers, such as Kafka topics, Google Pub/Sub, SNS fanning out to SQS queues, EventBridge rules, or a webhook gateway delivering to several handlers; built for fan-in and fan-out.
Architecture: grouped panels left to rightTwo to fourteen components placed in two to five networks, clusters, subnets, or accounts, such as an AWS VPC with public and private subnets or a Kubernetes cluster with namespaces, optionally inside one region with users or third-party services outside.
Architecture: isometric floating layer plates stacked with a clear gapA layered system where components rely on specific components in the layer directly below: software layers from experience through services to data, an operating model from strategy through operations to delivery teams, or a data stack from reports through warehouse and pipelines to sources.