Description:
Captures the retirement or decommissioning events of hardware modules within the platform.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the module retirement record. |
created_at |
TIMESTAMP_TZ | Timestamp when the retirement record was created. |
image |
TEXT | Optional path or URL to an image documenting the retirement. |
note |
TEXT | Additional notes about the module’s retirement. |
reason |
NUMBER | Reason code indicating why the module was retired (0 => DAMAGE, 1 => LOST, 2 => OTHER). |
reason_name |
TEXT | String label for reason. |
created_by |
NUMBER | ID of the user or system that created the retirement entry. |
module_id |
NUMBER | ID of the module that was retired. |
_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. |