sip.setting

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: setting_setting_group_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('sip.setting_id_seq'::regclass)
setting_group FK	`integer`	No		→ sip.setting_group(id)
name	`text`	No
description	`text`	No
value	`json`	No

id PK

integer

nextval('sip.setting_id_seq'::regclass)

setting_group FK

integer

→ sip.setting_group(id)

name

text

description

text

value

json

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	`setting_setting_group_fkey`

setting_group

sip.setting_group(id)

CASCADE

NO ACTION

DEFERRED

setting_setting_group_fkey

Unique Constraints

name_once_per_inst: (setting_group, name)

Indexes

Index Method Definition

Index	Method	Definition
`setting_pkey` PK	btree	`CREATE UNIQUE INDEX setting_pkey ON sip.setting USING btree (id)`
`name_once_per_inst` UNIQUE	btree	`CREATE UNIQUE INDEX name_once_per_inst ON sip.setting USING btree (setting_group, name)`

setting_pkey PK

btree

CREATE UNIQUE INDEX setting_pkey ON sip.setting USING btree (id)

name_once_per_inst UNIQUE

btree

CREATE UNIQUE INDEX name_once_per_inst ON sip.setting USING btree (setting_group, name)