hr.geolocations

Schema: hr
English table: hr.geolocations
Italian original table: hr.geolocalizzazione
Description: Geolocation tracking records. Captures GPS coordinates, addresses, and optional images for start/end points of activities such as clock-in/clock-out events, field work, client visits, or delivery routes. Used for attendance verification, field workforce management, and activity tracking.

Overview

• Columns: 15
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 0
• Indexes: 4

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Primary key (internal surrogate ID).
geo_id	geo_id	integer	NO		Business identifier for the geolocation record (unique within tenant).
geo_timecard_entry_id	geo_lat_start	integer	NO		Associated timecard/attendance entry identifier (references time tracking system, e.g., pres.timbra table).
geo_report_id	geo_lon_start	integer	NO		Associated report or expense claim identifier (references activity reports or expense reimbursement records).
geo_start_latitude	geo_address_start	numeric(12,8)	NO		Starting point latitude coordinate (decimal degrees, e.g., 45.4642035 for Milan).
geo_start_longitude	geo_lat_end	numeric(12,8)	NO		Starting point longitude coordinate (decimal degrees, e.g., 9.1899814 for Milan).
geo_start_address	geo_lon_end	text	NO		Reverse-geocoded address for the starting point (e.g., "Via Roma 123, Milano, MI").
geo_end_latitude	geo_address_end	numeric(12,8)	NO		Ending point latitude coordinate (decimal degrees).
geo_end_longitude	geo_name_img_start	numeric(12,8)	NO		Ending point longitude coordinate (decimal degrees).
geo_end_address	geo_name_img_end	text	NO		Reverse-geocoded address for the ending point.
geo_start_image_name	geo_tim_id	text	NO		Filename or path of image captured at the starting point (e.g., photo taken during clock-in for verification).
geo_end_image_name	geo_rendcont_id	text	NO		Filename or path of image captured at the ending point (e.g., photo taken during clock-out).
tenant_id	tenant_id	integer	YES		Tenant identifier for multi-tenancy (references cloud._tenant).
colcustom	colcustom	jsonb	YES	'{}'::jsonb	JSON object for custom fields and tenant-specific extensions.
_deleted	_deleted	boolean	YES	false	Soft delete flag for technical deletion (not functional cancellation).

Relationships

Outgoing foreign keys

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

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_geolocations → id
• Unique: uk_geolocations_geo_id_tenant → geo_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_geo_tenant	NO	btree	tenant_id
idx_geo_tenant_geo_id	NO	btree	tenant_id, geo_id) WHERE (_deleted = false
idx_geo_tenant_report	NO	btree	tenant_id, geo_report_id) WHERE (_deleted = false
idx_geo_tenant_timecard	NO	btree	tenant_id, geo_timecard_entry_id) WHERE (_deleted = false

Navigation

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