Data model

Customers

Note: Customer Id must be unique and match customer from Transactions and any other entity group. You can include up to 50 additional attributes not listed below in the table. All those attributes will be represented as attribute_{name_of_attribute} where name_of_attribute will be original name of your column lowercased with underscore instead of special characters or spaces.

Customers data model can be found here.

Transactions

Note: Combination of transaction id, customer id, item id, purchase date, quantity, price is a unique raw are included.

Transactions data model can be found here.

Items

Note: Item Id must be unique and to match the item_id from Transactions and any other entity group. 

Items data model can be found here.

Leaflet

Leaflet data model can be found here.