hr.customer_activity_calendar

Schema: hr
English table: hr.customer_activity_calendar
Italian original table: hr.in_clienti_attivita_calendario
Description: Detailed calendar of scheduled activities for customers, derived from activity plans.

Overview

• Columns: 24
• Primary key: id
• Outgoing foreign keys: 3
• Incoming foreign keys: 0
• Indexes: 5

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Internal surrogate primary key.
cac_id	incliac_id	integer	NO		Unique identifier from the scheduling engine.
activity_plan_id	incliac_inclia_id	integer	NO		Reference to the originating activity plan.
employment_relationship_id	incliac_rap_id	integer	NO		The employee assigned to this specific calendar slot.
activity_date	incliac_data	date	NO		Scheduled date for the activity.
start_time	incliac_dalle	integer	NO		Original scheduled start time.
end_time	incliac_alle	integer	NO		Original scheduled end time.
day_of_week	incliac_giorno_settimana	integer	NO		Numerical day of the week (e.g. 1=Monday).
hours_count	incliac_num_ore	integer	NO		Total scheduled hours for this slot.
is_cancelled	incliac_annullato	boolean	NO		Flag indicating if the activity slot was cancelled.
is_confirmed	incliac_confermato	boolean	NO		Flag indicating if the activity has been confirmed/validated.
moved_employment_relationship_id	incliac_rap_id_spostato	integer	NO		Reference to the new employee if the activity was reassigned.
moved_on_date	incliac_data_spostato	integer	NO		The new date if the activity was rescheduled.
moved_start_time	incliac_dalle_spostato	integer	NO		The new start time if rescheduled.
moved_end_time	incliac_alle_spostato	integer	NO		The new end time if rescheduled.
moved_day_of_week	incliac_giorno_settimana_spostato	integer	NO		Numerical day of the week for the rescheduled date.
moved_hours_count	incliac_num_ore_spostato	integer	NO		Total hours for the rescheduled slot.
is_partial	incliac_parziale	boolean	NO		Flag indicating a partial fulfillment of the slot.
employee_start_time	incliac_dip_dalle	integer	NO		Actual start time reported by the employee.
employee_end_time	incliac_dip_alle	integer	NO		Actual end time reported by the employee.
employee_hours_count	incliac_dip_num_ore	integer	NO		Actual number of hours worked as reported by the employee.
tenant_id	tenant_id	integer	YES		Multi-tenancy identifier.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	JSON storage for custom fields.
_deleted	_deleted	boolean	YES	false	Technical soft delete flag.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_customer_activity_calendar_activity_plan	activity_plan_id, tenant_id	hr.customer_activity_schedules	cas_id, tenant_id	RESTRICT	RESTRICT
fk_customer_activity_calendar_employment	employment_relationship_id, tenant_id	hr.employment_relationships	er_id, tenant_id	RESTRICT	CASCADE
fk_customer_activity_calendar_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_customer_activity_calendar → id
• Unique: uk_customer_activity_calendar_cac_id → cac_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_cac_date_tenant	NO	btree	tenant_id, activity_date) WHERE (_deleted = false
idx_cac_employment_tenant	NO	btree	tenant_id, employment_relationship_id) WHERE (_deleted = false
idx_cac_external_id_tenant	NO	btree	tenant_id, cac_id) WHERE (_deleted = false
idx_cac_plan_tenant	NO	btree	tenant_id, activity_plan_id) WHERE (_deleted = false
idx_cac_tenant_base	NO	btree	tenant_id

Navigation

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