Vehicle Data Model

Data Model Overview

🏗️ Primary Entities

Vehicles: Vehicle profiles with make, model, year, VIN, odometer, and specification details

Maintenance Reminders: Scheduled service reminders with category, description, and dates

Deferred Services: Services that were recommended but not yet performed

🔗 Key Relationships

Many-to-One: Vehicle → Tenant (each vehicle belongs to one tenant)

Many-to-One: Vehicle → Customer (each vehicle belongs to one customer)

One-to-Many: Vehicle → Maintenance Reminders (JSON array)

One-to-Many: Vehicle → Deferred Services (JSON array)

Field Specifications

Vehicle Identification

Core identification fields linking vehicles to tenants and customers.

Tip

Primary Key: STEER_VEHICLE_ID is the primary key for this table. Each row represents one unique vehicle.

Field Name	Data Type	Description	Required
STEER_TENANT_ID	String (UUID)	Unique tenant identifier (parent organization)	Yes
STEER_VEHICLE_ID	String (UUID)	Unique vehicle identifier (primary key)	Yes
STEER_CUSTOMER_ID	String (UUID)	Customer who owns this vehicle. Links to Customer Data Model STEER_CUSTOMER_ID	Yes

Vehicle Details

Core vehicle information including make, model, year, and physical attributes.

Field Name	Data Type	Description	Required
VEHICLE_TYPE	String	Type of the service object (e.g., Vehicle, Truck)	No
VEHICLE_YEAR	Number	Manufacturing year	No
VEHICLE_MAKE	String	Vehicle manufacturer (e.g., Toyota, Ford)	No
VEHICLE_MODEL	String	Vehicle model (e.g., Camry, F-150)	No
VEHICLE_SUBMODEL	String	Vehicle submodel or trim level	No
VEHICLE_ENGINE	String	Engine description	No
VEHICLE_COLOR	String	Vehicle color	No
VEHICLE_LICENSE_PLATE	String	License plate number	No
VEHICLE_STATE	String	Vehicle registration state	No
VEHICLE_VIN	String	Vehicle Identification Number (17-character standard)	No
VEHICLE_FLEET_NUMBER	String	Fleet identifier for fleet-managed vehicles	No

Specification Matching

Fields related to vehicle specification lookup and matching.

Field Name	Data Type	Description	Required
VEHICLE_IS_SPECIFICATION_MATCHED	Boolean	Whether a specification match was found for this vehicle	No
VEHICLE_ORIGINAL_SPECIFICATION_MAKE	String	Original specification make (before matching)	No
VEHICLE_ORIGINAL_SPECIFICATION_MODEL	String	Original specification model (before matching)	No
VEHICLE_ORIGINAL_SPECIFICATION_YEAR	String	Original specification year (before matching)	No

Odometer & Usage

Mileage tracking and vehicle usage classification.

Field Name	Data Type	Description	Required
VEHICLE_LAST_VISIT_ODOMETER	Number	Odometer reading at last service visit	No
VEHICLE_STEER_ESTIMATED_ODOMETER	Number	Current estimated odometer from Steer’s EstimatedMileage calculation	No
VEHICLE_USAGE_CATEGORY	String	Vehicle usage classification based on driving patterns	No

Important Dates

Key dates related to vehicle registration, inspection, and service history.

Field Name	Data Type	Description	Required
VEHICLE_INSPECTION_EXPIRED_AT	Timestamp	Inspection expiration date (UTC)	No
VEHICLE_REGISTRATION_EXPIRED_AT	Timestamp	Registration expiration date (UTC)	No
VEHICLE_LAST_SERVICE_AT	Timestamp	Last date the vehicle was serviced (UTC)	No
VEHICLE_PRODUCTION_AT	Timestamp	Vehicle production date (UTC)	No

Vehicle Status

Field Name	Data Type	Description	Required
VEHICLE_IS_DELETED	Boolean	Whether the vehicle record has been soft-deleted	Yes

Maintenance Reminders

Scheduled service reminders returned as a JSON array. Each vehicle may have zero or more reminders.

Field Name	Data Type	Description	Required
VEHICLE_MAINTENANCE_REMINDERS	JSON Array	Array of maintenance reminder objects (see structure below)	No

Maintenance Reminder Object Structure:

Property	Data Type	Description
category	String	Reminder category name — free-text (e.g., Oil Change, Tire Rotation, Brake Inspection)
description	String	Description of the reminder
direct	Boolean	Whether the reminder came from a direct integration/external system (true) or was inferred by Steer (false)
dueAt	Timestamp	When the service is due (UTC). null if no due date set
serviceAt	Timestamp	When the service was last performed (UTC). null if never serviced

Deferred Services

Services that were recommended but deferred by the customer, returned as a JSON array of service names.

Field Name	Data Type	Description	Required
VEHICLE_DEFERRED_SERVICES	JSON Array	Array of deferred service name strings (e.g., ["Brake Pad Replacement", "Transmission Flush"])	No

System Metadata

Field Name	Data Type	Description	Required
STEER_UPDATED_AT	Timestamp	Last modification timestamp for this vehicle record (UTC)	Yes

Field Enum Values

Vehicle Type

• Vehicle: Standard passenger vehicle
• Motorcycle: Motorcycle
• Truck: Truck or commercial vehicle

Usage Category

Based on Steer’s EstimatedMileage calculation using daily mileage ranges:

