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 and Magento Open Source load 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 and Magento Open Source load 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 and Magento Open Source primarily store customer-specific information in customer, address, order, quote, and payment tables. Other tables contain references to the customer ID.
Customer data
Adobe Commerce and Magento Open Source 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:
email
prefix
firstname
middlename
lastname
suffix
dob
gender
These tables reference customer_entity
and can contain custom customer attributes:
customer_entity_datetime
value
customer_entity_decimal
value
customer_entity_int
value
customer_entity_text
value
customer_entity_varchar
value
customer_grid_flat
table
The following columns in the customer_grid_flat
table contain customer information:
name
email
dob
gender
shipping_full
billing_full
billing_firstname
billing_lastname
billing_telephone
billing_postcode
billing_country_id
billing_region
billing_city
billing_fax
billing_vat_id
billing_company
Address data
Adobe Commerce and Magento Open Source store 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:
city
company
country_id
fax
firstname
lastname
middlename
postcode
region
region_id
street
suffix
telephone
vat_id
These tables reference customer_address_entity
and can contain custom customer attributes:
customer_address_entity_datetime
value
customer_address_entity_decimal
value
customer_address_entity_int
value
customer_address_entity_text
value
customer_address_entity_varchar
value
Order 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_dob
customer_email
customer_firstname
customer_gender
customer_group_id
customer_id
customer_lastname
customer_middlename
customer_prefix
customer_suffix
customer_taxvat
quote_address_id
remote_ip
x_forwarded_for
sales_order_address
table
The sales_order_address
table contains the customer’s address.
customer_address_id
quote_address_id
region_id
customer_id
fax
region
postcode
lastname
street
city
email
telephone
country_id
firstname
suffix
company
sales_order_grid
table
The following columns in the sales_order_grid
table contain customer information:
customer_id
shipping_name
billing_name
billing_address
shipping_address
shipping_information
customer_email
customer_name
Quote 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_id
customer_email
customer_prefix
customer_firstname
customer_middlename
customer_lastname
customer_dob
remote_ip
customer_taxvat
customer_gender
quote_address
table
The following columns in the quote_address
table contain customer information:
customer_id
email
prefix
firstname
middlename
lastname
suffix
company
street
city
region
region_id
postcode
country_id
telephone
fax
Payment data
The sales_order_payment
table includes credit card information and other transactional information.
cc_exp_month
echeck_bank_name
cc_last_4
cc_owner
po_number
cc_exp_year
echeck_routing_number
cc_debug_response_body
echeck_account_name
cc_number_enc
additional_information
Invitation data
Adobe Commerce and Magento Open Source 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_id
email
referral_id
magento_invitation_track
table
The magento_invitation_track
table also contains customer information.
inviter_id
referral_id
Miscellaneous tables that reference customer
The following tables contain a customer_id
column:
catalog_compare_item
catalog_product_frontend_action
downloadable_link_purchased
magento_customerbalance
magento_customersegment_customer
magento_reward
magento_rma
oauth_token
paypal_billing_agreement
persistent_session
product_alert_price
product_stock_alert
report_compared_product_index
report_viewed_product_index
review_detail
salesrule_coupon_usage
salesrule_customer
wishlist