As a fish keeper I would like an inventory and record keeping system to help me care for and study fish.
Albino Catfish
I want to keep a list of all fish plus:
- The species of each fish
- The size of each fish when I got it
- Its current size
- What I am feeding it
Tank information:
- PH
- GH
- Temperature
- Size
I also want to keep a record of activities that includes:
- feedings
- cleanings
- medications
The information can be organized into tables
Tank Table
| tank identifier | description | tank location | size | target PH | target GH | temperature | image |
|---|---|---|---|---|---|---|---|
| 1 | fresh water 1 | library | 50 gallon | 7 | 80 | 78 | tank1.jpg |
| 2 | fresh water 2 | basement | 75 gallon | 7 | 80 | 76 | tank2.jpg |
Fish Table
We will link each row in our fish table to a row on the tank table because each fish is in a tank.| fish identifier | tank identifier | description | genus | variety | size when bought | current size | date bought | image | reference link |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | bronze corydoras | albino | 3 cm | 4cm | June 1, 2011 | albino corycat.jpg | Wikipedia | |
| 2 | 1 | corydoras | 4 cm | 5 cm | July 20, 2011 | corycat.jpg | Wikipedia |
Feeding History Table
I want to keep track of feeding by tank so the feeding table is related to the tank table. I don't need to relate the feeding table to the fish table because the fish table is related to the tank table.| feeding id | tank id | food type | amount | feeding notes | feeding date |
|---|---|---|---|---|---|
| 1 | 1 | flake | 1 gram | May 1, 2012 | |
| 2 | 1 | live | 1 gram | May 1, 2012 | |
| 3 | 2 | flake | 1 gram | May 1, 2012 |
Tank Water Quality History Table
I need a chart for keeping track of basic information, weekly water quality, a chart for No2, No3 and KH.| quality id | tank id | NO2 nitrites | NO3 nitrates | PH | KH carbonate hardness | GH general hardness | sample date |
|---|---|---|---|---|---|---|---|
| 1 | 1 | 0 | 30 ppm | 7 | 80 | 80 | May 1, 2012 |
| 2 | 1 | 0 | 25 ppm | 7 | 80 | 80 | May 2, 2012 |
| 3 | 2 | 0 | 20 ppm | 7 | 80 | 80 | May 2, 2012 |
Tank Maintenance History Table
I need a chart for tracking tank maintenance such as cycling.| maintenance id | tank id | type | notes | maintenance date |
|---|---|---|---|---|
| 1 | 1 | cycle | May 1, 2012 | |
| 2 | 1 | clean | May 15, 2012 | |
| 3 | 2 | cycle | May 2, 2012 |
I want to store the scientific names of fish in a table so I can pick the name of my fish from a list. I also want to be able to get more information on a fish from a reference like Wikipedia.
Taxonomy Table
| Taxonomy id | Scientific Name | Reference Type |
|---|---|---|
| 1 | Cyprinidae | WIKI |
| 2 | Barbus | WIKI |
| 3 | Barbus arulius | WIKI |
I want to be able to find the correct scientific name for a fish quickly so I want an easy name lookup.
Type in a scientific name for a fish and try out the fish name lookup.
It still needs some work and we are missing some names but give it a try.
Fish Name LookupClick the load fish names button and see a list of all fish names on the Taxonomy table and then practice finding fish from the list in the search box.