---
title: "Entity relationship diagram"
description: "Provides the entity relationship diagram (ERD) for the Reporting API tables as a downloadable PDF."
contentType: "reference"
url: "https://developer.mindtickle.com/docs/reporting/entity-relationship-diagram/"
---

The entity relationship diagram (ERD) illustrates the structure of the Reporting API tables and defines how they relate to one another through common metrics and unique identifiers, that is primary and foreign keys.

## What the ERD shows

- **Data model:** How user, content, and performance data are organized.
- **Relationships:** The correct keys to join tables for complex queries.
- **Integration design:** How to design ETL pipelines that feed Mindtickle data into your BI tools.

## Download

[Mindtickle Reporting APIs entity relationship diagram (PDF)](/docs/files/reporting/mindtickle-reporting-apis-entity-relationship-diagram-erd.pdf)

## Related

- [Tables: performance and completion](/docs/reporting/tables-performance-and-completion/): The tables the diagram maps.
- [Best practices](/docs/reporting/best-practices/): How to query the tables once you know how they join.