sip.filter

Cascading Deletes: Deleting rows from this table will cascade to: sip.setting_group.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('sip.filter_id_seq'::regclass)
enabled	`boolean`	No	false
setting_group FK	`integer`	No		→ sip.setting_group(id)
identifier	`text`	No
strip	`boolean`	No	false
replace_with	`text`	Yes

id PK

integer

nextval('sip.filter_id_seq'::regclass)

enabled

boolean

false

setting_group FK

integer

→ sip.setting_group(id)

identifier

text

strip

boolean

false

replace_with

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`setting_group`	sip.setting_group(id)	CASCADE	NO ACTION	DEFERRED	`filter_setting_group_fkey`

setting_group

sip.setting_group(id)

CASCADE

NO ACTION

DEFERRED

filter_setting_group_fkey

Indexes

Index Method Definition

Index	Method	Definition
`filter_pkey` PK	btree	`CREATE UNIQUE INDEX filter_pkey ON sip.filter USING btree (id)`

filter_pkey PK

btree

CREATE UNIQUE INDEX filter_pkey ON sip.filter USING btree (id)