crates/secd/store/pg/sql/find_identity_by_code.sql


1
2
3
4
5
6
7
8
9
10
11

select identity_email_id
from auth.email_validation
where email_validation_public_id = $1::uuid
--
select
        identity_public_id
        , data
        , i.created_at
from auth.identity            i
left join auth.identity_email ie using (identity_id)
where ie.identity_email_id = $1;