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!