Investigate logingov_uuid uniqueness constraint on Account table

[bosawt]

The uniqueness constraint for logingov_uuid and idme_uuid is a potential issue on the Account table, given that a user could have a non-verified Account (account1) with a logingov_uuid, a verified Account (account2) with an idme_uuid, then when the login.gov user is verified, there may be an attempt to update the account2 record with the logingov_uuid

[schaisso]

Hi @bosawt , I can help you on this issue. Is there a data model I can take a look at to investigate?