phone

A unique list of every phone number we've seen

Primary Key:

• phone_id

Checks:

• phone_phone_number_check - ((phone_number <> ''::text) AND (phone_number = claims.clean_phone(phone_number)))

Indexes:

• phone_phone_number_uq (Unique) - phone_number

Column	Data Type	Nullable	Indexed	Description
phone_id	bigint	No	Yes	Snowflake ID of the phone record.
phone_number	text	No	Yes	The unique telephone number.
sms_verified	boolean	No	No	Identifies whether the phone number has been verified through SMS messaging.
verification_code	text	No	No	The verification code that has been generated as part of the phone verification process.