Description:
Represents a vehicle category definition within the mobility platform. Each record captures category-specific configuration, hierarchical structure, and system-specific properties used across apps, dashboards, and backend services. Used for utilization analysis at category level and to scope pricing, eligibility, and promotions per category.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the vehicle category. |
created_at |
TIMESTAMP_TZ | Timestamp when the vehicle category was created. |
updated_at |
TIMESTAMP_TZ | Timestamp when the vehicle category was last updated. |
created_by |
NUMBER | ID of the user or system that created the vehicle category. |
updated_by |
NUMBER | ID of the user or system that last updated the vehicle category. |
parent_id |
NUMBER | ID of the parent vehicle category, if this category is part of a hierarchy. |
name |
TEXT | Human-readable name of the vehicle category. |
app_properties |
VARIANT | JSON field storing properties used by the mobile or frontend app. |
dashboard_properties |
VARIANT | JSON field with settings/configs relevant to the internal dashboard. |
core_properties |
VARIANT | JSON field with system-level or backend-related properties. |
bookable |
BOOLEAN | Indicates whether vehicles in this category can be booked. |
shared_properties |
VARIANT | JSON field with shared configuration across systems or modules. |
description |
TEXT | Optional free-text description of the category’s purpose or use case. |
vehicle_attribute_ids |
ARRAY | Array of attribute IDs associated with this vehicle category. |
_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. |