Live Operational IntegrationCloudflare D1 (Strictly Read-Only)
FastAttend Pro QR Attendance & Staff Profile Sync
Connected to admin.faithavenuehospitalgh.com and attendance.faithavenuehospitalgh.com (backed up to GitHub faithplus-attendance-pro). Imports all 59+ staff records and 43 cached profile photos for Faith Avenue Hospital & PlusLab Diagnostics.
Total Staff Synced
62
60 Active on duty
Faith Avenue Hospital
29
Hospital OPD, Wards & Pharmacy
PlusLab Diagnostics
31
Lab, Imaging, Ultrasound, Radiography
Profile Photos Stored
43
Offline avatars (/public/staff-photos/)
Database: faithplus-attendance-operational-gh-db•Protection: 4 Desk Logins Protected
Database Architecture & Multi-Desk Online Deployment
The Faith Avenue Hospital CMS is engineered on Prisma ORM and SQLite for seamless instant local dev and zero external dependency setup. To connect to a managed cloud database for multi-desk online browser access across Reception, Doctors, and Cashier:
# In prisma/schema.prisma:
datasource db { provider = "postgresql" }
# In .env (Supabase / Neon / Vercel Postgres):
DATABASE_URL="postgresql://postgres:[PASSWORD]@[HOST]:5432/postgres?sslmode=require"