query.select_item

Cascading Deletes: Deleting rows from this table will cascade to: query.stored_query.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: select_item_expression_fkey, select_item_stored_query_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('query.select_item_id_seq'::regclass)
stored_query FK	`integer`	No		→ query.stored_query(id)
seq_no	`integer`	No
expression FK	`integer`	No		→ query.expression(id)
column_alias	`text`	Yes
grouped_by	`boolean`	No	false

id PK

integer

nextval('query.select_item_id_seq'::regclass)

stored_query FK

integer

→ query.stored_query(id)

seq_no

integer

expression FK

integer

→ query.expression(id)

column_alias

text

Yes

grouped_by

boolean

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`expression`	query.expression(id)	NO ACTION	NO ACTION	DEFERRED	`select_item_expression_fkey`
`stored_query`	query.stored_query(id)	CASCADE	NO ACTION	DEFERRED	`select_item_stored_query_fkey`

expression

query.expression(id)

NO ACTION

DEFERRED

select_item_expression_fkey

stored_query

query.stored_query(id)

CASCADE

NO ACTION

DEFERRED

select_item_stored_query_fkey

Unique Constraints

select_sequence: (stored_query, seq_no)

Indexes

Index Method Definition

Index	Method	Definition
`select_item_pkey` PK	btree	`CREATE UNIQUE INDEX select_item_pkey ON query.select_item USING btree (id)`
`select_sequence` UNIQUE	btree	`CREATE UNIQUE INDEX select_sequence ON query.select_item USING btree (stored_query, seq_no)`

select_item_pkey PK

btree

CREATE UNIQUE INDEX select_item_pkey ON query.select_item USING btree (id)

select_sequence UNIQUE

btree

CREATE UNIQUE INDEX select_sequence ON query.select_item USING btree (stored_query, seq_no)