action_trigger.event_def_group_member

Cascading Deletes: Deleting rows from this table will cascade to: action_trigger.event_def_group.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('action_trigger.event_def_group_member_id_seq'::regclass)
grp FK	`integer`	No		→ action_trigger.event_def_group(id)
event_def FK	`integer`	No		→ action_trigger.event_definition(id)
sortable	`boolean`	No	true
holdings	`boolean`	No	false
external	`boolean`	No	false
name	`text`	No

id PK

integer

nextval('action_trigger.event_def_group_member_id_seq'::regclass)

grp FK

integer

→ action_trigger.event_def_group(id)

event_def FK

integer

→ action_trigger.event_definition(id)

sortable

boolean

true

holdings

boolean

false

external

boolean

false

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
`event_def`	action_trigger.event_definition(id)	RESTRICT	CASCADE	DEFERRED	`event_def_group_member_event_def_fkey`
`grp`	action_trigger.event_def_group(id)	CASCADE	CASCADE	DEFERRED	`event_def_group_member_grp_fkey`

event_def

action_trigger.event_definition(id)

RESTRICT

CASCADE

DEFERRED

event_def_group_member_event_def_fkey

grp

action_trigger.event_def_group(id)

CASCADE

DEFERRED

event_def_group_member_grp_fkey

Indexes

Index Method Definition

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

event_def_group_member_pkey PK

btree

CREATE UNIQUE INDEX event_def_group_member_pkey ON action_trigger.event_def_group_member USING btree (id)