hr.vehicles

Schema: hr
English table: hr.vehicles
Italian original table: hr.auto
Description: Company vehicles / fleet registry (multi-tenant).

Overview

• Columns: 17
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 1
• Indexes: 2

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
veh_id	auto_id	integer	NO		Logical vehicle identifier (unique per tenant).
veh_make_model	auto_marca_modello	character varying(60)	NO		Vehicle make and model.
veh_color	auto_colore	character varying(15)	NO		Vehicle color.
veh_license_plate	auto_targa	character varying(10)	NO		Vehicle license plate.
veh_registration_date	auto_data_immatricolazione	date	NO		First registration date.
veh_equipment	auto_dotazioni	text	NO		Equipment / accessories (free text).
veh_service_interval_km	auto_km_tagliando	numeric(8,0)	NO		Service interval in km (planned).
veh_last_service_date	auto_data_ultimo_tagliando	date	NO		Last service date.
veh_last_service_odometer_km	auto_km_ultimo_tagliando	numeric(8,0)	NO		Odometer reading at last service (km).
veh_last_inspection_date	auto_data_ultima_revisione	date	NO		Last mandatory inspection date.
veh_is_decommissioned	auto_dismessa	boolean	NO		Whether the vehicle has been decommissioned/dismissed.
veh_decommission_notes	auto_note_dismissione	text	NO		Decommission notes.
veh_accidents_notes	auto_incidenti	text	NO		Accidents notes/history (free text).
tenant_id	tenant_id	integer	YES		Tenant identifier for data isolation.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	Custom fields (JSON).
_deleted	_deleted	boolean	YES	false	Technical soft-delete flag.

Relationships

Outgoing foreign keys

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

Referenced by

From table	Foreign key	Source columns	Target columns
hr.person_vehicle_assignments	fk_pva_vehicle_id	pva_vehicle_id, tenant_id	veh_id, tenant_id

Constraints

• Primary key: pk_vehicles → id
• Unique: uk_veh_id_tenant → veh_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_vehicles_tenant	NO	btree	tenant_id
idx_vehicles_veh_id_tenant	NO	btree	tenant_id, veh_id) WHERE (_deleted = false

Navigation

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