1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
insert into credential ( credential_public_id , identity_id , partial_key , type , data , created_at , revoked_at , deleted_at ) values ( $1 , (select identity_id from identity where identity_public_id = $2) , $3 , $4 , $5 , $6 , $7 , $8 );