How mousegenomics/mausdb works
MausDB is a web-based MySQL application for managing mouse colonies and related phenotyping work. Its principal workflow is a user interacting with the CGI application, which provides colony and experimental-management capabilities backed by a database. The tree documents distinct modules for breeding, animal movement, treatment, phenotyping, importing and reporting, alongside SQL setup and query scripts. Only the browser JavaScript and README were sampled, so links among individual Perl modules and specific SQL operations are not asserted.
Main entry points: mausdb.cgi CGI application · DB_connect.pm DB connection · create_tables_mausdb.sql Database setup · SQL SQL operations
Components 17
Web application
- CGI application
code/usr/lib/cgi-bin/mausdb/mausdb.cgi - Browser controls
code/var/www/mausdb/static_pages/mausdb.js
Colony management
- Colony operations
code/usr/lib/cgi-bin/mausdb/lib_mating.pl - Weaning
code/usr/lib/cgi-bin/mausdb/lib_weaning.pl - Animal movement
code/usr/lib/cgi-bin/mausdb/lib_move.pl - Genotyping
code/usr/lib/cgi-bin/mausdb/lib_genotype.pl
Research operations
- Phenotyping
code/usr/lib/cgi-bin/mausdb/lib_phenotyping.pl - Experiments
code/usr/lib/cgi-bin/mausdb/lib_experiment.pl - Treatments
code/usr/lib/cgi-bin/mausdb/lib_treatment.pl - Data import
code/usr/lib/cgi-bin/mausdb/lib_import.pl - Reports
code/usr/lib/cgi-bin/mausdb/lib_reports.pl - Accounting
code/usr/lib/cgi-bin/mausdb/lib_accounting.pl
Data and persistence
- DB connection
code/var/maus_connect/DB_connect.pm - Database setup
SQL/setup_database/create_tables_mausdb.sql - SQL operations
SQL - MySQL database
Other components
- MausDB user
Connections 6
- MausDB user → CGI application: uses
- CGI application → Browser controls: serves controls
- CGI application → DB connection: connects through
- DB connection → MySQL database: connects to
- Database setup → MySQL database: creates schema
- SQL operations → MySQL database: queries and updates