There is a need for a generic system to allow individual animal static details and life event data to be recorded and reported. Life events for farmed livestock are similar across the different animal species and production systems. This means that in principle a single relational database structure can be used with modifications made to allow appropriate labelling for a given species-production system of interest.
In the remainder of this document the term `herd health software' is used to describe the system to allow individual animal event data to be recorded, stored and reported on. A herd health software package is made up of three components:
The material presented in this document relates to item (1) --- a system to allow individual animal biographical and lifetime events to be electronically recorded. We describe the structure of a generic relational database required to record individual animal static details and life event data. To populate the tables that comprise the relational database a series of data entry forms are required. The data entry `system' might be deployed as software to run on a personal computer, as an app to run on either a smart phone or tablet, or via a web interface.
A staged approach to whole system development is proposed, as follows:
For development Stage 1 a herd-flock will be initiated by creating (using third party software tools) a CSV file listing the core data indicated in the tAnimals table. At the start of the first working day the tAnimals table will be copied from either the cloud or the farm server to the app. This allows herd-flock managers to enter lifetime events (e.g., calvings, heats, services, treatments) for individual animals that already exist in the herd-flock during a given working day.
At the end of a working day (when the herd-flock managers connect the app to the Internet) the data collected by the app during the day will be transfered to either the cloud or the farm server. If tables (i.e., CSV files) already exist on the cloud or on the farm server, the newly collected data will be appended to the existing data files.
At the outset (to keep things simple) only the tAnimals table will be copied to the app. This means that while a herd-flock manager will have access to biographical details for an individual via the app, they won't be able to view all lifetime events for that individual. Modifications to the system might be made in future to allow this to occur.