hr.work_sites

Schema: hr
English table: hr.work_sites
Italian original table: hr.sedi_operative
Description: Operational sites and branches with geofencing data for attendance tracking.

Overview

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

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
sede_id	sede_id	integer	NO		Identifier of the related sede record.
sede_az_id	sede_az_id	integer	NO		Identifier of the related sede az record.
sede_descrizione	sede_descrizione	character varying(60)	NO		Text value.
sede_indirizzo	sede_indirizzo	character varying(60)	NO		Text value.
sede_cap	sede_cap	character varying(5)	NO		Text value.
ws_city	sede_comune	character varying(40)	NO		Text value.
ws_province	sede_provincia	character varying(2)	NO		Text value.
ws_internal_code	sede_codice	character varying(2)	NO		Code for ws internal.
ws_meridiana_code	sede_codice_meridiana	character varying(6)	NO		Code for ws meridiana.
ws_syncro_code	sede_code_syncro	character varying(10)	NO		Code for ws syncro.
ws_reference_relationship_id	sede_rap_id	integer	NO		Identifier of the related ws reference relationship record.
sede_lat_p1	sede_lat_p1	numeric(12,8)	NO		Sede lat p1.
sede_long_p1	sede_long_p1	numeric(12,8)	NO		Sede long p1.
sede_lat_p2	sede_lat_p2	numeric(12,8)	NO		Sede lat p2.
sede_long_p2	sede_long_p2	numeric(12,8)	NO		Sede long p2.
ws_street_number	sede_num_civico	character varying(10)	NO		Text value.
ws_geofence_radius	sede_raggio	integer	NO		Numeric value.
ws_p1_latitude	sede_p1_latitudine	numeric(19,15)	NO		Ws p1 latitude.
ws_p1_longitude	sede_p1_longitudine	numeric(19,15)	NO		Ws p1 longitude.
ws_p2_latitude	sede_p2_latitudine	numeric(19,15)	NO		Ws p2 latitude.
ws_p2_longitude	sede_p2_longitudine	numeric(19,15)	NO		Ws p2 longitude.
ws_latitude	sede_lat_indirizzo	numeric(19,15)	NO		Ws latitude.
ws_longitude	sede_lon_indirizzo	numeric(19,15)	NO		Ws longitude.
ws_manager_relationship_id	sede_responsabile_rap_id	integer	YES		Identifier of the related ws manager relationship 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_sede_responsabile_rap_id	ws_manager_relationship_id, tenant_id	hr.employment_relationships	er_id, tenant_id	RESTRICT	CASCADE
fk_tenant_id	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
hr.company_work_sites	fk_sedel_sede_id	cws_work_site_id, tenant_id	sede_id, tenant_id
hr.organization_units	fk_ou_workplace	ou_workplace_id, tenant_id	sede_id, tenant_id
hr.work_site_time_terminals	fk_sedet_sede_id	wstt_work_site_id, tenant_id	sede_id, tenant_id

Constraints

• Primary key: pk_work_sites → id
• Unique: uk_ws_id_tenant → sede_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_ws_company_tenant	NO	btree	tenant_id, sede_az_id) WHERE (_deleted = false
idx_ws_id_tenant	NO	btree	tenant_id, sede_id) WHERE (_deleted = false
idx_ws_manager_rel_tenant	NO	btree	tenant_id, ws_manager_relationship_id) WHERE (_deleted = false
idx_ws_ref_rel_tenant	NO	btree	tenant_id, ws_reference_relationship_id) WHERE (_deleted = false
idx_ws_tenant	NO	btree	tenant_id

Navigation

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