action_trigger.environment

↑ action_trigger schema

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('action_trigger.environment_id_seq'::regclass)

event_def FK

integer

No

→ action_trigger.event_definition(id)

path

text

Yes

collector FK

text

Yes

→ action_trigger.collector(module)

label

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

collector

action_trigger.collector(module)

NO ACTION

NO ACTION

DEFERRED

environment_collector_fkey

event_def

action_trigger.event_definition(id)

NO ACTION

NO ACTION

DEFERRED

environment_event_def_fkey

Unique Constraints

  • env_event_label_once: (event_def, label)

Check Constraints

  • environment_label_check: CHECK label <> ALL (ARRAY['result'::text, 'target'::text, 'event'::text])

Indexes

Index Method Definition

environment_pkey PK

btree

CREATE UNIQUE INDEX environment_pkey ON action_trigger.environment USING btree (id)

env_event_label_once UNIQUE

btree

CREATE UNIQUE INDEX env_event_label_once ON action_trigger.environment USING btree (event_def, label)
Previous
Next