Constraints

23 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

event_def_group_hook_fkey

event_def_group.hook

hook.key

Restrict delete

event_def_group_owner_fkey

event_def_group.owner

Restrict delete

event_params_event_def_fkey

event_params.event_def

event_definition.id

Restrict delete

environment_collector_fkey

environment.collector

collector.module

Restrict delete

environment_event_def_fkey

environment.event_def

event_definition.id

Restrict delete

event_def_group_member_grp_fkey

event_def_group_member.grp

event_def_group.id

Cascade on delete

event_def_group_member_event_def_fkey

event_def_group_member.event_def

event_definition.id

Restrict delete

event_definition_hook_fkey

event_definition.hook

hook.key

Restrict delete

event_definition_validator_fkey

event_definition.validator

validator.module

Restrict delete

event_definition_opt_in_setting_fkey

event_definition.opt_in_setting

usr_setting_type.name

Restrict delete

event_definition_cleanup_success_fkey

event_definition.cleanup_success

cleanup.module

Restrict delete

event_definition_reactor_fkey

event_definition.reactor

reactor.module

Restrict delete

event_definition_cleanup_failure_fkey

event_definition.cleanup_failure

cleanup.module

Restrict delete

event_definition_owner_fkey

event_definition.owner

Restrict delete

event_error_output_fkey

event.error_output

event_output.id

Restrict delete

event_event_def_fkey

event.event_def

event_definition.id

Restrict delete

event_context_library_fkey

event.context_library

Restrict delete

event_async_output_fkey

event.async_output

event_output.id

Restrict delete

event_template_output_fkey

event.template_output

event_output.id

Restrict delete

event_context_bib_fkey

event.context_bib

record_entry.id

Restrict delete

event_context_user_fkey

event.context_user

usr.id

Restrict delete

alternate_template_locale_fkey

alternate_template.locale

i18n_locale.code

Restrict delete

alternate_template_event_def_fkey

alternate_template.event_def

event_definition.id

Restrict delete

Check Constraints

Table	Constraint Name	Constraint
environment	environment_label_check	((label <> ALL (ARRAY['result'::text, 'target'::text, 'event'::text])))
event	event_state_check	((state = ANY (ARRAY['pending'::text, 'invalid'::text, 'found'::text, 'collecting'::text, 'collected'::text, 'validating'::text, 'valid'::text, 'reacting'::text, 'reacted'::text, 'cleaning'::text, 'complete'::text, 'error'::text])))
event	event_user_data_check	(((user_data IS NULL) OR is_json(user_data)))