Description:
Represents the association between vehicles and hardware modules within the mobility platform. Tracks each time a vehicle’s module assignment changes, including the module it replaced (old_module_id), to support traceability and hardware lifecycle management.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the association record. |
module_id |
NUMBER | ID of the currently assigned module. |
old_module_id |
NUMBER | ID of the previously assigned module before the current one. |
vehicle_id |
NUMBER | ID of the vehicle that the module is or was associated with. |
created_at |
TIMESTAMP_TZ | Timestamp when this association was created. |
created_by |
NUMBER | ID of the user that created the association. |
_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. |