qry_history


Description

Records changes to canned query. Old query is the JSON returned by _oat.json_qry_query_complete
right before the update.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
query_id int4 10 null
date_retired timestamp 29,6 null
old_query json 2147483647 null
userid text 2147483647 null

Table contained 2166 rows

Indexes

Constraint Name Type Sort Column(s)
qry_history_pkey Primary key Asc/Asc query_id + date_retired

Diagram producer might be missing

No diagrams were produced please see application output for any errors