hr.rooms_timeslot_definitions

Schema: hr
English table: hr.rooms_timeslot_definitions
Italian original table: hr.in_riu_fasce_orarie
Description: Configuration of availability windows, capacity, and scheduling rules for shared rooms.

Overview

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

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
rtd_id	riuf_id	integer	NO		Identifier of the related rtd record.
rtd_room_id	riuf_riul_id	integer	NO		Identifier of the related rtd room record.
rtd_day_of_week	riuf_dayweek	numeric(1,0)	NO		Rtd day of week.
rtd_start_time	riuf_dalle_ore	integer	NO		Opening time of the slot (integer, usually minutes from midnight).
rtd_end_time	riuf_alle_ore	integer	NO		Closing time of the slot (integer, usually minutes from midnight).
rtd_slot_duration_minutes	riuf_slot_time	integer	NO		Numeric value.
rtd_max_booking_duration	riuf_max_time	integer	NO		Numeric value.
rtd_capacity	riuf_capienza	integer	NO		Maximum number of people allowed in this timeslot.
rtd_tolerance_minutes	riuf_tolleranza	integer	NO		Numeric value.
rtd_available_from	riuf_disp_da_data	date	NO		Boundary value used for range filtering (start/end).
rtd_available_to	riuf_disp_a_data	date	NO		Boundary value used for range filtering (start/end).
rtd_suspended_from	riuf_sosp_da_data	date	NO		Boundary value used for range filtering (start/end).
rtd_suspended_to	riuf_sosp_a_data	date	NO		Boundary value used for range filtering (start/end).
rtd_days_bitmask	riuf_giorni	character varying(8)	NO		String representation or bitmask of active days.
rtd_booking_type_id	riuf_tipo_prenot	integer	NO		Identifier of the related rtd booking type record.
tenant_id	tenant_id	integer	YES		Tenant identifier for data isolation.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	JSON payload containing additional attributes.
_deleted	_deleted	boolean	YES	false	Flag indicating whether the record is soft-deleted.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_rtd_room	rtd_room_id, tenant_id	hr.rooms	rm_id, tenant_id	RESTRICT	RESTRICT
fk_rtd_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
hr.room_bookings	fk_rb_rescheduled_timeslot	rb_rescheduled_timeslot_id, tenant_id	rtd_id, tenant_id
hr.room_bookings	fk_rb_timeslot	rb_timeslot_definition_id, tenant_id	rtd_id, tenant_id
hr.rooms_timeslot_assignments	fk_rta_timeslot	rta_timeslot_id, tenant_id	rtd_id, tenant_id

Constraints

• Primary key: pk_rooms_timeslot_definitions → id
• Unique: uk_rooms_timeslot_definitions_id → rtd_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_rtd_id_tenant	NO	btree	tenant_id, rtd_id) WHERE (_deleted = false
idx_rtd_room_tenant	NO	btree	tenant_id, rtd_room_id) WHERE (_deleted = false
idx_rtd_tenant	NO	btree	tenant_id

Navigation

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