action_trigger.alternate_template

↑ action_trigger schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id	`integer`	No	nextval('action_trigger.alternate_template_id_seq'::regclass)
event_def FK	`integer`	Yes		→ action_trigger.event_definition(id)
template	`text`	Yes
active	`boolean`	Yes	true
locale FK	`text`	Yes		→ config.i18n_locale(code)
message_title	`text`	Yes
message_template	`text`	Yes

integer

nextval('action_trigger.alternate_template_id_seq'::regclass)

event_def FK

integer

Yes

→ action_trigger.event_definition(id)

template

text

Yes

active

boolean

Yes

true

locale FK

text

Yes

→ config.i18n_locale(code)

message_title

text

Yes

message_template

text

Yes

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	`alternate_template_event_def_fkey`
`locale`	config.i18n_locale(code)	NO ACTION	NO ACTION	DEFERRED	`alternate_template_locale_fkey`

event_def

action_trigger.event_definition(id)

NO ACTION

DEFERRED

alternate_template_event_def_fkey

locale

config.i18n_locale(code)

NO ACTION

DEFERRED

alternate_template_locale_fkey

Unique Constraints

alternate_template_event_def_locale_key: (event_def, locale)

Indexes

Index Method Definition

Index	Method	Definition
`alternate_template_event_def_locale_key` UNIQUE	btree	`CREATE UNIQUE INDEX alternate_template_event_def_locale_key ON action_trigger.alternate_template USING btree (event_def, locale)`

alternate_template_event_def_locale_key UNIQUE

btree

CREATE UNIQUE INDEX alternate_template_event_def_locale_key ON action_trigger.alternate_template USING btree (event_def, locale)