PHP

UI Veterinary Teaching Hospital Archive (UI-VTH)

A clinical records management system for the University of Ibadan Veterinary Teaching Hospital. The system manages patient animals, their owners, veterinary cases, diagnoses, treatments, and documents. Each animal receives a unique ID tag (format: VTH_AN_SURNAME_####) ensuring full traceability from case to animal to owner. Supports bulk document uploads, PDF attachments, and a searchable case history. Deployed with Windows installer packaging.


UI Veterinary Teaching Hospital Archive (UI-VTH) screenshot

Key Features

8 features built into this project

Unique animal ID tag system (VTH_AN_SURNAME_####)
Case management linked to specific animals
Owner and animal registration
Bulk document upload with PDF support
Case history search and filter
Role-based staff access
Windows installer (.zip) for offline deployment
Audit trail for all record changes

Challenges & Solutions

Technical problems encountered during development and how each was resolved.

1

The core architectural problem was that animals were previously linked to cases only by species — meaning a dog named "Rex" owned by Mr. Eze and another dog owned by Mrs. Obi were indistinguishable in case history. Implementing the unique ID tag system and migrating historical records without breaking existing case links required a carefully scripted data migration with rollback support.