# Piwik PRO schema ERD

Table and field reference for the Fivetran Piwik PRO connector.

## Table & Field Reference

### app_site_query_param

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| app_id | Unknown | PK, FK |
| query_param | Unknown |  |

### app_site_category_param

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| app_id | Unknown | PK, FK |
| category_param | Unknown |  |

### app_excluded_url_param

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| app_id | Unknown | PK, FK |
| excluded_url_param | Unknown |  |

### app_excluded_ip

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| app_id | Unknown | PK, FK |
| excluded_ip | Unknown |  |

### app_excluded_user_agent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| app_id | Unknown | PK, FK |
| excluded_user_agent | Unknown |  |

### app_url

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| app_id | Unknown | PK, FK |
| url | Unknown |  |

### app_privacy_coookie_domain

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| app_id | Unknown | PK, FK |
| privacy_cookie_domain | Unknown |  |

### app

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| added_at | Unknown |  |
| app_type | Unknown |  |
| cnil | Unknown |  |
| currency | Unknown |  |
| delay | Unknown |  |
| e_commerce_tracking | Unknown |  |
| exclude_unknown_url | Unknown |  |
| gdpr | Unknown |  |
| gdpr_data_anonymization | Unknown |  |
| gdpr_data_anonymization_mode | Unknown |  |
| gdpr_location_recognition | Unknown |  |
| gdpr_usermode_enabled | Unknown |  |
| keep_url_fragment | Unknown |  |
| name | Unknown |  |
| organization | Unknown |  |
| privacy_cookie_domains_enabled | Unknown |  |
| privacy_cookie_expiration_period | Unknown |  |
| privacy_use_cookies | Unknown |  |
| privacy_use_finger_printing | Unknown |  |
| session_id_strict_privacy_mode | Unknown |  |
| sharepoint_integration | Unknown |  |
| site_search_tracking | Unknown |  |
| timezone | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK |
| session_id | Unknown | FK |
| website_id | Unknown | FK |
| content_name | Unknown |  |
| content_piece | Unknown |  |
| content_target | Unknown |  |
| custom_event_name | Unknown |  |
| download_url | Unknown |  |
| event_index | Unknown |  |
| goal_id | Unknown |  |
| goal_id_label | Unknown |  |
| goal_revenue | Unknown |  |
| goal_uuid_id | Unknown |  |
| goal_uuid_label | Unknown |  |
| item_count | Unknown |  |
| lost_revenue | Unknown |  |
| next_event_title | Unknown |  |
| next_event_url | Unknown |  |
| order_id | Unknown |  |
| outlink_url | Unknown |  |
| page_generation_time | Unknown |  |
| page_view_index | Unknown |  |
| previous_event_title | Unknown |  |
| previous_event_url | Unknown |  |
| revenue | Unknown |  |
| revenue_discount | Unknown |  |
| revenue_shipping | Unknown |  |
| revenue_subtotal | Unknown |  |
| revenue_tax | Unknown |  |
| search_category | Unknown |  |
| search_keyword | Unknown |  |
| search_results_count | Unknown |  |
| time_on_page | Unknown |  |
| timestamps | Unknown |  |
| title | Unknown |  |
| type_id | Unknown |  |
| type_label | Unknown |  |
| url | Unknown |  |
| visitor_id | Unknown |  |

### session_location

| Column | Type | Keys |
| --- | --- | --- |
| session_id | Unknown | PK |
| website_id | Unknown | FK |
| city_name_id | Unknown |  |
| city_name_label | Unknown |  |
| continent_iso_code_id | Unknown |  |
| continent_iso_code_label | Unknown |  |
| country_name_id | Unknown |  |
| country_name_label | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| metro_code_id | Unknown |  |
| metro_code_label | Unknown |  |
| organization | Unknown |  |
| provider | Unknown |  |
| subdivision_1_name_id | Unknown |  |
| subdivision_1_name_label | Unknown |  |
| subdivision_2_name_id | Unknown |  |
| subdivision_2_name_label | Unknown |  |
| timestamps | Unknown |  |
| visitor_id | Unknown |  |

