Topic: dual foreing keys
I have a table of Users. In the table are employees and clients (all of them can logon to the website). I also have a table called requests. The request has a foreign key to the users table to link who made the request (a client in the user table).
I would like to have a second foreign key in the request table that links to the users table for the employee the request is assigned to.
Is that possible? Or do I need to rethink this and have a separate table for employees?