# Google Business Profile schema ERD

Table and field reference for the Fivetran Google Business Profile connector.

## Table & Field Reference

### location_additional_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| location_id | Unknown | PK, FK |
| phone_number | Unknown |  |

### location_regular_hour_period

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| location_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| display_name | Unknown |  |

### location_additional_category_service_type

| Column | Type | Keys |
| --- | --- | --- |
| service_type_id | Unknown | PK |
| location_additional_category_index | Unknown | PK, FK |
| location_id | Unknown | PK, FK |
| display_name | Unknown |  |

### location_additional_category_hour_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| location_additional_category_index | Unknown | PK, FK |
| location_id | Unknown | PK, FK |
| display_name | Unknown |  |
| hour_type_id | Unknown |  |
| localized_display_name | Unknown |  |

### location_additional_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| location_id | Unknown | PK, FK |
| display_name | Unknown |  |
| name | Unknown |  |

### location_special_hour_period

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| location_id | Unknown | PK, FK |
| 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 | PK, FK |
| place_name | Unknown |  |

### location_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| location_id | Unknown | PK, FK |
| label | Unknown |  |

### location_relationship_data_children_location

| Column | Type | Keys |
| --- | --- | --- |
| place_id | Unknown | PK |
| location_id | Unknown | PK, FK |
| relation_type | Unknown |  |

### location_more_hour_period

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| location_id | Unknown | PK, FK |
| location_more_hour_index | Unknown | PK, FK |
| 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 | PK, FK |
| hour_type_id | Unknown |  |

### location_service_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| location_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| location_id | Unknown | PK, FK |
| 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 | PK, FK |
| local_post_id | Unknown | PK, FK |
| location_id | Unknown | PK, FK |
| 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 | PK, FK |
| location_id | Unknown | PK, FK |
| 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 | PK, FK |
| location_id | Unknown | PK, FK |
| 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 | PK, FK |
| location_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- location_additional_phone_number(location_id) → location(id)
- location_regular_hour_period(location_id) → location(id)
- location_primary_category_hour_type(location_id) → location(id)
- location_primary_category_service_type(location_id) → location(id)
- location_additional_category_service_type(location_additional_category_index) → location_additional_category(index)
- location_additional_category_service_type(location_id) → location_additional_category(location_id)
- location_additional_category_hour_type(location_additional_category_index) → location_additional_category(index)
- location_additional_category_hour_type(location_id) → location_additional_category(location_id)
- location_additional_category(location_id) → location(id)
- location_special_hour_period(location_id) → location(id)
- location_service_area_place(location_id) → location(id)
- location_label(location_id) → location(id)
- location_relationship_data_children_location(location_id) → location(id)
- location_more_hour_period(location_more_hour_index) → location_more_hour(index)
- location_more_hour_period(location_id) → location_more_hour(location_id)
- location_more_hour(location_id) → location(id)
- location_service_item(location_id) → location(id)
- location(account_id) → account(id)
- location_admin(account_id) → account(id)
- location_admin(location_id) → location(id)
- location_insight(location_id) → location(id)
- media(location_id) → location(id)
- media(account_id) → account(id)
- local_post_media(local_post_id) → local_post(id)
- local_post_media(location_id) → local_post(location_id)
- local_post_media(account_id) → local_post(account_id)
- local_post(location_id) → location(id)
- local_post(account_id) → account(id)
- location_keyword_impression(location_id) → location(id)
- review(location_id) → location(id)
- review(account_id) → account(id)
- customer_media(location_id) → location(id)
- customer_media(account_id) → account(id)