ZFIN ID: ZDB-PUB-101011-10
A Versatile Aquatics Facility Inventory System with Real-Time Barcode Scan Entry
Anderson, J.L., Macurak, M.L., Halpern, M.E., and Farber, S.A.
Date: 2010
Source: Zebrafish   7(3): 281-287 (Journal)
Registered Authors: Anderson, Jennifer, Farber, Steven, Halpern, Marnie E., Macurak, Michelle
Keywords: none
MeSH Terms:
  • Animals
  • Aquaculture*
  • Databases, Factual*
  • Electronic Data Processing/methods*
  • Software
  • Zebrafish
PubMed: 20874493 Full text @ Zebrafish
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 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.