Legal operationsDelivered
LCTS
A case tracker rebuilt without losing a single trigger.
The Legal Case Tracking System for E&S Sterling Attorneys, rebuilt from vanilla PHP and MySQL into React, Express and PostgreSQL. The schema was converted one to one from the production database dump, data included.
What it does
- 01Legacy MySQL trigger behaviour (case numbering, activity logging, assignment notifications, superadmin protection) reimplemented in the API layer
- 02Migration preserved every existing case record and its history
- 03Cookie-session authentication with document upload handling