hr.person_vehicle_assignments
Schema: hr
English table: hr.person_vehicle_assignments
Italian original table: hr.ana_auto
Description: Vehicle assignments to a person (company car or private). Stores assignment/return dates, odometer readings, return compliance and notes (multi-tenant).
Overview
- Columns: 18
- Primary key: id
- Outgoing foreign keys: 3
- Incoming foreign keys: 0
- Indexes: 5
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
pva_id | anaauto_id | integer | NO | Logical assignment identifier (unique per tenant). | |
pva_person_id | anaauto_ana_id | integer | NO | Person identifier. FK to hr.person_registry(pr_id, tenant_id). | |
pva_vehicle_id | anaauto_auto_id | integer | NO | Vehicle identifier. FK to hr.auto(auto_id, tenant_id) (to be translated). | |
pva_assigned_on | anaauto_data_assegnazione | date | NO | Assignment date (vehicle delivered to the person). | |
pva_return_due_on | anaauto_data_restituzione | date | NO | Planned/expected return date (as per source naming). | |
pva_odometer_start_km | anaauto_km_assegnazione | numeric(8,0) | NO | Odometer reading at assignment time (km). | |
pva_odometer_end_km | anaauto_km_restituzione | numeric(8,0) | NO | Odometer reading at return time (km). | |
pva_is_returned | anaauto_restituito | boolean | NO | Whether the vehicle has been returned. | |
pva_return_notes | anaauto_note_restituzione | text | NO | Return notes. | |
pva_is_return_non_compliant | anaauto_restituzione_non_conforme | boolean | NO | True if the return is non-compliant (e.g., damage, missing items, late, etc.). | |
pva_is_private | anaauto_privata | boolean | NO | True if the vehicle is private (used for reimbursements). | |
pva_license_plate | anaauto_targa | character varying(20) | NO | Vehicle license plate (as recorded on assignment). | |
pva_vehicle_model | anaauto_modello | character varying(50) | NO | Vehicle model/description (as recorded on assignment). | |
pva_km_reimbursement_rate | anaauto_rimb_km | numeric(5,2) | NO | Kilometer reimbursement rate (currency per km). | |
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_pva_person_id | pva_person_id, tenant_id | hr.person_registry | pr_id, tenant_id | RESTRICT | CASCADE |
fk_pva_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
fk_pva_vehicle_id | pva_vehicle_id, tenant_id | hr.vehicles | veh_id, tenant_id | RESTRICT | RESTRICT |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_person_vehicle_assignments→id - Unique:
uk_pva_id_tenant→pva_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_person_vehicle_assignments_tenant | NO | btree | tenant_id |
idx_pva_id_tenant | NO | btree | tenant_id, pva_id) WHERE (_deleted = false |
idx_pva_person_id_is_private_tenant | NO | btree | tenant_id, pva_person_id, pva_is_private) WHERE (_deleted = false |
idx_pva_person_id_tenant | NO | btree | tenant_id, pva_person_id) WHERE (_deleted = false |
idx_pva_vehicle_id_tenant | NO | btree | tenant_id, pva_vehicle_id) WHERE (_deleted = false |
Navigation
- Back to main index
- [Back to
hrindex]../)