Add unique constraint to `detection_reviews` table - Githubissues

rfcx / rfcx-api

Core, Media/Assets and MQTT APIs

https://api.rfcx.org/docs/

Apache License 2.0

0 stars 0 forks source link

Add unique constraint to `detection_reviews` table #627

Closed grindarius closed 5 months ago

grindarius commented 5 months ago

✅ DoD

[x] Resolves #623
[ ] API docs updated na
[x] Release notes updated
[ ] Deployment notes updated na
[x] Unit or integration tests added
[x] DB migrations tested

(use na when API docs (Release notes, etc) do not need to be updated)

📝 Summary

Add unique constraint to table detection_reviews with column of (detection_id, user_id) to force a user to only have 1 review status per 1 detection only.

📸 Examples

Put screenshots or response/request examples here!

🛑 Problems

Write any discovered & unresolved problems (link to created Jira issues)

💡 More ideas

Write any more ideas you have