Magento 2.x Database Tables Briefly Explanation

core_config_data
Customer Registration is EAV Entity, There are following below 6 Customer Entity Tables, where customer's Registration details are stored.
  1. customer_entity
  2. customer_entity_int
  3. customer_entity_varchar
  4. customer_entity_text
  5. customer_entity_decimal
  6. customer_entity_datetime
Customer Address is EAV Entity, There are following below 6 Customer Address Entity Tables, where customer's shipping & billing address details are stored.
  1. customer_address_entity
  2. customer_address_entity_int
  3. customer_address_entity_varchar
  4. customer_address_entity_text
  5. customer_address_entity_decimal
  6. customer_address_entity_datetime
customer_eav_attribute
customer_eav_attribute_website

Customer Form is set of Customer's Registration Form, Customer's Login Form, Customer's Checkout Form, Customer's Billing & Shipping Address Form These Customer Form attribute details are stored in below Table.

customer_form_attribute
customer_grid_flat
There is following below table stored Magento 2.x Customer's Group
customer_group
By default, Magento 2 provides following below customer group
  1. --NOT LOGGED IN
  2. --General
  3. --Wholesale
  4. --Retailer

As per below customer_group table, where column customer_group_code stored all four customer's group
customer_log
customer_visitor
adminnotification_inbox
It is used to store all admin Notifications as
  1. Latest Catalog Information
  2. Latest Magento Version Update Information
  3. Latest Module Version Update Information
  4. Latest Security Patch Information
  5. Export Product File Information
etc.
Magento 2 Admin Notifications
Magento 2 Admin Notifications Stores Database Table
admin_user
admin_user_expiration
admin_system_messages
admin_user_session
cms_page
There are following below 2.x Tables, where CMS pagess & Stores establish connection with each other.
  1. cms_page
  2. cms_page_store
cms_block
There are following below 2.x Tables, where CMS Blocks & Stores establish connection with each other.
  1. cms_block
  2. cms_block_store
authorization_role
authorization_rule
directory_country
directory_country_format
directory_country_region_name
directory_country_region
tfa_country_codes
tfa_country_codes
theme
store_website

this table column code having unique website code, if Multisite setting, need to put below in MAGE_RUN_CODE, to distinct website

For website abc.com where abc_code unique website code
SetEnvIf Host .*dev.abc.com.* MAGE_RUN_CODE=abc_code
SetEnvIf Host .*dev.abc.com.* MAGE_RUN_TYPE=website

For website xyz.com where xyz_code unique website code

SetEnvIf Host .*dev.xyz.com.* MAGE_RUN_CODE=xyz_code
SetEnvIf Host .*dev.xyz.com.* MAGE_RUN_TYPE=website
store_group
store
Catalog Products are EAV Entity, There are following below 6 Catalog Products Entity Tables, where product details are stored.

  1. catalog_product_entity
  2. catalog_product_entity_datetime
  3. catalog_product_entity_decimal
  4. catalog_product_entity_int
  5. catalog_product_entity_text
  6. catalog_product_entity_varchar
Catalog Categories are EAV Entity, There are following below 6 Catalog Categories Entity Tables, where Category details are stored.

  1. catalog_category_entity
  2. catalog_category_entity_datetime
  3. catalog_category_entity_decimal
  4. catalog_category_entity_int
  5. catalog_category_entity_text
  6. catalog_category_entity_varchar
catalog_category_product
There are following below Magento 2.x Database tables store bundle products

  1. catalog_product_bundle_option
  2. catalog_product_bundle_option_value
  3. catalog_product_bundle_price_index
  4. catalog_product_bundle_selection
  5. catalog_product_bundle_selection_price
  6. catalog_product_bundle_stock_index
There are following below Magento 2.x Database tables store Store Product Attributes

  1. eav_attribute
  2. eav_attribute_group
  3. eav_attribute_label
  4. eav_attribute_option
  5. eav_attribute_option_swatch
  6. eav_attribute_option_value
  7. eav_attribute_set
There are following below set of Magento 2.x Database Tables store Shopping Cart Items & its related data.

  1. quote
  2. quote_item
  3. quote_item_option
  4. quote_payment
  5. quote_address
  6. quote_address_item
  7. quote_payment
  8. quote_shipping_rate
  9. quote_id_mask
There are following below Magento 2.x Database tables store Store Product Attributes

  1. sales_order
  2. sales_order_item
  3. sales_order_grid
  4. sales_order_address
  5. sales_order_payment
  6. sales_order_status

There are following set of Magento 2.x Database Tables Store Sales Invoice Order Data

  1. sales_Invoice
  2. sales_Invoice_item
  3. sales_Invoice_grid
  4. sales_Invoice_comment
  5. sales_Invocie_aggregated
  6. sales_Invocie_aggregated_order
There are following below Magento 2.x Database table store Sales Payment Transaction

sales_payment_transaction
There are following set of Magento 2.x Database Tables Store Sales Tax and Its related Data

  1. sales_order_tax_item
  2. tax_calculation
  3. tax_calculation_rate
  4. tax_calculation_rate_title
  5. tax_calculation_rule
  6. tax_class
  7. tax_order_aggregated_created
  8. tax_order_aggregated_updated
There are following below table store Magento 2.x Module Security Patches

patch_list
There are following below set of Magento 2.x Database Tables Store Customer’s Newsletter Data

  1. newsletter_problem
  2. newsletter_queue
  3. newsletter_queue_link
  4. newsletter_queue_store_link
  5. newsletter_subscriber
  6. newsletter_template
