Campaign Entity Type Configurations
The campaign_entity_type_configurations table contains data about entity settings in a campaign, as controlled by the entity settings tab in campaign customize options.
This table can be used to determine which entity types have which custom entity create forms, conversation logging forms, spotlighted responses, and spotlighted icon, 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 configuration is in. Relates to the id column in the campaigns table. |
INT8 | Yes |
| entity_type_id | The numerical identifier of the entity this configuration applies to. Relates to the id column in the entities table. |
INT8 | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |
| spotlight_tag_ids | An array of the tag ids that are spotlighted for this entity type. Relates to the id column in the tags table. |
JSONB | Yes |
| spotlight_icon | The name of the icon used when spotlighting entities of this type. | VARCHAR | Yes |
| custom_form_id | The numerical identifier of the conversation logging form for this entity type. Relates to the id column in the custom_forms table. |
INT8 | Yes |
| creation_custom_form_id | The numerical identifier of the custom creation form for this entity type. Relates to the id column in the custom_forms table. |
INT4 | Yes |