I am integrating employee/position data with another system.
The first system is HR. It has an Employee table and a Positions table. The second system tracks office space and tracks who the office belongs to. It uses one table [em] to store both employees and position data.
If an employee changes position then the position id changes. If the position becomes vacant and a new employee fills the position then employee id is changed.
Both position id and employee ID act like primary keys for this table. I am trying to figure out if there is a name for this type of relationship in a database terminology?