# Triple Whale schema ERD

Table and field reference for the Fivetran Triple Whale connector.

## Table & Field Reference

### orders_journey

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| event | Unknown |  |
| path | Unknown |  |
| product_id | Unknown |  |
| time | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| order_id | Unknown | PK |
| created_at | Unknown |  |
| currency | Unknown |  |
| customer_id | Unknown |  |
| order_name | Unknown |  |
| total_price | Unknown |  |

### orders_attribution

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| type | Unknown | PK |
| order_id | Unknown | PK, FK |
| ad_id | Unknown |  |
| adset_id | Unknown |  |
| campaign_id | Unknown |  |
| click_date | Unknown |  |
| source | Unknown |  |

### summary_page_service

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| summary_page_id | Unknown | PK, FK |
| service | Unknown |  |

### summary_page

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deltas | Unknown |  |
| metric_id | Unknown |  |
| tip | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| values_current | Unknown |  |
| values_previous | Unknown |  |

### summary_page_chart

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| type | Unknown | PK |
| summary_page_id | Unknown | PK, FK |
| x | Unknown |  |
| y | Unknown |  |

## Relationships

- orders_journey(order_id) → orders(order_id)
- orders_attribution(order_id) → orders(order_id)
- summary_page_service(summary_page_id) → summary_page(id)
- summary_page_chart(summary_page_id) → summary_page(id)