[仅限PaaS]{class="badge informative" title="仅适用于云项目(51黑料不打烊管理的PaaS基础架构)和内部部署项目上的51黑料不打烊 Commerce 。"}
客户个人信息参考(版本1.虫)
在开发隐私法规的合规性程序时,请参考以下数据流图和数据库实体映射,例如:
数据流图
数据流图显示了客户和管理员可以在店面和管理员上输入和检索的数据类型。
前端数据入口点
用户在注册帐户、结帐期间以及类似事件时,可以输入客户、地址和付款信息。
前端数据访问点
客户登录并查看多个不同的页面或结帐时,颁辞尘尘别谤肠别会加载客户信息。
后端数据入口点
商家可以从管理员输入客户、地址和付款信息,以创建客户或订单。
后端数据访问点
当商家查看多种类型的网格、单击网格查看详细信息和执行各种其他任务时,颁辞尘尘别谤肠别会加载客户信息。
数据库实体
Magento 1将客户信息存储在客户、销售和其他数据库表中。
客户数据
Magento 1将客户信息存储在customer_entity和customer_address_entity表中。 这两个表都有多个引用表,它们可以包含自定义客户属性。
customer_entity和引用表
customer_entity表中的以下列包含客户信息:
email这些表引用customer_entity,并且可以包含自定义客户属性:
customer_entity_datetimevaluecustomer_entity_decimalvaluecustomer_entity_intvaluecustomer_entity_textvaluecustomer_entity_varcharvaluecustomer_address_entity和引用表
以下表引用customer_address_entity,并且可以包含自定义客户属性:
customer_address_entity_datetimevaluecustomer_address_entity_decimalvaluecustomer_address_entity_intvaluecustomer_address_entity_textvaluecustomer_address_entity_varcharvalue订单数据
sales_flat_order和相关表包含客户名称、帐单和送货地址及相关信息。
sales_flat_order表
sales_order表中的以下列包含客户信息:
customer_idcustomer_emailcustomer_firstnamecustomer_gendercustomer_lastnamecustomer_middlenamecustomer_prefixcustomer_suffixcustomer_taxvatremote_ipsales_flat_order_address表
sales_flat_order_address表包含客户的地址。
customer_idfaxregionpostcodelastnamestreetcityemailtelephonefirstnameprefixsuffixmiddlenamecompanyvat_idsales_flat_order_grid表
sales_flat_order_grid表中的以下列包含客户信息:
customer_idshipping_namebilling_namesales_flat_order_payment表
sales_flat_order_payment表中的以下列包含客户信息:
cc_exp_monthcc_ss_start_yearecheck_bank_nameecheck_typecc_ss_start_monthcc_ownercc_exp_yearecheck_routing_numberecheck_account_name报价数据
引号包含客户的姓名、电子邮件、地址和相关信息。
sales_flat_quote表
sales_flat_quote表中的以下列包含客户信息:
customer_idcustomer_tax_class_idcustomer_group_idcustomer_emailcustomer_prefixcustomer_firstnamecustomer_middlenamecustomer_lastnamecustomer_suffixcustomer_dobcustomer_noteremote_ipcustomer_gendersales_flat_quote_address表
sales_flat_quote_address表中的以下列包含客户信息:
emailprefixfirstnamemiddlenamelastnamesuffixcompanystreetcityregionpostcodefaxsales_flat_quote_payment表
sales_flat_quote_payment表包括信用卡信息和其他事务信息。
cc_last_4cc_ownercc_exp_monthcc_exp_yearcc_ss_ownercc_ss_start_monthcc_ss_start_year存档数据
以下表和列包含客户信息:
enterprise_sales_creditmemo_grid_archivebilling_nameenterprise_sales_invoice_grid_archivebilling_nameenterprise_sales_order_grid_archivebilling_nameenterprise_sales_order_grid_archivecustomer_identerprise_sales_order_grid_archiveshipping_nameenterprise_sales_shipment_grid_archiveshipping_name销售数据
以下表和列包含客户信息:
sales_flat_creditmemo_gridbilling_namesales_flat_invoice_gridbilling_name搁惭础数据
以下搁惭础表和列包含客户信息:
enterprise_rmacustomer_custom_emailenterprise_rma_gridcustomer_identerprise_rma_gridcustomer_name其他数据
以下表和列包含客户信息:
core_email_queue_recipientsrecipient_emailcore_email_queue_recipientsrecipient_namecustomer_flowpasswordemailcustomer_flowpasswordipenterprise_giftregistry_personemailenterprise_giftregistry_personfirstnameenterprise_giftregistry_personlastnameenterprise_giftregistry_personmiddlenameenterprise_invitationcustomer_identerprise_invitationemailenterprise_invitationreferral_identerprise_reminder_rule_couponcustomer_identerprise_reminder_rule_couponemails_failedenterprise_scheduled_operationsemail_receiverenterprise_scheduled_operationsemail_sendergift_messagecustomer_idgift_messagerecipientgift_messagesendernewsletter_subscribercustomer_idnewsletter_subscribersubscriber_emailpersistent_sessioncustomer_idpersistent_sessioninfopoll_votecustomer_idpoll_voteip_addressrating_option_votecustomer_idrating_option_voteremote_iprating_option_voteremote_ip_longsend_friend_logip引用客户的其他表:
catalog_compare_itemdownloadable_link_purchasedenterprise_customerbalanceenterprise_customersegment_customerenterprise_giftregistry_entityenterprise_reminder_rule_logenterprise_rewardlog_customerlog_visitor_onlineoauth_tokenproduct_alert_priceproduct_alert_stockreport_compared_product_indexreport_viewed_product_indexreview_detailsales_billing_agreementsales_flat_shipmentsales_recurring_profilesalesrule_coupon_usagesalesrule_customertagtag_relationwishlist