email

A unique list of every email address we've seen in claims and eligibility

Primary Key:

• email_id

Checks:

• email_email_address_check - (email_address <> ''::text)

Indexes:

• email_email_address_idx (Unique) - email_address
• email_email_user_email_domain_idx (Unique) - email_user, email_domain

Column	Data Type	Nullable	Indexed	Description
email_id	bigint	No	Yes	Snowflake ID for email. Generated through expression:
email_address	text	No	Yes	Email address. Generated through expression:
is_verified	boolean	No	No	Indicates whether the email has been verified. This includes successfully sending an email to the address and the user clicking on a link in that email to verify the email. Generated through expression:
verification_code	text	No	No	Email verification code is a unique, temporary code sent to an email address to verify it is valid and the user has access to it. Generated through expression:
email_user	text	No	Yes	The user portion of an email address (before the @). For example, in the email address 'my.email@example.com', the user is 'my.email'. Generated through expression: lower("substring"(email_address, 0, POSITION(('@'::text) IN (email_address))))
email_domain	text	No	Yes	The domain portion of an email address (after the @). For example, in the email address 'my.email@example.com', the domain is 'example.com.' Generated through expression: lower("substring"(email_address, (POSITION(('@'::text) IN (email_address)) + 1)))