Table Type: Metadata
Contact Lists are used to store lists of contacts that can be used in campaigns. This table stores the actual contact lists, the contents of these can also be downloaded.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| id | string | Primary Key | The unique identifier of the contact list. |
| db_last_updated | datetime | When this record was last updated in UTC. | |
| db_when_created | datetime | When this record was created in UTC. | |
| db_when_deleted | datetime | When this record was deleted in UTC. NULL if not deleted. | |
| name | string | The name of the contact list. If exported, this will be the name of the table in the configured dynamic database | |
| when_created | datetime | When this record was created in UTC. | |
| when_modified | datetime | When this record was last modified in UTC. | |
| version | int32 | The version of the contact list. | |
| division_id | string | The division id that this contact list belongs to. | |
| division_name | string | The division name that this contact list belongs to. | |
| automatic_time_zone_mapping | boolean | ||
| zip_code_column_name | string | ||
| trim_whitespace | boolean |