# Brevo schema ERD

Table and field reference for the Fivetran Brevo connector.

## 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 | PK, FK |
| sms_campaign_id | Unknown | PK, FK |

### sms_campaign_exclusion_list

| Column | Type | Keys |
| --- | --- | --- |
| exclusion_list_id | Unknown | PK, FK |
| sms_campaign_id | Unknown | PK, FK |

### 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 | PK, FK |
| list_id | Unknown | PK, FK |

### contact_attribute_object

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| contact_id | Long | PK, FK |
| 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 | PK, FK |
| list_id | Unknown | PK, FK |

### email_campaign_exclusion_list

| Column | Type | Keys |
| --- | --- | --- |
| email_campaign_id | Unknown | PK, FK |
| exclusion_list_id | Unknown | PK, FK |

### email_campaign_stats

| Column | Type | Keys |
| --- | --- | --- |
| email_campaign_id | Unknown | PK, FK |
| email_statistics_index | Unknown | PK, FK |
| list_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| product_id | Unknown | PK, FK |

### 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 |  |

## Relationships

- inbound_event(sender) → sender(email)
- sms_campaign_list(list_id) → list(id)
- sms_campaign_list(sms_campaign_id) → sms_campaign(id)
- sms_campaign_exclusion_list(exclusion_list_id) → list(id)
- sms_campaign_exclusion_list(sms_campaign_id) → sms_campaign(id)
- contact_list(list_id) → list(id)
- contact_list(contact_id) → contact(id)
- contact_attribute_object(contact_id) → contact(id)
- transactional_email_event(template_id) → email_template(id)
- email_campaign_list(list_id) → list(id)
- email_campaign_list(email_campaign_id) → email_campaign(id)
- email_campaign_exclusion_list(exclusion_list_id) → list(id)
- email_campaign_exclusion_list(email_campaign_id) → email_campaign(id)
- email_campaign_stats(list_id) → list(id)
- email_campaign_stats(email_statistics_index) → email_statistics(index)
- email_campaign_stats(email_campaign_id) → email_statistics(email_campaign_id)
- email_statistics(email_campaign_id) → email_campaign(id)
- email_campaign(id) → sender(id)
- product_category(category_id) → category(id)
- product_category(product_id) → product(id)
- product(parent_id) → product(id)
- list(folder_id) → folder(id)
- ips(sender_id) → sender(id)
- email_template(sender_id) → sender(id)