This table stores data about how many times any customer has purchased a particular product. It is used for the Affinity Selling feature of ATG Commerce.
Column Name | Type | Length | Null Allowed | Description |
|---|---|---|---|---|
CUSTOMER_ID | int | No | Primary key component. Foreign key to ARF_USER.ID column. | |
PRODUCT_ID | int | No | Primary key component. Foreign key to ARF_PRODUCT.ID column. | |
DAY_ID | varchar | 40 | No | Primary key component. Foreign key to ARF_TIME_DAY.ID column. |
LAST_PURCHASE | timestamp | Yes | The last time the customer purchased the product on the specified day. | |
OCCURRENCES | int | No | The quantity of items of the product purchased by the customer on this day. |
