 |  | |
| HomePrev | Chapter 26. Database Schema | Next |
|---|---|---|
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 |
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 |
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]))) |
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 |
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.environment | action_trigger.event |
| action_trigger.event_params |
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 |
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,
|
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 |
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 |
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 |