### event_custom_variable

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK |
| session_id | Unknown | FK |
| website_id | Unknown | FK |
| dimension_1 | Unknown |  |
| dimension_2 | Unknown |  |
| dimension_3 | Unknown |  |
| dimension_4 | Unknown |  |
| dimension_5 | Unknown |  |
| key_1 | Unknown |  |
| key_2 | Unknown |  |
| key_3 | Unknown |  |
| key_4 | Unknown |  |
| key_5 | Unknown |  |
| timestamps | Unknown |  |
| value_1 | Unknown |  |
| value_2 | Unknown |  |
| value_3 | Unknown |  |
| value_4 | Unknown |  |
| value_5 | Unknown |  |
| visitor_id | Unknown |  |

### session_custom_variables

| Column | Type | Keys |
| --- | --- | --- |
| session_id | Unknown | PK |
| website_id | Unknown | FK |
| dimension_1 | Unknown |  |
| dimension_2 | Unknown |  |
| dimension_3 | Unknown |  |
| dimension_4 | Unknown |  |
| dimension_5 | Unknown |  |
| key_1 | Unknown |  |
| key_2 | Unknown |  |
| key_3 | Unknown |  |
| key_4 | Unknown |  |
| key_5 | Unknown |  |
| timestamps | Unknown |  |
| value_1 | Unknown |  |
| value_2 | Unknown |  |
| value_3 | Unknown |  |
| value_4 | Unknown |  |
| value_5 | Unknown |  |
| visitor_id | Unknown |  |

### session_users

| Column | Type | Keys |
| --- | --- | --- |
| session_id | Unknown | PK |
| website_id | Unknown | FK |
| cookie_id | Unknown |  |
| timestamps | Unknown |  |
| visitor_days_since_first_session | Unknown |  |
| visitor_days_since_last_session | Unknown |  |
| visitor_days_since_order | Unknown |  |
| visitor_id | Unknown |  |
| visitor_returning_id | Unknown |  |
| visitor_returning_label | Unknown |  |
| visitor_session_number | Unknown |  |
| website_name_id | Unknown |  |
| website_name_label | Unknown |  |

### event_consent

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK |
| session_id | Unknown | FK |
| website_id | Unknown | FK |
| action_id | Unknown |  |
| action_label | Unknown |  |
| form_button_id | Unknown |  |
| form_button_label | Unknown |  |
| scope_id | Unknown |  |
| scope_label | Unknown |  |
| source_id | Unknown |  |
| source_label | Unknown |  |
| timestamps | Unknown |  |
| type_ab_testing_personalization | Unknown |  |
| type_analytics | Unknown |  |
| type_conversion_tracking | Unknown |  |
| type_custom_1 | Unknown |  |
| type_marketing_automation | Unknown |  |
| type_remarketing | Unknown |  |
| type_user_feedback | Unknown |  |
| visitor_id | Unknown |  |

### session_device_and_platform

| Column | Type | Keys |
| --- | --- | --- |
| session_id | Unknown | PK |
| website_id | Unknown | FK |
| browser_engine | Unknown |  |
| browser_fingerprint | Unknown |  |
| browser_language_iso_639_id | Unknown |  |
| browser_language_iso_639_label | Unknown |  |
| browser_name_id | Unknown |  |
| browser_name_label | Unknown |  |
| browser_version | Unknown |  |
| device_brand_id | Unknown |  |
| device_brand_label | Unknown |  |
| device_model | Unknown |  |
| device_type_id | Unknown |  |
| device_type_label | Unknown |  |
| ipv_4_address | Unknown |  |
| ipv_6_address | Unknown |  |
| operating_system_id | Unknown |  |
| operating_system_label | Unknown |  |
| operating_system_version | Unknown |  |
| plugin_cookie | Unknown |  |
| plugin_director | Unknown |  |
| plugin_flash | Unknown |  |
| plugin_gear | Unknown |  |
| plugin_java | Unknown |  |
| plugin_pdf | Unknown |  |
| plugin_quicktime | Unknown |  |
| plugin_realplayer | Unknown |  |
| plugin_silverlight | Unknown |  |
| plugin_windowsmedia | Unknown |  |
| resolution | Unknown |  |
| resolution_height | Unknown |  |
| resolution_width | Unknown |  |
| timestamps | Unknown |  |
| visitor_id | Unknown |  |

