Birdeye

Explore the interactive ERD

Table & Field Reference

category_stat

Column	Type	Keys
`id`	Unknown	PK
`insight_id`	Unknown	PKFK
`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_extra_param

Column	Type	Keys
`name`	Unknown	PK
`review_id`	String	PKFK
`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	PKFK

contact_mapping

Column	Type	Keys
`index`	Unknown	PK
`contact_id`	Unknown	PKFK
`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	PKFK
`theme_id`	Unknown	PKFK

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	PKFK
`keyword_id`	Unknown	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`value`	Unknown

response_extra_param

Column	Type	Keys
`name`	Unknown	PK
`response_id`	Unknown	PKFK
`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