action_trigger.event_def_group

↑ action_trigger schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('action_trigger.event_def_group_id_seq'::regclass)
owner FK	`integer`	No		→ actor.org_unit(id)
hook FK	`text`	No		→ action_trigger.hook(key)
active	`boolean`	No	true
name	`text`	No

id PK

integer

nextval('action_trigger.event_def_group_id_seq'::regclass)

owner FK

integer

→ actor.org_unit(id)

hook FK

text

→ action_trigger.hook(key)

active

boolean

true

name

text

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`hook`	action_trigger.hook(key)	RESTRICT	CASCADE	DEFERRED	`event_def_group_hook_fkey`
`owner`	actor.org_unit(id)	RESTRICT	CASCADE	DEFERRED	`event_def_group_owner_fkey`

hook

action_trigger.hook(key)

RESTRICT

CASCADE

DEFERRED

event_def_group_hook_fkey

owner

actor.org_unit(id)

RESTRICT

CASCADE

DEFERRED

event_def_group_owner_fkey

Indexes

Index Method Definition

Index	Method	Definition
`event_def_group_pkey` PK	btree	`CREATE UNIQUE INDEX event_def_group_pkey ON action_trigger.event_def_group USING btree (id)`

event_def_group_pkey PK

btree

CREATE UNIQUE INDEX event_def_group_pkey ON action_trigger.event_def_group USING btree (id)

Referenced By

The following tables have foreign keys pointing to action_trigger.event_def_group (1 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
action_trigger.event_def_group_member	`grp`	`id`	`event_def_group_member_grp_fkey`

action_trigger.event_def_group_member

grp

id

event_def_group_member_grp_fkey