List of personal data and sensitive content in the DB
Alex Trofimov edited this page Mar 24, 2022
·
5 revisions
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.
-
sys_accounts
table,name
,email
,phone
,password
fields -
bx_persons_data
table,fullname
,last_name
,birthday
fields and maybe some other custom fields which was added -
bx_inv_invites
table,email
field -
bx_inv_requests
table,email
field -
bx_massmailer_campaigns
,reply_to
andemail_list
fields -
bx_massmailer_letters
,email
field -
bx_massmailer_segments
,email_list
field -
bx_xero_contacts
,email
field -
sys_queue_email,
email` field
bx_ads_meta_locations
-
bx_ads_entries
,location
field bx_albums_meta_locations
-
bx_albums_albums
,location
field bx_classes_meta_locations
-
bx_classes_classes
,location
field bx_courses_meta_locations
-
bx_courses_data
,location
field bx_directory_meta_locations
bx_events_meta_locations
-
bx_events_data
,location
field bx_groups_meta_locations
-
bx_groups_data
,location
field bx_market_meta_locations
-
bx_market_products
,location
field bx_organizations_meta_locations
-
bx_organizations_data
,location
field bx_persons_meta_locations
-
bx_persons_data
,location
field bx_photos_meta_locations
-
bx_photos_entries
,location
field bx_polls_meta_locations
-
bx_polls_entries
,location
field bx_posts_meta_locations
-
bx_posts_posts
,location
field bx_reviews_meta_locations
-
bx_reviews_reviews
,location
field bx_shopify_meta_locations
-
bx_shopify_entries
,location
field bx_snipcart_meta_locations
-
bx_snipcart_entries
,location
field bx_spaces_meta_locations
-
bx_spaces_data
,location
field bx_stream_meta_locations
-
bx_stream_streams
,location
field bx_timeline_meta_locations
-
bx_timeline_events
,location
field bx_videos_meta_locations
-
bx_videos_entries
,location
field bx_mapshow_accounts
-
sys_accounts
table,ip
field -
bx_antispam_block_log
table,ip
field -
bx_ads_polls_answers_votes_track
table,author_nip
field -
bx_ads_reactions_track
table,author_nip
field -
bx_ads_reports_track
table,author_nip
field -
bx_ads_views_track
table,viewer_nip
field -
bx_ads_votes_track
table,author_nip
field -
bx_albums_reactions_track
table,author_nip
field -
bx_albums_reports_media_track
table,author_nip
field -
bx_albums_reports_track
table,author_nip
field -
bx_albums_scores_media_track
table,author_nip
field -
bx_albums_scores_track
table,author_nip
field -
bx_albums_views_media_track
table,viewer_nip
field -
bx_albums_views_track
table,viewer_nip
field -
bx_albums_votes_media_track
table,author_nip
field -
bx_albums_votes_track
table,author_nip
field -
bx_classes_polls_answers_votes_track
table,author_nip
field -
bx_classes_reactions_track
table,author_nip
field -
bx_classes_reports_track
table,author_nip
field -
bx_classes_scores_track
table,author_nip
field -
bx_classes_views_track
table,viewer_nip
field -
bx_classes_votes_track
table,author_nip
field -
bx_cnl_reports_track
table,author_nip
field -
bx_cnl_scores_track
table,author_nip
field -
bx_cnl_views_track
table,viewer_nip
field -
bx_cnl_votes_track
table,author_nip
field -
bx_convos_views_track
table,author_nip
field -
bx_courses_reports_track
table,author_nip
field -
bx_courses_scores_track
table,author_nip
field -
bx_courses_views_track
table,viewer_nip
field -
bx_courses_votes_track
table,author_nip
field -
bx_directory_polls_answers_votes_track
table,author_nip
field -
bx_directory_reactions_track
table,author_nip
field -
bx_directory_reports_track
table,author_nip
field -
bx_directory_scores_track
table,author_nip
field -
bx_directory_views_track
table,viewer_nip
field -
bx_directory_votes_track
table,author_nip
field -
bx_events_reports_track
table,author_nip
field -
bx_events_scores_track
table,author_nip
field -
bx_events_views_track
table,viewer_nip
field -
bx_events_votes_track
table,author_nip
field -
bx_files_reactions_track
table,author_nip
field -
bx_files_reports_track
table,author_nip
field -
bx_files_scores_track
table,author_nip
field -
bx_files_views_track
table,viewer_nip
field -
bx_files_votes_track
table,author_nip
field -
bx_forum_polls_answers_votes_track
table,author_nip
field -
bx_forum_reactions_track
table,author_nip
field -
bx_forum_reports_track
table,author_nip
field -
bx_forum_scores_track
table,author_nip
field -
bx_forum_views_track
table,viewer_nip
field -
bx_forum_votes_track
table,author_nip
field -
bx_glossary_reactions_track
table,author_nip
field -
bx_glossary_reports_track
table,author_nip
field -
bx_glossary_scores_track
table,author_nip
field -
bx_glossary_views_track
table,viewer_nip
field -
bx_glossary_votes_track
table,author_nip
field -
bx_groups_reports_track
table,author_nip
field -
bx_groups_scores_track
table,author_nip
field -
bx_groups_views_track
table,author_nip
field -
bx_groups_votes_track
table,author_nip
field -
bx_market_downloads_track
table,profile_nip
field -
bx_market_reactions_track
table,author_nip
field -
bx_market_reports_track
table,author_nip
field -
bx_market_scores_track
table,author_nip
field -
bx_market_views_track
table,viewer_nip
field -
bx_market_votes_track
table,author_nip
field -
bx_organizations_reports_track
table,author_nip
field -
bx_organizations_scores_track
table,author_nip
field -
bx_organizations_views_track
table,viewer_nip
field -
bx_organizations_votes_track
table,author_nip
field -
bx_persons_reports_track
table,author_nip
field -
bx_persons_scores_track
table,author_nip
field -
bx_persons_views_track
table,viewer_nip
field -
bx_persons_votes_track
table,author_nip
field -
bx_photos_reactions_track
table,author_nip
field -
bx_photos_reports_track
table,author_nip
field -
bx_photos_scores_track
table,author_nip
field -
bx_photos_svotes_track
table,author_nip
field -
bx_photos_views_track
table,viewer_nip
field -
bx_photos_votes_track
table,author_nip
field -
bx_polls_reactions_track
table,author_nip
field -
bx_polls_reports_track
table,author_nip
field -
bx_polls_scores_track
table,author_nip
field -
bx_polls_views_track
table,viewer_nip
field -
bx_polls_votes_subentries_track
table,author_nip
field -
bx_polls_votes_track
table,author_nip
field -
bx_posts_polls_answers_votes_track
table,author_nip
field -
bx_posts_reactions_track
table,author_nip
field -
bx_posts_reports_track
table,author_nip
field -
bx_posts_scores_track
table,author_nip
field -
bx_posts_views_track
table,viewer_nip
field -
bx_posts_votes_track
table,author_nip
field -
bx_reviews_polls_answers_votes_track
table,author_nip
field -
bx_reviews_reactions_track
table,author_nip
field -
bx_reviews_reports_track
table,author_nip
field -
bx_reviews_scores_track
table,author_nip
field -
bx_reviews_svotes_track
table,author_nip
field -
bx_reviews_votes_track
table,author_nip
field -
bx_reviews_views_track
table,viewer_nip
field -
bx_shopify_reactions_track
table,author_nip
field -
bx_shopify_reports_track
table,author_nip
field -
bx_shopify_scores_track
table,author_nip
field -
bx_shopify_views_track
table,viewer_nip
field -
bx_shopify_votes_track
table,author_nip
field -
bx_snipcart_reactions_track
table,author_nip
field -
bx_snipcart_reports_track
table,author_nip
field -
bx_snipcart_scores_track
table,author_nip
field -
bx_snipcart_views_track
table,viewer_nip
field -
bx_snipcart_votes_track
table,author_nip
field -
bx_spaces_reports_track
table,author_nip
field -
bx_spaces_scores_track
table,author_nip
field -
bx_spaces_views_track
table,viewer_nip
field -
bx_spaces_votes_track
table,author_nip
field -
bx_stream_reactions_track
table,author_nip
field -
bx_stream_reports_track
table,author_nip
field -
bx_stream_scores_track
table,author_nip
field -
bx_stream_views_track
table,viewer_nip
field -
bx_stream_votes_track
table,author_nip
field -
bx_tasks_reactions_track
table,author_nip
field -
bx_tasks_reports_track
table,author_nip
field -
bx_tasks_scores_track
table,author_nip
field -
bx_tasks_views_track
table,viewer_nip
field -
bx_tasks_votes_track
table,author_nip
field -
bx_timeline_reactions_track
table,author_nip
field -
bx_timeline_reports_track
table,author_nip
field -
bx_timeline_reposts_track
table,author_nip
field -
bx_timeline_scores_track
table,author_nip
field -
bx_timeline_views_track
table,viewer_nip
field -
bx_timeline_votes_track
table,author_nip
field -
bx_videos_reactions_track
table,author_nip
field -
bx_videos_reports_track
table,author_nip
field -
bx_videos_scores_track
table,author_nip
field -
bx_videos_svotes_track
table,author_nip
field -
bx_videos_views_track
table,viewer_nip
field -
bx_videos_votes_track
table,author_nip
field -
sys_cmts_reactions_track
table,author_nip
field -
sys_cmts_reports_track
table,author_nip
field -
sys_cmts_scores_track
table,author_nip
field -
sys_cmts_votes_track
table,author_nip
field
-
bx_albums_files2albums
table,exif
table -
bx_photos_entries
table,exif
table
-
bx_dolcon_accounts
table,remote_profile
field, Dolphin based sites, Dolphin site URL is stored insys_options
table, record wherename
= 'bx_dolcon_url' -
bx_facebook_accounts
table,fb_profile
field, Facebook profile ID -
bx_googlecon_accounts
table,remote_profile
field, Google profile ID -bx_linkedin_accounts
table,remote_profile
field, LinkedIn profile ID -
bx_twitter_accounts
table,remote_profile
field, Twitter profile ID -
bx_unacon_accounts
table,remote_profile
field, other UNA based sites, UNA site URL is stored insys_options
table, record wherename
= 'bx_unacon_url'
-
sys_options
table,value
field for record wherename
= 'bx_dolcon_secret' -
sys_options
table,value
field for record wherename
= 'bx_unacon_secret' -
sys_options
table,value
field for record wherename
= 'bx_stripe_connect_api_secret_test' -
sys_options
table,value
field for record wherename
= 'bx_stripe_connect_api_secret_live' -
sys_options
table,value
field for record wherename
= 'bx_smtp_password' -
sys_options
table,value
field for record wherename
= 'bx_mailchimp_option_api_key' -
sys_options
table,value
field for record wherename
= 'bx_twitter_secret' -
sys_options
table,value
field for record wherename
= 'bx_linkedin_secret' -
sys_options
table,value
field for record wherename
= 'bx_googlecon_secret' -
sys_options
table,value
field for record wherename
= 'bx_intercom_option_api_key' -
sys_options
table,value
field for record wherename
= 'bx_datafox_secret' -
sys_options
table,value
field for record wherename
= 'bx_facebook_connect_secret' -
sys_options
table,value
field for record wherename
= 'bx_antispam_toxicity_filter_api_key' -
sys_options
table,value
field for record wherename
= 'bx_antispam_stopforumspam_api_key' -
sys_options
table,value
field for record wherename
= 'bx_antispam_akismet_api_key' -
sys_options
table,value
field for record wherename
= 'sys_maps_api_key' -
sys_options
table,value
field for record wherename
= 'sys_twilio_gate_token' -
sys_options
table,value
field for record wherename
= 'sys_push_rest_api' -
sys_options
table,value
field for record wherename
= 'sys_push_app_id' -
sys_options
table,value
field for record wherename
= 'sys_storage_s3_secret_key' -
sys_options
table,value
field for record wherename
= 'sys_recaptcha_key_private' -
sys_options
table,value
field for record wherename
= 'sys_iframely_api_key' -
sys_options
table,value
field for record wherename
= 'sys_embedly_api_key' -
sys_options
table,value
field for record wherename
= 'sys_oauth_secret' -
sys_options
table,value
field for record wherename
= 'sys_ftp_password' -
bx_oauth_access_tokens
table,access_token
field -
bx_oauth_authorization_codes
table,authorization_code
field -
bx_oauth_clients
table,client_secret
field -
bx_oauth_refresh_tokens
table,refresh_token
field -
bx_payment_user_values
table,value
field -
bx_shopify_settings
table,access_token
field -
bx_stripe_connect_accounts
,access_token
andrefresh_token
fields -
sys_keys
,key
field -
sys_sessions
,id
field
sys_sessions
bx_notifications_queue
bx_timeline_cache
sys_queue_email
sys_queue_push
sys_storage_deletions
sys_storage_tokens
sys_transcoder_queue
IMPORTANT NOTE: documentation was moved here - https://una.io/wiki/Introduction