Transactions
The Transaction Table contains details of Transactions made by Customers, such as Purchases and Returns. The Transaction table has 7 Mandatory fields, as this data is required for understanding the long-term Value of every Customer for better predictions.
The primary key for this table is the combination of 5 fields: customer_id
, invoice_id
, transaction_timestamp, order_type
and item_number
. In other words, for every transaction made by a customer at a given time, each record should contain a Unique item.
Last updated