This is what I have (simplified version)
USERS table
id
username
password
Each users has clients. The following table contains clients for all the users. userid column tells the app whose client it is.
CLIENTS table
id
userid (user client belongs to)
name
email
When a USER logs in, he sees a list of his CLIENTS.
SELECT * FROM CLIENTS WHERE USERID = 1234
The same goes for appointments, projects, etc.
Do you suggest I try another approach? For example, what about creating a table for each user so the user can have all of its clients information in a table. Or would that be complicating things.
Example:
table CLIENTS-1234
table CLIENTS-1235
table CLIENTS-1236
I’m sorry if this question is very basic. I’m going to start reading a book about just MySQL so I can make better, more informed MySQL database design decision.
