# Birdeye schema ERD

Table and field reference for the Fivetran Birdeye connector.

## Table & Field Reference

### category_stat

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| insight_id | Unknown | PK, FK |
| average_score | Double |  |
| color_code | String |  |
| competitor | Boolean |  |
| count | Unknown |  |
| enterprise_name | String |  |
| grade | String |  |

### insight_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_name | String |  |

### aggregation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| aggregation_status | Unknown |  |
| source_alias | String |  |
| source_name | String |  |
| source_url | String |  |

### employee_business

| Column | Type | Keys |
| --- | --- | --- |
| business_id | Unknown | PK |
| employee_id | Unknown | FK |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email_id | String |  |
| first_name | String |  |
| image_url | String |  |
| last_name | String |  |
| name | String |  |
| phone | String |  |

### review_assisted_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_id | String | PK, FK |
| email_id | String |  |
| first_name | String |  |
| id | Unknown |  |
| last_name | String |  |
| phone_number | String |  |

### review_extra_param

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| review_id | String | PK, FK |
| value | Unknown |  |

### review

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| business_name | String | FK |
| business_id | Unknown |  |
| business_type | String |  |
| comments | String |  |
| customer_id | Unknown |  |
| enable_reply | Boolean |  |
| featured | Unknown |  |
| rating | Double |  |
| response | String |  |
| response_date | String |  |
| review_date | String |  |
| review_url | String |  |
| reviewer_city | String |  |
| reviewer_email_id | String |  |
| reviewer_facebook_id | Unknown |  |
| reviewer_first_name | String |  |
| reviewer_last_name | String |  |
| reviewer_nickname | String |  |
| reviewer_phone | String |  |
| reviewer_state | String |  |
| reviewer_thumbnail_url | String |  |
| source_type | String |  |
| status | String |  |
| title | String |  |
| unique_review_url | String |  |

### business_competitor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| enterprise_id | Unknown | FK |
| location_address_1 | String |  |
| location_address_2 | String |  |
| location_city | String |  |
| location_country_code | String |  |
| location_country_name | String |  |
| location_latitude | Double |  |
| location_longitude | Double |  |
| location_state | String |  |
| location_zip | Unknown |  |
| name | String |  |

### competitor

| Column | Type | Keys |
| --- | --- | --- |
| enterprise_id | Unknown | PK |
| enterprise_name | String |  |

### contact_location

| Column | Type | Keys |
| --- | --- | --- |
| location | Unknown | PK |
| contact_id | Unknown | PK, FK |

### contact_mapping

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| mapping_business_id | Unknown |  |
| mapping_customer_id | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_type | Unknown |  |
| created | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_activity_on | Unknown |  |
| last_name | Unknown |  |
| native_email_unsub_type | Unknown |  |
| native_sms_unsub_type | Unknown |  |
| phone | Unknown |  |
| source | Unknown |  |
| tags | Json |  |
| custom_** |  |  |

### theme_stat

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| theme_id | Unknown | FK |
| adjective | String |  |
| count | Unknown |  |
| keyword | String |  |
| negative_count | Unknown |  |
| positive_count | Unknown |  |
| score | Unknown |  |
| scr | Unknown |  |
| theme | String |  |

### theme_competitor

| Column | Type | Keys |
| --- | --- | --- |
| competitor_id | Unknown | PK, FK |
| theme_id | Unknown | PK, FK |

### theme

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| average_score | Double |  |
| count | Unknown |  |
| name | String |  |
| negative_count | Unknown |  |
| negative_percentage | Double |  |
| occurrence | Unknown |  |
| percentage | Double |  |
| positive_count | Unknown |  |
| positive_percentage | Double |  |
| themes | Json |  |

### keyword_stat

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| keyword_id | Unknown | FK |
| keyword | String |  |
| occurrence | Unknown |  |
| score | Unknown |  |
| scr | Unknown |  |

### keyword_adjective

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| keyword_id | Unknown | FK |
| adjective | String |  |
| average_score | Double |  |
| occurrence | Unknown |  |
| percentage | Unknown |  |

### keyword_competitor

| Column | Type | Keys |
| --- | --- | --- |
| competitor_id | Unknown | PK, FK |
| keyword_id | Unknown | PK, FK |

### keyword

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| average_score | Double |  |
| count | Unknown |  |
| keywords | Json |  |
| name | String |  |

### conversation_message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| attachments | Json |  |
| channel | Unknown |  |
| direction | Unknown |  |
| message_date | Unknown |  |
| message_status | Unknown |  |
| sent_at | Unknown |  |
| text | Unknown |  |
| user_id | Unknown |  |

### conversation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| assigned_to_email_id | Unknown |  |
| assigned_to_id | Unknown |  |
| assigned_to_name | Unknown |  |
| assigned_to_type | Unknown |  |
| contact_created_date | Unknown |  |
| contact_team | Unknown |  |
| contact_updated_date | Unknown |  |
| conversation_start_date | Unknown |  |
| last_message_received_on | Unknown |  |
| last_used_channel | Unknown |  |
| status | Unknown |  |

