Google My Business schema

15 tables · 7 joins

About the connector Start free

15 tables

Loading diagram…

account_location

local_post

account

24

id

string

name

string

account_name

string

account_number

string

organization_info_address_address_lines

string

organization_info_address_administrative_area

string

organization_info_address_language_code

string

organization_info_address_locality

string

organization_info_address_organization

string

account_location

43

id

string

account_id

string

name

string

language_code

string

store_code

string

title

string

phone_numbers

string

categories_primary_category_name

string

categories_primary_category_display_name

string

storefront_address_revision

string

account_location_primary_category_more_hour_type

6

location_id

string

hours_type_id

string

display_name

string

localized_display_name

string

index

double

_weld_synced

date

account_location_primary_category_service_type

5

location_id

string

service_type_id

string

display_name

string

index

double

_weld_synced

date

account_location_additional_category

5

location_id

string

name

string

display_name

string

index

double

_weld_synced

date

account_location_additional_category_more_hour_type

6

category_id

string

hours_type_id

string

display_name

string

localized_display_name

string

index

double

_weld_synced

date

account_location_additional_category_service_type

5

category_id

string

service_type_id

string

display_name

string

index

double

_weld_synced

date

account_location_regular_hour_period

7

location_id

string

open_day

string

open_time

string

close_day

string

close_time_hours

double

index

double

_weld_synced

date

location_admin

8

account_id

string

location_id

string

name

string

admin

string

role

string

pending_invitation

boolean

account

string

_weld_synced

date

local_post

29

id

string

account_id

string

location_id

string

name

string

language_code

string

call_to_action_action_type

string

call_to_action_url

string

state

string

event_title

string

event_schedule_start_date_year

double

local_post_media

6

account_id

string

local_post_id

string

media_id

string

location_id

string

name

string

_weld_synced

date

location_performance_daily

5

location_id

string

date

string

metric

string

value

long

_weld_synced

date

location_search_keywords_impressions_monthly

6

location_id

string

month

string

search_keyword

string

value

long

threshold

long

_weld_synced

date

media

22

id

string

account_id

string

location_id

string

name

string

media_format

string

location_association_category

string

google_url

string

thumbnail_url

string

create_time

date

dimensions_width_pixels

double

review

14

review_id

string

account_id

string

location_id

string

star_rating

string

create_time

date

update_time

date

name

string

reviewer_profile_photo_url

string

reviewer_display_name

string

reviewer_is_anonymous

string

comment

string

review_reply_comment

string

review_reply_update_time

string

_weld_synced

date