pres.attendance_alerts

Schema: pres
English table: pres.attendance_alerts
Italian original table: pres.avvisi
Description: Alerts and anomalies generated during the timesheet calculation process (e.g., missing clock-ins, excessive lateness).

Overview

• Columns: 7
• Primary key: id
• Outgoing foreign keys: 3
• Incoming foreign keys: 0
• Indexes: 2

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Identifier of the related record.
aal_id	avvi_id	integer	NO		Unique identifier for the alert instance.
tenant_id	tenant_id	integer	NO		Identifier of the related tenant.
aal_employment_id	avvi_rap_id	integer	NO	0	The employee affected by the alert.
aal_date	avvi_data	date	NO		The specific date the alert refers to.
aal_alert_code	avvi_codice	character(4)	NO	''::bpchar	Reference code for the type of anomaly (e.g., missing clock-in).
aal_is_deleted	avvi_deleted	boolean	NO	false	Soft-delete flag for the alert.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_aal_alert_type	tenant_id, aal_alert_code	pres.attendance_alert_definitions	tenant_id, aad_code	CASCADE	RESTRICT
fk_aal_tenant	tenant_id	cloud.tenants	ten_internal_id	CASCADE	CASCADE
fk_avvisi_avvi_rap_id_to_rapporti	tenant_id, aal_employment_id	hr.employment_relationships	tenant_id, er_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_attendance_alerts → id
• Unique: c_uk_aal_code_tenant → tenant_id, aal_alert_code
• Unique: c_uk_aal_id_tenant → tenant_id, aal_id

Indexes

Name	Unique	Method	Columns / expression
idx_aal_date_lookup	NO	btree	tenant_id, aal_date
idx_aal_employment_date_lookup	NO	btree	tenant_id, aal_employment_id, aal_date

Navigation

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