# Mention schema ERD

Table and field reference for the Fivetran Mention connector.

## Table & Field Reference

### alert_preference

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_id | String | PK, FK |
| alert_id | Long | PK, FK |
| desktop_notification_frequency | String |  |
| email_notification_frequency | String |  |
| instant_notifications_active | Boolean |  |
| push_notification_frequency | String |  |
| stats_email_active | Boolean |  |
| trending_email_notification_frequency | String |  |
| trending_sms_notification_frequency | String |  |
| weight | Long |  |

### alert_language

| Column | Type | Keys |
| --- | --- | --- |
| languages | String | PK |
| alert_id | Long | PK, FK |

### alert_source

| Column | Type | Keys |
| --- | --- | --- |
| source | String | PK |
| alert_id | Long | PK, FK |

### alert_country

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| alert_id | Long | PK, FK |

### alert_blocked_site

| Column | Type | Keys |
| --- | --- | --- |
| blocked_site | String | PK |
| alert_id | Long | PK, FK |

### alert_included_keyword

| Column | Type | Keys |
| --- | --- | --- |
| included_keyword | String | PK |
| alert_id | Long | PK, FK |

### alert_required_keyword

| Column | Type | Keys |
| --- | --- | --- |
| required_keyword | String | PK |
| alert_id | Long | PK, FK |

### alert_excluded_keyword

| Column | Type | Keys |
| --- | --- | --- |
| excluded_keyword | String | PK |
| alert_id | Long | PK, FK |

### alert_monitored_facebook_page

| Column | Type | Keys |
| --- | --- | --- |
| url | String | PK |
| alert_id | Long | PK, FK |
| block_comments | Boolean |  |
| block_self | Boolean |  |
| facebook_id | String |  |
| name | String |  |
| type | String |  |
| valid | Boolean |  |

### alert_monitored_twitter_account

| Column | Type | Keys |
| --- | --- | --- |
| url | String | PK |
| alert_id | Long | PK, FK |
| block_comments | Boolean |  |
| block_retweets | Boolean |  |
| block_self | Boolean |  |
| name | String |  |
| type | String |  |
| valid | Boolean |  |

### alert

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| account_id | String | FK |
| color | String |  |
| connection_type | String |  |
| created_at | Instant |  |
| graph_ql_id | String |  |
| group_graph_ql_id | String |  |
| group_id | String |  |
| index_version | Long |  |
| last_update | Instant |  |
| look_for_spread | Boolean |  |
| name | String |  |
| noise_detection | Boolean |  |
| paused | Boolean |  |
| permissions_can_use_linkedin_sources | Boolean |  |
| permissions_can_use_reviews_sources | Boolean |  |
| permissions_create_tag | Boolean |  |
| permissions_edit | Boolean |  |
| permissions_edit_mentions | Boolean |  |
| permissions_export_mentions | Boolean |  |
| permissions_list_logs | Boolean |  |
| permissions_list_tasks | Boolean |  |
| permissions_share | Boolean |  |
| query_type | String |  |
| quota_used | Long |  |
| read_access_secret | String |  |
| role | String |  |
| sentiment_analysis | Boolean |  |
| slack_configuration_is_configured | Boolean |  |
| slack_configuration_minimal_influence_score | Long |  |
| slack_configuration_new_mentions | Boolean |  |
| slack_configuration_recurring_recap | Boolean |  |
| slack_configuration_timezone | String |  |
| stats_done_tasks_total | Long |  |
| stats_favorite_mentions_total | Long |  |
| stats_logs_total | Long |  |
| stats_mention_folders_archive_total | Long |  |
| stats_mention_folders_inbox_total | Long |  |
| stats_mention_folders_spam_total | Long |  |
| stats_mention_folders_trash_total | Long |  |
| stats_mention_sources_total | Long |  |
| stats_tasks_total | Long |  |
| stats_todo_tasks_total | Long |  |
| stats_unread_mentions_total | Long |  |
| stats_unseen_mentions_total | Long |  |
| type | String |  |
| updated_at | Instant |  |

