Hi, I'm doing a college project, it's an internship site project, it has to be developed in Java WEB with database. It has three types of users, the student, the company, and the administrator. I would like to know if there is any way I can log in to the three tables at the time of logging in.
I was thinking of making a user table, which has the email, the password, the type of it (1- adm, 2 student ...) and finally a user id field in its respective table. I would then do the query in the user table, and from the type of it, I would find out the table where it is and with the id found it.
In this way I'm doing two searches. have another way to do with just one?
Thank you!