Begin of the insertionThe goal isEnd of the insertion Begin of the deletion We wantEnd of the deletion to Begin of the insertionreplace version usage everywhere so that weEnd of the insertion Begin of the deletion represent a many to many relationship between WorkPackage & Version

A WorkPackageEnd of the deletion can Begin of the insertionrely on target\_versions as being the single sourceEnd of the insertion Begin of the deletion have many versionsEnd of the deletion of Begin of the insertiontruth. This should not cause any product behaviour changes, only transform how we use data.End of the insertion Begin of the deletion different types ("target"/"observed\_in")End of the deletion

Begin of the deletion A Version can be associated to many different WorkPackages

<br>

Goal:

create a new table work\_package\_associated\_versions with:

End of the deletion * Begin of the insertionmake sure write operations properly persist the data in target\_versionsEnd of the insertion Begin of the deletion idEnd of the deletion

* Begin of the insertionmake sure all subsystems read from target\_versions,End of the insertion Begin of the deletion version\_id

* work\_package\_id

* kind (target | observed\_in)


This table can represent any associated versions (both target/observed\_inEnd of the deletion and Begin of the insertionignore version


<br>End of the insertion Begin of the deletion any other types we may invent in the future)End of the deletion