Skip to content

Latest commit

Β 

History

History
56 lines (49 loc) Β· 2.3 KB

File metadata and controls

56 lines (49 loc) Β· 2.3 KB

πŸ“± Application Architecture

Page Structure

πŸ“ 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

Component Architecture

πŸ“ 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

Data Layer

πŸ“ src/lib/
β”œβ”€β”€ πŸ”Œ supabase/          # Database client and configuration
β”œβ”€β”€ 🎯 types/             # TypeScript definitions
└── πŸ› οΈ utils/             # Helper functions and utilities

πŸ—οΈ Database Schema

Core Tables

  • 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

Real-time Features

  • 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