### session_traffic

| Column | Type | Keys |
| --- | --- | --- |
| session_id | Unknown | PK |
| website_id | Unknown | FK |
| campaign_content | Unknown |  |
| campaign_id | Unknown |  |
| campaign_name | Unknown |  |
| keyword | Unknown |  |
| medium | Unknown |  |
| referrer_type_id | Unknown |  |
| referrer_type_label | Unknown |  |
| referrer_url | Unknown |  |
| source | Unknown |  |
| source_medium | Unknown |  |
| timestamps | Unknown |  |
| visitor_id | Unknown |  |

### event_website_performance

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK |
| session_id | Unknown | FK |
| website_id | Unknown | FK |
| domain_lookup_time | Unknown |  |
| is_entry | Unknown |  |
| is_exit | Unknown |  |
| page_rendering_time | Unknown |  |
| redirections_time | Unknown |  |
| server_connection_time | Unknown |  |
| server_response_time | Unknown |  |
| timestamps | Unknown |  |
| timing_dom_interactive | Unknown |  |
| timing_event_end | Unknown |  |
| visitor_id | Unknown |  |

### session_goal

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| session_id | Unknown | PK, FK |
| session_goals | Unknown |  |

### session_goal_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| session_id | Unknown | PK, FK |
| session_goal_id | Unknown |  |

### session

| Column | Type | Keys |
| --- | --- | --- |
| session_id | Unknown | PK |
| website_id | Unknown | FK |
| campaign_gclid | Unknown |  |
| ecommerce_status_id | Unknown |  |
| ecommerce_status_label | Unknown |  |
| entry_title | Unknown |  |
| entry_url | Unknown |  |
| exit_title | Unknown |  |
| exit_url | Unknown |  |
| is_bounce | Unknown |  |
| local_hour | Unknown |  |
| second_title | Unknown |  |
| second_url | Unknown |  |
| timestamps | Unknown |  |
| total_abandoned_cart | Unknown |  |
| total_cart_addition | Unknown |  |
| total_cart_removal | Unknown |  |
| total_content_impression | Unknown |  |
| total_content_interaction | Unknown |  |
| total_custom_event | Unknown |  |
| total_download | Unknown |  |
| total_ecommerce_conversion | Unknown |  |
| total_event | Unknown |  |
| total_goal_conversion | Unknown |  |
| total_outlink | Unknown |  |
| total_page_view | Unknown |  |
| total_product_detail_view | Unknown |  |
| total_site_search | Unknown |  |
| total_time | Unknown |  |
| unique_content_impression | Unknown |  |
| unique_content_interaction | Unknown |  |
| unique_custom_event | Unknown |  |
| unique_download | Unknown |  |
| unique_outlink | Unknown |  |
| unique_page_view | Unknown |  |
| unique_searche | Unknown |  |
| user_id | Unknown |  |
| visitor_id | Unknown |  |

### product_name

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_name | Unknown |  |

### product_sku

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_sku | Unknown |  |

### product_brand

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_sku | Unknown |  |

### product_price

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_price | Unknown |  |

### product_quantity

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_quantity | Unknown |  |

### product_revenue

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_revenue | Unknown |  |

### product_variant

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_variant | Unknown |  |

### product_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_category | Unknown |  |

### product_category_1

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_category_1 | Unknown |  |

### product_category_2

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_category_2 | Unknown |  |

### product_category_3

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_category_3 | Unknown |  |

### product_category_4

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_category_4 | Unknown |  |

### product_category_5

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_category_5 | Unknown |  |

### product_dimension_1

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_1 | Unknown |  |

### product_dimension_2

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_2 | Unknown |  |

### product_dimension_3

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_3 | Unknown |  |

### product_dimension_4

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_4 | Unknown |  |

### product_dimension_5

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_5 | Unknown |  |

### product_dimension_6

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_6 | Unknown |  |

### product_dimension_7

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_7 | Unknown |  |

### product_dimension_8

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_8 | Unknown |  |

### product_dimension_9

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_9 | Unknown |  |

