Add missing indexes

Some foreign keys were not properly indexed, which was likely to cause a bunch of full table scans when fetching based on that foreign key