Fivetran documentation

Search the docs

/

Brevo

Explore the interactive ERD

Table & Field Reference

inbound_event

Column	Type	Keys
`id`	Unknown	PK
`sender`	Unknown	FK
`date`	Unknown
`recipient`	Unknown

sms_campaign_list

Column	Type	Keys
`list_id`	Unknown	PKFK
`sms_campaign_id`	Unknown	PKFK

sms_campaign_exclusion_list

Column	Type	Keys
`exclusion_list_id`	Unknown	PKFK
`sms_campaign_id`	Unknown	PKFK

sms_campaign

Column	Type	Keys
`id`	Unknown	PK
`content`	Unknown
`created_at`	Unknown
`modified_at`	Unknown
`name`	Unknown
`organisation_prefix`	Unknown
`scheduled_at`	Unknown
`sender`	Unknown
`status`	Unknown
`unsubscribe_instruction`	Unknown

contact_list

Column	Type	Keys
`contact_id`	Long	PKFK
`list_id`	Unknown	PKFK

contact_attribute_object

Column	Type	Keys
`name`	Unknown	PK
`contact_id`	Long	PKFK
`value`	Unknown

contact

Column	Type	Keys
`id`	Long	PK
`created_at`	Unknown
`email`	String
`email_blacklisted`	Boolean
`list_unsubscribed`	Unknown
`modified_at`	Unknown
`sms_blacklisted`	Boolean

transactional_email_event

Column	Type	Keys
`date`	Instant	PK
`message_id`	Unknown	PK
`template_id`	Unknown	FK
`email`	Unknown
`event`	Unknown
`from_email`	Unknown
`ip`	Unknown
`link`	Unknown
`reason`	Unknown
`subject`	Unknown
`tag_name`	Unknown

attribute_enumeration

Column	Type	Keys
`index`	Unknown	PK
`value`	Unknown	PK
`attribute_name`	Unknown
`label`	Unknown

attribute

Column	Type	Keys
`_fivetran_id`	String	PK
`calculated_value`	Unknown
`category`	Unknown
`name`	Unknown
`type`	Unknown
`custom_`

email_campaign_list

Column	Type	Keys
`email_campaign_id`	Unknown	PKFK
`list_id`	Unknown	PKFK

email_campaign_exclusion_list

Column	Type	Keys
`email_campaign_id`	Unknown	PKFK
`exclusion_list_id`	Unknown	PKFK

email_campaign_stats

Column	Type	Keys
`email_campaign_id`	Unknown	PKFK
`email_statistics_index`	Unknown	PKFK
`list_id`	Unknown	PKFK
`clicker`	Unknown
`complaint`	Unknown
`deferred`	Unknown
`delivered`	Unknown
`hard_bounce`	Unknown
`sent`	Unknown
`soft_bounce`	Unknown
`trackable_view`	Unknown
`unique_click`	Unknown
`unique_view`	Unknown
`unsubscriptions`	Unknown
`viewed`	Unknown

email_statistics

Column	Type	Keys
`index`	Unknown	PK
`email_campaign_id`	Unknown	PKFK
`global_stats_clicker`	Unknown
`global_stats_complaint`	Unknown
`global_stats_delivered`	Unknown
`global_stats_estimated_view`	Unknown
`global_stats_hard_bounce`	Unknown
`global_stats_sent`	Unknown
`global_stats_soft_bounce`	Unknown
`global_stats_trackable_views`	Unknown
`global_stats_trackable_views_rate`	Unknown
`global_stats_unique_click`	Unknown
`global_stats_unique_view`	Unknown
`global_stats_unsubscriptions`	Unknown
`global_stats_viewed`	Unknown
`links_stats`	Json
`mirror_click`	Unknown
`remaining`	Unknown
`stats_by_domain_`

email_campaign

Column	Type	Keys
`id`	Unknown	PKFK
`ab_testing`	Unknown
`created_at`	Unknown
`footer`	Unknown
`header`	Unknown
`html_content`	Unknown
`inline_image_activation`	Unknown
`mirror_active`	Unknown
`modified_at`	Unknown
`name`	Unknown
`recurring`	Unknown
`reply_to`	Unknown
`return_bounce`	Unknown
`scheduled_at`	Unknown
`send_at_best_time`	Unknown
`sender_id`	Unknown
`sent_date`	Unknown
`share_link`	Unknown
`split_rule`	Unknown
`status`	Unknown
`subject`	Unknown
`subject_a`	Unknown
`subject_b`	Unknown
`tags`	Unknown
`test_sent`	Unknown
`to_field`	Unknown
`type`	Unknown
`winner_criteria`	Unknown
`winner_delay`	Unknown

process

Column	Type	Keys
`id`	Unknown	PK
`export_url`	Unknown
`name`	Unknown
`status`	Unknown

product_category

Column	Type	Keys
`category_id`	Unknown	PKFK
`product_id`	Unknown	PKFK

product

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`created_at`	Unknown
`image_url`	Unknown
`modified_at`	Unknown
`name`	Unknown
`price`	Unknown
`s_3_original`	Unknown
`s_3_thumb_analytics`	Unknown
`s_3_thumb_editor`	Unknown
`sku`	Unknown
`url`	Unknown

list

Column	Type	Keys
`id`	Unknown	PK
`folder_id`	Unknown	FK
`name`	Unknown
`total_blacklisted`	Unknown
`total_subscribers`	Unknown
`unique_subscribers`	Unknown

folder

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`total_blacklisted`	Unknown
`total_subscriber`	Unknown
`unique_subscriber`	Unknown

ips

Column	Type	Keys
`_fivetran_id`	String	PK
`sender_id`	Unknown	FK
`domain`	Unknown
`ip`	Unknown
`weight`	Unknown

sender

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`email`	Unknown
`name`	Unknown

category

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`modified_at`	Unknown
`name`	Unknown
`url`	Unknown

email_template

Column	Type	Keys
`id`	Unknown	PK
`sender_id`	Unknown	FK
`created_at`	Unknown
`doi_template`	Unknown
`html_content`	Unknown
`is_active`	Unknown
`modified_at`	Unknown
`name`	Unknown
`reply_to`	Unknown
`subject`	Unknown
`tags`	Unknown
`test_sent`	Unknown
`to_field`	Unknown