event_definition

72 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('action_trigger.event_definition_id_seq'::regclass)
alternate_template.event_def alternate_template_event_def_fkey R
environment.event_def environment_event_def_fkey R
event.event_def event_event_def_fkey R
event_def_group_member.event_def event_def_group_member_event_def_fkey R
event_params.event_def event_params_event_def_fkey R
active bool 1 true
owner int4 10 null
org_unit.id event_definition_owner_fkey R
name text 2147483647 null
hook text 2147483647 null
hook.key event_definition_hook_fkey R
validator text 2147483647 null
validator.module event_definition_validator_fkey R
reactor text 2147483647 null
reactor.module event_definition_reactor_fkey R
cleanup_success text 2147483647 √ null
cleanup.module event_definition_cleanup_success_fkey R
cleanup_failure text 2147483647 √ null
cleanup.module event_definition_cleanup_failure_fkey R
delay interval 49,6 '00:05:00'::interval
max_delay interval 49,6 √ null
repeat_delay interval 49,6 √ null
usr_field text 2147483647 √ null
opt_in_setting text 2147483647 √ null
usr_setting_type.name event_definition_opt_in_setting_fkey R
delay_field text 2147483647 √ null
group_field text 2147483647 √ null
template text 2147483647 √ null
granularity text 2147483647 √ null
context_usr_path text 2147483647 √ null
context_library_path text 2147483647 √ null
context_bib_path text 2147483647 √ null
context_item_path text 2147483647 √ null
message_template text 2147483647 √ null
message_usr_path text 2147483647 √ null
message_library_path text 2147483647 √ null
message_title text 2147483647 √ null
retention_interval interval 49,6 √ null

Indexes

Constraint Name Type Sort Column(s)
event_definition_pkey Primary key Asc id
ev_def_name_owner_once Must be unique Asc/Asc owner + name
ev_def_owner_hook_val_react_clean_delay_once Must be unique Asc/Asc/Asc/Asc/Asc/Asc owner + hook + validator + reactor + delay + delay_field

Relationships

Close relationships within degrees of separation