### working_hour

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| business_name | String | FK |
| hours_of_operation_index | Unknown | FK |
| end_hour | String |  |
| start_hour | String |  |

### hours_of_operation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| business_name | String | PK, FK |
| comment | String |  |
| day | Unknown |  |
| is_open | Unknown |  |

### business

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| alias | String |  |
| avg_rating | Double |  |
| base_url | String |  |
| business_status | String |  |
| category | String |  |
| cover_business_info_layout | String |  |
| cover_image_url | String |  |
| covid_info | Json |  |
| created_date | String |  |
| description | String |  |
| email_id | String |  |
| fax | String |  |
| image_1_url | String |  |
| image_2_url | String |  |
| image_3_url | String |  |
| internal_listing_category | String |  |
| internal_listing_display_category | String |  |
| internal_listing_subcategory_1 | String |  |
| is_address_hidden | String |  |
| is_seoenabled | Boolean |  |
| is_service_area_provider | String |  |
| keywords | String |  |
| languages | Json |  |
| location_address_1 | String |  |
| location_address_2 | String |  |
| location_city | String |  |
| location_country_code | String |  |
| location_country_name | String |  |
| location_latitude | Double |  |
| location_longitude | Double |  |
| location_state | String |  |
| location_zip | Unknown |  |
| logo_url | String |  |
| payment | String |  |
| phone | String |  |
| review_count | Unknown |  |
| services | String |  |
| social_profile_urls_facebook_url | String |  |
| social_profile_urls_google_url | String |  |
| social_profile_urls_linkedin_url | String |  |
| social_profile_urls_twitter_url | String |  |
| social_profile_urls_youtube_url | String |  |
| status | String |  |
| timezone | String |  |
| type | String |  |
| website_url | String |  |
| working_24_x_7 | Unknown |  |

### source_list

| Column | Type | Keys |
| --- | --- | --- |
| alias | String | PK |

### answer_child

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| answer_index | Unknown | FK |
| response_id | Unknown | FK |
| answer | String |  |
| conditional | Boolean |  |
| hidden | Boolean |  |
| max_value | Unknown |  |
| min_value | Unknown |  |
| question_title | String |  |
| question_type | String |  |
| show_date | Boolean |  |
| show_time | Boolean |  |
| shown_to_customer | Boolean |  |
| visible | Boolean |  |

### answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| response_id | Unknown | PK, FK |
| answer | String |  |
| conditional | Boolean |  |
| hidde | Boolean |  |
| max_value | Unknown |  |
| min_value | Unknown |  |
| question_title | String |  |
| question_type | String |  |
| show_date | Boolean |  |
| show_time | Boolean |  |
| shown_to_customer | Boolean |  |
| visible | Boolean |  |

### response_custom_param

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| response_id | Unknown | PK, FK |
| value | Unknown |  |

### response_extra_param

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| response_id | Unknown | PK, FK |
| value | Unknown |  |

### response

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | FK |
| business_id | Unknown |  |
| business_location_name | String |  |
| business_number | Unknown |  |
| completed | Boolean |  |
| customer_id | Unknown |  |
| customer_name | String |  |
| locale | String |  |
| location_name | String |  |
| question_count | Unknown |  |
| request_date | String |  |
| response_date | String |  |
| ticketed | Boolean |  |

### conversation_report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agg_review_count | Unknown |  |
| alias_1 | String |  |
| business_number | Unknown |  |
| email_click_info_mobile_birdeye | Unknown |  |
| email_click_info_mobile_google | Unknown |  |
| email_click_info_mobile_other_sites | Unknown |  |
| email_click_info_mobile_yelp | Unknown |  |
| email_click_info_pc_birdeye | Unknown |  |
| email_click_info_pc_google | Unknown |  |
| email_click_info_pc_other_sites | Unknown |  |
| email_click_info_pc_yelp | Unknown |  |
| email_click_info_percent | Double |  |
| email_click_info_total | Unknown |  |
| email_open_info_mobile_android | Unknown |  |
| email_open_info_mobile_ios | Unknown |  |
| email_open_info_mobile_other | Unknown |  |
| email_open_info_pc | Unknown |  |
| email_open_info_percent | Double |  |
| email_open_info_tablet_android | Unknown |  |
| email_open_info_tablet_ios | Unknown |  |
| email_open_info_tablet_other | Unknown |  |
| email_open_info_total | Unknown |  |
| email_sent_info_email_details | Json |  |
| email_sent_info_req_count | Unknown |  |
| email_sent_info_req_reminder_count | Unknown |  |
| email_sent_info_share_req_count | Unknown |  |
| email_sent_info_share_req_reminder_count | Unknown |  |
| email_sent_info_total | Unknown |  |
| heirarchy_groups | String |  |
| is_modifiable | Unknown |  |
| name | String |  |
| organic_review_count | Unknown |  |
| reviews | Json |  |
| sms_detail_birdeye | Unknown |  |
| sms_detail_google | Unknown |  |
| sms_detail_message_click | Unknown |  |
| sms_detail_message_sent | Unknown |  |
| sms_detail_other_sites | Unknown |  |
| sms_detail_percent | Double |  |
| sms_detail_yelp | Unknown |  |

