phone
A unique list of every phone number we've seen
Primary Key:Checks:phone_phone_number_check-((phone_number <> ''::text) AND (phone_number = claims.clean_phone(phone_number)))
phone_phone_number_idx(Unique) -phone_number
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
phone_id | bigint | No | Yes | Snowflake ID of the phone record. Generated through expression: |
phone_number | text | No | Yes | The unique telephone number. Generated through expression: |
sms_verified | boolean | No | No | Identifies whether the phone number has been verified through SMS messaging. Generated through expression: |
verification_code | text | No | No | The verification code that has been generated as part of the phone verification process. Generated through expression: |