Description:
Records when a hardware module was detached from a vehicle. An audit-style entity that mirrors VEHICLES_MODULES_ASSOCIATIONS without the old_module_id field, supporting traceability of module lifecycle changes.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the dissociation record. |
module_id |
NUMBER | ID of the module that was detached from the vehicle. |
vehicle_id |
NUMBER | ID of the vehicle the module was detached from. |
created_at |
TIMESTAMP_TZ | Timestamp when this dissociation was created. |
created_by |
NUMBER | ID of the user that created the dissociation. |
_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. |