Batch

Batches record the execution of indicator groups.

Table: batch

Attribute	Type	Description
id	Integer	Unique identifier of the batch, used as a primary key.
status	Text	Indicate the current state of the batch.
created_date	Timestamp	Record created date.
updated_date	Timestamp	Record last updated date.
created_by_id	Integer	Foreign key of the user table, to indicate which user created the record.
updated_by_id	Integer	Foreign key of the user table, to indicate which user updated the record.
user_group_id	Integer	Foreign key of the user_group table, to indicate to which user group the record belongs to.
indicator_group_id	Integer	Foreign key of the indicator_group table, to indicate for which indicator group the batch was executed.

---

Session

Sessions record the execution of indicators within a batch.

Table: session

Attribute	Type	Description
id	Integer	Unique identifier of the session, used as a primary key.
status	Text	Indicate the current state of the session.
alert_operator	Text	Operator used to compare the result dataset of the indicator with the alert threshold.
alert_threshold	Float	Numeric value used to evaluate the result dataset of the indicator.
nb_records	Integer	Number of records in the result dataset of the indicator.
nb_records_alert	Integer	Number of records which triggered an alert in the result dataset of the indicator.
nb_records_no_alert	Integer	Number of records which did not trigger an alert in the result dataset of the indicator.
created_date	Timestamp	Record created date.
updated_date	Timestamp	Record last updated date.
created_by_id	Integer	Foreign key of the user table, to indicate which user created the record.
updated_by_id	Integer	Foreign key of the user table, to indicate which user updated the record.
user_group_id	Integer	Foreign key of the user_group table, to indicate to which user group the record belongs to.
batch_id	Integer	Foreign key of the batch table, to indicate during which batch the session was executed.
indicator_id	Integer	Foreign key of the indicator table, to indicate for which indicator the session was executed.