Customer Addressxref

This entity provides a cross-reference between child-customers and their respective addresses.

CUSTOMERADDRESSXREF

customerid, addressid

customeraddressxref.customerid=customer.id

customeraddressxref.addressid=address.id

Customer First Transaction Product Category

This entity cross-references master-customers with the product categories of their first transactions.

CUSTOMERFIRSTTRANSACTION
PRODUCTCATEGORY

productcategoryid, mastercustomerid

customerfirsttransactionproductcategory.productcategoryid=
productcategorysummary.id

customerfirsttransactionproductcategory.mastercustomerid=
customersummary.mastercustomerid

Customer Last Transaction Product Category

This entity cross-references master-customers with the product categories of their last transactions.

CUSTOMERLASTTRANSACTION
PRODUCTCATEGORY

productcategoryid, mastercustomerid

customerlasttransactionproductcategory.productcategoryid=
productcategorysummary.id

customerlasttransactionproductcategory.mastercustomerid=
customersummary.mastercustomerid

Product Categoryxref

This entity cross-references products with their corresponding product categories.

PRODUCTCATEGORYXREF

productid, productcategory

productcategoryxref.productid=product.id

productcategoryxref.productcategoryid=productcategory.id

Transaction Payment Methodxref

This entity cross-references child-customers with their corresponding addresses.

TRANSACTIONPAYMENT
METHODXREF

paymentmethodid, transaction

transactionpaymentmethodxref.paymentmethodid=paymentmethod.id

transactionpaymentmethodxref.transactionid=transaction.id