Make owned FK columns not null and add unique constraints 

Create explicit indexes for FK cols that need to be part of unique
constraints
Create unique constraints for compound keys in association tables