I am developing an app that has two types of user: Customers and employees.
I have planned to make the supertype as user that contains only:
While there would be two subtypes (customer and employee). Each of them has different specific data, namely,
Could someone help me by suggesting a structure with what foreign key to put and implement?
I'm clearly new to making databases.