multiple entities that share a table I have this situation where i have two different entities, Researcher and Lab Manager and i want for a both to have a profile.
When a user logs in he could be one of the two entities, and searching in both tables for a username can be inefficient, so i think both of theme sharing a table called profile would be the way to go.
here is my attempt

but i realized two issues with it

instead of a researcher or manager have a profile, a profile have to have both a researcher and a manager as owners in the same time
when i query for a user how can i know his type without adding an attribute of type

any ideas would be appreciated
Allow Field to be NULL and every user that has no Field is researcher.
If field isn't enough there is also TeamId which can be -1 for magaers.
Or a combination of both
But to be honest a Type field make a lot if sense as Tinyint, and you  are felible for future as there must be student helpers and so on