Customer personal information reference (version 1.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 on 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
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, address, and payment information from the Admin to create a customer or order.
Backend data access points
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
Magento 1 stores customer information in customer, sales, and other database tables.
Customer data
Magento 1 stores customer information in the customer_entity
and customer_address_entity
tables. Both of these tables have several reference tables that can contain custom customer attributes.
customer_entity
and reference tables
The following columns in the customer_entity
table contain customer information:
email
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_address_entity
and reference tables
The following 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_flat_order
and related tables contain the customer’s name, billing and shipping addresses, and related information.
sales_flat_order
table
The following columns in the sales_order
table contain customer information:
customer_id
customer_email
customer_firstname
customer_gender
customer_lastname
customer_middlename
customer_prefix
customer_suffix
customer_taxvat
remote_ip
sales_flat_order_address
table
The sales_flat_order_address
table contains the customer’s address.
customer_id
fax
region
postcode
lastname
street
city
email
telephone
firstname
prefix
suffix
middlename
company
vat_id
sales_flat_order_grid
table
The following columns in the sales_flat_order_grid
table contain customer information:
customer_id
shipping_name
billing_name
sales_flat_order_payment
table
The following columns in the sales_flat_order_payment
table contain customer information:
cc_exp_month
cc_ss_start_year
echeck_bank_name
echeck_type
cc_ss_start_month
cc_owner
cc_exp_year
echeck_routing_number
echeck_account_name
Quote data
Quotes contain a customer’s name, email, address, and related information.
sales_flat_quote
table
The following columns in the sales_flat_quote
table contain customer information:
customer_id
customer_tax_class_id
customer_group_id
customer_email
customer_prefix
customer_firstname
customer_middlename
customer_lastname
customer_suffix
customer_dob
customer_note
remote_ip
customer_gender
sales_flat_quote_address
table
The following columns in the sales_flat_quote_address
table contain customer information:
email
prefix
firstname
middlename
lastname
suffix
company
street
city
region
postcode
fax
sales_flat_quote_payment
table
The sales_flat_quote_payment
table includes credit card information and other transactional information.
cc_last_4
cc_owner
cc_exp_month
cc_exp_year
cc_ss_owner
cc_ss_start_month
cc_ss_start_year
Archive data
The following tables and columns contain customer information:
enterprise_sales_creditmemo_grid_archive
billing_name
enterprise_sales_invoice_grid_archive
billing_name
enterprise_sales_order_grid_archive
billing_name
enterprise_sales_order_grid_archive
customer_id
enterprise_sales_order_grid_archive
shipping_name
enterprise_sales_shipment_grid_archive
shipping_name
Sales data
The following tables and columns contain customer information:
sales_flat_creditmemo_grid
billing_name
sales_flat_invoice_grid
billing_name
RMA data
The following RMA tables and columns contain customer information:
enterprise_rma
customer_custom_email
enterprise_rma_grid
customer_id
enterprise_rma_grid
customer_name
Miscellaneous data
The following tables and columns contain customer information:
core_email_queue_recipients
recipient_email
core_email_queue_recipients
recipient_name
customer_flowpassword
email
customer_flowpassword
ip
enterprise_giftregistry_person
email
enterprise_giftregistry_person
firstname
enterprise_giftregistry_person
lastname
enterprise_giftregistry_person
middlename
enterprise_invitation
customer_id
enterprise_invitation
email
enterprise_invitation
referral_id
enterprise_reminder_rule_coupon
customer_id
enterprise_reminder_rule_coupon
emails_failed
enterprise_scheduled_operations
email_receiver
enterprise_scheduled_operations
email_sender
gift_message
customer_id
gift_message
recipient
gift_message
sender
newsletter_subscriber
customer_id
newsletter_subscriber
subscriber_email
persistent_session
customer_id
persistent_session
info
poll_vote
customer_id
poll_vote
ip_address
rating_option_vote
customer_id
rating_option_vote
remote_ip
rating_option_vote
remote_ip_long
send_friend_log
ip
Other tables that reference Customer:
catalog_compare_item
downloadable_link_purchased
enterprise_customerbalance
enterprise_customersegment_customer
enterprise_giftregistry_entity
enterprise_reminder_rule_log
enterprise_reward
log_customer
log_visitor_online
oauth_token
product_alert_price
product_alert_stock
report_compared_product_index
report_viewed_product_index
review_detail
sales_billing_agreement
sales_flat_shipment
sales_recurring_profile
salesrule_coupon_usage
salesrule_customer
tag
tag_relation
wishlist