1
vote
Enforce unique constraint without denormalization
If a task can belong only to one service, the second data model is the correct one. To enforce your constraint, you have to add a redundant copy of environment to task:
add a new column environment ...
- 47.9k
Only top scored, non community-wiki answers of a minimum length are eligible