List of personal data and sensitive content in the DB
This info is for all standard UNA modules, if you have custom modules or modules from 3rd-party providers then such info can be in other tables as well.
Personal data
sys_accountstable,name,email,phone,passwordfieldsbx_persons_datatable,fullname,last_name,birthdayfields and maybe some other custom fields which was addedbx_inv_invitestable,emailfieldbx_inv_requeststable,emailfieldbx_massmailer_campaigns,reply_toandemail_listfieldsbx_massmailer_letters,emailfieldbx_massmailer_segments,email_listfieldbx_xero_contacts,emailfieldsys_queue_email,email` field
Locations for users and other content
bx_ads_meta_locationsbx_ads_entries,locationfieldbx_albums_meta_locationsbx_albums_albums,locationfieldbx_classes_meta_locationsbx_classes_classes,locationfieldbx_courses_meta_locationsbx_courses_data,locationfieldbx_directory_meta_locationsbx_events_meta_locationsbx_events_data,locationfieldbx_groups_meta_locationsbx_groups_data,locationfieldbx_market_meta_locationsbx_market_products,locationfieldbx_organizations_meta_locationsbx_organizations_data,locationfieldbx_persons_meta_locationsbx_persons_data,locationfieldbx_photos_meta_locationsbx_photos_entries,locationfieldbx_polls_meta_locationsbx_polls_entries,locationfieldbx_posts_meta_locationsbx_posts_posts,locationfieldbx_reviews_meta_locationsbx_reviews_reviews,locationfieldbx_shopify_meta_locationsbx_shopify_entries,locationfieldbx_snipcart_meta_locationsbx_snipcart_entries,locationfieldbx_spaces_meta_locationsbx_spaces_data,locationfieldbx_stream_meta_locationsbx_stream_streams,locationfieldbx_timeline_meta_locationsbx_timeline_events,locationfieldbx_videos_meta_locationsbx_videos_entries,locationfieldbx_mapshow_accounts
Users IPs
sys_accountstable,ipfieldbx_antispam_block_logtable,ipfieldbx_ads_polls_answers_votes_tracktable,author_nipfieldbx_ads_reactions_tracktable,author_nipfieldbx_ads_reports_tracktable,author_nipfieldbx_ads_views_tracktable,viewer_nipfieldbx_ads_votes_tracktable,author_nipfieldbx_albums_reactions_tracktable,author_nipfieldbx_albums_reports_media_tracktable,author_nipfieldbx_albums_reports_tracktable,author_nipfieldbx_albums_scores_media_tracktable,author_nipfieldbx_albums_scores_tracktable,author_nipfieldbx_albums_views_media_tracktable,viewer_nipfieldbx_albums_views_tracktable,viewer_nipfieldbx_albums_votes_media_tracktable,author_nipfieldbx_albums_votes_tracktable,author_nipfieldbx_classes_polls_answers_votes_tracktable,author_nipfieldbx_classes_reactions_tracktable,author_nipfieldbx_classes_reports_tracktable,author_nipfieldbx_classes_scores_tracktable,author_nipfieldbx_classes_views_tracktable,viewer_nipfieldbx_classes_votes_tracktable,author_nipfieldbx_cnl_reports_tracktable,author_nipfieldbx_cnl_scores_tracktable,author_nipfieldbx_cnl_views_tracktable,viewer_nipfieldbx_cnl_votes_tracktable,author_nipfieldbx_convos_views_tracktable,author_nipfieldbx_courses_reports_tracktable,author_nipfieldbx_courses_scores_tracktable,author_nipfieldbx_courses_views_tracktable,viewer_nipfieldbx_courses_votes_tracktable,author_nipfieldbx_directory_polls_answers_votes_tracktable,author_nipfieldbx_directory_reactions_tracktable,author_nipfieldbx_directory_reports_tracktable,author_nipfieldbx_directory_scores_tracktable,author_nipfieldbx_directory_views_tracktable,viewer_nipfieldbx_directory_votes_tracktable,author_nipfieldbx_events_reports_tracktable,author_nipfieldbx_events_scores_tracktable,author_nipfieldbx_events_views_tracktable,viewer_nipfieldbx_events_votes_tracktable,author_nipfieldbx_files_reactions_tracktable,author_nipfieldbx_files_reports_tracktable,author_nipfieldbx_files_scores_tracktable,author_nipfieldbx_files_views_tracktable,viewer_nipfieldbx_files_votes_tracktable,author_nipfieldbx_forum_polls_answers_votes_tracktable,author_nipfieldbx_forum_reactions_tracktable,author_nipfieldbx_forum_reports_tracktable,author_nipfieldbx_forum_scores_tracktable,author_nipfieldbx_forum_views_tracktable,viewer_nipfieldbx_forum_votes_tracktable,author_nipfieldbx_glossary_reactions_tracktable,author_nipfieldbx_glossary_reports_tracktable,author_nipfieldbx_glossary_scores_tracktable,author_nipfieldbx_glossary_views_tracktable,viewer_nipfieldbx_glossary_votes_tracktable,author_nipfieldbx_groups_reports_tracktable,author_nipfieldbx_groups_scores_tracktable,author_nipfieldbx_groups_views_tracktable,author_nipfieldbx_groups_votes_tracktable,author_nipfieldbx_market_downloads_tracktable,profile_nipfieldbx_market_reactions_tracktable,author_nipfieldbx_market_reports_tracktable,author_nipfieldbx_market_scores_tracktable,author_nipfieldbx_market_views_tracktable,viewer_nipfieldbx_market_votes_tracktable,author_nipfieldbx_organizations_reports_tracktable,author_nipfieldbx_organizations_scores_tracktable,author_nipfieldbx_organizations_views_tracktable,viewer_nipfieldbx_organizations_votes_tracktable,author_nipfieldbx_persons_reports_tracktable,author_nipfieldbx_persons_scores_tracktable,author_nipfieldbx_persons_views_tracktable,viewer_nipfieldbx_persons_votes_tracktable,author_nipfieldbx_photos_reactions_tracktable,author_nipfieldbx_photos_reports_tracktable,author_nipfieldbx_photos_scores_tracktable,author_nipfieldbx_photos_svotes_tracktable,author_nipfieldbx_photos_views_tracktable,viewer_nipfieldbx_photos_votes_tracktable,author_nipfieldbx_polls_reactions_tracktable,author_nipfieldbx_polls_reports_tracktable,author_nipfieldbx_polls_scores_tracktable,author_nipfieldbx_polls_views_tracktable,viewer_nipfieldbx_polls_votes_subentries_tracktable,author_nipfieldbx_polls_votes_tracktable,author_nipfieldbx_posts_polls_answers_votes_tracktable,author_nipfieldbx_posts_reactions_tracktable,author_nipfieldbx_posts_reports_tracktable,author_nipfieldbx_posts_scores_tracktable,author_nipfieldbx_posts_views_tracktable,viewer_nipfieldbx_posts_votes_tracktable,author_nipfieldbx_reviews_polls_answers_votes_tracktable,author_nipfieldbx_reviews_reactions_tracktable,author_nipfieldbx_reviews_reports_tracktable,author_nipfieldbx_reviews_scores_tracktable,author_nipfieldbx_reviews_svotes_tracktable,author_nipfieldbx_reviews_votes_tracktable,author_nipfieldbx_reviews_views_tracktable,viewer_nipfieldbx_shopify_reactions_tracktable,author_nipfieldbx_shopify_reports_tracktable,author_nipfieldbx_shopify_scores_tracktable,author_nipfieldbx_shopify_views_tracktable,viewer_nipfieldbx_shopify_votes_tracktable,author_nipfieldbx_snipcart_reactions_tracktable,author_nipfieldbx_snipcart_reports_tracktable,author_nipfieldbx_snipcart_scores_tracktable,author_nipfieldbx_snipcart_views_tracktable,viewer_nipfieldbx_snipcart_votes_tracktable,author_nipfieldbx_spaces_reports_tracktable,author_nipfieldbx_spaces_scores_tracktable,author_nipfieldbx_spaces_views_tracktable,viewer_nipfieldbx_spaces_votes_tracktable,author_nipfieldbx_stream_reactions_tracktable,author_nipfieldbx_stream_reports_tracktable,author_nipfieldbx_stream_scores_tracktable,author_nipfieldbx_stream_views_tracktable,viewer_nipfieldbx_stream_votes_tracktable,author_nipfieldbx_tasks_reactions_tracktable,author_nipfieldbx_tasks_reports_tracktable,author_nipfieldbx_tasks_scores_tracktable,author_nipfieldbx_tasks_views_tracktable,viewer_nipfieldbx_tasks_votes_tracktable,author_nipfieldbx_timeline_reactions_tracktable,author_nipfieldbx_timeline_reports_tracktable,author_nipfieldbx_timeline_reposts_tracktable,author_nipfieldbx_timeline_scores_tracktable,author_nipfieldbx_timeline_views_tracktable,viewer_nipfieldbx_timeline_votes_tracktable,author_nipfieldbx_videos_reactions_tracktable,author_nipfieldbx_videos_reports_tracktable,author_nipfieldbx_videos_scores_tracktable,author_nipfieldbx_videos_svotes_tracktable,author_nipfieldbx_videos_views_tracktable,viewer_nipfieldbx_videos_votes_tracktable,author_nipfieldsys_cmts_reactions_tracktable,author_nipfieldsys_cmts_reports_tracktable,author_nipfieldsys_cmts_scores_tracktable,author_nipfieldsys_cmts_votes_tracktable,author_nipfield
Images EXIF info
bx_albums_files2albumstable,exiftablebx_photos_entriestable,exiftable
Profiles IDs from other sites
bx_dolcon_accountstable,remote_profilefield, Dolphin based sites, Dolphin site URL is stored insys_optionstable, record wherename= 'bx_dolcon_url'bx_facebook_accountstable,fb_profilefield, Facebook profile IDbx_googlecon_accountstable,remote_profilefield, Google profile ID -bx_linkedin_accountstable,remote_profilefield, LinkedIn profile IDbx_twitter_accountstable,remote_profilefield, Twitter profile IDbx_unacon_accountstable,remote_profilefield, other UNA based sites, UNA site URL is stored insys_optionstable, record wherename= 'bx_unacon_url'
Sensitive data
sys_optionstable,valuefield for record wherename= 'bx_dolcon_secret'sys_optionstable,valuefield for record wherename= 'bx_unacon_secret'sys_optionstable,valuefield for record wherename= 'bx_stripe_connect_api_secret_test'sys_optionstable,valuefield for record wherename= 'bx_stripe_connect_api_secret_live'sys_optionstable,valuefield for record wherename= 'bx_smtp_password'sys_optionstable,valuefield for record wherename= 'bx_mailchimp_option_api_key'sys_optionstable,valuefield for record wherename= 'bx_twitter_secret'sys_optionstable,valuefield for record wherename= 'bx_linkedin_secret'sys_optionstable,valuefield for record wherename= 'bx_googlecon_secret'sys_optionstable,valuefield for record wherename= 'bx_intercom_option_api_key'sys_optionstable,valuefield for record wherename= 'bx_datafox_secret'sys_optionstable,valuefield for record wherename= 'bx_facebook_connect_secret'sys_optionstable,valuefield for record wherename= 'bx_antispam_toxicity_filter_api_key'sys_optionstable,valuefield for record wherename= 'bx_antispam_stopforumspam_api_key'sys_optionstable,valuefield for record wherename= 'bx_antispam_akismet_api_key'sys_optionstable,valuefield for record wherename= 'sys_maps_api_key'sys_optionstable,valuefield for record wherename= 'sys_twilio_gate_token'sys_optionstable,valuefield for record wherename= 'sys_push_rest_api'sys_optionstable,valuefield for record wherename= 'sys_push_app_id'sys_optionstable,valuefield for record wherename= 'sys_storage_s3_secret_key'sys_optionstable,valuefield for record wherename= 'sys_recaptcha_key_private'sys_optionstable,valuefield for record wherename= 'sys_iframely_api_key'sys_optionstable,valuefield for record wherename= 'sys_embedly_api_key'sys_optionstable,valuefield for record wherename= 'sys_oauth_secret'sys_optionstable,valuefield for record wherename= 'sys_ftp_password'bx_oauth_access_tokenstable,access_tokenfieldbx_oauth_authorization_codestable,authorization_codefieldbx_oauth_clientstable,client_secretfieldbx_oauth_refresh_tokenstable,refresh_tokenfieldbx_payment_user_valuestable,valuefieldbx_shopify_settingstable,access_tokenfieldbx_stripe_connect_accounts,access_tokenandrefresh_tokenfieldssys_keys,keyfieldsys_sessions,idfield
Caches and queues
sys_sessionsbx_notifications_queuebx_timeline_cachesys_queue_emailsys_queue_pushsys_storage_deletionssys_storage_tokenssys_transcoder_queue