Hey all,
I have a shop locator and here are the tables in it.
Is this a good SQL DB schema? It just seems like in order to pull up a shop, I need to make so many calls (I pull the shop, then I gotta pull the city ID, then, from that, I gotta pull the state ID for EVERY record.)
Is there any...