### product_dimension_10

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_10 | Unknown |  |

### product_dimension_11

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_11 | Unknown |  |

### product_dimension_12

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_12 | Unknown |  |

### product_dimension_13

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_13 | Unknown |  |

### product_dimension_14

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_14 | Unknown |  |

### product_dimension_15

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_15 | Unknown |  |

### product_dimension_16

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_16 | Unknown |  |

### product_dimension_17

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_17 | Unknown |  |

### product_dimension_18

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_18 | Unknown |  |

### product_dimension_19

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_19 | Unknown |  |

### product_dimension_20

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| product_dimension_20 | Unknown |  |

### event_product

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK |
| session_id | Unknown | FK |
| website_id | Unknown | FK |
| product_count | Unknown |  |
| timestamps | Unknown |  |
| visitor_id | Unknown |  |

### event_custom_events

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK |
| session_id | Unknown | FK |
| website_id | Unknown | FK |
| action | Unknown |  |
| category | Unknown |  |
| name | Unknown |  |
| timestamps | Unknown |  |
| value | Unknown |  |
| visitor_id | Unknown |  |

## Relationships

- app_site_query_param(app_id) → app(id)
- app_site_category_param(app_id) → app(id)
- app_excluded_url_param(app_id) → app(id)
- app_excluded_ip(app_id) → app(id)
- app_excluded_user_agent(app_id) → app(id)
- app_url(app_id) → app(id)
- app_privacy_coookie_domain(app_id) → app(id)
- event(session_id) → session(session_id)
- event(website_id) → app(id)
- session_location(website_id) → app(id)
- event_custom_variable(session_id) → session(session_id)
- event_custom_variable(website_id) → app(id)
- session_custom_variables(website_id) → app(id)
- session_users(website_id) → app(id)
- event_consent(session_id) → session(session_id)
- event_consent(website_id) → app(id)
- session_device_and_platform(website_id) → app(id)
- session_traffic(website_id) → app(id)
- event_website_performance(session_id) → session(session_id)
- event_website_performance(website_id) → app(id)
- session_goal(session_id) → session(session_id)
- session_goal_id(session_id) → session(session_id)
- session(website_id) → app(id)
- product_name(event_id) → event_product(event_id)
- product_sku(event_id) → event_product(event_id)
- product_brand(event_id) → event_product(event_id)
- product_price(event_id) → event_product(event_id)
- product_quantity(event_id) → event_product(event_id)
- product_revenue(event_id) → event_product(event_id)
- product_variant(event_id) → event_product(event_id)
- product_category(event_id) → event_product(event_id)
- product_category_1(event_id) → event_product(event_id)
- product_category_2(event_id) → event_product(event_id)
- product_category_3(event_id) → event_product(event_id)
- product_category_4(event_id) → event_product(event_id)
- product_category_5(event_id) → event_product(event_id)
- product_dimension_1(event_id) → event_product(event_id)
- product_dimension_2(event_id) → event_product(event_id)
- product_dimension_3(event_id) → event_product(event_id)
- product_dimension_4(event_id) → event_product(event_id)
- product_dimension_5(event_id) → event_product(event_id)
- product_dimension_6(event_id) → event_product(event_id)
- product_dimension_7(event_id) → event_product(event_id)
- product_dimension_8(event_id) → event_product(event_id)
- product_dimension_9(event_id) → event_product(event_id)
- product_dimension_10(event_id) → event_product(event_id)
- product_dimension_11(event_id) → event_product(event_id)
- product_dimension_12(event_id) → event_product(event_id)
- product_dimension_13(event_id) → event_product(event_id)
- product_dimension_14(event_id) → event_product(event_id)
- product_dimension_15(event_id) → event_product(event_id)
- product_dimension_16(event_id) → event_product(event_id)
- product_dimension_17(event_id) → event_product(event_id)
- product_dimension_18(event_id) → event_product(event_id)
- product_dimension_19(event_id) → event_product(event_id)
- product_dimension_20(event_id) → event_product(event_id)
- event_product(session_id) → session(session_id)
- event_product(website_id) → app(id)
- event_custom_events(session_id) → session(session_id)
- event_custom_events(website_id) → app(id)