In this article, we will be sharing a short description of each of the data tables under _directory database.


301_redirects


All the 301 Redirects added under Developer Hub >> 301 Redirects can be found in this table.


admin_roles


All the custom admin roles added under Admin Role Permissions can be found in this table.


admin_role_permissions


Custom Relation


admin_role_plugins_permissions


?


bd_webhooks


All the webhooks added under Developer Hub >> Webhooks can be found in this table.


category


-- Not used, we candelete


category_bridge


?


category_group

?


chat_message_items


?


chat_message_threads

All the chat message threads created by members can be found in this table.


comments


All the comments added by members can be found in this table.


contacts


All the contacts created under Emails >> View Contacts can be found in this table.


contacts_bridge


?


data_categories


Any settings saved under My Content >> Edit Post Settings for any post type can be found in this table.


data_flows


?


data_flow_actions


?


data_posts


Any single image post (like Articles, Job Listings, etc.) posted on the website can be found in this table.


data_types


All the available data types can be found in this table.


data_widgets


All the custom and newly created widgets under Widget Manager can be found in this table.


data_widgets_rel


Relation of widgets to sidebars. This database stores which widgets are in a sidebar and in what order


email_accounts


-- Not used


email_automation_settings


Settings related to the Billing Reminders can be found in this table.


email_auto_log


-- Tracks all the activity returned from SendGrid regarding opens, delivers and bounces regarding an email sent through an email campaign.


email_auto_sent


Tracks the sending activity from newsletter campaigns sent to individual members


email_list


?


email_log


?


email_templates


All the custom or newly created Email Templates can be found in this table.


forms


All the custom or newly created forms under Form Manager can be found in this table.


form_fields


All the available form fields can be found in this table.


form_field_types


All the available form field types can be found in this table.


form_inquiries


Any form submission that can be found under Emails >> Forms Inbox can be found in this table.


image_settings


All the Image Settings will be stored in this table.


installer_groups


?


installer_steps


?


leads


All the leads that can be found under Interactions >> Member Leads will be stored in this table.


lead_matches


All the leads that are matched to a member can be found in this table.


lead_services


?


list_countries


A list of all countries and their country codes can be found in this table.


list_professions


All the Top-Level Categories of the website can be found in this table.


list_seo


All the web pages under My Content >> Web Page Builder can be found in this table.


list_seo_template


All the custom SEO Templates can be found in this table.


list_services


All the Sub and Sub-Sub Categories of the website can be found in this table.


Important Note: The sub-categories will have master_id=0 and the sub-sub-categories will have master_id>0.



list_states


The list of custom state / provinces that can be utilized on a website. Enabling the custom_list_states  advanced setting will enable this database.


list_tags


?


location_cities


List of cities that are returned from the Google Maps geocoder.


location_states


List of states  that are returned from the Google Maps geocoder.


menus


All the custom or newly created menus under Menu Manager can be found in this table.


menu_items


All the individual menu items added to a custom menu can be found in this table.


messages


--- Not Used


orders


-- Not used


password_retrieval_sessions


?


payment_gateway


-- Not used


payment_log


-- Not used


payout_accounts


-- Not used


picture_settings


?


plugin_records


All third-party plugins can be found in this table.


post_transactions


?


rel_categories


?


rel_services


All the sub and sub-sub level categories selected by the members can be found in this table.


rel_users


?


reminders


?


service_areas


All the Service Areas added by the members can be found in this table.


sidebars


All the custom sidebars under Sidebar Manager can be found in this table.


smart_lists


All the Smart Lists created can be found in this table.


subscription_types


All the Membership Plans of the site and their settings can be found in this table.


unsubcribe_list


All the email unsubscribers can be found in this table.


users_activity


?


users_billing


?


users_clicks


All the user clicks that are used in the calculation of Member Profile Analytics can be found in this table.


users_contacts


?


users_data


All the members of the site and their unique information can be found in this table. If a new member is added to the site, it will create a new row in this table.


users_emails


?


users_favorite


All the Bookmarks saved by a member can be found in this table.


users_geolocation


?


users_location


?


users_log


All user logins and logouts can be found in this table.


users_meta


This table stores any extra data that needs to be saved on one of the other available tables but there is no column for it in that table.


users_photo


???? All the profile photos, logos, or cover images added by members can be found in this table. ????


users_portfolio


All the images added by a member to the multi-photo post types can be found in this table.


users_portfolio_groups


Any multi-image posts (like Products, Properties, etc.) posted on the website can be found in this table.


users_portfolio_tags


?


users_reviews


All the Reviews submitted to members can be found in this table.


users_setting


?


user_invite_log


?


user_types


?


visitors_searches


?


website_contacts


-- Deprecated


website_design_settings


All the Design Settings saved on the website can be found in this table.


website_labels


All the Text Labels of the website can be found in this table.


website_layouts


-- Deprecated


website_notifications


List of website activity that is tracked and is viewable in the Activity Tracker


website_settings


All the General Settings saved on the website can be found in this table.