π± Application Architecture
π src/app/
βββ π page.tsx # Landing/redirect page
βββ π login/ # Authentication
βββ π dashboard/ # Executive metrics overview
βββ π’ rooms/ # Live room monitoring (main page)
βββ π
bookings/ # Booking management
βββ π analytics/ # Historical analysis & Analytics Buckets
βββ π¨ alerts/ # Real-time facilities management system
βββ π€ profile/ # User profile settings
π src/components/
βββ π¨ ui/ # shadcn/ui base components
βββ π§ navigation/ # Navigation menu with role-based access
βββ π’ dashboard/ # Dashboard-specific widgets
βββ π charts/ # Custom chart components
βββ π§ common/ # Shared utility components
π src/lib/
βββ π supabase/ # Database client and configuration
βββ π― types/ # TypeScript definitions
βββ π οΈ utils/ # Helper functions and utilities
rooms - Conference room details (57 rooms across multiple floors)
sensor_readings - IoT sensor data (occupancy, temperature, noise, air quality)
room_bookings - Calendar integration and booking data
user_profiles - User authentication and role management
service_tickets - Automated facilities management tickets with ServiceNow integration
facility_alerts - Legacy system notifications and maintenance alerts
Live sensor updates via Supabase real-time subscriptions
Booking status changes with immediate UI updates
Automated capacity violation detection with service ticket creation
Real-time ticket queue processing and assignment workflows
ServiceNow integration for enterprise facilities management
Environmental monitoring with threshold notifications
Analytics Buckets Integration
Large-scale historical analysis using Apache Iceberg
Time travel queries for data versioning
Schema evolution support for changing data requirements
Open table format for data portability