Add foreign key constraints

[begriffs]

Turn them into associations
• belongs_to
• has_one
• has_many
• has_and_belongs_to_many

Distinguishing foreign keys that were intended as has_one vs has_many might be tricky.