I'm working/playing on an app where individual users' data will be completely independent from each other. Of course, there will be common tables for other parts of the app (e.g. "users"), but for the rest of the tables, would it be wise to create a new set of tables for each user?
List of tables: users user1_transactions, user1_items, user1_tags user2_transactions, user2_items, user2_tags
for a total of 7 tables for the 2 users.
Would I have trouble with migrations with this setup (assuming the condition that user data will always be independent)?
I don't have much experience with relational design, so I guess this is a "I don't know what I don't know" situation. Is this a bad idea?