Stores queries submitted to ATG Search; that is, the end user’s question after preliminary processing has taken place.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| smallint | No | Identifier; primary key. | |
| timestamp | Yes | The date and time the query took place. | |
| varchar | 40 | No | Foreign key to |
| integer | No | Foreign key to | |
| varchar | 40 | No | Natural ID of the query. |
| integer | No | Foreign key to | |
| varchar | 40 | No | Foreign key to |
| smallint | No | Foreign key to | |
| smallint | No | Foreign key to | |
| smallint | No | Foreign key to | |
| tinyint | No | Foreign key to | |
| integer | No | Foreign key to | |
| integer | No | Foreign key to | |
| smallint | No | Foreign key to | |
| bigint | No | Foreign key to | |
| integer | No | Foreign key to | |
| integer | No | Foreign key to | |
| integer | No | Foreign key to | |
| integer | No | Foreign key to | |
| integer | No | Foreign key to | |
| integer | No | Identifies a question topic. Foreign key to | |
| integer | No | Identifies a constraint topic. Foreign key to | |
| smallint | No | Foreign key to | |
| integer | No | Foreign key to | |
| integer | No | Response time of Search engine in ms. | |
| integer | No | Top score of returned results. | |
| integer | No | Count of results for this query. | |
| one-digit | No | Indicates whether this is the final query in the session. 0 = No 1 = Yes | |
| varchar | 128 | Yes | ID of the user session. |
| smallint | No | Foreign key to ARF_SITE.ID. | |
| integer | No | Foreign key to ARF_SRCH_SITE_CONSTR.ID. |