客户个人信息参考(版本1.x)
在开发隐私法规的合规性程序时,请参考以下数据流图和数据库实体映射,例如:
数据流图
数据流图显示了客户和管理员可以在店面和管理员上输入和检索的数据类型。
前端数据入口点
用户在注册帐户、结帐期间以及类似事件时,可以输入客户、地址和付款信息。
前端数据访问点
客户登录并查看多个不同的页面或结帐时,Commerce会加载客户信息。
后端数据入口点
商家可以从管理员输入客户、地址和付款信息,以创建客户或订单。
后端数据访问点
当商家查看多种类型的网格、单击网格查看详细信息和执行各种其他任务时,Commerce会加载客户信息。
数据库实体
Magento1将客户信息存储在customer 、 sales和其他数据库表中。
客户数据
Magento1将客户信息存储在customer_entity
和customer_address_entity
表中。 这两个表都有多个引用表,它们可以包含自定义客户属性。
customer_entity
和引用表
customer_entity
表中的以下列包含客户信息:
email
这些表引用customer_entity
,并且可以包含自定义客户属性:
customer_entity_datetime
value
customer_entity_decimal
value
customer_entity_int
value
customer_entity_text
value
customer_entity_varchar
value
customer_address_entity
和引用表
以下表引用customer_address_entity
,并且可以包含自定义客户属性:
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
订单数据
sales_flat_order
和相关表包含客户名称、帐单和送货地址及相关信息。
sales_flat_order
表
sales_order
表中的以下列包含客户信息:
customer_id
customer_email
customer_firstname
customer_gender
customer_lastname
customer_middlename
customer_prefix
customer_suffix
customer_taxvat
remote_ip
sales_flat_order_address
表
sales_flat_order_address
表包含客户的地址。
customer_id
fax
region
postcode
lastname
street
city
email
telephone
firstname
prefix
suffix
middlename
company
vat_id
sales_flat_order_grid
表
sales_flat_order_grid
表中的以下列包含客户信息:
customer_id
shipping_name
billing_name
sales_flat_order_payment
表
sales_flat_order_payment
表中的以下列包含客户信息:
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
报价数据
引号包含客户的姓名、电子邮件、地址和相关信息。
sales_flat_quote
表
sales_flat_quote
表中的以下列包含客户信息:
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
表
sales_flat_quote_address
表中的以下列包含客户信息:
email
prefix
firstname
middlename
lastname
suffix
company
street
city
region
postcode
fax
sales_flat_quote_payment
表
sales_flat_quote_payment
表包括信用卡信息和其他事务信息。
cc_last_4
cc_owner
cc_exp_month
cc_exp_year
cc_ss_owner
cc_ss_start_month
cc_ss_start_year
存档数据
以下表和列包含客户信息:
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_flat_creditmemo_grid
billing_name
sales_flat_invoice_grid
billing_name
RMA数据
以下RMA表和列包含客户信息:
enterprise_rma
customer_custom_email
enterprise_rma_grid
customer_id
enterprise_rma_grid
customer_name
其他数据
以下表和列包含客户信息:
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
引用客户的其他表:
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