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.

 
loading table of contents...