UNUS London  —  Compliance Architecture Division  |  UNCLASSIFIED // REGULATED INDUSTRIES
Home Solutions Legal & Professional Financial Services Manufacturing Healthcare Academy Blogs Ebooks About Book Discovery Call UNUS Govern
Home › Solutions › ⚖️ Legal & Professional Services › MS 01 — SRA Supervision Register
01
⚖️ Legal & Professional Services
← View All Solutions

Supervision Evidence. Retrieved in Under 30 Seconds.

The SRA Supervision Register is a PostgreSQL database system that tracks every supervision event for every fee earner in your firm. When an SRA inspector asks for evidence of compliance with §7.1, you retrieve it in under 30 seconds — not 30 minutes of searching emails.

The Problem This Solves
Law firms regularly fail SRA supervision audits not because supervision did not happen, but because they cannot evidence it. Supervision logs kept in Word documents, spreadsheets, or email chains cannot be searched, verified, or produced reliably under audit pressure.
Regulatory Basis
SRA Code of Conduct for Firms 2019, §7.1
Firms must ensure that the work of managers and employees is properly supervised. Evidence of supervision must be producible on request. The register provides the structural evidence layer that satisfies this requirement.
📅 Book Discovery Call ↗ See What's Included Send Enquiry
⚖️ Legal & Professional Services
MS 01
SRA Supervision Register
£1,647
ONE-TIME · FULL CODE OWNERSHIP · NO LICENCE FEE
✓ Production-ready PostgreSQL schema
✓ n8n automation workflow (JSON export)
✓ HTML / JavaScript frontend
✓ Immutable audit trail built in
✓ Build guide — step-by-step setup
✓ Sub-30-second evidence retrieval
✓ SRA Code of Conduct for Firms 2019, §7.1 aligned
Book Discovery Call ↗ Send Enquiry
Delivered and live within 14 days or money back
What's Included

Six Production-Ready Deliverables

Every component is built, tested, and transferred to you on day one of deployment. No dependencies. No ongoing licence fees. Full code ownership from the moment it goes live.

🗄️
supervision_events table
Core table capturing supervisor, fee earner, date, type, notes, and outcome for every supervision event. UUID primary key. firm_id foreign key for RLS isolation.
👤
fee_earners table
Staff register with role ENUM (trainee_solicitor, NQ_solicitor, associate, senior_associate, partner, consultant), admission date, and active flag.
📊
vw_supervision_coverage
Live view showing every active fee earner with their last supervision date, days since last supervision, and a coverage status flag (current / overdue / critical).
⚡
Overdue Supervision Trigger
PostgreSQL trigger fires when a supervision event is logged past the 90-day threshold. Alert record written to the notification queue for n8n pickup.
🔄
n8n Supervision Workflow
Multi-node n8n workflow handling form submission, field validation, UUID resolution, database insert, and email confirmation. Webhook-triggered, instant response.
🖥️
HTML Supervision Frontend
Clean HTML/JavaScript form for logging supervision events. Dropdowns populated from fee_earners table. Success state, validation feedback, and audit reference displayed on submit.
Technical Specification & Live View

Built to Run. Not to Demo.

Every UNUS London mini solution is a production system — not a prototype. The schema runs on PostgreSQL 17.4 with full referential integrity, Row-Level Security, and an immutable audit trail from day one. The n8n workflow handles every user interaction end-to-end.

The evidence view below is representative of the live data structure you will have in your system. Every record shown reflects the actual column names, data types, and status logic in the deployed schema.

DatabasePostgreSQL 17.4 (Supabase)
Tables2 (supervision_events, fee_earners)
Views1 (vw_supervision_coverage)
Triggers1 (overdue alert)
n8n Nodes8–12
Evidence Retrieval < 30 seconds
Avg Query Time < 20 ms
Code Ownership100% — transferred Day 1
legal-supervision-register — live data view
SE-2026-001 J. Okafor P. Mensah 03 Mar 2026 Monthly 1:1 ✓ Current
SE-2026-002 A. Clarke P. Mensah 28 Feb 2026 File review ✓ Current
SE-2026-003 T. Williams S. Adeola 14 Jan 2026 Monthly 1:1 ⚠ Overdue
SE-2026-004 M. Patel S. Adeola 06 Mar 2026 Court prep ✓ Current

Get the SRA Supervision Register
live in your firm.

A 30-minute discovery call is enough to scope this system for your firm, walk through the schema live, and confirm the delivery timeline. No obligation. A genuine technical conversation.

📅 Book Discovery Call ↗ Send Enquiry