Table Type: Metadata
This table contains email addresses and phone numbers for users.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| user_id | string | Primary Key | The ID of the user. |
| media_type | string | Primary Key | The media type of the contact (Phone, Email, Sms). |
| type | string | Primary Key | The type of the contact (Primary, Work, Mobile, etc.). |
| address | string | Email address or phone number for this contact type. | |
| display | string | Formatted version of the address property. | |
| extension | string | Internal extension for the contact, if used instead of address. | |
| country_code | string | The country code for the contact. | |
| integration | string | Integration tag value if this number is associated with an external integration. | |
| db_last_updated | datetime | Required | When this record was last updated in UTC. |