Google Business Profile

Explore the interactive ERD

Table & Field Reference

location_additional_phone_number

Column	Type	Keys
`index`	Unknown	PK
`location_id`	Unknown	PKFK
`phone_number`	Unknown

location_regular_hour_period

Column	Type	Keys
`index`	Unknown	PK
`location_id`	Unknown	PKFK
`close_day`	Unknown
`close_time_hours`	Unknown
`close_time_minutes`	Unknown
`close_time_nanos`	Unknown
`close_time_seconds`	Unknown
`open_day`	Unknown
`open_time_hours`	Unknown
`open_time_minutes`	Unknown
`open_time_nanos`	Unknown
`open_time_seconds`	Unknown

location_primary_category_hour_type

Column	Type	Keys
`index`	Unknown	PK
`location_id`	Unknown	PKFK
`display_name`	Unknown
`hour_type_id`	Unknown
`localized_display_name`	Unknown
`primary_category_name`	Unknown

location_primary_category_service_type

Column	Type	Keys
`service_type_id`	Unknown	PK
`location_id`	Unknown	PKFK
`display_name`	Unknown

location_additional_category_service_type

Column	Type	Keys
`service_type_id`	Unknown	PK
`location_additional_category_index`	Unknown	PKFK
`location_id`	Unknown	PKFK
`display_name`	Unknown

location_additional_category_hour_type

Column	Type	Keys
`index`	Unknown	PK
`location_additional_category_index`	Unknown	PKFK
`location_id`	Unknown	PKFK
`display_name`	Unknown
`hour_type_id`	Unknown
`localized_display_name`	Unknown

location_additional_category

Column	Type	Keys
`index`	Unknown	PK
`location_id`	Unknown	PKFK
`display_name`	Unknown
`name`	Unknown

location_special_hour_period

Column	Type	Keys
`index`	Unknown	PK
`location_id`	Unknown	PKFK
`close_time_hours`	Unknown
`close_time_minutes`	Unknown
`close_time_nanos`	Unknown
`close_time_seconds`	Unknown
`closed`	Unknown
`end_date_day`	Unknown
`end_date_month`	Unknown
`end_date_year`	Unknown
`open_time_hours`	Unknown
`open_time_minutes`	Unknown
`open_time_nanos`	Unknown
`open_time_seconds`	Unknown
`start_date_day`	Unknown
`start_date_month`	Unknown
`start_date_year`	Unknown

location_service_area_place

Column	Type	Keys
`place_id`	Unknown	PK
`location_id`	Unknown	PKFK
`place_name`	Unknown

location_label

Column	Type	Keys
`index`	Unknown	PK
`location_id`	Unknown	PKFK
`label`	Unknown

location_relationship_data_children_location

Column	Type	Keys
`place_id`	Unknown	PK
`location_id`	Unknown	PKFK
`relation_type`	Unknown

location_more_hour_period

Column	Type	Keys
`index`	Unknown	PK
`location_id`	Unknown	PKFK
`location_more_hour_index`	Unknown	PKFK
`close_day`	Unknown
`close_time_hours`	Unknown
`close_time_minutes`	Unknown
`close_time_nanos`	Unknown
`close_time_seconds`	Unknown
`open_day`	Unknown
`open_time_hours`	Unknown
`open_time_minutes`	Unknown
`open_time_nanos`	Unknown
`open_time_seconds`	Unknown

location_more_hour

Column	Type	Keys
`index`	Unknown	PK
`location_id`	Unknown	PKFK
`hour_type_id`	Unknown

location_service_item

Column	Type	Keys
`index`	Unknown	PK
`location_id`	Unknown	PKFK
`free_form_service_item_category`	Unknown
`free_form_service_item_label_description`	Unknown
`free_form_service_item_label_display_name`	Unknown
`free_form_service_item_label_language_code`	Unknown
`price_currency_code`	Unknown
`price_nanos`	Unknown
`price_units`	Unknown
`structured_service_description`	Unknown
`structured_service_type_id`	Unknown

location

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`ad_word_location_extension_phone`	Unknown
`language_code`	Unknown
`latitude`	Unknown
`longitude`	Unknown
`open_info_can_reopen`	Unknown
`open_info_status`	Unknown
`opening_date_day`	Unknown
`opening_date_month`	Unknown
`opening_date_year`	Unknown
`primary_category_display_name`	Unknown
`primary_category_name`	Unknown
`primary_phone_number`	Unknown
`profile_description`	Unknown
`relationship_data_parent_chain`	Unknown
`relationship_data_parent_place_id`	Unknown
`relationship_data_parent_relation_type`	Unknown
`service_area_business_type`	Unknown
`service_area_region_code`	Unknown
`store_code`	Unknown
`storefront_address_administrative_area`	Unknown
`storefront_address_language_code`	Unknown
`storefront_address_lines`	Json
`storefront_address_locality`	Unknown
`storefront_address_organization`	Unknown
`storefront_address_postal_code`	Unknown
`storefront_address_recipients`	Json
`storefront_address_region_code`	Unknown
`storefront_address_revision`	Unknown
`storefront_address_sorting_code`	Unknown
`storefront_address_sub_locality`	Unknown
`title`	Unknown
`website_uri`	Unknown
`metadata_`

location_admin

