`pres.attendance_alert_definitions`

Schema: pres
English table: pres.attendance_alert_definitions
Italian original table: pres.tab_avvisi
Description: User-defined rules for attendance alerts and anomaly detection.

Overview

Columns: 26
Primary key: id
Outgoing foreign keys: 1
Incoming foreign keys: 1
Indexes: 1

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
`id`	`id`	`integer`	NO		Primary Key.
`aad_alert_id`	`av_id`	`integer`	NO		Internal alert identifier.
`tenant_id`	`tenant_id`	`integer`	NO		Tenant identifier for data isolation.
`aad_code`	`cod_av`	`character(4)`	NO	`''::bpchar`	Unique mnemonic code for the alert definition.
`aad_description`	`av_descrizione`	`character(80)`	NO	`''::bpchar`	Human-readable description of the alert.
`aad_message_template`	`av_messaggio`	`text`	NO	`''::text`	The message text to be displayed or sent when the alert triggers.
`aad_type`	`av_tipo`	`numeric(1,0)`	NO	`0`	Category or type of alert.
`aad_periodicity`	`av_periodo`	`numeric(1,0)`	NO	`0`	Frequency or period considered for the alert calculation.
`aad_value_type_1`	`av_valore_tipo1`	`numeric(1,0)`	NO	`0`	Value of aad value type 1.
`aad_value_type_2`	`av_valore_tipo2`	`character(10)`	NO	`''::bpchar`	Value of aad value type 2.
`aad_calculation_expression`	`av_valore_expr`	`text`	NO	`''::text`	Formula or SQL-like expression used to evaluate the alert condition.
`aad_c1_operator`	`av_cri1_oper`	`numeric(1,0)`	NO	`0`	Comparison operator for the first criterion.
`aad_c1_min_value`	`av_cri1_minimo`	`numeric(4,0)`	YES	`0`	Lower bound for the first criterion.
`aad_c1_max_value`	`av_cri1_massimo`	`numeric(4,0)`	YES	`0`	Upper bound for the first criterion.
`aad_c1_logic_operator`	`av_cri1_logic`	`numeric(1,0)`	NO	`0`	Logical operator (AND/OR) to connect with the next criterion.
`aad_c2_operator`	`av_cri2_oper`	`numeric(1,0)`	NO	`0`	Value of aad c2 operator.
`aad_c2_min_value`	`av_cri2_minimo`	`numeric(4,0)`	YES	`0`	Value of aad c2 min value.
`aad_c2_max_value`	`av_cri2_massimo`	`numeric(4,0)`	YES	`0`	Value of aad c2 max value.
`aad_c2_logic_operator`	`av_cri2_logic`	`numeric(1,0)`	NO	`0`	Value of aad c2 logic operator.
`aad_c3_operator`	`av_cri3_oper`	`numeric(1,0)`	NO	`0`	Value of aad c3 operator.
`aad_c3_min_value`	`av_cri3_minimo`	`numeric(4,0)`	YES	`0`	Value of aad c3 min value.
`aad_c3_max_value`	`av_cri3_massimo`	`numeric(4,0)`	YES	`0`	Value of aad c3 max value.
`aad_c3_logic_operator`	`av_cri3_logic`	`numeric(1,0)`	NO	`0`	Value of aad c3 logic operator.
`aad_is_enabled_for_web`	`av_web`	`boolean`	NO	`false`	If true, the alert is visible/active on the web portal.
`aad_block_anomaly_reporting_legacy`	`avvi_blocca_segnalazione_anomalia`	`boolean`	NO	`false`	Boolean flag for aad block anomaly reporting legacy.
`aad_block_anomaly_reporting`	`av_blocca_segnalazione_anomalia`	`boolean`	NO	`true`	If true, prevents the system from flagging this condition as a blocking anomaly.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
`fk_aad_tenant`	`tenant_id`	`cloud.tenants`	`ten_internal_id`	CASCADE	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
`pres.attendance_alerts`	`fk_aal_alert_type`	`tenant_id, aal_alert_code`	`tenant_id, aad_code`

Constraints

Primary key: pk_attendance_alert_definitions → id
Unique: c_uk_aad_tenant_alert_id → tenant_id, aad_alert_id
Unique: c_uk_aad_tenant_code → tenant_id, aad_code

Indexes

Name	Unique	Method	Columns / expression
`idx_aad_tenant_alert_id`	NO	`btree`	`tenant_id, aad_alert_id`

Back to main index
[Back to pres index]../)

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​