Add foreign keys to database

[mamhoff]

Many of our reference fields do not have foreign key constraints set. Since Rails 4.2, support for foreign keys is there for all DB adapters. There is a WIP PR in #2036, but that needs a serious rebase.

[jacobherrington]

This is relevant to the change being made in #2360 and should be revisited after it has been merged.