View source

This page documents the database table "aggclick" as used by [[Inverse Search]] and [[Woogle4MediaWiki]] for the aggregate query logging.

See also [[Aggquery table]]

{| {{table}}
| align="center" style="background:#f0f0f0;"|'''field'''
| align="center" style="background:#f0f0f0;"|'''description'''
| align="center" style="background:#f0f0f0;"|'''Test'''
| align="center" style="background:#f0f0f0;"|'''fix/upd'''
| align="center" style="background:#f0f0f0;"|'''change on'''
| align="center" style="background:#f0f0f0;"|'''issue/info'''
| align="center" style="background:#f0f0f0;"|'''usage'''
| align="center" style="background:#f0f0f0;"|'''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)||||
|-
| 
|}