PWA Ready • Supabase PostgreSQL • Dynamic QR 2.0

Modern Student Attendance & Timetable System

An enterprise-grade, responsive attendance ecosystem for colleges and universities. Featuring anti-proxy dynamic QR codes, master semester timetables, progressive offline web app support, and strict PostgreSQL Row-Level Security.

Enterprise Architecture

Comprehensive System Features

Engineered with modern web standards, progressive offline caching, and permanent PostgreSQL persistence via Supabase.

Dynamic Anti-Proxy QR

12-second cryptographic token rotation with millisecond timestamps and nonces preventing proxy attendance and screenshot forwarding.

Master Academic Timetable

Full semester schedule view for students and faculty featuring day-wise period slots, lab sessions, faculty names, and lecture room numbers.

Progressive Web App (PWA)

Installable directly on Android, iOS, and PC. Powered by Service Worker caching for instant loading and offline dashboard viewing.

Row Level Security (RLS)

PostgreSQL policies enforce strict role authorization. Students can only view & record their own presence, preventing unauthorized spoofing.

Multi-Mode Student Scanner

Offers 3 versatile check-in methods: live webcam scanner, photo snap for plain Wi-Fi HTTP, and an instant 1-click test simulator.

Real-Time Analytics & Reports

Instant percentage calculation, interactive Chart.js visualizations, subject-wise attendance logs, and RFC-4180 CSV export.

Full-Stack Cloud Architecture

PostgreSQL + Supabase + PWA Architecture

This application is engineered as a high-performance modern web application deployable on custom domains, cloud hosting, or local college intranets. All authentication, sessions, and relational records are securely managed in Supabase PostgreSQL with strict Row Level Security (RLS).

  • Vanilla ES6+ JavaScript for modular, sub-30ms execution speed
  • Progressive Web App (PWA) with service worker caching & installability
  • Supabase Auth & PostgreSQL RLS for encrypted sessions & database security
  • Dynamic 12s Cryptographic Nonce for anti-proxy attendance verification
Database Schema Overview
profiles ───< students ───< attendance >─── subjects >─── classes

// RLS Policy Verification
CREATE POLICY "Students view own attendance"
ON attendance FOR SELECT
TO authenticated
USING (student_id IN (SELECT id FROM students WHERE profile_id = auth.uid()));