title: Collate ER Diagrams | Visualize Data Relationships
slug: /how-to-guides/data-discovery/er-diagrams
collate: true
---
# Collate: Entity Relationship (ER) Diagrams
## Overview
Entity Relationship (ER) Diagrams in Collate provide a visual representation of how tables are connected within a database. These diagrams offer a complete picture of your data structure by automatically detecting relationships based on constraints such as **primary keys** and **foreign keys** during metadata ingestion.
Collate's [**metadata ingestion workflow**](/connectors/ingestion/workflows/metadata) identifies and extracts table relationships, ensuring that **primary key** and **foreign key** constraints are accurately represented. Once ingestion is completed, users can access ER diagrams at both the **table level** and **database schema level**.
## Features of ER Diagrams
### Visualizing Table Relationships
- ER diagrams display **tables, constraints, and relationships** between them.
- **Relationship cardinality** is clearly indicated, helping users understand data connections.
- ER diagrams create a **common language** for database discussions.
- Helps teams **visualize complex relationships** and constraints.
### Enhanced Troubleshooting & Impact Analysis
- Users can quickly **identify table relationships** and assess the impact of schema changes.
- Assists in **debugging and optimizing database structures**.
With **Collate's ER Diagrams**, users gain **greater visibility** into their data relationships, improving **data discovery, governance, and analysis**.