Description of each data table under _directory database

Link: https://support.brilliantdirectories.com/support/solutions/articles/12000085676-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.