Description:
The Vehicles table contains comprehensive information about each vehicle in the fleet, including location, status, battery levels, usage metrics, and operational metadata. This data supports fleet inventory tracking, availability and utilization analysis, and integration with rental and service workflows.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Internal vehicle ID. |
address |
TEXT | Human-readable address derived from the latest position. |
code |
TEXT | Internal or external reference code. |
name |
TEXT | Display name or label for the vehicle. |
license_plate |
TEXT | Vehicle’s license plate number. |
vin |
TEXT | Vehicle Identification Number. |
uuid |
TEXT | Universally unique identifier for the vehicle. |
branch_id |
NUMBER | Associated branch/location ID. |
category_id |
NUMBER | ID of the vehicle’s assigned category. |
module_id |
NUMBER | ID of the IoT module connected to the vehicle. |
position |
GEOMETRY | Geographic location of the vehicle (SRID 4326). |
kilometers |
FLOAT | Total distance the vehicle has traveled. |
remaining_kilometers |
FLOAT | Estimated range left based on current battery level. |
state_of_charge |
NUMBER | Battery state of charge. |
legal_inspection_date |
DATE | Date of the last legal inspection. |
last_online_at |
TIMESTAMP_TZ | Last time the IoT module was connected. |
last_ended_rental_at |
TIMESTAMP_TZ | When the last rental ended. |
last_operational_at |
TIMESTAMP_TZ | Last time the vehicle was fully operational. |
last_out_of_order_at |
TIMESTAMP_TZ | When the vehicle was last marked out of order. |
position_last_modified_at |
TIMESTAMP_TZ | Last time the position was updated. |
rental_state_last_modified_at |
TIMESTAMP_TZ | Timestamp of the last rental_state update. |
power_state_last_modified_at |
TIMESTAMP_TZ | Timestamp of the last power_state update. |
service_state_v2_last_modified_at |
TIMESTAMP_TZ | Last update time for service_state_v2. |
battery_level_last_modified_at |
TIMESTAMP_TZ | Last time battery_level was updated. |
reward |
BOOLEAN | Whether a reward is active for this vehicle. |
reward_invalidation_at |
TIMESTAMP_TZ | When the reward was invalidated. |
iot_module_level |
FLOAT | Battery/signal level reported by the IoT module. |
custom_properties |
VARIANT | Flexible object for tenant-specific or dynamic metadata. Example: { "rfidCardHolder.count": "0" } or { "helmets": "MISSING", "helmets.count": "0" } or { "helmets": "PRESENT", "helmets.count": "2" }. |
rental_state |
NUMBER | Current rental state. (0 => AVAILABLE: available for rental. 1 => RESERVATION: a rental in state RESERVATION is associated. 2 => DRIVING: a rental in state ACTIVE is associated and the vehicle is in DRIVING mode. 3 => PARKING: a rental in state ACTIVE is associated and the vehicle is in PARKING mode. 4 => DELIVERED: associated to a booking in state DELIVERED, ready for the user to turn the booking into a rental.) |
rental_state_name |
TEXT | String label for rental_state. |
service_state_name |
TEXT | String label for the legacy service state. Allowed values: OPERATIONAL, LOW_SOC, OUT_OF_ORDER, RETIRED, CRITICAL_SOC, IN_SERVICE. |
service_state_v2 |
NUMBER | Service state of the vehicle. (0 => FUNCTIONAL. 1 => INSPECT. 2 => RELOCATE. 3 => COLLECT. 4 => SERVICE_ON_SITE. 5 => SERVICE_WORKSHOP. 6 => SERVICE_EXTERNAL. 7 => REPLACE. 8 => IMPOUNDED. 9 => LOST. 10 => RETIRED. 11 => OTHER. 12 => READY_FOR_DEPLOYMENT. 13 => MAINTENANCE. 14 => WAITING_FOR_PARTS. 15 => UNREPAIRABLE. 16 => DEFLEETED. 17 => OPERATIONAL_HOLD. 18 => AWAITING_ACTION. 19 => SERVICE_MECHANICS. 20 => REGULATORY_INSPECTION_READY. 21 => REGULATORY_INSPECTION. 22 => SERVICE_WORKSHOP_INSURANCE. 23 => SERVICE_WORKSHOP_QUEUE. 24 => READY_FOR_DEPLOYMENT_NEW. 25 => COLLECT_EXTERNAL.) |
service_state_v2_name |
TEXT | String label for service_state_v2. |
service_state_before_approach |
NUMBER | Service state before a technician approached the vehicle. Uses the same value space as service_state_v2 (0 => FUNCTIONAL … 25 => COLLECT_EXTERNAL). |
service_state_before_approach_name |
TEXT | String label for service_state_before_approach. |
charging_state |
NUMBER | Charging status. (0 => UNKNOWN, 1 => UNPLUGGED, 2 => PLUGGED, 3 => CHARGING.) |
charging_state_name |
TEXT | String label for charging_state. |
power_state |
NUMBER | Power mode of the vehicle. (0 => UNKNOWN, 1 => OFF, 2 => ON.) |
power_state_name |
TEXT | String label for power_state. |
battery_level |
NUMBER | Battery level bucket. (0 => UNKNOWN, 1 => HIGH, 2 => LOW, 3 => CRITICAL, 4 => MEDIUM.) |
battery_level_name |
TEXT | String label for battery_level. |
iot_online_state |
NUMBER | Online/offline state of the IoT module. (0 => UNSET, 1 => OFF, 2 => ON.) |
iot_online_state_name |
TEXT | String label for iot_online_state. |
created_at |
TIMESTAMP_TZ | Record creation timestamp. |
updated_at |
TIMESTAMP_TZ | Record last update timestamp. |
created_by |
NUMBER | User/system that created the record. |
updated_by |
NUMBER | User/system that last updated the record. |
_snowflake_inserted_at |
TIMESTAMP_NTZ | System timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | System timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |