item |
VARCHAR |
Name of item that the user viewed or bought. Corresponds to the user table column item_column. |
usr |
VARCHAR |
Unique user identifier. Corresponds to the user table column user_column. |
recommendation |
DOUBLE PRECISION |
Recommendation score. If the user viewed or bought the item, this value is the user preference score for the item (in preference_column in the user table). Otherwise, this value is the recommendation score calculated by the function. |
new_reco_flag |
INTEGER |
New recommendation flag, which indicates whether the item is to be recommended to the user. This value is 1 (yes) if the user never viewed or bought the item and the recommendation score is greater than 0; 0 (no) otherwise. |
accumulate_item_column
|
Same as in item table |
Column copied from the item table. |
accumulate_user_column
|
Same as in user table |
Column copied from the user table. |