As seen in https://gitlab.com/gitlab-org/gitlab/issues/198593#note_276245548, projects can be orphaned when their namespaces entries get removed. Currently `namespaces` is a STI table that supports both `Namespace` and `Group`, but I think we can still add a foreign constraint key constraint between `projects.namespaces_id` and `namespaces`.