### button_text

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | FK |
| locale | String |  |
| locale_text | String |  |
| text_key | String |  |

### question_choice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| question_id | Unknown | FK |
| hidden | Boolean |  |
| orders | Unknown |  |
| title | String |  |

### page_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_id | Unknown | FK |
| add_page_break | Boolean |  |
| display_logic | Json |  |
| display_question | Boolean |  |
| dynamic_choices | Json |  |
| edit_answer | Boolean |  |
| embed_in_email | Boolean |  |
| hidden | Boolean |  |
| interval | Boolean |  |
| is_required | Boolean |  |
| maximum_value | Unknown |  |
| minimum_value | Unknown |  |
| name | String |  |
| orders | Unknown |  |
| react_element_id | Unknown |  |
| rows | Json |  |
| show_date | Boolean |  |
| show_question_numbers | Unknown |  |
| show_time | Boolean |  |
| shown_to_customer | Boolean |  |
| skip_logic | Json |  |
| skip_question | Boolean |  |
| standard_field | Boolean |  |
| title | String |  |
| type | String |  |
| value | Json |  |
| visible | Boolean |  |

### page

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | FK |
| hidden | Boolean |  |
| name | String |  |
| orders | Unknown |  |
| page_title | String |  |
| show_question_numbers | Unknown |  |
| thankyou_msg | String |  |
| visible | Boolean |  |

### survey_custom_param

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | FK |
| key | String |  |
| label | String |  |

### survey

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_name | String | FK |
| brand_name | String |  |
| business_id | Unknown |  |
| cloneable | Boolean |  |
| created | Instant |  |
| default_locale | String |  |
| hide_birdeye_logo | Boolean |  |
| hide_locale_menu | Boolean |  |
| insights_enabled | Boolean |  |
| last_modified | Instant |  |
| name | String |  |
| owner_email | String |  |
| owner_name | String |  |
| progressbar_position | String |  |
| question_count | Unknown |  |
| responses | String |  |
| show_business_name | Boolean |  |
| show_location_ques | Unknown |  |
| show_logo | String |  |
| show_progress_bar | Boolean |  |
| show_question_number | Boolean |  |
| show_survey_title | Boolean |  |
| show_title | String |  |
| status | String |  |
| str_created_date | String |  |
| str_last_modified_date | String |  |
| supported_locales | Json |  |
| survey_type | String |  |
| thankyou_msg | String |  |
| theme_color | String |  |
| theme_text_color | String |  |
| type | String |  |

### business_enterprise

| Column | Type | Keys |
| --- | --- | --- |
| competitor_id | Unknown | PK |
| enterprise_id | Unknown | FK |
| alias | String |  |
| child_count | Unknown |  |
| name | String |  |

## Relationships

- category_stat(insight_id) → insight_category(id)
- employee_business(employee_id) → employee(id)
- review_assisted_user(review_id) → review(id)
- review_extra_param(review_id) → review(id)
- review(business_name) → business(name)
- business_competitor(enterprise_id) → competitor(enterprise_id)
- contact_location(contact_id) → contact(id)
- contact_mapping(contact_id) → contact(id)
- theme_stat(theme_id) → theme(id)
- theme_competitor(competitor_id) → business_enterprise(competitor_id)
- theme_competitor(theme_id) → theme(id)
- keyword_stat(keyword_id) → keyword(id)
- keyword_adjective(keyword_id) → keyword(id)
- keyword_competitor(competitor_id) → business_enterprise(competitor_id)
- keyword_competitor(keyword_id) → keyword(id)
- conversation_message(conversation_id) → conversation(id)
- conversation(contact_id) → contact(id)
- working_hour(hours_of_operation_index) → hours_of_operation(index)
- working_hour(business_name) → hours_of_operation(business_name)
- hours_of_operation(business_name) → business(name)
- answer_child(answer_index) → answer(index)
- answer_child(response_id) → answer(response_id)
- answer(response_id) → response(id)
- response_custom_param(response_id) → response(id)
- response_extra_param(response_id) → response(id)
- response(survey_id) → survey(id)
- button_text(survey_id) → survey(id)
- question_choice(question_id) → page_question(id)
- page_question(page_id) → page(id)
- page(survey_id) → survey(id)
- survey_custom_param(survey_id) → survey(id)
- survey(business_name) → business(name)
- business_enterprise(enterprise_id) → competitor(enterprise_id)