query.case_branch

Cascading Deletes: Rows in this table will be automatically deleted when rows are deleted from: query.expression.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: case_branch_condition_fkey, case_branch_parent_expr_fkey, case_branch_result_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('query.case_branch_id_seq'::regclass)
parent_expr FK	`integer`	No		→ query.expression(id)
seq_no	`integer`	No
condition FK	`integer`	Yes		→ query.expression(id)
result FK	`integer`	No		→ query.expression(id)

id PK

integer

nextval('query.case_branch_id_seq'::regclass)

parent_expr FK

integer

→ query.expression(id)

seq_no

integer

condition FK

integer

Yes

→ query.expression(id)

result 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
`condition`	query.expression(id)	NO ACTION	NO ACTION	DEFERRED	`case_branch_condition_fkey`
`parent_expr`	query.expression(id)	CASCADE	NO ACTION	DEFERRED	`case_branch_parent_expr_fkey`
`result`	query.expression(id)	NO ACTION	NO ACTION	DEFERRED	`case_branch_result_fkey`

condition

query.expression(id)

NO ACTION

DEFERRED

case_branch_condition_fkey

parent_expr

query.expression(id)

CASCADE

NO ACTION

DEFERRED

case_branch_parent_expr_fkey

result

query.expression(id)

NO ACTION

DEFERRED

case_branch_result_fkey

Unique Constraints

case_branch_parent_seq: (parent_expr, seq_no)

Indexes

Index Method Definition

Index	Method	Definition
`case_branch_pkey` PK	btree	`CREATE UNIQUE INDEX case_branch_pkey ON query.case_branch USING btree (id)`
`case_branch_parent_seq` UNIQUE	btree	`CREATE UNIQUE INDEX case_branch_parent_seq ON query.case_branch USING btree (parent_expr, seq_no)`

case_branch_pkey PK

btree

CREATE UNIQUE INDEX case_branch_pkey ON query.case_branch USING btree (id)

case_branch_parent_seq UNIQUE

btree

CREATE UNIQUE INDEX case_branch_parent_seq ON query.case_branch USING btree (parent_expr, seq_no)