HomeIoT & TelemetrySmart Home Automation

Smart Home Automation

Home automation with rooms, devices, automations, scenes, schedules, and energy monitoring

SchemaVerse
IoT & TelemetryPostgreSQLEvent SourcingIoTNormalized
1
0
0
smart-home.dbml
13 tables|17 relations

About this Schema

Overview

Smart home automation platform schema. Organizes devices by room, creates automation rules, defines scenes, schedules actions, and monitors energy consumption.

Key Design Decisions

  • Room Organization: Group devices by physical location
  • Automation Rules: Trigger-action rules (if motion, then lights on)
  • Scenes: One-tap multi-device control (movie mode, goodnight)
  • Energy Monitoring: Track consumption per device and room

Tables

12 tables covering homes, rooms, devices, automations, scenes, schedules, triggers, actions, and energy readings. Complete smart home platform.

Comments

Sign in to comment on this schema

Loading comments...