PawPatientManager - Backend

Backend service for veterinary clinic patient and staff management

📖 Overview

Backend for PawPatientManager System - A .NET-based service that provides management capabilities for veterinary clinics. The system enables registration and tracking of animals (patients), their owners, veterinary staff, and related clinic data such as species, breeds, and patient statuses.

Built on .NET 8 and ASP.NET Core, the backend provides a RESTful API architecture with Entity Framework Core for database operations using SQL Server. Real-time updates are delivered to connected clients via SignalR WebSockets, ensuring immediate synchronization across all clinic workstations.

The service manages critical veterinary clinic data including:

• Animal Patients - Complete patient records with demographic information, medical identifiers (microchip numbers), breed/species classification, and owner relationships
• Owners - Client contact information and address details with relationships to their pets
• Employees - Staff management with role-based organization
• Reference Data - Species, breeds, statuses, and roles for data consistency

🏗️ Architecture Overview

The PawPatientManager is built as a single BaseService microservice with a modular architecture designed for future scalability. The service follows a layered pattern with clear separation of concerns:

• Controllers Layer - RESTful API endpoints for CRUD operations on all entities
• Models Layer - Domain entities representing core business objects (Animals, Owners, Employees, etc.)
• Data Transfer Objects (DTOs) - Separate objects for API communication to control data exposure
• Context Layer - Entity Framework Core database context for data access
• Hubs Layer - SignalR WebSockets for real-time client communication

📊 Database Schema

The service uses Microsoft SQL Server with Entity Framework Core migrations. The database schema includes:

Entities:

• Employees - Staff records
• Roles - Staff role definitions
• Animals - Patient records
• Owners - Client information
• Species - Animal species reference
• Breeds - Animal breeds reference
• Statuses - Patient status reference