About This Architecture
WattWise ERD models a comprehensive smart energy monitoring platform with nine interconnected entities tracking users, IoT devices, power outlets, and consumption patterns. Data flows from Device and Outlet entities through History Log and History Daily for granular and aggregated energy tracking, while Budget and Notification entities manage user alerts and spending limits. The schema demonstrates normalized database design for real-time power monitoring, historical analytics, and automated safety controls—essential for IoT applications requiring reliable audit trails and multi-tenant isolation. Fork this diagram on Diagrams.so to customize table relationships, add indexes, or adapt the schema for your AWS RDS or DynamoDB implementation. The Power Safety and Device Command entities exemplify how to layer automation and safety constraints into an energy management system.