Add DB constraints for tables used by Copr plugin

[mizdebsk]

Since we have no real data for testing Copr plugin, I tried generating some random data. But it seems I violated non-written assumptions about DB consistency, which caused numerous crashes in frontend.