I have a house-share entity( primary key : house-share id) and housekeeper entity (primary key: housekeeper id).
At any point in time a housekeeper can only work in one house-share.
When a housekeeper finishes an allocation with a particular house-share the allocation is recorded(start date and end date).
A house-keeper may return to a house-share they previously worked in; if they do so, a new allocation is recorded.
I believe the relationship between house share and housekeeper must be many to many. I can come up with a bridge entity(e.g. housekeepingwork) which have pk's housekeeper id, start_date and end_date. But usually a bridge entity will have primary keys from both entities but not in this case. I'm wondering if I'm modelling this wrong?