### share

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| alert_id | Long | FK |
| blocked | Boolean |  |
| created_at | Instant |  |
| last_seen_count | Long |  |
| permissions_delete | Boolean |  |
| permissions_edit | Boolean |  |
| role | String |  |
| subscriber | Boolean |  |
| weight | Long |  |

### account_group

| Column | Type | Keys |
| --- | --- | --- |
| graph_ql_id | String | PK |
| id | String | PK |
| account_id | String | PK, FK |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| application_notification_enabled | Boolean |  |
| bucket | Long |  |
| client_state | String |  |
| company_name | String |  |
| company_size | String |  |
| created_at | Instant |  |
| default_desktop_notification_frequency | String |  |
| default_email_notification_frequency | String |  |
| default_push_notification_frequency | String |  |
| default_trending_email_notification_frequency | String |  |
| default_trending_sms_notification_frequency | String |  |
| email | String |  |
| email_subscriptions_quota_exceeded | Boolean |  |
| enabled_mfa | Boolean |  |
| extended_profile_set | Boolean |  |
| grouped_email_notification | Boolean |  |
| hide_mark_all_read_mentions | Boolean |  |
| language_code | String |  |
| marketing_notification_enabled | Boolean |  |
| name | String |  |
| permissions_can_access_dashboard_homepage | Boolean |  |
| permissions_can_use_linkedin_sources | Boolean |  |
| permissions_can_use_reviews_sources | Boolean |  |
| permissions_create_alert | Boolean |  |
| permissions_create_dashboard | Boolean |  |
| permissions_create_report | Boolean |  |
| permissions_create_report_blank | Boolean |  |
| permissions_create_report_facebook_comparison | Boolean |  |
| permissions_create_report_instagram_comparison | Boolean |  |
| permissions_create_report_mentions_list | Boolean |  |
| permissions_create_report_twitter_comparison | Boolean |  |
| permissions_create_scheduled_report | Boolean |  |
| permissions_create_team_request | Boolean |  |
| permissions_delete_team_reports | Boolean |  |
| permissions_edit_modules_report | Boolean |  |
| permissions_list_team_reports | Boolean |  |
| permissions_publish_access | Boolean |  |
| permissions_read_dashboards | Boolean |  |
| permissions_read_demoalert | Boolean |  |
| permissions_read_integrations | Boolean |  |
| permissions_read_plans_notifications | Boolean |  |
| permissions_read_quota_stats | Boolean |  |
| permissions_read_reports | Boolean |  |
| permissions_read_scheduled_reports | Boolean |  |
| permissions_read_social_accounts | Boolean |  |
| permissions_read_team_members | Boolean |  |
| permissions_read_team_requests | Boolean |  |
| permissions_read_team_social_accounts | Boolean |  |
| permissions_request_demo | Boolean |  |
| permissions_respond_access | Boolean |  |
| phone | String |  |
| publish_notif_approved_post_email | Boolean |  |
| publish_notif_failure_desktop | Boolean |  |
| publish_notif_failure_email | Boolean |  |
| publish_notif_in_review_post_email | Boolean |  |
| publish_notif_ongoing_desktop | Boolean |  |
| publish_notif_ongoing_email | Boolean |  |
| publish_notif_success_desktop | Boolean |  |
| publish_notif_success_email | Boolean |  |
| registration_country | String |  |
| respond_notif_assigned_to_you_desktop | Boolean |  |
| respond_notif_assigned_to_you_email | Boolean |  |
| respond_notif_new_message_desktop | Boolean |  |
| respond_notif_new_message_email | Boolean |  |
| seen_onboarding | Long |  |
| signup_values_job_position | String |  |
| signup_values_use_case | Long |  |
| subscription_advanced_query_access | Boolean |  |
| subscription_billing_account_id | String |  |
| subscription_broadcast_sources_access | Boolean |  |
| subscription_chart_access | Boolean |  |
| subscription_collaborative_features_access | Boolean |  |
| subscription_custom | Boolean |  |
| subscription_data_export_access | Boolean |  |
| subscription_facebook_keyword_access | Boolean |  |
| subscription_feature_discovery_add_alert | Boolean |  |
| subscription_feature_discovery_add_team | Boolean |  |
| subscription_feature_discovery_assign_task | Boolean |  |
| subscription_feature_discovery_check_stats | Boolean |  |
| subscription_feature_discovery_share_alert | Boolean |  |
| subscription_feature_discovery_social_account | Boolean |  |
| subscription_geofiltering_access | Boolean |  |
| subscription_has_failed_renews | Boolean |  |
| subscription_history | Long |  |
| subscription_history_access | Boolean |  |
| subscription_instant_notification_daily_quota | Long |  |
| subscription_instant_notification_monthly_quota | Long |  |
| subscription_instant_notification_monthly_quota_usage | Long |  |
| subscription_is_blocked | Boolean |  |
| subscription_max_alerts | Long |  |
| subscription_max_languages_per_alert | Long |  |
| subscription_max_members | Long |  |
| subscription_max_reports | Long |  |
| subscription_mentions_quota | Long |  |
| subscription_mentions_remaining | Long |  |
| subscription_paid_subscription | Boolean |  |
| subscription_permissions_can_manage_account | Boolean |  |
| subscription_permissions_change_plan | Boolean |  |
| subscription_permissions_manage | Boolean |  |
| subscription_permissions_manage_team_members | Boolean |  |
| subscription_permissions_use_mfa | Boolean |  |
| subscription_permissions_use_sms_for_mfa | Boolean |  |
| subscription_permissions_view_price | Boolean |  |
| subscription_pinterest_crawling_access | Boolean |  |
| subscription_plan_code | String |  |
| subscription_plan_group | String |  |
| subscription_plan_name | String |  |
| subscription_plan_team | String |  |
| subscription_prepaid_remaining | Long |  |
| subscription_prepaid_until | Instant |  |
| subscription_publish_access | Boolean |  |
| subscription_remaining_days_before_churning | Long |  |
| subscription_resets_at | Instant |  |
| subscription_respond_access | Boolean |  |
| subscription_search_access | Boolean |  |
| subscription_seen_onboarding | Long |  |
| subscription_sentiment_analysis_access | Boolean |  |
| subscription_spread_access | Boolean |  |
| subscription_statistics_access | Boolean |  |
| subscription_team_owner | Boolean |  |
| subscription_tiktok_crawling_access | Boolean |  |
| subscription_trial_plan | Boolean |  |
| subscription_whitelabeling | Boolean |  |
| subscription_youtube_crawling_access | Boolean |  |
| team_id | String |  |
| timezone | String |  |
| trial_search_count | Long |  |
| updated_at | Instant |  |
| validated_mfa | Boolean |  |

