event

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('action_trigger.event_id_seq'::regclass)
target int8 19 null
event_def int4 10 √ null
event_definition.id event_event_def_fkey R
add_time timestamptz 35,6 now()
run_time timestamptz 35,6 null
start_time timestamptz 35,6 √ null
update_time timestamptz 35,6 √ null
complete_time timestamptz 35,6 √ null
update_process int4 10 √ null
state text 2147483647 'pending'::text
user_data text 2147483647 √ null
template_output int8 19 √ null
event_output.id event_template_output_fkey R
error_output int8 19 √ null
event_output.id event_error_output_fkey R
async_output int8 19 √ null
event_output.id event_async_output_fkey R
context_user int4 10 √ null
usr.id event_context_user_fkey R
context_library int4 10 √ null
org_unit.id event_context_library_fkey R
context_bib int8 19 √ null
record_entry.id event_context_bib_fkey R
context_item int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
event_pkey Primary key Asc id
atev_async_output Performance Asc async_output
atev_context_item Performance Asc context_item
atev_context_library Performance Asc context_library
atev_context_user Performance Asc context_user
atev_def_state Performance Asc/Asc event_def + state
atev_error_output Performance Asc error_output
atev_target_def_idx Performance Asc/Asc target + event_def
atev_template_output Performance Asc template_output

Check Constraints

Constraint Name Constraint
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_user_data_check (((user_data IS NULL) OR is_json(user_data)))

Relationships

Close relationships within degrees of separation