Revisit handling of `on_delete` in `workspaces` table migrations

The following discussion from !105783 (merged) should be addressed:

• @a_akgun started a discussion: (+2 comments)

  Minor nitpick: We may open an issue for this and remove the comments on the foreign key references.