query.order_by_item

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

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('query.order_by_item_id_seq'::regclass)
stored_query FK	`integer`	No		→ query.stored_query(id)
seq_no	`integer`	No
expression FK	`integer`	No		→ query.expression(id)

id PK

integer

nextval('query.order_by_item_id_seq'::regclass)

stored_query FK

integer

→ query.stored_query(id)

seq_no

integer

expression FK

integer

→ 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
`expression`	query.expression(id)	CASCADE	NO ACTION	DEFERRED	`order_by_item_expression_fkey`
`stored_query`	query.stored_query(id)	CASCADE	NO ACTION	DEFERRED	`order_by_item_stored_query_fkey`

expression

query.expression(id)

CASCADE

NO ACTION

DEFERRED

order_by_item_expression_fkey

stored_query

query.stored_query(id)

CASCADE

NO ACTION

DEFERRED

order_by_item_stored_query_fkey

Unique Constraints

order_by_sequence: (stored_query, seq_no)

Indexes

Index Method Definition

Index	Method	Definition
`order_by_item_pkey` PK	btree	`CREATE UNIQUE INDEX order_by_item_pkey ON query.order_by_item USING btree (id)`
`order_by_sequence` UNIQUE	btree	`CREATE UNIQUE INDEX order_by_sequence ON query.order_by_item USING btree (stored_query, seq_no)`

order_by_item_pkey PK

btree

CREATE UNIQUE INDEX order_by_item_pkey ON query.order_by_item USING btree (id)

order_by_sequence UNIQUE

btree

CREATE UNIQUE INDEX order_by_sequence ON query.order_by_item USING btree (stored_query, seq_no)