There are following below set of Magento 2.x Database Tables Store Custom Rating Data for Products.

  1. rating_entity
  2. rating_option
  3. rating_option_vote
  4. rating_option_vote_aggregated
  5. rating_store
  6. rating_title
There are following below set of Magento 2.x Database Tables Store Custom Review Data for Products.

  1. review
  2. review_detail
  3. review_entity
  4. review_entity_summary
  5. review_status
  6. review_store
There are following below set of Magento 2.x Database Tables store Customer’s Wishlist Products

  1. wishlist
  2. wishlist_item
  3. wishlist_item_option
  4. email_wishlist
There are following below Magento 2.x Database Table having all URLs storage.

url_rewrite
There are following below set of Magento 2.x Database Tables store Cart Price Rules

  1. salesrule
  2. salesrule_coupon
  3. salesrule_coupon_aggregated
  4. salesrule_coupon_aggregated_order
  5. salesrule_coupon_aggregated_updated
  6. salesrule_coupon_usage
  7. salesrule_customer
  8. salesrule_customer_group
  9. salesrule_label
  10. salesrule_product_attribute
  11. salesrule_website
There are following below set of Magento 2.x Database Tables store Catalog Price Rules

  1. catalogrule
  2. catalogrule_customer_group
  3. catalogrule_group_website
  4. catalogrule_group_website_replica
  5. catalogrule_product
  6. catalogrule_product_price
  7. catalogrule_product_price_replica
  8. catalogrule_product_replica
  9. catalogrule_website
There are following below set of Magento 2.x Database Tables store Bundle Products

  1. catalog_product_bundle_option
  2. catalog_product_bundle_option_value
  3. catalog_product_bundle_price_index
  4. catalog_product_bundle_selection
  5. catalog_product_bundle_selection_price
  6. catalog_product_bundle_stock_index
  7. catalog_product_index_price_bundle_idx
  8. catalog_product_index_price_bundle_opt_idx
  9. catalog_product_index_price_bundle_opt_tmp
  10. catalog_product_index_price_bundle_sel_idx
  11. catalog_product_index_price_bundle_sel_tmp
  12. catalog_product_index_price_bundle_tmp
There are following below set of Magento 2.x Database Tables store PayPal Billing Agreement

  1. paypal_billing_agreement
  2. paypal_billing_agreement_order
There are following below set of Magento 2.x Database Tables store Sales Paypal Settlement Report

  1. paypal_settlement_report
  2. paypal_settlement_report_row
There are following below Magento 2.x Database Table store Sales Paypal Payment Transaction

  1. paypal_payment_transaction
There are following below set of Magento 2.x Database Table store downloadable products

  1. downloadable_link
  2. downloadable_link_price
  3. downloadable_link_purchased
  4. downloadable_link_purchased_item
  5. downloadable_link_title
  6. downloadable_sample
  7. downloadable_sample_title
There are following below set of Magento 2.x Database Table store Braintree Payment Details

  1. braintree_credit_prices
  2. braintree_transaction_details
The Total number of Database Tables in Magento 2.4 is 399

More Details Magento 2.4 Database Tables

The Total number of Database Tables in Magento 2.4.3 is 411

More Details Magento 2.4.3 Database Tables

The Total number of Database Tables in Magento 2.4.3 is 411

More Details Magento 2.4.3-P1 Database Tables

The Total number of Database Tables in Magento 2.4.1 is 404

More Details Magento 2.4.1 Database Tables

The Total number of Database Tables in Magento 2.4.2 is 408

More Details Magento 2.4.2 Database Tables

The following below set of Magento 2.x Database Tables, once Magento 2.x connected to Algolia Search

  1. algoliasearch_landing_page
  2. algoliasearch_query
  3. algoliasearch_queue
  4. algoliasearch_queue_archive
  5. algoliasearch_queue_log
  6. algolia_additional_sections_cl
  7. algolia_categories_cl
  8. algolia_delete_products_cl
  9. algolia_pages_cl
  10. algolia_products_cl
  11. algolia_queue_runner_cl
  12. algolia_suggestions_cl

More Details Magento 2.x Connected Algolia Search

The following below two tables store Magento 2.x compare products

  1. catalog_compare_item
  2. catalog_compare_list

More Details Magento 2.x Compare Products Tables

The following below Magento 2.x Database Table having Catalog URL Rewrite ID.

catalog_url_product_category

The following below Magento 2.x Database Table having store Email Templates.

email_template

The following below Magento 2.x Database Table having Cron Job details.

cron_schedule

The following below Magento 2.x / Adobe Commerce 2.x Database Tables responsible to verify that the catalog data has been exported from your Adobe Commerce instance and is synchronized for Live Search.

catalog_data_exporter_products

catalog_data_exporter_product_attributes

The following below Adobe Commerce 2.x - B2B Database Tables responsible to store Customer Company or User Company Details
  1. - Company & It’s concerned details are stored in
    Database Table — Company
  2. - Relationship between Company_id & Customer_id stored in
    Database Table – company_advanced_customer_entity
  3. - Company Credit related details stored in
    Database Table– company_credit
  4. - Company payment related details stored in
    Database Table – company_credit
  5. - Company Structure related ID details stored in
    Database Table – company_structure
  6. - Company negotiable quote related ID details stored in
    Database Table – negotiable_quote_company_config
  7. - Company purchase order related details stored in
    Database Table – purchase_order_company_config