cprod

cprod — Clustered. Stores contextual product prodding history. This makes sure people are not pestered by specific prodding when they do not want it anymore.

cprod

Column name Type Null Default Description
userid int unsigned   0  
cprodid smallint unsigned   0  
firstshowtime int unsigned YES The time when it was first highlighted to them (not at the show everything page).
recentshowtime int unsigned YES A recent showing time. Perhaps not _the_ most recent, though.
acktime int unsigned YES The time the user saw the box, either by clicking next/no/more info.
nothankstime int unsigned YES Also a boolean: time/if user does not want to see it again.
clickthrutime int unsigned YES The time when the user clicked for more information.
clickthruver smallint unsigned YES  
Key name Type Column(s)
PRIMARY PRIMARY