`pres.shift_definitions`

Schema: pres
English table: pres.shift_definitions
Italian original table: pres.orari
Description: Master table for work shift models, theoretical punching times, and calculation logic.

Overview

Columns: 47
Primary key: id
Outgoing foreign keys: 1
Incoming foreign keys: 7
Indexes: 0

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
`id`	`id`	`integer`	NO		Identifier of the related record.
`shd_id`	`ora_id`	`integer`	NO		Unique internal identifier for the shift.
`tenant_id`	`tenant_id`	`integer`	NO		Identifier of the related tenant.
`shd_code`	`cod_ora`	`character(4)`	NO	`''::bpchar`	Short alphanumeric code for the shift (e.g., FULL, NIGHT).
`shd_description`	`ora_descrizione`	`character(40)`	NO	`''::bpchar`	Extended description of the work schedule.
`shd_time_1`	`ora_t1`	`numeric(4,0)`	NO	`0`	Theoretical 1st entry time (HHMM format).
`shd_time_2`	`ora_t2`	`numeric(4,0)`	NO	`0`	Theoretical 1st exit time (HHMM format).
`shd_time_3`	`ora_t3`	`numeric(4,0)`	NO	`0`	Theoretical 2nd entry time (HHMM format).
`shd_time_4`	`ora_t4`	`numeric(4,0)`	NO	`0`	Theoretical 2nd exit time (HHMM format).
`shd_time_5`	`ora_t5`	`numeric(4,0)`	NO	`0`	Time associated with shd time 5.
`shd_time_6`	`ora_t6`	`numeric(4,0)`	NO	`0`	Time associated with shd time 6.
`shd_time_7`	`ora_t7`	`numeric(4,0)`	NO	`0`	Time associated with shd time 7.
`shd_time_8`	`ora_t8`	`numeric(4,0)`	NO	`0`	Time associated with shd time 8.
`shd_is_mandatory_1`	`ora_obb1`	`boolean`	NO	`false`	Flag: indicates if the 1st entry is mandatory for shift validity.
`shd_is_mandatory_2`	`ora_obb2`	`boolean`	NO	`false`	Boolean flag for shd is mandatory 2.
`shd_is_mandatory_3`	`ora_obb3`	`boolean`	NO	`false`	Boolean flag for shd is mandatory 3.
`shd_is_mandatory_4`	`ora_obb4`	`boolean`	NO	`false`	Boolean flag for shd is mandatory 4.
`shd_is_mandatory_5`	`ora_obb5`	`boolean`	NO	`false`	Boolean flag for shd is mandatory 5.
`shd_is_mandatory_6`	`ora_obb6`	`boolean`	NO	`false`	Boolean flag for shd is mandatory 6.
`shd_is_mandatory_7`	`ora_obb7`	`boolean`	NO	`false`	Boolean flag for shd is mandatory 7.
`shd_is_mandatory_8`	`ora_obb8`	`boolean`	NO	`false`	Boolean flag for shd is mandatory 8.
`shd_break_start_index`	`ora_inipausa`	`numeric(1,0)`	NO	`0`	Pointer to which time pair represents the start of the break.
`shd_auto_insert_justifications`	`ora_ins_auto`	`boolean`	NO	`false`	Boolean flag for shd auto insert justifications.
`ora_cod_cau1`	`ora_cod_cau1`	`character(4)`	NO	`''::bpchar`	Value of ora cod cau1.
`ora_ore_cau1`	`ora_ore_cau1`	`numeric(4,0)`	NO	`0`	Value of ora ore cau1.
`ora_minimo_lav1`	`ora_minimo_lav1`	`numeric(4,0)`	NO	`0`	Value of ora minimo lav1.
`ora_solo_nonlav1`	`ora_solo_nonlav1`	`boolean`	NO	`false`	Boolean flag for ora solo nonlav1.
`ora_cod_cau2`	`ora_cod_cau2`	`character(4)`	NO	`''::bpchar`	Value of ora cod cau2.
`ora_ore_cau2`	`ora_ore_cau2`	`numeric(4,0)`	NO	`0`	Value of ora ore cau2.
`ora_minimo_lav2`	`ora_minimo_lav2`	`numeric(4,0)`	NO	`0`	Value of ora minimo lav2.
`ora_solo_nonlav2`	`ora_solo_nonlav2`	`boolean`	NO	`false`	Boolean flag for ora solo nonlav2.
`shd_shift_type_index`	`ora_turno`	`numeric(1,0)`	NO	`0`	Value of shd shift type index.
`shd_is_night_shift`	`ora_notturno`	`boolean`	NO	`false`	Flag: indicates if the shift crosses midnight or is classified as night work.
`shd_is_holiday_shift`	`ora_festivo`	`boolean`	NO	`false`	Flag: indicates if the shift is specific for holidays/Sundays.
`shd_standard_hours`	`ora_ore_ordinarie`	`numeric(4,0)`	NO	`0`	Expected standard working minutes for this shift.
`shd_correction_minutes`	`ora_correzione`	`numeric(4,0)`	NO	`0`	Value of shd correction minutes.
`shd_rounding_minutes`	`ora_quadra`	`numeric(4,0)`	NO	`0`	Rounding value (quadratura) applied to the final calculated hours.
`shd_overtime_profile_code`	`ora_prof_str`	`character(4)`	NO	`''::bpchar`	Reference to the overtime calculation profile to be applied.
`ora_ini_cau1`	`ora_ini_cau1`	`numeric(4,0)`	NO	`0`	Value of ora ini cau1.
`ora_end_cau1`	`ora_end_cau1`	`numeric(4,0)`	NO	`0`	Value of ora end cau1.
`ora_ini_cau2`	`ora_ini_cau2`	`numeric(4,0)`	NO	`0`	Value of ora ini cau2.
`ora_end_cau2`	`ora_end_cau2`	`numeric(4,0)`	NO	`0`	Value of ora end cau2.
`shd_post_processing_expression`	`ora_expr_after`	`text`	NO	`''::text`	SQL expression or script for custom post-calculation logic.
`shd_short_name`	`ora_abbreviazione`	`character(4)`	NO	`''::bpchar`	Abbreviated name for compact calendar views.
`shd_color_hex`	`ora_colore`	`character varying(7)`	YES		Hexadecimal color code for UI visualization.
`shd_is_flexible`	`ora_variabile`	`boolean`	NO	`false`	Boolean flag for shd is flexible.
`_deleted`	`_deleted`	`boolean`	NO	`false`	Logical deletion flag (soft-delete).

