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.

 
loading table of contents...