action.fieldset_col_val

Cascading Deletes: Deleting rows from this table will cascade to: action.fieldset.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('action.fieldset_col_val_id_seq'::regclass)
fieldset FK	`integer`	No		→ action.fieldset(id)
col	`text`	No
val	`text`	Yes

id PK

integer

nextval('action.fieldset_col_val_id_seq'::regclass)

fieldset FK

integer

→ action.fieldset(id)

col

text

val

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
`fieldset`	action.fieldset(id)	CASCADE	NO ACTION	DEFERRED	`fieldset_col_val_fieldset_fkey`

fieldset

action.fieldset(id)

CASCADE

NO ACTION

DEFERRED

fieldset_col_val_fieldset_fkey

Unique Constraints

fieldset_col_once_per_set: (fieldset, col)

Indexes

Index Method Definition

Index	Method	Definition
`fieldset_col_val_pkey` PK	btree	`CREATE UNIQUE INDEX fieldset_col_val_pkey ON action.fieldset_col_val USING btree (id)`
`fieldset_col_once_per_set` UNIQUE	btree	`CREATE UNIQUE INDEX fieldset_col_once_per_set ON action.fieldset_col_val USING btree (fieldset, col)`

fieldset_col_val_pkey PK

btree

CREATE UNIQUE INDEX fieldset_col_val_pkey ON action.fieldset_col_val USING btree (id)

fieldset_col_once_per_set UNIQUE

btree

CREATE UNIQUE INDEX fieldset_col_once_per_set ON action.fieldset_col_val USING btree (fieldset, col)