# Yext schema ERD

Table and field reference for the Fivetran Yext connector.

## Table & Field Reference

### location_category

| Column | Type | Keys |
| --- | --- | --- |
| category_id | Unknown | PK |
| account_id | Unknown | PK, FK |
| location_id | Unknown | PK, FK |

### location_photo

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| location_id | Unknown | PK, FK |
| alternate_text | Unknown |  |
| derivative | Json |  |
| description | Unknown |  |
| height | Unknown |  |
| url | Unknown |  |
| width | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| accepting_new_patient | Unknown |  |
| additional_hours_text | Unknown |  |
| address | Unknown |  |
| address_2 | Unknown |  |
| admitting_hospital | Json |  |
| alternate_name | Json |  |
| alternate_phone | Unknown |  |
| alternate_website | Json |  |
| association | Unknown |  |
| attire | Unknown |  |
| bio_list_id | Json |  |
| bio_list_label | Unknown |  |
| certification | Json |  |
| city | Unknown |  |
| competitor | Json |  |
| condition_treated | Json |  |
| country_code | Unknown |  |
| degree | Json |  |
| description | Unknown |  |
| display_address | Unknown |  |
| display_lat | Unknown |  |
| display_lng | Unknown |  |
| display_menu_url | Unknown |  |
| display_order_url | Unknown |  |
| display_reservation_url | Unknown |  |
| display_website_url | Unknown |  |
| dropoff_lat | Unknown |  |
| dropoff_lng | Unknown |  |
| education_list | Json |  |
| email | Json |  |
| event_list_id | Json |  |
| event_list_label | Unknown |  |
| facebook_call_action_type | Unknown |  |
| facebook_call_action_value | Unknown |  |
| facebook_cover_photo_alternatetext | Unknown |  |
| facebook_cover_photo_height | Unknown |  |
| facebook_cover_photo_url | Unknown |  |
| facebook_cover_photo_width | Unknown |  |
| facebook_page_url | Unknown |  |
| facebook_profile_picture_derivative | Json |  |
| facebook_profile_picture_height | Unknown |  |
| facebook_profile_picture_source_url | Unknown |  |
| facebook_profile_picture_url | Unknown |  |
| facebook_profile_picture_width | Unknown |  |
| fax_phone | Unknown |  |
| featured_message | Unknown |  |
| featured_message_url | Unknown |  |
| first_party_review_page | Unknown |  |
| folder_id | Unknown |  |
| gender | Unknown |  |
| google_attribute | Json |  |
| google_cover_photo_alternate_text | Unknown |  |
| google_cover_photo_height | Unknown |  |
| google_cover_photo_url | Unknown |  |
| google_cover_photo_width | Unknown |  |
| google_profile_photo_height | Unknown |  |
| google_profile_photo_url | Unknown |  |
| google_profile_photo_width | Unknown |  |
| holiday_hour | Json |  |
| holiday_hour_confirmation_enabled | Unknown |  |
| hours | Unknown |  |
| instagram_handle | Unknown |  |
| insurance_accepted | Json |  |
| intelligent_search_tracking_enabled | Unknown |  |
| intelligent_search_tracking_frequency | Unknown |  |
| is_closed | Unknown |  |
| is_cluster_primary | Unknown |  |
| is_phone_tracked | Unknown |  |
| iso_region_code | Unknown |  |
| keyword | Unknown |  |
| label_id | Json |  |
| languages | Unknown |  |
| local_phone | Unknown |  |
| located_in | Unknown |  |
| location_keyword | Json |  |
| logo_derivative | Json |  |
| logo_height | Unknown |  |
| logo_url | Unknown |  |
| logo_width | Unknown |  |
| meal_served | Json |  |
| menu_id | Json |  |
| menu_url | Unknown |  |
| menus_label | Unknown |  |
| mobile_phone | Unknown |  |
| name | Unknown |  |
| npi | Unknown |  |
| office_name | Json |  |
| order_url | Unknown |  |
| payment_option | Json |  |
| phone | Unknown |  |
| pickup_lat | Unknown |  |
| pickup_lng | Unknown |  |
| place | Json |  |
| price_range | Unknown |  |
| primary_contact | Unknown |  |
| produc_list_id | Json |  |
| product | Unknown |  |
| product_list_id | Json |  |
| product_list_label | Unknown |  |
| query_template | Json |  |
| radius | Unknown |  |
| reservation_url | Unknown |  |
| review_balancing_url | Unknown |  |
| review_response_conversation_enabled | Unknown |  |
| routable_lat | Unknown |  |
| routable_lng | Unknown |  |
| schema_type | Json |  |
| service | Json |  |
| speciality | Json |  |
| state | Unknown |  |
| sublocality | Unknown |  |
| suppress_address | Unknown |  |
| timestamps | Unknown |  |
| timezone | Unknown |  |
| toll_free_phone | Unknown |  |
| tracking_site | Unknown |  |
| tty_phone | Unknown |  |
| twitter_handle | Unknown |  |
| type | Unknown |  |
| uber_embed_code | Unknown |  |
| uber_link | Unknown |  |
| uber_link_raw | Unknown |  |
| uber_link_text | Unknown |  |
| uber_link_type | Unknown |  |
| uber_trip_branding_description | Unknown |  |
| uber_trip_branding_text | Unknown |  |
| uber_trip_branding_url | Unknown |  |
| uid | Unknown |  |
| unit | Unknown |  |
| video_url | Json |  |
| walkable_lat | Unknown |  |
| walkable_lng | Unknown |  |
| website_url | Unknown |  |
| year_established | Unknown |  |
| yext_display_lat | Unknown |  |
| yext_display_lng | Unknown |  |
| yext_dropoff_lat | Unknown |  |
| yext_dropoff_lng | Unknown |  |
| yext_pickup_lat | Unknown |  |
| yext_pickup_lng | Unknown |  |
| yext_routable_lat | Unknown |  |
| yext_routable_lng | Unknown |  |
| yext_walkable_lat | Unknown |  |
| yext_walkable_lng | Unknown |  |
| zip | Unknown |  |
| custom_** |  |  |

