Description of each data table under _directory database
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.