A Versatile Aquatics Facility Inventory System with Real-Time Barcode Scan Entry

Research involving model organisms necessitates recording and archiving many types of animal maintenance and use data. We developed a comprehensive inventory system using FileMaker Pro (R) to incorporate, record, and archive data on zebrafish stocks, tank organization, husbandry, and fish usage. Our relational database is constructed of tables containing detailed information on fish identity, parents of origin, tank location, mutant phenotypes, caretakers, natural mating and in vitro fertilization experiments, and fish mortality. In addition to its basic annotation and reporting capabilities, the database allows barcode scan entry of several actions, for example, moving a tank of fish, mating or performing in vitro fertilization with specific fish, and recording dead fish. All data are input in real time using either barcode scanning or manual entry. The database provides several types of preformatted reports, as well as printed labels for tank location and stock identification. In summary, we have created a versatile, multipurpose inventory system that can be personalized and enhanced for any zebrafish facility and can be further adapted to organize data and archival information for other model systems or applications.