Hi guys, I’m currently in development for a full stack saas application and would like some advice on the database design.
The app is a management app for a family member’s cleaning business to help pool their client scheduling information all in one location. The front end is react, the backend is node.js, and the database is mysql. The idea right now is to create the app with the intention of scaling out to multiple businesses.
The current problem I’m facing is how I’ll keep the data isolated in mysql from multiple users managing their own client data. My thought is to create a user table and FK the client table to that specific user when they user creates new clients. What do you guys think about this? And would there be a better way to handle this given the intention to scale out in the future? Any help would be awesome thank you!
Thats a lot of help with those example questions to ask myself. Do you have any recommendations on resources to use to learn basic database design? I’m currently looking at essentialsql.com going through their database normalization right now.