[48226601] create unique-index for join-table

This will ensure one candidate cannot be assigned to one opening multiple-times.