I am developing an application that let adviser to assign advising times and let the student to schedule to meet the advisor at the assigned times.
I have 5 tables advisor, student, advisor_schedule, student_queue and advisor_office_hr.
I need to create the log in page .
role: student/ advisor
would you advise me how to structure the data to create the log in page do I need another table for role, how to let the application decide whether the advisor or the students is logging in .