This uniqueness constraint needs to be mirrored in the `add_index` call in the migration to free us from race condition uniqueness checks.