Add missing indexes to collaboration-related tables

[#79005958]

Mostly foreign keys. Looks like there could be more places where
indexes could be useful (perhaps new bug / chore?), but this commit
fixes collaboration-related tables only.