Flywheel Digital

Explore the interactive ERD

Table & Field Reference

online_store_search_result

Column	Type	Keys
`index`	Unknown	PK
`report_date`	LocalDate	PKFK
`search_term_id`	Unknown	PKFK
`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	PKFK
`report_date`	LocalDate	PKFK
`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	PKFK
`search_term`	Unknown	PKFK
`search_term_id`	Unknown	PKFK
`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