hr.rooms

Schema: hr
English table: hr.rooms
Italian original table: hr.in_riu_luoghi
Description: Master registry for reservable spaces such as meeting rooms, canteen, or shared workstations.

Overview

• Columns: 17
• Primary key: id
• Outgoing foreign keys: 3
• Incoming foreign keys: 3
• Indexes: 4

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
rm_id	riul_id	integer	NO		Unique room identifier within a tenant.
rm_name	riul_nome	character varying(50)	NO		Display name of the room.
rm_description	riul_descrizione	text	NO		Description text.
rm_floor	riul_piano	character varying(5)	NO		Floor level location.
rm_capacity	riul_capienza	integer	NO		Numeric value.
rm_tolerance_minutes	riul_tolleranza	integer	NO		Numeric value.
rm_available_from	riul_disp_da_data	date	NO		Boundary value used for range filtering (start/end).
rm_available_to	riul_disp_a_data	date	NO		Boundary value used for range filtering (start/end).
rm_suspended_from	riul_sosp_da_data	date	NO		Boundary value used for range filtering (start/end).
rm_suspended_to	riul_sosp_a_data	date	NO		Boundary value used for range filtering (start/end).
rm_days_bitmask	riul_giorni	character varying(8)	NO		Text value.
rm_booking_type_id	riul_riultp_id	integer	NO		Identifier of the related rm booking type record.
rm_room_type_id	riul_riultl_id	integer	NO		Identifier of the related rm room 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_rm_booking_type	rm_booking_type_id, tenant_id	hr.room_booking_types	rbt_id, tenant_id	RESTRICT	RESTRICT
fk_rm_room_type	rm_room_type_id, tenant_id	hr.room_types	rt_id, tenant_id	RESTRICT	RESTRICT
fk_rm_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
hr.room_amenities	fk_ra_room	ra_room_id, tenant_id	rm_id, tenant_id
hr.room_bookings	fk_rb_room	rb_room_id, tenant_id	rm_id, tenant_id
hr.rooms_timeslot_definitions	fk_rtd_room	rtd_room_id, tenant_id	rm_id, tenant_id

Constraints

• Primary key: pk_rooms → id
• Unique: uk_rooms_id → rm_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_rm_booking_type_tenant	NO	btree	tenant_id, rm_booking_type_id) WHERE (_deleted = false
idx_rm_id_tenant	NO	btree	tenant_id, rm_id) WHERE (_deleted = false
idx_rm_room_type_tenant	NO	btree	tenant_id, rm_room_type_id) WHERE (_deleted = false
idx_rm_tenant	NO	btree	tenant_id

Navigation

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