`hr.customer_activity_schedules`

Schema: hr
English table: hr.customer_activity_schedules
Italian original table: hr.in_clienti_pianifica_att
Description: Master schedule for recurring customer activities and service planning.

Overview

Columns: 35
Primary key: id
Outgoing foreign keys: 1
Incoming foreign keys: 2
Indexes: 8

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
`id`	`id`	`integer`	NO		Internal surrogate primary key.
`cas_id`	`inclia_id`	`integer`	NO		Unique identifier for the schedule within a tenant.
`cas_customer_location_id`	`inclia_inclise_id`	`integer`	NO		Reference to the customer site/location.
`cas_project_id`	`inclia_com_id`	`integer`	NO		Reference to the customer project.
`cas_project_link_id`	`inclia_coml_id`	`integer`	NO		Reference to the project link (assignment).
`cas_project_activity_id`	`inclia_comat_id`	`integer`	NO		Reference to the specific activity of the project.
`cas_start_date`	`inclia_dal`	`date`	NO		Start date of the scheduled period.
`cas_end_date`	`inclia_al`	`date`	NO		End date of the scheduled period.
`cas_slot1_start_time`	`inclia_fascia1_dalle`	`integer`	NO		Start time for the first time slot (minutes from midnight).
`cas_slot1_end_time`	`inclia_fascia1_alle`	`integer`	NO		End time for the first time slot (minutes from midnight).
`cas_slot2_start_time`	`inclia_fascia2_dalle`	`integer`	NO		Start time for the second time slot.
`cas_slot2_end_time`	`inclia_fascia2_alle`	`integer`	NO		End time for the second time slot.
`cas_hours_quantity`	`inclia_num_ore`	`integer`	NO		Number of hours planned.
`cas_people_quantity`	`inclia_num_persone`	`integer`	NO		Number of people required.
`cas_is_monday`	`inclia_lun`	`boolean`	NO		Flag indicating the activity is scheduled on Mondays.
`cas_is_tuesday`	`inclia_mar`	`boolean`	NO		Flag indicating the activity is scheduled on Tuesdays.
`cas_is_wednesday`	`inclia_mer`	`boolean`	NO		Flag indicating the activity is scheduled on Wednesdays.
`cas_is_thursday`	`inclia_gio`	`boolean`	NO		Flag indicating the activity is scheduled on Thursdays.
`cas_is_friday`	`inclia_ven`	`boolean`	NO		Flag indicating the activity is scheduled on Fridays.
`cas_is_saturday`	`inclia_sab`	`boolean`	NO		Flag indicating the activity is scheduled on Saturdays.
`cas_is_sunday`	`inclia_dom`	`boolean`	NO		Flag indicating the activity is scheduled on Sundays.
`cas_is_holiday`	`inclia_fest`	`boolean`	NO		Flag indicating if the activity is scheduled on holidays.
`cas_is_rigid`	`inclia_rigido`	`boolean`	NO		Flag indicating if the schedule is fixed/rigid.
`cas_hours_quantity_alt`	`inclia_num_ore2`	`integer`	NO		Alternative number of hours planned.
`cas_people_quantity_alt`	`inclia_num_persone2`	`integer`	NO		Alternative number of people required.
`cas_is_rigid_alt`	`inclia_rigido2`	`boolean`	NO		Alternative rigid flag.
`cas_period_label`	`inclia_periodo`	`character varying(30)`	NO		Label describing the scheduling period (e.g. Weekly).
`cas_notes`	`inclia_note`	`text`	NO		General notes for the schedule.
`cas_last_scheduled_on`	`inclia_dt_ultima_pianificazione`	`date`	NO		Date of the last automatic scheduling execution.
`cas_weekly_frequency`	`inclia_volte_settimana`	`character varying(20)`	NO		Textual representation of weekly frequency.
`cas_last_assigned_on`	`inclia_dt_ultima_assegnazione`	`date`	NO		Date of the last manual or automatic assignment.
`tenant_id`	`tenant_id`	`integer`	YES		Tenant identifier for data isolation.
`colcustom`	`colcustom`	`jsonb`	YES	`'{}'::jsonb`	JSON field for custom data.
`_deleted`	`_deleted`	`boolean`	YES	`false`	Technical soft delete flag.
`cas_validity_period`	`inclia_dt_periodo`	`daterange`	YES	GENERATED: `daterange(cas_start_date, cas_end_date, '[]'::text)`	Generated daterange for the schedule validity.

Relationships

Outgoing foreign keys

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

Referenced by

From table	Foreign key	Source columns	Target columns
`hr.customer_activity_calendar`	`fk_customer_activity_calendar_activity_plan`	`activity_plan_id, tenant_id`	`cas_id, tenant_id`
`hr.customer_fixed_activities`	`fk_customer_fixed_activities_activity_plan`	`activity_plan_id, tenant_id`	`cas_id, tenant_id`

Constraints

Primary key: pk_customer_activity_schedules → id
Unique: uk_customer_activity_schedules_id → cas_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
`idx_cas_id_tenant`	NO	`btree`	`tenant_id, cas_id) WHERE (_deleted = false`
`idx_cas_location_tenant`	NO	`btree`	`tenant_id, cas_customer_location_id) WHERE (_deleted = false`
`idx_cas_project_activity_tenant`	NO	`btree`	`tenant_id, cas_project_activity_id) WHERE (_deleted = false`
`idx_cas_project_link_tenant`	NO	`btree`	`tenant_id, cas_project_link_id) WHERE (_deleted = false`
`idx_cas_project_tenant`	NO	`btree`	`tenant_id, cas_project_id) WHERE (_deleted = false`
`idx_cas_tenant`	NO	`btree`	`tenant_id`
`idx_cas_tenant_location_period_gist`	NO	`gist`	`tenant_id, cas_customer_location_id, cas_validity_period) WHERE (_deleted = false`
`idx_cas_tenant_period_gist`	NO	`gist`	`tenant_id, cas_validity_period) WHERE (_deleted = false`

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

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​