First thank you in advance! I would like ideas with my table architecture of my project. I am new to AirTable.
I am building a contact database for my homeowner’s association. Using node.js, Twilio Functions, I want to be able to ask the question, “What is the contact phone numbers for pool vendor and homeowners at 123 Oak Ave?”
These are the tables that I was thinking I need:
- homes address table with the house number, street
- vendor table with the different vendors’ name, address, multiple phone numbers and emails.
- contact table with names, link addresses, and multiple phone numbers and emails per record. An example would be I want both spouses cell phone numbers tied to the address. We have some people own multiple homes.
I would like a “Last Updated” column know too when any of the tables’ rows are updated.
Then, I want to provide associations to the different vendors for the home.
Example would be all Oak Ave address use the vendor Best Pools. We do have one offs too where house 231 Oak Ave uses a different pool vendor.