This table stores data about how often pairs of products are purchased together. It is used for the Affinity Selling feature of ATG Commerce.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
PRODUCT_1_ID | int | No | Primary key component. Foreign key to ARF_PRODUCT.ID column. | |
PRODUCT_2_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. |
PURCHASE_PURCHASE_OCCURRENCES | int | Yes | The number of times these two products have been purchased by the same customer, on the day the second product was purchased. | |
PURCHASE_PURCHASE_AFFINITY | double | Yes | The number of times these two products 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. The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right. | |
PURCHASE_BROWSE_OCCURRENCES | int | Yes | Reserved for future use. | |
PURCHASE_BROWSE_AFFINITY | double | Yes | Reserved for future use. | |
BROWSE_BROWSE_OCCURRENCES | int | Yes | Reserved for future use. | |
BROWSE_BROWSE_AFFINITY | double | Yes | Reserved for future use. | |
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. |