query.stored_query

↑ query schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: stored_query_from_clause_fkey, stored_query_having_clause_fkey, stored_query_limit_count_fkey, stored_query_offset_count_fkey, stored_query_where_clause_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('query.stored_query_id_seq'::regclass)
type	`text`	No
use_all	`boolean`	No	false
use_distinct	`boolean`	No	false
from_clause FK	`integer`	Yes		→ query.from_relation(id)
where_clause FK	`integer`	Yes		→ query.expression(id)
having_clause FK	`integer`	Yes		→ query.expression(id)
limit_count FK	`integer`	Yes		→ query.expression(id)
offset_count FK	`integer`	Yes		→ query.expression(id)

id PK

integer

nextval('query.stored_query_id_seq'::regclass)

type

text

use_all

boolean

false

use_distinct

boolean

false

from_clause FK

integer

Yes

→ query.from_relation(id)

where_clause FK

integer

Yes

→ query.expression(id)

having_clause FK

integer

Yes

→ query.expression(id)

limit_count FK

integer

Yes

→ query.expression(id)

offset_count FK

integer

Yes

→ query.expression(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`from_clause`	query.from_relation(id)	NO ACTION	NO ACTION	DEFERRED	`stored_query_from_clause_fkey`
`having_clause`	query.expression(id)	NO ACTION	NO ACTION	DEFERRED	`stored_query_having_clause_fkey`
`limit_count`	query.expression(id)	NO ACTION	NO ACTION	DEFERRED	`stored_query_limit_count_fkey`
`offset_count`	query.expression(id)	NO ACTION	NO ACTION	DEFERRED	`stored_query_offset_count_fkey`
`where_clause`	query.expression(id)	NO ACTION	NO ACTION	DEFERRED	`stored_query_where_clause_fkey`

from_clause

query.from_relation(id)

NO ACTION

DEFERRED

stored_query_from_clause_fkey

having_clause

query.expression(id)

NO ACTION

DEFERRED

stored_query_having_clause_fkey

limit_count

query.expression(id)

NO ACTION

DEFERRED

stored_query_limit_count_fkey

offset_count

query.expression(id)

NO ACTION

DEFERRED

stored_query_offset_count_fkey

where_clause

query.expression(id)

NO ACTION

DEFERRED

stored_query_where_clause_fkey

Check Constraints

query_type: CHECK type = ANY (ARRAY['SELECT'::text, 'UNION'::text, 'INTERSECT'::text, 'EXCEPT'::text])

Indexes

Index Method Definition

Index	Method	Definition
`stored_query_pkey` PK	btree	`CREATE UNIQUE INDEX stored_query_pkey ON query.stored_query USING btree (id)`

stored_query_pkey PK

btree

CREATE UNIQUE INDEX stored_query_pkey ON query.stored_query USING btree (id)

Referenced By

The following tables have foreign keys pointing to query.stored_query (7 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
action.fieldset	`stored_query`	`id`	`fieldset_stored_query_fkey`
query.expression	`subquery`	`id`	`expression_subquery_fkey`
query.from_relation	`subquery`	`id`	`from_relation_subquery_fkey`
query.order_by_item	`stored_query`	`id`	`order_by_item_stored_query_fkey`
query.query_sequence	`child_query`	`id`	`query_sequence_child_query_fkey`
query.query_sequence	`parent_query`	`id`	`query_sequence_parent_query_fkey`
query.select_item	`stored_query`	`id`	`select_item_stored_query_fkey`