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. | |
CATEGORY_ID | int | No | Primary key component. Foreign key to ARF_CATEGORY.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 a product from this category on the specified day. | |
OCCURRENCES | int | No | The quantity of items from this category purchased by the customer on this day. |