Smart Device Schema
- File Name:
smartdevice.parquet - Type: Full
- Schema Version: 01.00
- Last Updated: 2026-02-25
Description
Contains master data for smart devices (IoT sensors, cameras, and monitoring equipment) including hardware specifications, connectivity information, and installation status.
Fields
📋 Includes Common Fields: Client Information, Location Information, Asset Information
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| SmartDeviceId | int | NOT NULL | Unique identifier for the smart device |
| SmartDeviceSerialNumber | varchar(255) | NOT NULL | Serial number of the smart device |
| SmartDeviceType | nvarchar(255) | NOT NULL | Type of smart device |
| MacAddress | varchar(255) | NOT NULL | MAC address |
| Imei | varchar(20) | NOT NULL | International Mobile Equipment Identity |
| SimNum | varchar(20) | NOT NULL | SIM card number |
| FirmwareVersion | varchar(255) | NOT NULL | Firmware version |
| HardwareVersion | varchar(10) | NOT NULL | Hardware version |
| InventoryLocation | varchar(50) | NOT NULL | Inventory location |
| ShippingDate | datetime | NULL | Shipping date |
| DeliveryDate | datetime | NULL | Delivery date |
| WarrantyEndDate | datetime | NULL | Warranty end date |
| InstallationDate | datetime | NULL | Installation date |
| LastPing | datetime | NULL | Last ping timestamp (local time) |
| LastPingUTC | datetime | NULL | Last ping timestamp (UTC) |
| ModifiedOn | datetime | NOT NULL | Record modification timestamp |
| LatestRssi | int | NULL | Latest signal strength (RSSI) |
| LatestHealthEventTime | datetime | NULL | Latest health event timestamp |
| ImageEventBatteryValue | int | NULL | Battery value at image event |
| InstallAssetBatteryValue | int | NULL | Battery value at asset installation |
| LatestLatitude | decimal(13,6) | NULL | Latest latitude coordinate |
| LatestLongitude | decimal(13,6) | NULL | Latest longitude coordinate |
| PurityDateTime | datetime | NULL | Latest image purity date/time |
| LatestImageStatus | varchar(500) | NULL | Status of latest image |
| ClientName | nvarchar(50) | NOT NULL | Name of the client |
| ClientCode | varchar(10) | NOT NULL | Code of the client |
| LocationId | int | NOT NULL | Location identifier |
| Name | nvarchar(200) | NULL | Location name |
| Code | nvarchar(100) | NULL | Location code |
| ExternalLocationCode | nvarchar(250) | NULL | External system location code |
| Street | nvarchar(150) | NULL | Street address |
| Street2 | nvarchar(150) | NULL | Street address line 2 |
| Street3 | nvarchar(150) | NULL | Street address line 3 |
| City | nvarchar(50) | NULL | City name |
| PostalCode | nvarchar(50) | NULL | Postal/ZIP code |
| StateId | int | NOT NULL | State/province identifier |
| State | nvarchar(50) | NOT NULL | State/province name |
| CountryId | int | NOT NULL | Country identifier |
| Country | varchar(50) | NOT NULL | Country name |
| DisplayName | varchar(500) | NOT NULL | Time zone display name |
| MarketId | int | NOT NULL | Market identifier |
| MarketName | nvarchar(150) | NOT NULL | Market name |
| LocationTypeId | int | NOT NULL | Location type identifier |
| Channel | nvarchar(255) | NOT NULL | Channel/location type name |
| ClassificationId | int | NOT NULL | Location classification identifier |
| Classification | nvarchar(200) | NOT NULL | Location classification name |
| DistributorId | int | NULL | Distributor identifier |
| DistributorName | nvarchar(100) | NULL | Distributor name |
| AssetId | int | NOT NULL | Asset identifier |
| SerialNumber | nvarchar(50) | NOT NULL | Asset serial number |
| ExternalAssetCode | nvarchar(250) | NULL | External system asset code |
| AssetTypeId | int | NOT NULL | Asset type identifier |
| AssetType | nvarchar(50) | NOT NULL | Asset type name |
| ModifiedByUsername | varchar(50) | NOT NULL | Username of last modifier |