From TeamWeaverWiki
This page documents the database table "aggclick" as used by Inverse Search and Woogle4MediaWiki for the aggregate query logging.
See also Aggquery table
| field
| description
| Test
| fix/upd
| change on
| issue/info
| usage
| db_opt*
|
| id | id | | | | | | PK
|
| qid | qid/hashed query id | | x | | (=aggquery.qid) | | UNIQUE_IDX_C
|
| subject | uri of the clicked result | | x | | | | UNIQUE_IDX_C, UI
|
| clicks | total number of clicks on this result for query qid | | U | click | | |
|
| position | position of result in result list at last click | | U | click | | |
|
| recency (!) | beim erstellen = now(), beim update clicks() * recency + recency)/ getClicks+1 | | U | click | !!! | |
|
| firstdate | time of first click on this result for qid | | x | | | |
|
| lastdate | time of last click on this result for qid | | U | click | | |
|
| repoid | repositoryId | | x | | (one value for WooNative) | |
|
|
|