Description of each data table under _directory database

 Link: https://support.brilliantdirectories.com/support/solutions/articles/12000085676

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.