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 |