Home IoT & TelemetryIoT Sensor Platform

IoT Sensor Platform

Time-series sensor platform with device management, readings, alerts, data aggregation, and calibration

SchemaVerse

IoT & TelemetryPostgreSQLEvent SourcingIoTTime-series

sensor-data.dbml

11 tables|9 relations

device_types

idinteger

namevarchar(100)

*UQ

manufacturervarchar(200)

modelvarchar(200)

descriptiontext

specificationsjson

created_attimestamp

devices

idinteger

device_idvarchar(100)

FK*UQ

device_type_idinteger

FK*

namevarchar(200)

locationvarchar(255)

latitudedecimal(10,7)

longitudedecimal(10,7)

installation_datedate

firmware_versionvarchar(50)

statusvarchar(20)

last_seen_attimestamp

created_attimestamp

updated_attimestamp

sensors

idinteger

device_idinteger

FK*

sensor_typevarchar(50)

namevarchar(100)

unitvarchar(20)

min_valuedecimal(10,2)

max_valuedecimal(10,2)

precision_decimalsinteger

sampling_interval_secondsinteger

is_activeboolean

created_attimestamp

updated_attimestamp

sensor_readings

idinteger

sensor_idinteger

FK*

valuedecimal(10,2)

timestamptimestamp

quality_scoredecimal(3,2)

metadatajson

created_attimestamp

device_groups

idinteger

namevarchar(100)

*UQ

descriptiontext

group_typevarchar(50)

created_attimestamp

updated_attimestamp

group_devices

group_idinteger

FK*

device_idinteger

FK*

created_attimestamp

alert_rules

idinteger

namevarchar(200)

sensor_typevarchar(50)

conditionvarchar(50)

threshold_valuedecimal(10,2)

threshold_mindecimal(10,2)

threshold_maxdecimal(10,2)

duration_secondsinteger

severityvarchar(20)

notification_channelsjson

is_activeboolean

created_attimestamp

updated_attimestamp

alerts

idinteger

sensor_idinteger

FK*

rule_idinteger

FK*

severityvarchar(20)

messagetext

triggered_valuedecimal(10,2)

triggered_attimestamp

acknowledged_attimestamp

acknowledged_byvarchar(200)

resolved_attimestamp

statusvarchar(20)

created_attimestamp

data_streams

idinteger

namevarchar(200)

descriptiontext

sensor_idsjson

aggregation_methodvarchar(50)

window_size_secondsinteger

is_activeboolean

created_attimestamp

updated_attimestamp

aggregated_readings

idinteger

stream_idinteger

FK*

window_starttimestamp

window_endtimestamp

value_avgdecimal(10,2)

value_mindecimal(10,2)

value_maxdecimal(10,2)

value_sumdecimal(12,2)

reading_countinteger

created_attimestamp

calibration_records

idinteger

sensor_idinteger

FK*

calibration_datetimestamp

performed_byvarchar(200)

reference_valuedecimal(10,2)

measured_valuedecimal(10,2)

offset_applieddecimal(10,2)

notestext

created_attimestamp

React Flow

About this Schema

Overview

IoT sensor data platform for collecting and analyzing time-series sensor readings. Manages device registration, data ingestion, alert rules, aggregation queries, and sensor calibration.

Key Design Decisions

Time-Series Storage: Optimized for high-frequency sensor readings
Alert System: Rule-based alerts on threshold violations
Data Aggregation: Pre-computed hourly/daily summaries
Calibration: Sensor calibration factors and drift correction

Tables

10 tables covering devices, sensors, readings, alerts, alert rules, aggregations, and calibration. IoT data platform foundation.

Comments

Loading comments...