Care Hub

A UK CQC-regulated residential and nursing home running on paper MAR charts, paper handover, paper everything — needing to digitise care plans, medications, incidents, safeguarding, training, audits, meals & nutrition, activities, rota, and CQC KLOE evidence into one system. Built to the same architecture standard as Compliance Hub, with the same RLS-first, RAG-as-data, audit-by-default principles, but tailored for the regulatory regime that actually matters to a care home: CQC Key Lines of Enquiry across Safe, Effective, Caring, Responsive, and Well-led.

mar_entries is the digital Medication Administration Record. Each entry stores resident_id, medication_id, administered_at, administered_by, dose, route, witness_id (NULL for non-CD), reason_not_given. RAG triggers compute the medication's status per resident — green if administered on time, amber if approaching window close, red if missed. For controlled drugs, the dual-signature requirement is enforced at the database level: CHECK (witness_id IS NOT NULL AND witness_id <> signed_by) You cannot insert a controlled_drugs_register entry where the witness is the same as the signer, and you cannot insert one without a witness at all. Application logic can be wrong; the database constraint cannot.

news2_observations stores RR, SpO2, scale, temp, BP, HR, consciousness. A SQL function computes the NEWS2 aggregate score per row. RAG status is derived: 0-4 = green, 5-6 (or any single param = 3) = amber, ≥7 = red. The dashboard surfaces every red NEWS2 observation in the last 24h as "residents needing attention" — the floor manager sees the deterioration before they walk into the room.

27 residents · 4,295 temperature logs · 155 supplier deliveries · 206 cleaning schedule rows · 246 menu plans · 60 medications · 142 MAR entries · 60 daily logs · 40 NEWS2 observations · 5 staff · 25 shifts · 3 controlled drug entries · 5 KLOE evidence tags · plus advance care plans, best-interests decisions, ABC charts, COSHH assessments, water outlet temp checks, fire drill records, supervision logs, appraisals. A prospective buyer logs in and sees a working care home, not a clean slate.

Live at care-hub.app on a GCP VM. Demo: demo@jonnyai.co.uk / Demo2026!! Strict CI: tsc --noEmit, next lint, next build — all hard gates. 22 application pages from /residents through /coshh to /reports/kloe. Mobile responsive. Sage primary #4A7C59 · warm gold #D4A574 · cream surface #FAF8F4 · forest text #2C3E2D — calm clinical palette, dark mode supported. Sold as a SaaS: £99/mo Starter (1 home, up to 5 staff users), £299/mo Pro (up to 5 homes, 25 users), £999/mo + £1,500 setup white-label for groups that need their own brand.