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
301 Redirects found on the Developer Hub >> 301 Redirects page in the Admin area.
admin_roles
Custom Admin Roles added through the Admin Role Permissions page in the Admin area.
admin_role_permissions
Individual permissions for each custom Admin Role added through the Admin Role Permissions page in the Admin area.
admin_role_plugins_permissions
Admin Role Permissions for plugins added by 3rd party developers.
bd_webhooks
Webhooks added through the Developer Hub >> Webhooks page in the Admin area.
category
Deprecated
category_bridge
Deprecated
category_group
Deprecated
chat_message_items
Individual chat messages created through the Private Member Chat Add-On.
chat_message_threads
Chat message threads created through the Private Member Chat Add-On.
comments
Comments added to posts using the Community Comments Add-On.
contacts
Deprecated - used to store contacts seen on the deprecated Emails >> View Contacts page.
contacts_bridge
Deprecated - previously used to store relations between "contacts" and "contact lists".
data_categories
Settings for the Post Types found on the My Content >> Edit Post Settings page in the Admin area.
data_flows
High level settings for lead matching workflows when the Automatic Lead Matching Add-On is active on a website.
data_flow_actions
Settings for specific groups of Membership Plans used for the Automatic Lead Matching Add-On.
data_posts
Individual posts for single-image Post Types (EG: Articles, Job Listings, etc). Individual posts can be seen on the Content » Manage Posts page in the Admin area.
data_types
General categories of Post Types used on the website. It is not recommended to edit the contents of this table.
data_widgets
Custom Widgets found on the Toolbox » Widget Manager page in the Admin area.
data_widgets_rel
Relationship between Widgets and Sidebars and the order in which widgets appear in sidebars. Sidebars can be edited on the Toolbox » Sidebar Manager page in the Admin area.
email_accounts
Deprecated
email_automation_settings
Settings related to the Billing Reminders Add-On.
email_auto_log
Log of individual email activity related to the Emails » Send Newsletter functionality in the Admin area.
email_auto_sent
Log of campaigns sent using the Emails » Send Newsletter functionality in the Admin area.
email_list
Deprecated
email_log
Deprecated
email_templates
Custom Email Templates created through the Emails >> Email Templates page in the Admin area.
forms
Custom forms created through the Toolbox » Form Manager page in the Admin area.
form_fields
Individual form fields for forms created through the Toolbox » Form Manager page in the Admin area.
form_field_types
The form field types used for form fields. It is not recommended to edit the contents of this table.
form_inquiries
Data submitted through public contact forms on the site. These submissions can be found on the Emails >> Forms Inbox page in the Admin area.
image_settings
The settings for images uploaded to the site. These settings can be found on the Developer Hub » Image Settings page in the Admin area.
installer_groups
Deprecated
installer_steps
Deprecated
leads
Leads submitted to members on the site. These can be found on the Interactions >> Member Leads page in the Admin area.
lead_matches
The relationship between individual leads and the members they are matched to.
lead_services
Deprecated
list_countries
List of all countries and their country codes used on the site.
list_professions
The Top-Level Categories available for members to choose from. These can be found on the My Members » Member Categories page in the Admin area.
list_seo
The individual Web Pages created on the My Content >> Web Page Builder page in the Admin area.
list_seo_template
The custom SEO Templates found on the Content » SEO Templates page in the Admin area.
list_services
The Sub Categories and Sub-Sub Categories available for members to choose from. These can be found on the My Members » Member Categories page in the Admin area.
Important Note: The Sub Categories will have a master_id value of 0 and the Sub-Sub Categories will have master_id > 0.
list_states
Deprecated
list_tags
Deprecated
location_cities
Cities that have been added to the database by members being geocoded to these locations through the Google Maps API.
location_states
States / provinces that have been added to the database by members being geocoded to these locations through the Google Maps API.
menus
Custom menus created through the Toolbox » Menu Manager page in the Admin area.
menu_items
Individual menu items added to a custom menu through the Toolbox » Menu Manager page in the Admin area.
messages
Deprecated
orders
Deprecated
password_retrieval_sessions
Session information stored by the system related to the workflow when members use the "Forgot Password" link on a member login page.
payment_gateway
Deprecated
payment_log
Deprecated
payout_accounts
Deprecated
picture_settings
Deprecated
plugin_records
Data related to third-party plugins installed on the site.
post_transactions
Log of transactions made related to the Pay Per Post Add-On.
rel_categories
Deprecated
rel_services
Relationship between members and the Sub and Sub-Sub Categories they selected.
rel_users
Deprecated
reminders
Deprecated
service_areas
Service Areas selected by members through the Multi-Location Listing Add-On.
sidebars
Custom sidebars added to a site through the Toolbox » Sidebar Manager page in the Admin area.
smart_lists
The Smart Lists added to a site through the My Members » Smart Lists page in the Admin area.
subscription_types
Settings for the Membership Plans of the site. These can be found on the Finance » Membership Plans page in the Admin area.
unsubcribe_list
The email addresses that have requested to be unsubscribed from future newsletters sent through the Emails » Send Newsletter page in the Admin area.
users_activity
Deprecated
users_billing
Deprecated
users_clicks
Log of the clicks tracked through the Member Profile Analytics Add-On.
users_contacts
Deprecated
users_data
The default / primary data stored for website members. Members can be found on the My Members » Search Members page in the Admin area.
users_emails
Deprecated
users_favorite
The bookmarks / favorites saved by members through the Bookmark My Favorites Add-On.
users_geolocation
Deprecated
users_location
Deprecated
users_log
Log tracking members logging in and out of their account.
users_meta
Additional data related to the other tables on this list. When data would normally be saved to another table, but there is no column for that data in the table, it is stored here.
users_photo
Relationship between members and the profile photos, logos, and cover photos they uploaded.
users_portfolio
Relationship between multi-image posts and the images added for those posts.
users_portfolio_groups
Individual posts for multi-image Post Types (EG: Products, Properties, etc). Individual posts can be seen on the Content » Manage Posts page in the Admin area.
users_portfolio_tags
Deprecated
users_reviews
The Reviews submitted to members. These can be seen on the Interactions » Member Reviews page in the Admin area.
users_setting
Meta data about members saved by the system.
user_invite_log
Deprecated
user_types
Legacy internal categories of members on the site. It is not recommended to edit the contents of this table.
visitors_searches
Deprecated
website_contacts
Deprecated
website_design_settings
The Design Settings saved for the site. These can be edited on the Settings » Design Settings page in the Admin area.
website_labels
The Text Labels saved for the site. These can be edited on the Settings » Text Labels page in the Admin area.
website_layouts
Deprecated
website_notifications
Log of all website activity shown on the Dashboard >> Activity Tracker page in the Admin area.
website_settings
The General Settings saved for the site. These can be edited on the Settings » General Settings page in the Admin area.
