# Flywheel Digital schema ERD

Table and field reference for the Fivetran Flywheel Digital connector.

## Table & Field Reference

### online_store_search_result

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_date | LocalDate | PK, FK |
| search_term_id | Unknown | PK, FK |
| market | Unknown |  |
| online_store | Unknown |  |
| search_result_link | Unknown |  |

### search_term

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_date | LocalDate | PK |
| region | Unknown |  |
| search_term | Unknown |  |
| search_term_priority_status | Unknown |  |
| type | Unknown |  |

### product_promotion

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| report_date | LocalDate | PK, FK |
| discount_amount | Int |  |
| discount_percent | Int |  |
| discounted_price | Int |  |
| listed_price | Int |  |
| net_diff_from_min | Unknown |  |
| net_diff_from_min_percent | Unknown |  |
| non_discounted_price | Int |  |
| promotion_type | String |  |
| text | Json |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| report_date | LocalDate | PK |
| availability_complaint | Unknown |  |
| availability_status | Unknown |  |
| average_sales | Unknown |  |
| brand | Unknown |  |
| category | Unknown |  |
| content_compliant | Unknown |  |
| content_milestone_10_compliant | Boolean |  |
| content_milestone_1_compliant | Boolean |  |
| content_milestone_2_compliant | Boolean |  |
| content_milestone_3_compliant | Boolean |  |
| content_milestone_4_compliant | Boolean |  |
| content_milestone_5_compliant | Boolean |  |
| content_milestone_6_compliant | Boolean |  |
| content_milestone_7_compliant | Boolean |  |
| content_milestone_8_compliant | Boolean |  |
| content_milestone_9_compliant | Boolean |  |
| dimension_1 | String |  |
| dimension_2 | String |  |
| dimension_3 | String |  |
| dimension_4 | String |  |
| dimension_5 | String |  |
| dimension_6 | String |  |
| dimension_7 | String |  |
| dimension_8 | String |  |
| harvested_additional_description | Unknown |  |
| harvested_duplicate_image_count | Unknown |  |
| harvested_gallery_video_count | Unknown |  |
| harvested_image_alt_text | Unknown |  |
| harvested_image_count | Unknown |  |
| harvested_ingredients_list | Unknown |  |
| harvested_product_description | Unknown |  |
| harvested_product_image_url | Unknown |  |
| harvested_size_information | Unknown |  |
| harvested_url | Unknown |  |
| harvested_variant_information | Unknown |  |
| harvested_video_count | Unknown |  |
| imaging_compliance | Json |  |
| imaging_compliant | Unknown |  |
| imaging_status | String |  |
| is_competitor | Unknown |  |
| is_on_promotion | Unknown |  |
| manufacturer | Unknown |  |
| menu_compliant | String |  |
| menu_position | String |  |
| online_store | Unknown |  |
| overall_rating | Unknown |  |
| pricing_currency_symbol | Unknown |  |
| pricing_diff_from_min_max | Unknown |  |
| pricing_diff_from_min_max_percent | Unknown |  |
| pricing_diff_from_msrp | Unknown |  |
| pricing_diff_from_msrp_compliant | Unknown |  |
| pricing_diff_from_msrp_percent | Unknown |  |
| pricing_diff_from_previous_observed_price | Unknown |  |
| pricing_diff_from_previous_observed_price_percent | Unknown |  |
| pricing_max_price | Unknown |  |
| pricing_min_price | Unknown |  |
| pricing_msrp | Unknown |  |
| pricing_net_diff_from_min | Unknown |  |
| pricing_net_diff_from_min_compliant | Unknown |  |
| pricing_net_diff_from_min_percent | Unknown |  |
| pricing_non_discounted_price | Unknown |  |
| pricing_observed_price | Unknown |  |
| pricing_previous_observed_price | Unknown |  |
| pricing_price_compliant | Unknown |  |
| pricing_subheading | Unknown |  |
| rating_compliant | Unknown |  |
| region | Unknown |  |
| review_compliant | Unknown |  |
| review_count | Unknown |  |
| sales_currency_symbol | Unknown |  |
| search_score_compliant | Unknown |  |
| traffic_page_views | String |  |
| traffic_rank | String |  |
| trusted_mpc | String |  |
| trusted_product_description | Unknown |  |
| trusted_rpc | String |  |
| trusted_upc | String |  |
| type | Unknown |  |

### content_result

| Column | Type | Keys |
| --- | --- | --- |
| harvested_rpc | Unknown | PK |
| id | Unknown | PK |
| report_date | LocalDate | PK |
| brand | Unknown |  |
| category | Unknown |  |
| dimension_1 | String |  |
| dimension_2 | String |  |
| dimension_3 | String |  |
| dimension_4 | String |  |
| dimension_5 | String |  |
| dimension_6 | String |  |
| dimension_7 | String |  |
| dimension_8 | String |  |
| harvested | Unknown |  |
| harvested_url | Unknown |  |
| is_competitor | Unknown |  |
| manufacturer | Unknown |  |
| milestone | Unknown |  |
| online_store | Unknown |  |
| region | Unknown |  |
| rule_error_message | Unknown |  |
| rule_name | Unknown |  |
| trusted_mpc | String |  |
| trusted_product_description | Unknown |  |
| trusted_upc | String |  |
| type | Unknown |  |

### search_term_result

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| online_store | Unknown | PK |
| search_result_rank | Unknown | PK |
| report_date | Unknown | PK, FK |
| search_term | Unknown | PK, FK |
| search_term_id | Unknown | PK, FK |
| brand | Unknown |  |
| category | Unknown |  |
| dimension_1 | String |  |
| dimension_2 | String |  |
| dimension_3 | String |  |
| dimension_4 | String |  |
| dimension_5 | String |  |
| dimension_6 | String |  |
| dimension_7 | String |  |
| dimension_8 | String |  |
| harvested_product_description | Unknown |  |
| harvested_product_image_url | Unknown |  |
| harvested_url | Unknown |  |
| is_competitor | Unknown |  |
| is_priority_search_term | Unknown |  |
| manufacturer | Unknown |  |
| region | Unknown |  |
| results_per_page | Unknown |  |
| search_result_basic_score | Unknown |  |
| search_result_is_paid | Unknown |  |
| search_result_max_rank | Unknown |  |
| search_result_priority_score | Unknown |  |
| search_result_segment | Unknown |  |
| search_result_segment_value | Unknown |  |
| search_result_weighted_score | Unknown |  |
| trusted_mpc | String |  |
| trusted_product_description | Unknown |  |
| trusted_rpc | String |  |
| trusted_upc | String |  |
| type | Unknown |  |

## Relationships

- online_store_search_result(search_term_id) → search_term(id)
- online_store_search_result(report_date) → search_term(report_date)
- product_promotion(product_id) → product(id)
- product_promotion(report_date) → product(report_date)
- search_term_result(search_term) → search_term(search_term)
- search_term_result(report_date) → search_term(report_date)
- search_term_result(search_term_id) → search_term(id)