Home IoT & TelemetryIoT Device Registry

IoT Device Registry

Device management with provisioning, OTA firmware updates, configuration, certificates, and telemetry

SchemaVerse

IoT & TelemetryPostgreSQLIoTNormalizedMicroservices

device-registry.dbml

13 tables|17 relations

device_types

idinteger

namevarchar(100)

*UQ

manufacturervarchar(200)

modelvarchar(200)

categoryvarchar(50)

hardware_versionvarchar(50)

descriptiontext

specificationsjson

created_attimestamp

updated_attimestamp

firmware_versions

idinteger

device_type_idinteger

FK*

versionvarchar(50)

release_datedate

changelogtext

file_urlvarchar(500)

file_size_bytesinteger

checksumvarchar(64)

is_stableboolean

min_hardware_versionvarchar(50)

is_activeboolean

created_attimestamp

devices

idinteger

device_idvarchar(100)

FK*UQ

device_type_idinteger

FK*

namevarchar(200)

serial_numbervarchar(100)

mac_addressvarchar(17)

firmware_version_idinteger

statusvarchar(20)

provisioned_attimestamp

activated_attimestamp

last_seen_attimestamp

ip_addressvarchar(45)

locationvarchar(255)

metadatajson

created_attimestamp

updated_attimestamp

device_configs

idinteger

device_idinteger

FK*

config_versioninteger

config_datajson

applied_attimestamp

statusvarchar(20)

error_messagetext

created_attimestamp

firmware_updates

idinteger

device_idinteger

FK*

from_version_idinteger

to_version_idinteger

FK*

statusvarchar(20)

scheduled_attimestamp

started_attimestamp

completed_attimestamp

progress_percentageinteger

error_messagetext

retry_countinteger

created_attimestamp

updated_attimestamp

device_events

idinteger

device_idinteger

FK*

event_typevarchar(50)

event_codevarchar(50)

messagetext

severityvarchar(20)

event_datajson

timestamptimestamp

created_attimestamp

locations

idinteger

namevarchar(200)

*UQ

location_typevarchar(50)

parent_idinteger

addresstext

cityvarchar(100)

statevarchar(50)

countryvarchar(100)

latitudedecimal(10,7)

longitudedecimal(10,7)

metadatajson

created_attimestamp

updated_attimestamp

device_locations

idinteger

device_idinteger

FK*

location_idinteger

FK*

installed_attimestamp

removed_attimestamp

is_currentboolean

created_attimestamp

device_groups

idinteger

namevarchar(100)

*UQ

descriptiontext

group_typevarchar(50)

parent_idinteger

created_attimestamp

updated_attimestamp

group_memberships

device_idinteger

FK*

group_idinteger

FK*

added_attimestamp

certificates

idinteger

device_idinteger

FK*

certificate_typevarchar(50)

common_namevarchar(255)

serial_numbervarchar(100)

*UQ

public_keytext

private_key_hashvarchar(64)

issuervarchar(255)

valid_fromtimestamp

valid_untiltimestamp

statusvarchar(20)

revoked_attimestamp

revocation_reasonvarchar(255)

created_attimestamp

updated_attimestamp

provisioning_records

idinteger

device_idinteger

FK*

provisioning_methodvarchar(50)

provisioned_byvarchar(200)

provisioning_codevarchar(100)

activation_codevarchar(100)

provisioned_attimestamp

activated_attimestamp

statusvarchar(20)

error_messagetext

created_attimestamp

device_telemetry

idinteger

device_idinteger

FK*

cpu_usage_percentdecimal(5,2)

memory_usage_percentdecimal(5,2)

disk_usage_percentdecimal(5,2)

uptime_secondsinteger

network_bytes_sentinteger

network_bytes_receivedinteger

battery_level_percentinteger

temperature_celsiusdecimal(5,2)

timestamptimestamp

created_attimestamp

React Flow

About this Schema

Overview

IoT device registry and management platform. Handles device provisioning, over-the-air (OTA) firmware updates, remote configuration, certificate management, and device telemetry.

Key Design Decisions

Device Provisioning: Secure onboarding with certificate issuance
OTA Updates: Staged firmware rollouts with rollback capability
Remote Configuration: Push configuration updates to devices
Telemetry: Collect device health metrics and connectivity status

Tables

13 tables covering devices, firmware, OTA updates, configurations, certificates, telemetry, and device groups. Enterprise IoT device management.

Comments

Loading comments...