Add missing foreign keys

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

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?
Edited by 🤖 GitLab Bot 🤖