Schema action_trigger
HomePrev Chapter 1. Database Schema Next

Schema action_trigger

Table: cleanup

Columns: 

field name : datatype -- parameters, contraints and notes
module : text -- PRIMARY KEY,
description : text --

Tables referencing action_trigger.event_definition via Foreign Key Constraints: 

action_trigger.event_definition 

Table: collector

Columns: 

field name : datatype -- parameters, contraints and notes
module : text -- PRIMARY KEY,
description : text --

Tables referencing action_trigger.environment via Foreign Key Constraints: 

action_trigger.environment 

Table: environment

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
event_def : integer -- UNIQUE#1, NOT NULL, REFERENCES action_trigger.event_definition.
path : text --
collector : text -- REFERENCES action_trigger.collector.
label : text -- UNIQUE#1,

Constraints: 

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

Table: event

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
target : bigint -- NOT NULL,
event_def : integer -- REFERENCES action_trigger.event_definition.
add_time : timestamp with time zone -- NOT NULL, DEFAULT now(),
run_time : timestamp with time zone -- NOT NULL,
start_time : timestamp with time zone --
update_time : timestamp with time zone --
complete_time : timestamp with time zone --
update_process : integer --
state : text -- NOT NULL, DEFAULT 'pending'::text,
user_data : text --
template_output : bigint -- REFERENCES action_trigger.event_output.
error_output : bigint -- REFERENCES action_trigger.event_output.
async_output : bigint -- REFERENCES action_trigger.event_output.

Constraints: 

event_state_check : 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 : CHECK (((user_data IS NULL) OR is_json(user_data)))

Indexes: 

atev_target_def_idx : target, event_def

Table: event_definition

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
active : boolean -- NOT NULL, DEFAULT true,
owner : integer -- UNIQUE#2, UNIQUE#1, NOT NULL, REFERENCES actor.org_unit.
name : text -- UNIQUE#2, NOT NULL,
hook : text -- UNIQUE#1, NOT NULL, REFERENCES action_trigger.hook.
validator : text -- UNIQUE#1, NOT NULL, REFERENCES action_trigger.validator.
reactor : text -- UNIQUE#1, NOT NULL, REFERENCES action_trigger.reactor.
cleanup_success : text -- REFERENCES action_trigger.cleanup.
cleanup_failure : text -- REFERENCES action_trigger.cleanup.
delay : interval -- UNIQUE#1, NOT NULL, DEFAULT '00:05:00'::interval,
max_delay : interval --
usr_field : text --
opt_in_setting : text -- REFERENCES config.usr_setting_type.
delay_field : text -- UNIQUE#1,
group_field : text --
template : text --
granularity : text --

Tables referencing action_trigger.environment via Foreign Key Constraints: 

action_trigger.environmentaction_trigger.event
action_trigger.event_params 

Table: event_output

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
create_time : timestamp with time zone -- NOT NULL, DEFAULT now(),
is_error : boolean -- NOT NULL, DEFAULT false,
data : text -- NOT NULL,

Tables referencing action_trigger.event via Foreign Key Constraints: 

action_trigger.event 

Table: event_params

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
event_def : integer -- UNIQUE#1, NOT NULL, REFERENCES action_trigger.event_definition.
param : text -- UNIQUE#1, NOT NULL,
value : text -- NOT NULL,

Table: hook

Columns: 

field name : datatype -- parameters, contraints and notes
key : text -- PRIMARY KEY,
core_type : text -- NOT NULL,
description : text --
passive : boolean -- NOT NULL, DEFAULT false,

Tables referencing action_trigger.event_definition via Foreign Key Constraints: 

action_trigger.event_definition 

Table: reactor

Columns: 

field name : datatype -- parameters, contraints and notes
module : text -- PRIMARY KEY,
description : text --

Tables referencing action_trigger.event_definition via Foreign Key Constraints: 

action_trigger.event_definition 

Table: validator

Columns: 

field name : datatype -- parameters, contraints and notes
module : text -- PRIMARY KEY,
description : text --

Tables referencing action_trigger.event_definition via Foreign Key Constraints: 

action_trigger.event_definition 

Prev Up Next
Schema action Home Schema actor

Report any errors in this documentation using Launchpad.
Documentation for Evergreen version 2.2
Copyright © 2007-2012, Memebers of the Evergreen Project