Data relationships

Hi is there a schema doc somewhere of the data structures and how the relationship between tables are linked, if there is a relationship.

I do not want reverse engineer the relationship by query one table and query another time and try to find a collection with tables names and values.

Example: I assume there is a foreign key between Contact and Lead table?

Thanks in advance for your assistance.

I can definitely say that the response time and feedback is exceptional.

1 Like

Hi @Belinda_Whitfield,

I assume you are aware of the table schema reference but I’ll link that here:

https://developer.infusionsoft.com/docs/table-schema/

It’s not an ERD but is helpful. Also there is a graphic that you have to zoom in on to see but is helpful in looking at table dependencies. @Pav hosts it here:

Hope that all helps :wink:

1 Like

Thank you.
This will help for sure.

1 Like

I need to point out that Diagram needs to be upgraded as I have found more Table Relationships, plus there is a few other new API Tables.

1 Like