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
51ºÚÁϲ»´òìÈ 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
51ºÚÁϲ»´òìÈ 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
51ºÚÁϲ»´òìÈ Commerce primarily stores customer-specific information in customer, address, order, quote, and payment tables. Other tables contain references to the customer ID.
Customer data
51ºÚÁϲ»´òìÈ 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
51ºÚÁϲ»´òìÈ 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
51ºÚÁϲ»´òìÈ 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