# Relationship Diagram **URL:** \ **Category:** APIs & Integrations\ **Tags:** developer-tools\ **Created:** [June 17, 2020, 8:18pm UTC](https://community.hubspot.com/t/relationship-diagram/21808 "2020-06-17T20:18:19Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![tkravchuk](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tkravchuk/32/77060_2.png) [@tkravchuk](https://community.hubspot.com/u/tkravchuk)\ **Post date:** [June 17, 2020, 8:18pm UTC](https://community.hubspot.com/t/relationship-diagram/21808/1 "2020-06-17T20:18:19Z")
Hello, I’m a new developer to Hubspot. I’m trying to wrap my head around the data relationships among all the different API objects. To make this more straightforward, it would be great to take a look at an ERD, or entity relationship diagram, in order to more easily work with Hubspot data. I haven’t been able to find one in the docs or past posts herein. Could someone point me in the right direction to find one? ---
**Author:** ![Willson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/willson/32/84663_2.png) [@Willson](https://community.hubspot.com/u/Willson)\ **Post date:** [June 18, 2020, 10:07am UTC](https://community.hubspot.com/t/relationship-diagram/21808/2 "2020-06-18T10:07:37Z")
Hey @tkravchuk You can find the HubSpot ERD on this [documentation here](https://legacydocs.hubspot.com/docs/crm-integration-guide/overview). I hope this helps! ---
**Author:** ![tkravchuk](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tkravchuk/32/77060_2.png) [@tkravchuk](https://community.hubspot.com/u/tkravchuk)\ **Post date:** [June 18, 2020, 2:04pm UTC](https://community.hubspot.com/t/relationship-diagram/21808/3 "2020-06-18T14:04:32Z")
Hi @Willson, It looks like this revolves around the CRM system, and marketing emails aren’t included. Looking for how lists relate to marketing emails and contacts, and any other relationships on the marketing email delivery side of your system. Is there an ERD for those? Thanks ---
**Author:** ![DrAJ71](https://avatars.discourse-cdn.com/v4/letter/d/4bbf92/32.png) [@DrAJ71](https://community.hubspot.com/u/DrAJ71)\ **Post date:** [August 16, 2022, 11:28am UTC](https://community.hubspot.com/t/relationship-diagram/21808/4 "2022-08-16T11:28:49Z")
Hi @Willson , The ERD says it was updated in March 2022, however it still glosses over emails - Emails are still summarised within an ‘Engagement’ entity with ‘Type(oneof: Email, Call, Task, Meeting, Note)’. I’m using an API to enable visualisations of HubSpot data in Tableau (for all it’s benefits, I find HubSpot enforces too much ‘silo-ing’ of data for full analysis of results across different entities), and from looking at tables via Tableau Prep, there appear to be a number of email/campaign related tables underlying HubSpot - ‘Campaign’, ‘CampaignEmail’, and ‘CampaignEmailEvent’. It would simplify things enormously if we could see just how these are related to each other, as well as to ‘Contact’ and ‘Company’ entities. I’m sure i’ll figure it out, but it would be useful to easily see what the relevant primary and foreign keys are for each relationship. Sincerely, Andy ---
**Author:** ![gogeeprime](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gogeeprime/32/77566_2.png) [@gogeeprime](https://community.hubspot.com/u/gogeeprime)\ **Post date:** [April 28, 2021, 2:12am UTC](https://community.hubspot.com/t/relationship-diagram/21808/5 "2021-04-28T02:12:21Z")
Just FYI, it looks like now HubSpot’s API supports marketing email (as well as a lot more) — [Marketing API | Marketing Email - HubSpot docs](https://legacydocs.hubspot.com/docs/methods/lists/marketing-email-overview) ---
**Author:** ![shields-mops](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/shields-mops/32/56310_2.png) [@shields-mops](https://community.hubspot.com/u/shields-mops)\ **Post date:** [June 23, 2023, 7:59pm UTC](https://community.hubspot.com/t/relationship-diagram/21808/6 "2023-06-23T19:59:24Z")
@tkravchuk I could not find a complete HubSpot ER Diagram, so I made the Best HubSpot ER Diagram yet in Lucidchart at [https://lucid.app/lucidchart/6a45d47c-99f2-40f0-a353-dec7dc151d95/edit?viewport\_loc=76%2C-1558%2C3274%2C1420%2C0\_0&invitationId=inv\_4328c2ec-314f-4387-b8fd-aebe0b8898cb](https://lucid.app/lucidchart/6a45d47c-99f2-40f0-a353-dec7dc151d95/edit?viewport_loc=76%2C-1558%2C3274%2C1420%2C0_0&invitationId=inv_4328c2ec-314f-4387-b8fd-aebe0b8898cb) I need the engagement entities to be more organized on the map. If you have those engagement relationships solved, let’s work together to improve the map. ---
**Author:** ![bbuchert](https://avatars.discourse-cdn.com/v4/letter/b/ed8c4c/32.png) [@bbuchert](https://community.hubspot.com/u/bbuchert)\ **Post date:** [February 28, 2024, 3:29am UTC](https://community.hubspot.com/t/relationship-diagram/21808/7 "2024-02-28T03:29:07Z")
[Extract HubSpot data for analytics | Fivetran implementation](https://fivetran.com/docs/applications/hubspot) Maybe the erds listed here help.