Mention
Explore the interactive ERD
Table & Field Reference
alert_preference
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
account_id | String | PKFK |
alert_id | Long | PKFK |
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 | PKFK |
alert_source
| Column | Type | Keys |
|---|---|---|
source | String | PK |
alert_id | Long | PKFK |
alert_country
| Column | Type | Keys |
|---|---|---|
country | String | PK |
alert_id | Long | PKFK |
alert_blocked_site
| Column | Type | Keys |
|---|---|---|
blocked_site | String | PK |
alert_id | Long | PKFK |
alert_included_keyword
| Column | Type | Keys |
|---|---|---|
included_keyword | String | PK |
alert_id | Long | PKFK |
alert_required_keyword
| Column | Type | Keys |
|---|---|---|
required_keyword | String | PK |
alert_id | Long | PKFK |
alert_excluded_keyword
| Column | Type | Keys |
|---|---|---|
excluded_keyword | String | PK |
alert_id | Long | PKFK |
alert_monitored_facebook_page
| Column | Type | Keys |
|---|---|---|
url | String | PK |
alert_id | Long | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
children_offset_description
| Column | Type | Keys |
|---|---|---|
description | Long | PK |
children_id | String | PKFK |
children_offset_description_medium
| Column | Type | Keys |
|---|---|---|
description_medium | Long | PK |
children_id | String | PKFK |
children_offset_description_short
| Column | Type | Keys |
|---|---|---|
description_short | Long | PK |
children_id | String | PKFK |
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 | PKFK |
mention_offset_description
| Column | Type | Keys |
|---|---|---|
description | Long | PK |
mention_id | String | PKFK |
mention_offset_description_medium
| Column | Type | Keys |
|---|---|---|
description_medium | Long | PK |
mention_id | String | PKFK |
mention_offset_description_short
| Column | Type | Keys |
|---|---|---|
description_short | Long | PK |
mention_id | String | PKFK |
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 |