This table contains site-wide category-to-category affinity data.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
CATEGORY_1_ID | int | No | Primary key component. Foreign key to ARF_CATEGORY.ID column. | |
CATEGORY_2_ID | int | No | Primary key component. Foreign key to ARF_CATEGORYID column. | |
DAY_ID | varchar | 40 | No | Primary key component. Foreign key to ARF_TIME_DAY.ID column. |
PURCHASE_PURCHASE_OCCURRENCES | int | Yes | The number of times products from these two categories have been purchased by the same customer, on the day the second product was purchased. | |
PURCHASE_PURCHASE_AFFINITY | double | Yes | The number of times products from these two categories have been purchased by the same customer, on the day the second product was purchased, weighted by the number of days between the first and second product purchases. | |
INFLATION | double | Yes | A value used to ensure that recent purchase pairs are recommended more strongly than pairs purchased farther in the past. | |
PURCHASE_PURCHASE_INFLATED | double | Yes | The INFLATION value times the PURCHASE_PURCHASE_AFFINITY value. | |
PURCHASE_PURCHASE_TOTAL_SPREAD | int | Yes | Spread is defined as the number of days between purchases for each product in a product pair. For example, if Product 1 is purchased on April 1, and Product 2 is purchased on April 5, the spread is 4. The Purchase to Purchase Total Spread represents the sum of the spreads for all product pairs. |