Column	Type	Keys
`id`	Unknown	PK
`location_id`	Unknown	PKFK
`account_id`	Unknown	FK
`admin`	Unknown
`pending_invitation`	Unknown
`role`	Unknown

account

Column	Type	Keys
`id`	Unknown	PK
`account_name`	Unknown
`account_number`	Unknown
`organization_address_administrative_area`	Unknown
`organization_address_language_code`	Unknown
`organization_address_lines`	Json
`organization_address_locality`	Unknown
`organization_address_organization`	Unknown
`organization_address_postal_code`	Unknown
`organization_address_recipients`	Json
`organization_address_region_code`	Unknown
`organization_address_revision`	Unknown
`organization_address_sorting_code`	Unknown
`organization_address_sub_locality`	Unknown
`organization_phone_number`	Unknown
`organization_registered_domain`	Unknown
`permission_level`	Unknown
`primary_owner`	Unknown
`role`	Unknown
`type`	Unknown
`verification_state`	Unknown
`vetted_state`	Unknown

location_insight

Column	Type	Keys
`_fivetran_id`	String	PK
`location_id`	Unknown	FK
`daily_metric`	Unknown
`day`	Unknown
`month`	Unknown
`value`	Unknown
`year`	Unknown

media

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`location_id`	Unknown	PKFK
`attribution_profile_name`	Unknown
`attribution_profile_photo_url`	Unknown
`attribution_profile_url`	Unknown
`attribution_take_down_url`	Unknown
`create_time`	Unknown
`data_ref_resource_name`	Unknown
`description`	Unknown
`dimension_height_pixel`	Unknown
`dimension_width_pixel`	Unknown
`google_url`	Unknown
`insights_view_count`	Unknown
`location_association_category`	Json
`location_association_price_list_item_id`	Unknown
`media_format`	Unknown
`source_url`	Unknown
`summary`	Unknown
`thumbnail_url`	Unknown

local_post_media

Column	Type	Keys
`media_id`	Unknown	PK
`account_id`	Unknown	PKFK
`local_post_id`	Unknown	PKFK
`location_id`	Unknown	PKFK
`attribution_profile_name`	Unknown
`attribution_profile_photo_url`	Unknown
`attribution_profile_url`	Unknown
`attribution_take_down_url`	Unknown
`create_time`	Unknown
`data_ref_resource_name`	Unknown
`description`	Unknown
`dimension_height_pixel`	Unknown
`dimension_width_pixel`	Unknown
`google_url`	Unknown
`insights_view_count`	Unknown
`location_association_category`	Json
`location_association_price_list_item_id`	Unknown
`media_format`	Unknown
`source_url`	Unknown
`summary`	Unknown
`thumbnail_url`	Unknown

local_post

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`location_id`	Unknown	PKFK
`alert_type`	Unknown
`call_to_action_type`	Unknown
`call_to_action_url`	Unknown
`create_time`	Unknown
`event_schedule_end_date_day`	Unknown
`event_schedule_end_date_month`	Unknown
`event_schedule_end_date_year`	Unknown
`event_schedule_end_time_hours`	Unknown
`event_schedule_end_time_minutes`	Unknown
`event_schedule_end_time_nanos`	Unknown
`event_schedule_end_time_seconds`	Unknown
`event_schedule_start_date_day`	Unknown
`event_schedule_start_date_month`	Unknown
`event_schedule_start_date_year`	Unknown
`event_schedule_start_time_hours`	Unknown
`event_schedule_start_time_minutes`	Unknown
`event_schedule_start_time_nanos`	Unknown
`event_schedule_start_time_seconds`	Unknown
`event_title`	Unknown
`language_code`	Unknown
`offer_coupon_code`	Unknown
`offer_redeem_online_url`	Unknown
`offer_terms_conditions`	Unknown
`search_url`	Unknown
`state`	Unknown
`summary`	Unknown
`topic_type`	Unknown
`update_time`	Unknown

location_keyword_impression

Column	Type	Keys
`_fivetran_id`	String	PK
`location_id`	Unknown	FK
`end_date_day`	Unknown
`end_date_month`	Unknown
`end_date_year`	Unknown
`insights_value`	Unknown
`insights_value_threshold`	Unknown
`search_keyword`	Unknown
`start_date_day`	Unknown
`start_date_month`	Unknown
`start_date_year`	Unknown

review

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`location_id`	Unknown	PKFK
`comment`	Unknown
`create_time`	Unknown
`name`	Unknown
`review_reply_comment`	Unknown
`review_reply_update_time`	Unknown
`reviewer_display_name`	Unknown
`reviewer_is_anonymous`	Unknown
`reviewer_profile_photo_url`	Unknown
`star_rating`	Unknown
`update_time`	Unknown

customer_media

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`location_id`	Unknown	PKFK
`attribution_profile_name`	Unknown
`attribution_profile_photo_url`	Unknown
`attribution_profile_url`	Unknown
`attribution_take_down_url`	Unknown
`create_time`	Unknown
`data_ref_resource_name`	Unknown
`description`	Unknown
`dimension_height_pixel`	Unknown
`dimension_width_pixel`	Unknown
`google_url`	Unknown
`insights_view_count`	Unknown
`media_format`	Unknown
`source_url`	Unknown
`thumbnail_url`	Unknown