query.query_sequence

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

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

Columns

Column Type Nullable Default Notes

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

id PK

integer

nextval('query.query_sequence_id_seq'::regclass)

parent_query FK

integer

→ query.stored_query(id)

seq_no

integer

child_query FK

integer

→ query.stored_query(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`child_query`	query.stored_query(id)	CASCADE	NO ACTION	DEFERRED	`query_sequence_child_query_fkey`
`parent_query`	query.stored_query(id)	CASCADE	NO ACTION	DEFERRED	`query_sequence_parent_query_fkey`

child_query

query.stored_query(id)

CASCADE

NO ACTION

DEFERRED

query_sequence_child_query_fkey

parent_query

query.stored_query(id)

CASCADE

NO ACTION

DEFERRED

query_sequence_parent_query_fkey

Unique Constraints

query_query_seq: (parent_query, seq_no)

Indexes

Index Method Definition

Index	Method	Definition
`query_sequence_pkey` PK	btree	`CREATE UNIQUE INDEX query_sequence_pkey ON query.query_sequence USING btree (id)`
`query_query_seq` UNIQUE	btree	`CREATE UNIQUE INDEX query_query_seq ON query.query_sequence USING btree (parent_query, seq_no)`

query_sequence_pkey PK

btree

CREATE UNIQUE INDEX query_sequence_pkey ON query.query_sequence USING btree (id)

query_query_seq UNIQUE

btree

CREATE UNIQUE INDEX query_query_seq ON query.query_sequence USING btree (parent_query, seq_no)