cprod — Clustered. Stores contextual product prodding history. This makes sure people are not pestered by specific prodding when they do not want it anymore.
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 |