I have a MySQL database model where I have different types of users, each having common field names, like 'username', 'password', 'first_name', 'last_name', etc. etc. I've designed it so that these common fields are stored in a 'base' table called 'users' and specific fields that apply to each type of user are stored in derived 'sub-tables' for each type of user.
Here is what it looks like:
I know that this is a better design than having the 'common' fields stored in every 'user' table.
The problem I'm having is I'm trying to figure out how I'm going insert a new user. What