We want to represent a many to many relationship between WorkPackage & Version.

A WorkPackage can have many versions of different types (target/observed\_in).

A Version can be associated to many different WorkPackages

<br>

### Begin of the insertionGoal:End of the insertion Begin of the deletion Decisions:End of the deletion

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

* id

* version\_id

* work\_package\_id

* kind (target | observed\_in)


This table can represent any associated versions (both target/observed\_in and any other types we may invent in the future) Begin of the insertion

<br>

Reference implementation - https://github.com/opf/openproject/pull/22473/changes/cb8e53f82d9f48109953a527ccdfa537415788c0End of the insertion