### publisher_brand

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| publisher_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### publisher_supported_country

| Column | Type | Keys |
| --- | --- | --- |
| supported_country | Unknown | PK |
| account_id | Unknown | PK, FK |
| publisher_id | Unknown | PK, FK |

### publisher_supported_entity

| Column | Type | Keys |
| --- | --- | --- |
| supported_entity_type | Unknown | PK |
| account_id | Unknown | PK, FK |
| publisher_id | Unknown | PK, FK |

### publisher_feature

| Column | Type | Keys |
| --- | --- | --- |
| feature | Unknown | PK |
| account_id | Unknown | PK, FK |
| publisher_id | Unknown | PK, FK |

### publisher

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_email | Unknown |  |
| contact_first_name | Unknown |  |
| contact_last_name | Unknown |  |
| contact_phone | Unknown |  |
| name | Unknown |  |
| sub_account_count | Unknown |  |

### review_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| review_id | Unknown | PK, FK |
| author_email | Unknown |  |
| author_name | Unknown |  |
| author_role | Unknown |  |
| content | Unknown |  |
| date | Unknown |  |
| is_automatic_response | Unknown |  |
| publisher_date | Unknown |  |
| suppress_reviewer_contact | Unknown |  |
| visibility | Unknown |  |

### review_label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| review_id | Unknown | PK, FK |
| name | Unknown |  |

### review

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| location_id | Unknown | FK |
| publisher_id | Unknown | FK |
| api_identifier | Unknown |  |
| author_email | Unknown |  |
| author_name | Unknown |  |
| content | Unknown |  |
| external_id | Unknown |  |
| flag_status | Unknown |  |
| invitation_id | Unknown |  |
| label_id | Json |  |
| last_yext_update_time | Unknown |  |
| publisher_date | Unknown |  |
| rating | Unknown |  |
| recommendation | Unknown |  |
| review_language | Unknown |  |
| review_type | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| transaction_id | Unknown |  |
| url | Unknown |  |

## Relationships

- location_category(location_id) → location(id)
- location_category(account_id) → location(account_id)
- location_photo(location_id) → location(id)
- location_photo(account_id) → location(account_id)
- location(account_id) → account(id)
- publisher_brand(publisher_id) → publisher(id)
- publisher_brand(account_id) → publisher(account_id)
- publisher_supported_country(publisher_id) → publisher(id)
- publisher_supported_country(account_id) → publisher(account_id)
- publisher_supported_entity(publisher_id) → publisher(id)
- publisher_supported_entity(account_id) → publisher(account_id)
- publisher_feature(publisher_id) → publisher(id)
- publisher_feature(account_id) → publisher(account_id)
- publisher(account_id) → account(id)
- review_comment(review_id) → review(id)
- review_comment(account_id) → review(account_id)
- review_label(review_id) → review(id)
- review_label(account_id) → review(account_id)
- review(publisher_id) → publisher(id)
- review(location_id) → location(id)
- review(account_id) → account(id)