Customer personal information reference (version 2.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 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 entry points

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.

Frontend data access points

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

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.

Backend data access points

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
  • Email
  • First Name
  • Gender
  • Last Name
  • Middle Name/Initial
  • Name Prefix
  • Name Suffix
NOTE

In keeping with current security and privacy best practices, be sure you are aware of any potential legal and security risks associated with the storage of customers’ full date of birth (month, day, year) along with other personal identifiers, such as full name, before collecting or processing such data.

customer_entity and ‘customer_entity’ references

The following columns in the customer_entity table contain customer information:

Column Data type
email varchar(255)
prefix varchar(40)
firstname varchar(255)
middlename varchar(255)
lastname varchar(255)
suffix varchar(40)
dob date
gender smallint(5)

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_grid_flat table

The following columns in the customer_grid_flat table contain customer information:

Column Data type
name text
email varchar(255)
dob date
gender int(11)
shipping_full text
billing_full text
billing_firstname varchar(255)
billing_lastname varchar(255)
billing_telephone varchar(255)
billing_postcode varchar(255)
billing_country_id varchar(255)
billing_region varchar(255)
billing_city varchar(255)
billing_fax varchar(255)
billing_vat_id varchar(255)
billing_company varchar(255)

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:

Column Data type
city varchar(255)
company varchar(255)
country_id varchar(255)
fax varchar(255)
firstname varchar(255)
lastname varchar(255)
middlename varchar(255)
postcode varchar(255)
region varchar(255)
region_id int(10)
street text
suffix varchar(40)
telephone varchar(255)
vat_id varchar(255)

These 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_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:

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

sales_order_address table

The sales_order_address table contains the customer’s address.

Column Data type
customer_address_id int(11)
quote_address_id int(11)
region_id int(11)
customer_id int(11)
fax varchar(255)
region varchar(255)
postcode varchar(255)
lastname varchar(255)
street varchar(255)
city varchar(255)
email varchar(255)
telephone varchar(255)
country_id varchar(2)
firstname varchar(255)
suffix varchar(255)
company varchar(255)

sales_order_grid table

The following columns in the sales_order_grid table contain customer information:

Column Data type
customer_id int(10)
shipping_name varchar(255)
billing_name varchar(255)
billing_address varchar(255)
shipping_address varchar(255)
shipping_information varchar(255)
customer_email varchar(255)
customer_name varchar(255)

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:

Column Data type
customer_id int(10)
customer_email varchar(255)
customer_prefix varchar(40)
customer_firstname varchar(255)
customer_middlename varchar(40)
customer_lastname varchar(255)
customer_dob datetime
remote_ip varchar(32)
customer_taxvat varchar(255)
customer_gender varchar(255)

quote_address table

The following columns in the quote_address table contain customer information:

Column Data type
customer_id int(10)
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)
region_id int(10)
postcode varchar(20)
country_id varchar(30)
telephone varchar(255)
fax varchar(255)

Payment data

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

Column Data type
cc_exp_month varchar(12)
echeck_bank_name varchar(128)
cc_last_4 varchar(100)
cc_owner varchar(128)
po_number varchar(32)
cc_exp_year varchar(4)
echeck_routing_number varchar(32)
cc_debug_response_body varchar(32)
echeck_account_name varchar(32)
cc_number_enc varchar(128)
additional_information text

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.

Column Data type
customer_id int(10)
email varchar(255)
referral_id int(10)

magento_invitation_track table

The magento_invitation_track table also contains customer information.

Column Data type
inviter_id int(10)
referral_id int(10)

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

On this page