Add missing foreign keys

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Close this issue

The following columns are missing foreign keys, which results in exported projects to reference user IDs that no longer exist in the source instance.

• approvals: user_id
• events: author_id
• issues: last_edited_by_id
• notes: updated_by_id, resolved_by_id

Proposal

• Add the missing foreign keys

Question

1. What it intentional not to have such foreign keys?
2. Should we create a data migration to remove invalid user references before or after adding the foreign keys?