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).
Edited by João Pereira