Customer personal information reference (version 2.x)
Use the following dataflow diagrams and database entity mappings for reference when developing compliance programs for privacy regulations such as:
Dataflow diagrams
The dataflow diagrams show the types of data that customers and administrators can enter and retrieve from the storefront and Admin.
Frontend data entry points
A user can enter customer, address, and payment information when registering for an account, during checkout, and similar events.
Frontend data access points
Adobe Commerce loads customer information when the customer logs in and views several different pages, or checks out.
Backend data entry points
A merchant can enter customer information, address data, and payment data when creating a customer or order from the Admin.
Backend data access points
Adobe Commerce loads customer information when a merchant views several types of grids, clicks on a grid to see detailed information, and performs various other tasks.
Database entities
Adobe Commerce primarily stores customer-specific information in customer, address, order, quote, and payment tables. Other tables contain references to the customer ID.
Customer data
Adobe Commerce can be configured to store the following customer attributes:
- Date of Birth
- First Name
- Gender
- Last Name
- Middle Name/Initial
- Name Prefix
- Name Suffix
customer_entity and ‘customer_entity’ references
The following columns in the customer_entity table contain customer information:
emailprefixfirstnamemiddlenamelastnamesuffixdobgenderThese tables reference customer_entity and can contain custom customer attributes:
customer_entity_datetimevaluecustomer_entity_decimalvaluecustomer_entity_intvaluecustomer_entity_textvaluecustomer_entity_varcharvaluecustomer_grid_flat table
The following columns in the customer_grid_flat table contain customer information:
nameemaildobgendershipping_fullbilling_fullbilling_firstnamebilling_lastnamebilling_telephonebilling_postcodebilling_country_idbilling_regionbilling_citybilling_faxbilling_vat_idbilling_companyAddress data
Adobe Commerce stores the following customer attributes:
- City
- Company
- Country
- Fax
- First Name
- Last Name
- Middle Name/Initial
- Name Prefix
- Name Suffix
- Phone Number
- State/Province
- State/Province ID
- Street Address
- VAT Number
- Zip/Postal Code
customer_address_entity and customer_address_entity references
The following columns in the customer_address_entity table contain customer information:
citycompanycountry_idfaxfirstnamelastnamemiddlenamepostcoderegionregion_idstreetsuffixtelephonevat_idThese tables reference customer_address_entity and can contain custom customer attributes:
customer_address_entity_datetimevaluecustomer_address_entity_decimalvaluecustomer_address_entity_intvaluecustomer_address_entity_textvaluecustomer_address_entity_varcharvalueOrder data
The sales_order and related tables contain the customer name, billing and shipping addresses, and related data.
sales_order table
The following columns in the sales_order table contain customer information:
customer_dobcustomer_emailcustomer_firstnamecustomer_gendercustomer_group_idcustomer_idcustomer_lastnamecustomer_middlenamecustomer_prefixcustomer_suffixcustomer_taxvatquote_address_idremote_ipx_forwarded_forsales_order_address table
The sales_order_address table contains the customer’s address.
customer_address_idquote_address_idregion_idcustomer_idfaxregionpostcodelastnamestreetcityemailtelephonecountry_idfirstnamesuffixcompanysales_order_grid table
The following columns in the sales_order_grid table contain customer information:
customer_idshipping_namebilling_namebilling_addressshipping_addressshipping_informationcustomer_emailcustomer_nameQuote data
Quotes contain a customer’s name, email, address, and related information.
quote table
The following columns in the quote table contain customer information:
customer_idcustomer_emailcustomer_prefixcustomer_firstnamecustomer_middlenamecustomer_lastnamecustomer_dobremote_ipcustomer_taxvatcustomer_genderquote_address table
The following columns in the quote_address table contain customer information:
customer_idemailprefixfirstnamemiddlenamelastnamesuffixcompanystreetcityregionregion_idpostcodecountry_idtelephonefaxPayment data
The sales_order_payment table includes credit card information and other transactional information.
cc_exp_monthecheck_bank_namecc_last_4cc_ownerpo_numbercc_exp_yearecheck_routing_numbercc_debug_response_bodyecheck_account_namecc_number_encadditional_informationInvitation data
Adobe Commerce can be configured so that customers can send invitations to private sales and events.
magento_invitation table
The magento_invitation table contains the customer ID, email, and referral ID.
customer_idemailreferral_idmagento_invitation_track table
The magento_invitation_track table also contains customer information.
inviter_idreferral_idMiscellaneous tables that reference customer
The following tables contain a customer_id column:
catalog_compare_itemcatalog_product_frontend_actiondownloadable_link_purchasedmagento_customerbalancemagento_customersegment_customermagento_rewardmagento_rmaoauth_tokenpaypal_billing_agreementpersistent_sessionproduct_alert_priceproduct_stock_alertreport_compared_product_indexreport_viewed_product_indexreview_detailsalesrule_coupon_usagesalesrule_customerwishlist