# Poplar schema ERD

Table and field reference for the Fivetran Poplar connector.

## Table & Field Reference

### active_campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### audience

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| member_count | Unknown |  |
| name | Unknown |  |

### campaign_mailing

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| creative_id | Unknown | FK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| address_city | Unknown |  |
| address_company | Unknown |  |
| address_external_id | Unknown |  |
| address_name | Unknown |  |
| address_postal_code | Unknown |  |
| address_state_name | Unknown |  |
| back_url | Unknown |  |
| created_at | Unknown |  |
| front_url | Unknown |  |
| merge_tags | Json |  |
| pdf_url | Unknown |  |
| send_at | Unknown |  |
| state | Unknown |  |
| total_cost | Unknown |  |

### campaign_creative_rate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| creative_id | Unknown | PK, FK |
| name | Unknown |  |
| offset_minimum | Unknown |  |
| price | Unknown |  |
| rate_type | Unknown |  |

### campaign_creative

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| creative_type | Unknown |  |
| format | Unknown |  |
| image_format | Unknown |  |
| is_default | Unknown |  |
| mail_type | Unknown |  |
| merge_tags | Json |  |
| name | Unknown |  |
| thumbnail_url | Unknown |  |

## Relationships

- campaign_mailing(creative_id) → campaign_creative(id)
- campaign_mailing(campaign_id) → active_campaign(id)
- campaign_creative_rate(creative_id) → campaign_creative(id)
- campaign_creative_rate(campaign_id) → campaign_creative(campaign_id)
- campaign_creative(campaign_id) → active_campaign(id)