# Liftoff schema ERD

Table and field reference for the Fivetran Liftoff connector.

## Table & Field Reference

### creative

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| creative_type | Unknown |  |
| full_html_preview_url | Unknown |  |
| height | Unknown |  |
| name | Unknown |  |
| preview_url | Unknown |  |
| width | Unknown |  |

### app

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| app_store_id | Unknown |  |
| bundle_id | Unknown |  |
| name | Unknown |  |
| optimization_event_id | Unknown |  |
| optimization_event_name | Unknown |  |
| platform | Unknown |  |
| state | Unknown |  |
| title | Unknown |  |

### event

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

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| app_id | Unknown | FK |
| campaign_type | Unknown |  |
| max_os_version | Unknown |  |
| min_os_version | Unknown |  |
| name | Unknown |  |
| state | Unknown |  |
| state_last_changed_at | Unknown |  |
| tracker_type | Unknown |  |

### report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| app_id | Unknown | FK |
| campaign_id | Unknown | FK |
| creative_id | Unknown | FK |
| ad_format | Unknown |  |
| clicks | Unknown |  |
| country_code | Unknown |  |
| cpa | Unknown |  |
| cpc | Unknown |  |
| cpi | Unknown |  |
| cpm | Unknown |  |
| ctr | Unknown |  |
| date | Unknown |  |
| event_number | Unknown |  |
| impressions | Unknown |  |
| installs | Unknown |  |
| publisher_app_store_id | Unknown |  |
| publisher_name | Unknown |  |
| skan_installs_with_conversion_value | Unknown |  |
| skan_installs_with_no_conversion_value | Unknown |  |
| spend | Unknown |  |
| custom_** |  |  |

## Relationships

- event(app_id) → app(id)
- campaign(app_id) → app(id)
- report(campaign_id) → campaign(id)
- report(creative_id) → creative(id)
- report(app_id) → app(id)