Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Error in Aircall ERD

Completed
Jake Rohald User

Hi - can I clarify the following point.

In the Aircall ERD here: https://docs.google.com/presentation/d/1ANyTSOJlfQVLPZvxcpWB_TljO5zSPQruYU36YYNQ9lA/edit#slide=id.g148fa4730e7_0_5, for the contact_number table, is the contact_number id suppose to be a foreign key to the numbers table? If so, when I ingested data into my staging environment a few months ago,  I think it might not be referencing correctly as a foreign key to the numbers table.

Could you let me know if I am mistaken in this matter?

Thanks
Jake

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Unnikrishnan Nair Fivetranner

    Hi Jake,
    An update here slipped through the cracks.
    This is the analysis from our team:

    "The numbers.id represents the ID associated with a company and its information, whereas the contact_number.id refers to the ID associated with a specific phone number for an individual contact".

    Hope this helps.