### children_offset_title

| Column | Type | Keys |
| --- | --- | --- |
| title | Long | PK |
| children_id | String | PK, FK |

### children_offset_description

| Column | Type | Keys |
| --- | --- | --- |
| description | Long | PK |
| children_id | String | PK, FK |

### children_offset_description_medium

| Column | Type | Keys |
| --- | --- | --- |
| description_medium | Long | PK |
| children_id | String | PK, FK |

### children_offset_description_short

| Column | Type | Keys |
| --- | --- | --- |
| description_short | Long | PK |
| children_id | String | PK, FK |

### children

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| alert_id | Long | FK |
| mention_id | String | FK |
| children_children | Json |  |
| children_total | Long |  |
| country | String |  |
| created_at | Instant |  |
| cumulative_reach | Long |  |
| direct_reach | Long |  |
| display_site | Boolean |  |
| favorite | Boolean |  |
| folder | String |  |
| folder_set_by_user | Boolean |  |
| graph_ql_id | String |  |
| language_code | String |  |
| logs | Json |  |
| metadata_twitter_id_str | String |  |
| metadata_twitter_user_id_str | String |  |
| parent_id | Long |  |
| permissions_change_folder | Boolean |  |
| permissions_create_task | Boolean |  |
| permissions_edit | Boolean |  |
| permissions_favorite | Boolean |  |
| permissions_share_email | Boolean |  |
| permissions_share_facebook | Boolean |  |
| published_at | Instant |  |
| read | Boolean |  |
| relevance_score | Long |  |
| source_type | String |  |
| tags | Json |  |
| tasks | Json |  |
| tone | Long |  |
| tone_score | Long |  |
| unique_id | String |  |
| updated_at | Instant |  |

