action_trigger.event_params

↑ action_trigger schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('action_trigger.event_params_id_seq'::regclass)
event_def FK	`integer`	No		→ action_trigger.event_definition(id)
param	`text`	No
value	`text`	No

id PK

bigint

nextval('action_trigger.event_params_id_seq'::regclass)

event_def FK

integer

→ action_trigger.event_definition(id)

param

text

value

text

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`event_def`	action_trigger.event_definition(id)	NO ACTION	NO ACTION	DEFERRED	`event_params_event_def_fkey`

event_def

action_trigger.event_definition(id)

NO ACTION

DEFERRED

event_params_event_def_fkey

Unique Constraints

event_params_event_def_param_once: (event_def, param)

Indexes

Index Method Definition

Index	Method	Definition
`event_params_pkey` PK	btree	`CREATE UNIQUE INDEX event_params_pkey ON action_trigger.event_params USING btree (id)`
`event_params_event_def_param_once` UNIQUE	btree	`CREATE UNIQUE INDEX event_params_event_def_param_once ON action_trigger.event_params USING btree (event_def, param)`

event_params_pkey PK

btree

CREATE UNIQUE INDEX event_params_pkey ON action_trigger.event_params USING btree (id)

event_params_event_def_param_once UNIQUE

btree

CREATE UNIQUE INDEX event_params_event_def_param_once ON action_trigger.event_params USING btree (event_def, param)