Relationships

Outgoing foreign keys

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

Referenced by

From table	Foreign key	Source columns	Target columns
`pres.clocking_reason_mappings`	`fk_crm_shift`	`tenant_id, crm_target_shift_code`	`tenant_id, shd_code`
`pres.daily_attendance_details`	`fk_dad_shift_type`	`tenant_id, dad_shift_code`	`tenant_id, shd_code`
`pres.daily_shift_planning`	`fk_dsp_shift_type`	`tenant_id, dsp_shift_code`	`tenant_id, shd_code`
`pres.shift_advanced_settings`	`fk_sas_shift_definitions`	`tenant_id, sas_shift_code`	`tenant_id, shd_code`
`pres.shift_attendance_profiles`	`fk_sap_shift_definitions`	`tenant_id, sap_shift_code`	`tenant_id, shd_code`
`pres.shift_flexibility_rules`	`fk_sfr_shift_definitions`	`tenant_id, sfr_shift_id`	`tenant_id, shd_id`
`pres.weekly_schedule_details`	`fk_wsd_shift_definition`	`tenant_id, wsd_shift_code`	`tenant_id, shd_code`

Constraints

Primary key: pk_shift_definitions → id
Unique: c_uk_shd_code_tenant → tenant_id, shd_code
Unique: c_uk_shd_id_tenant → tenant_id, shd_id

Indexes

No indexes detected.

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

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​