### mention_offset_title

| Column | Type | Keys |
| --- | --- | --- |
| title | Long | PK |
| mention_id | String | PK, FK |

### mention_offset_description

| Column | Type | Keys |
| --- | --- | --- |
| description | Long | PK |
| mention_id | String | PK, FK |

### mention_offset_description_medium

| Column | Type | Keys |
| --- | --- | --- |
| description_medium | Long | PK |
| mention_id | String | PK, FK |

### mention_offset_description_short

| Column | Type | Keys |
| --- | --- | --- |
| description_short | Long | PK |
| mention_id | String | PK, FK |

### mention

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| alert_id | Long | FK |
| country | String |  |
| created_at | Instant |  |
| cumulative_reach | Long |  |
| direct_reach | Long |  |
| display_site | Boolean |  |
| favorite | Boolean |  |
| folder | String |  |
| folder_set_by_user | Boolean |  |
| graph_ql_id | String |  |
| language_code | String |  |
| logs | Json |  |
| metadata_twitter_id_str | String |  |
| metadata_twitter_user_id_str | String |  |
| permissions_change_folder | Boolean |  |
| permissions_create_task | Boolean |  |
| permissions_edit | Boolean |  |
| permissions_favorite | Boolean |  |
| permissions_share_email | Boolean |  |
| permissions_share_facebook | Boolean |  |
| published_at | Instant |  |
| read | Boolean |  |
| relevance_score | Long |  |
| source_type | String |  |
| tags | Json |  |
| tasks | Json |  |
| tone | Long |  |
| tone_score | Long |  |
| unique_id | String |  |
| updated_at | Instant |  |

## Relationships

- alert_preference(account_id) → account(id)
- alert_preference(alert_id) → alert(id)
- alert_language(alert_id) → alert(id)
- alert_source(alert_id) → alert(id)
- alert_country(alert_id) → alert(id)
- alert_blocked_site(alert_id) → alert(id)
- alert_included_keyword(alert_id) → alert(id)
- alert_required_keyword(alert_id) → alert(id)
- alert_excluded_keyword(alert_id) → alert(id)
- alert_monitored_facebook_page(alert_id) → alert(id)
- alert_monitored_twitter_account(alert_id) → alert(id)
- alert(account_id) → account(id)
- share(account_id) → account(id)
- share(alert_id) → alert(id)
- account_group(account_id) → account(id)
- children_offset_title(children_id) → children(id)
- children_offset_description(children_id) → children(id)
- children_offset_description_medium(children_id) → children(id)
- children_offset_description_short(children_id) → children(id)
- children(alert_id) → alert(id)
- children(account_id) → account(id)
- children(mention_id) → mention(id)
- mention_offset_title(mention_id) → mention(id)
- mention_offset_description(mention_id) → mention(id)
- mention_offset_description_medium(mention_id) → mention(id)
- mention_offset_description_short(mention_id) → mention(id)
- mention(alert_id) → alert(id)
- mention(account_id) → account(id)