---
title: "Table Information"
date: "2024-02-14T06:18:38+00:00"
summary: "Explore our comprehensive table information guide for Customer Data Platform (CDP). Learn about key tables, their descriptions, primary keys, and JOIN relationships to optimize your data analysis and customer insights."
image:
type: "page"
url: "/table-information"
id: "6f820499-8d55-43ab-a5b2-6f3b9446c157"
---

   

Table Name

Table Description

Primary Key

JOIN Relationships

[customersummary](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/customer-summary)

Individual master-customer records after Customer Data Platform (CDP)’s de-duping of raw child-customers.

mastercustomerid

*   customersummary.mastercustomerid=transactionsummary.mastercustomerid
    
*   customersummary.mastercustomerid=mastercustomer.mastercustomerid
    
*   customersummary.mastercustomerid=customerfirsttransactionproductcategory.mastercustomerid
    
*   customersummary.mastercustomerid=customerlasttransactionproductcategory.mastercustomerid
    
*   customersummary.FirstPromoID=promotiontypesummary.id
    
*   customersummary.FirstOfflinePromoID=promotiontypesummary.id
    
*   customersummary.closeststoreid=organizationsummary.id
    
*   customersummary.primarystoreid=organizationsummary.id
    

[transactionsummary](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/transation-summary)

Transaction records at the line-level across all sales channels.

id

*   transactionsummary.mastercustomerid=customersummary.mastercustomerid
    
*   transactionsummary.mastercustomerid=mastercustomer.mastercustomerid
    
*   transactionsummary.customerid=customer.id
    
*   transactionsummary.productid=productsummary.id
    
*   transactionsummary.organizationid=organizationsummary.id
    
*   transactionsummary.TransactionLastMarketingTouchID=promotiontypesummary.id
    
*   transactionsummary.TransactionLastOfflineMarketingTouchID=promotiontypesummary.id
    
*   transactionsummary.TransactionLastOfflineMarketingTouchIDHousehold=promotiontypesummary.id
    
*   transactionsummary.transactionid=event.transactionid
    

[productsummary](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/product-summary)

List of products.

id

*   productsummary.id=transactionsummary.productid
    
*   productsummary.id=productcategoryxref.productid
    
*   productsummary.id=productsummary.ParentProductID
    
*   productsummary.id=event.productid
    

[productcategorysummary](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/product-category-summary)

List of product categories.

id

*   productcategorysummary.id=productcategoryxref.productcategoryid
    
*   productcategorysummary.id=customerfirsttransactionproductcategory.productcategoryid
    
*   productcategorysummary.id=customerlasttransactionproductcategory.productcategoryid
    
*   productcategorysummary.id=event.productcategoryid
    

[productcategoryxref](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/product-category-xref)

Cross-reference between products and product categories.

id

*   productcategoryxref.productid=productsummary.id
    
*   productcategoryxref.productcategoryid=productcategorysummary.id
    

[customerfirsttransactionproductcategory](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/customer-first-transaction-product-category)

Cross-reference between master-customers and their first transaction product categories.

id

*   customerfirsttransactionproductcategory.productcategoryid=productcategorysummary.id
    
*   customerfirsttransactionproductcategory.mastercustomerid=customersummary.mastercustomerid
    

[customerlasttransactionproductcategory](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/customer-last-transaction-product-category)

Cross-reference between master-customers and their last transaction product categories.

id

*   customerlasttransactionproductcategory.productcategoryid=productcategorysummary.id
    
*   customerlasttransactionproductcategory.mastercustomerid=customersummary.mastercustomerid
    

[organizationsummary](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/organization-summary)

List of sales organizations and stores.

id

*   organizationsummary.id=transactionsummary.organizationid
    
*   organizationsummary.id=customersummary.closeststoreid
    
*   organizationsummary.id=customersummary.primarystoreid
    

[event](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/event)

List of events such as emailOpens, web productBrowsed or custom events for your tenant.

id

*   event.customerid=customer.id
    
*   event.customerid=mastercustomer.customerid
    
*   event.productid=productsummary.id
    
*   event.productcategoryid=productcategorysummary.id
    
*   event.transactionid=transactionsummary.transactionid
    

[mastercustomer](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/master-customer)

Cross-reference between child-customer and master-customer records. Multiple child-customer records could roll up to one master-customer record

id or customerid

*   mastercustomer.mastercustomerid=customersummary.mastercustomerid
    
*   mastercustomer.customerid=customer.id
    

[promotiontypesummary](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/promotion-type-summary)

List of online/offline marketing touches or promotions that influenced transactions.

id

*   promotiontypesummary.id=customersummary.FirstPromoID
    
*   promotiontypesummary.id=customersummary.FirstOfflinePromoID
    
*   promotiontypesummary.id=transactionsummary.TransactionLastMarketingTouchID
    
*   promotiontypesummary.id=transactionsummary.TransactionLastOfflineMarketingTouchID
    
*   promotiontypesummary.id=transactionsummary.TransactionLastOfflineMarketingTouchIDHousehold
    

[timesummary](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/time-summary)

Fiscal calendar mapping for each calendar date.

id (calendar day in YYYYMMDD format)

Any datetime attribute can be joined into the timesummary table to find the corresponding fiscal calendar date. Here are a few examples of how this can be achieved:

*   TO\_CHAR(timesummary.id)=TO\_CHAR(transactionsummary.transactiontimestamp, ‘YYYYMMDD’)
    
*   TO\_CHAR(timesummary.id)=TO\_CHAR(transactionsummary.shipdate, ‘YYYYMMDD’)
    
*   TO\_CHAR(timesummary.id)=TO\_CHAR(customersummary.FirstTransactionDate, ‘YYYYMMDD’)
    
*   TO\_CHAR(timesummary.id)=TO\_CHAR(customersummary.LastTransactionDate, ‘YYYYMMDD’)
    

[customer](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/customer) (optional)

Individual child-customer records before CDP’s de-duping.

id

*   customer.id=mastercustomer.customerid
    
*   customer.id=transactionsummary.customerid
    
*   customer.id=event.customerid
    
*   customer.id=customeraddressxref.customerid
    

[address](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/address) (optional)

List of address records for child-customers.

id

*   address.id=customeraddressxref.addressid
    

[customeraddressxref](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/customer-address-xref) (optional)

Cross-reference between child-customers and their addresses.

id

*   customeraddressxref.customerid=customer.id
    
*   customeraddressxref.addressid=address.id
    

[audiencehistory](/customer-data-platform/add-ons/interactive-queries/list-of-attributes/audience-history) (optional)

Cross-reference between cohorts and master-customers used to perform Cohort Analysis.

ID

*   customersummary.mastercustomerid = mastercustomer.mastercustomerid
    
*   mastercustomer.customerid = audiencehistory.mastercustomerid
    

any client-specific entities (optional)

Any client-specific tables configured for your account.

\-

\-