hr.expense_note_travel_means
Schema: hr
English table: hr.expense_note_travel_means
Italian original table: hr.in_notaspese_mezzi
Description: Lookup/configuration of travel/transport means used in expense notes. Controls required inputs (driver, km, trip token) and availability.
Overview
- Columns: 11
- 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. | |
entm_id | nsm_id | integer | NO | Logical travel mean identifier (unique per tenant). | |
entm_description | nsm_description | character varying(100) | NO | Travel mean description (e.g., company car, personal car, taxi, public transport). | |
entm_requires_driver | nsm_driver | boolean | NO | If TRUE, driver information is required for this travel mean. | |
entm_is_enabled | nsm_enabled | boolean | NO | If TRUE, this travel mean can be selected/used. | |
entm_ask_km | nsm_ask_km | boolean | NO | If TRUE, the user must provide travelled kilometers for this travel mean. | |
entm_ask_trip_token | nsm_ask_trip_token | boolean | NO | If TRUE, the user must provide a trip token/reference code for this travel mean. | |
entm_custom1 | nsm_custom1 | text | NO | Free custom text field (legacy/custom usage). | |
tenant_id | tenant_id | integer | YES | Tenant identifier for data isolation. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom fields container (JSON). |
_deleted | _deleted | boolean | YES | false | Technical soft delete flag. FALSE = active, TRUE = hidden (not a functional deletion). |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_entm_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
| From table | Foreign key | Source columns | Target columns |
|---|---|---|---|
hr.expense_note_travel_mean_custom_fields | fk_entmcf_travel_mean | entmcf_entm_id, tenant_id | entm_id, tenant_id |
Constraints
- Primary key:
pk_expense_note_travel_means→id - Unique:
uk_entm_id_tenant→entm_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_expense_note_travel_means_tenant | NO | btree | tenant_id |
idx_expense_note_travel_means_tenant_entm_id | NO | btree | tenant_id, entm_id) WHERE (_deleted = false |
Navigation
- Back to main index
- [Back to
hrindex]../)