When you delete your account, we atomically null out the authenticator fields (encrypted_password, auth_token, email, unconfirmed_email, confirmation_code), revoke every AuthSession, and set status='deleted'.
Conversations and household rows are preserved because they carry references from other members of the household, but the user foreign-key has no way back to you — your content becomes orphan rows. After 30 days the orphan rows are garbage-collected. If you want deletion to be literal and immediate (rather than soft-delete + GC), write to [email protected] with your request.