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.