Add indexes for foreign keys

Related to #206 (closed).

This MR adds indexes for all foreign keys, as per our development guidelines.

Note: The tables exclusively related to GC are out of scope in this MR. Those are dependent on !373 (merged).