i have a table employees.
each employee has a manager.
a manager is also an employee that is stored in the employees table.
over their lifetime an employee could report to many different managers (depending on promotions, demotions of merges of departments.)
How can i model this?
ensuring that there is a history of every manager the employee has reported to over their lifetime.