Campaign Topline Setting Items
The campaign_topline_setting_items table contains data about campaign topline settings.
This table can be used to determine which items are set as toplines in a given campaign and their order, as well as metadata about the configuration such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| campaign_id | The numerical identifier of the campaign this topline setting is in. Relates to the id column in the campaigns table. |
INT8 | Yes |
| targetable_id | The numerical identifier of the related object for this topline setting. Can be used with targetable_type to look up the object itself in the appropriate table. |
INT4 | Yes |
| item_type | The type of object for the topline setting. One of TagCategory, SocialNetwork, PhoneNumber, Address, Email, Age, EntityConnectionType, Note, or PreferredLanguage. |
VARCHAR | No |
| item_id | This column is always blank. | VARCHAR | Yes |
| position | The relative position of this topline in its section. 0 indicates a highlighted topline. |
INT4 | No |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |
| imported | This column has no meaning external to our backend systems and can be ignored. | BOOL | Yes |
| targetable_type | The type of object the topline setting is on. One of EntityType or EntityConnectionType. |
VARCHAR | Yes |