A unique list of every email address we've seen in claims and eligibility
Primary Key:Checks:email_email_domain_check
-(email_domain = lower(email_domain))
email_email_user_check
-(email_user = lower(email_user))
email_email_user_email_domain_idx
(Unique) -email_user
,email_domain
Column | Data Type | Nullable | Indexed | Description |
---|---|---|---|---|
email_id | bigint | No | Yes | - |
email_address | text | No | No | - |
email_user | text | No | Yes | - |
email_domain | text | No | Yes | - |
is_verified | boolean | No | No | - |
verification_code | text | No | No | - |