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.

 
loading table of contents...