Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| query_id | serial | 10 | √ | nextval('_oat.qry_query_query_id_seq'::regclass) |
|
|
Primary key identifying the query. |
|
| title | text | 2147483647 | null |
|
|
A title for this query. |
||
| description | text | 2147483647 | null |
|
|
A description of this query. |
||
| query | text | 2147483647 | null |
|
|
The SQL for the canned query. |
||
| active | bool | 1 | null |
|
|
Show the query to most users if true; show to query editors regardless. |
||
| crosstab | bool | 1 | false |
|
|
Table contained 423 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| qry_query_pkey | Primary key | Asc | query_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors