I have four different types of entities that all require authentication in a web application. I want to use a single user login table for authentication. The user table would look like:
One of the entities would look like:
FkUser -> References User Record
My Question: How does the application refer back to the customer when I also have four other tables refering to a user record?
I have altered the User table as follows:
FkCustomer ->References Customer Table
FkEmployee - References Employee Table
The records in the reference columns would only be placed in the column that was valid such as customer.
Is there a better way to use a single login/user table with many different types of entities?