• Low: Below-average mileage (~12 mi/day, range 0–15)
• Moderate: Slightly below-average mileage (~20 mi/day, range 15–25)
• Normal: Average mileage (~33 mi/day, range 25–40) — default category
• High: Above-average mileage (~50 mi/day, range 40–60)
• VeryHigh: Significantly above-average mileage (~65 mi/day, range 60+)

Timestamp Handling

Caution

Timezone: All timestamp fields (VEHICLE_INSPECTION_EXPIRED_AT, VEHICLE_REGISTRATION_EXPIRED_AT, VEHICLE_LAST_SERVICE_AT, VEHICLE_PRODUCTION_AT, STEER_UPDATED_AT) are stored as timestamp_ntz (timestamp without timezone) in UTC. Maintenance reminder timestamps (dueAt, serviceAt) are also in UTC.

Data Quality Notes

Null Values

Note

Expected Null Values

• Vehicle detail fields (VEHICLE_SUBMODEL, VEHICLE_ENGINE, VEHICLE_COLOR, VEHICLE_LICENSE_PLATE, VEHICLE_VIN) may be null based on data completeness
• VEHICLE_FLEET_NUMBER may be null if not configured
• Odometer fields may be null if no service visits have been recorded
• Date fields (VEHICLE_INSPECTION_EXPIRED_AT, VEHICLE_REGISTRATION_EXPIRED_AT, VEHICLE_PRODUCTION_AT) may be null if not provided
• VEHICLE_MAINTENANCE_REMINDERS is null when no reminders exist for the vehicle
• VEHICLE_DEFERRED_SERVICES is null when no deferred services exist for the vehicle
• Within maintenance reminder objects, dueAt and serviceAt may be null

Sample Record

Complete API response example with a vehicle record:

{
  "data": [
    [
      "f2e3d4c5-b6a7-8901-2345-6789abcdef01",
      "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
      "d07a1282-b6c4-4527-ad8f-981b57660856",
      "Vehicle",
      2021,
      "Toyota",
      "Camry",
      "SE",
      "2.5L 4-Cylinder",
      "Silver",
      "ABC-1234",
      "TX",
      "1HGBH41JXMN109186",
      null,
      true,
      "Toyota",
      "Camry",
      "2021",
      45230.5,
      47800.0,
      "Normal",
      "2026-06-15T00:00:00.000Z",
      "2027-03-01T00:00:00.000Z",
      "2026-01-15T14:30:00.000Z",
      "2020-11-10T00:00:00.000Z",
      false,
      [
        {
          "category": "Oil Change",
          "description": "Synthetic oil change recommended",
          "direct": false,
          "dueAt": "2026-04-15T00:00:00.000Z",
          "serviceAt": "2026-01-15T14:30:00.000Z"
        },
        {
          "category": "Tire Rotation",
          "description": "Rotate all four tires",
          "direct": true,
          "dueAt": "2026-05-01T00:00:00.000Z",
          "serviceAt": null
        }
      ],
      ["Brake Pad Replacement", "Transmission Flush"],
      "2026-03-10T05:00:01.701Z"
    ]
  ],
  "metadata": {
    "rowType": [
      {"name": "STEER_TENANT_ID", "type": "text"},
      {"name": "STEER_VEHICLE_ID", "type": "text"},
      {"name": "STEER_CUSTOMER_ID", "type": "text"},
      {"name": "VEHICLE_TYPE", "type": "text"},
      {"name": "VEHICLE_YEAR", "type": "fixed"},
      {"name": "VEHICLE_MAKE", "type": "text"},
      {"name": "VEHICLE_MODEL", "type": "text"},
      {"name": "VEHICLE_SUBMODEL", "type": "text"},
      {"name": "VEHICLE_ENGINE", "type": "text"},
      {"name": "VEHICLE_COLOR", "type": "text"},
      {"name": "VEHICLE_LICENSE_PLATE", "type": "text"},
      {"name": "VEHICLE_STATE", "type": "text"},
      {"name": "VEHICLE_VIN", "type": "text"},
      {"name": "VEHICLE_FLEET_NUMBER", "type": "text"},
      {"name": "VEHICLE_IS_SPECIFICATION_MATCHED", "type": "boolean"},
      {"name": "VEHICLE_ORIGINAL_SPECIFICATION_MAKE", "type": "text"},
      {"name": "VEHICLE_ORIGINAL_SPECIFICATION_MODEL", "type": "text"},
      {"name": "VEHICLE_ORIGINAL_SPECIFICATION_YEAR", "type": "text"},
      {"name": "VEHICLE_LAST_VISIT_ODOMETER", "type": "real"},
      {"name": "VEHICLE_STEER_ESTIMATED_ODOMETER", "type": "real"},
      {"name": "VEHICLE_USAGE_CATEGORY", "type": "text"},
      {"name": "VEHICLE_INSPECTION_EXPIRED_AT", "type": "timestamp_ntz"},
      {"name": "VEHICLE_REGISTRATION_EXPIRED_AT", "type": "timestamp_ntz"},
      {"name": "VEHICLE_LAST_SERVICE_AT", "type": "timestamp_ntz"},
      {"name": "VEHICLE_PRODUCTION_AT", "type": "timestamp_ntz"},
      {"name": "VEHICLE_IS_DELETED", "type": "boolean"},
      {"name": "VEHICLE_MAINTENANCE_REMINDERS", "type": "array"},
      {"name": "VEHICLE_DEFERRED_SERVICES", "type": "array"},
      {"name": "STEER_UPDATED_AT", "type": "timestamp_ntz"}
    ]
  }
}