Customer personal information reference (version 1.x)

NOTE

This is one in a series of topics to help Adobe Commerce and Magento Open Source merchants and developers prepare for compliance with privacy regulations. Consult with your legal counsel to determine whether and how your business should comply with any legal obligations.

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 entry points

Frontend data access points

Commerce loads customer information when the customer logs in and views several different pages or checks out.

Frontend data access points

Backend data entry points

A merchant can enter customer, address, and payment information from the Admin to create a customer or order.

Backend data entry points

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.

Backend data access points

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_entitytable contain customer information:

Column Data type
email varchar(255)

These tables reference customer_entity and can contain custom customer attributes:

Table Column Data type
customer_entity_datetime value datetime
customer_entity_decimal value decimal(12,4)
customer_entity_int value int(11)
customer_entity_text value text
customer_entity_varchar value varchar(255)

customer_address_entity and reference tables

The following tables reference customer_address_entity and can contain custom customer attributes:

Table Column Data type
customer_address_entity_datetime value datetime
customer_address_entity_decimal value decimal(12,4)
customer_address_entity_int value int(11)
customer_address_entity_text value text
customer_address_entity_varchar value varchar(255)

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:

Column Data type
customer_id int(10)
customer_email varchar(128)
customer_firstname varchar(128)
customer_gender int(11)
customer_lastname varchar(128)
customer_middlename varchar(128)
customer_prefix varchar(32)
customer_suffix varchar(32)
customer_taxvat varchar(32)
remote_ip varchar(32)

sales_flat_order_address table

The sales_flat_order_address table contains the customer’s address.

Column Data type
customer_id int(10)
fax varchar(255)
region varchar(255)
postcode varchar(255)
lastname varchar(255)
street varchar(255)
city varchar(255)
email varchar(255)
telephone varchar(255)
firstname varchar(255)
prefix varchar(255)
suffix varchar(255)
middlename varchar(255)
company varchar(255)
vat_id text

sales_flat_order_grid table

The following columns in the sales_flat_order_grid table contain customer information:

Column Data type
customer_id int(10)
shipping_name varchar(255)
billing_name varchar(255)

sales_flat_order_payment table

The following columns in the sales_flat_order_payment table contain customer information:

Column Data type
cc_exp_month varchar(255)
cc_ss_start_year varchar(255)
echeck_bank_name varchar(128)
echeck_type varchar(255)
cc_ss_start_month varchar(255)
cc_owner varchar(255)
cc_exp_year varchar(255)
echeck_routing_number varchar(255)
echeck_account_name varchar(255)

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:

Column Data type
customer_id int(10)
customer_tax_class_id int(10)
customer_group_id int(10)
customer_email varchar(255)
customer_prefix varchar(40)
customer_firstname varchar(255)
customer_middlename varchar(40)
customer_lastname varchar(255)
customer_suffix varchar(40)
customer_dob datetime
customer_note varchar(255)
remote_ip varchar(255)
customer_gender varchar(255)

sales_flat_quote_address table

The following columns in the sales_flat_quote_address table contain customer information:

Column Data type
email varchar(255)
prefix varchar(40)
firstname varchar(255)
middlename varchar(40)
lastname varchar(255)
suffix varchar(40)
company varchar(255)
street varchar(255)
city varchar(255)
region varchar(255)
postcode varchar(255)
fax varchar(255)

sales_flat_quote_payment table

The sales_flat_quote_payment table includes credit card information and other transactional information.

Column Data type
cc_last_4 varchar(255)
cc_owner varchar(255)
cc_exp_month smallint(5)
cc_exp_year smallint(5)
cc_ss_owner varchar(255)
cc_ss_start_month smallint(5)
cc_ss_start_year smallint(5)

Archive data

The following tables and columns contain customer information:

Table Column Data type
enterprise_sales_creditmemo_grid_archive billing_name varchar(255)
enterprise_sales_invoice_grid_archive billing_name varchar(255)
enterprise_sales_order_grid_archive billing_name varchar(255)
enterprise_sales_order_grid_archive customer_id int(10)
enterprise_sales_order_grid_archive shipping_name varchar(255)
enterprise_sales_shipment_grid_archive shipping_name varchar(255)

Sales data

The following tables and columns contain customer information:

Table Column Data type
sales_flat_creditmemo_grid billing_name varchar(255)
sales_flat_invoice_grid billing_name varchar(255)

RMA data

The following RMA tables and columns contain customer information:

Table Column Data type
enterprise_rma customer_custom_email varchar(255)
enterprise_rma_grid customer_id int(10)
enterprise_rma_grid customer_name varchar(255)

Miscellaneous data

The following tables and columns contain customer information:

Table Column Data type
core_email_queue_recipients recipient_email varchar(128)
core_email_queue_recipients recipient_name varchar(255)
customer_flowpassword email varchar(255)
customer_flowpassword ip varchar(50)
enterprise_giftregistry_person email varchar(150)
enterprise_giftregistry_person firstname varchar(100)
enterprise_giftregistry_person lastname varchar(100)
enterprise_giftregistry_person middlename text
enterprise_invitation customer_id int(10)
enterprise_invitation email varchar(255)
enterprise_invitation referral_id int(10)
enterprise_reminder_rule_coupon customer_id int(10)
enterprise_reminder_rule_coupon emails_failed smallint(5)
enterprise_scheduled_operations email_receiver varchar(150)
enterprise_scheduled_operations email_sender varchar(150)
gift_message customer_id int(10)
gift_message recipient varchar(255)
gift_message sender varchar(255)
newsletter_subscriber customer_id int(10)
newsletter_subscriber subscriber_email varchar(150)
persistent_session customer_id int(10)
persistent_session info text
poll_vote customer_id int(10)
poll_vote ip_address varbinary(16)
rating_option_vote customer_id int(10)
rating_option_vote remote_ip varchar(50)
rating_option_vote remote_ip_long varbinary(516)
send_friend_log ip varbinary(16)

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

On this page