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:
The dataflow diagrams show the types of data that customers and administrators can enter and retrieve from the storefront and Admin.
A user can enter customer, address, and payment information when registering for an account, during checkout, and similar events.
Adobe Commerce and Magento Open Source load customer information when the customer logs in and views several different pages, or checks out.
A merchant can enter customer information, address data, and payment data when creating a customer or order from the Admin.
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.
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.
Adobe Commerce and Magento Open Source can be configured to store the following customer attributes:
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’ referencesThe 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
tableThe 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) |
Adobe Commerce and Magento Open Source store the following customer attributes:
customer_address_entity
and customer_address_entity
referencesThe 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) |
The sales_order
and related tables contain the customer name, billing and shipping addresses, and related data.
sales_order
tableThe 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
tableThe 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
tableThe 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) |
Quotes contain a customer’s name, email, address, and related information.
quote
tableThe 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
tableThe 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) |
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 |
Adobe Commerce and Magento Open Source can be configured so that customers can send invitations to private sales and events.
magento_invitation
tableThe 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
tableThe magento_invitation_track
table also contains customer information.
Column | Data type |
---|---|
inviter_id |
int(10) |
referral_id |
int(10) |
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