courtesy of Celebane

Here is a database application that can be used to keep track of your fish breeding in Fish Tycoon. It can keep track of fish combinations, prices, and required tank environment and provides sorting and query functions. It also provides a built-in event log that you can use to log events by date and time.

Here's a brief overview of the program:

Adding Bodies and Fins
In order to add entries to the Lineages table the bodies and fins must first be added to their respective tables. To add a new body type click on the BREEDS button in the bottom left corner. This will bring up the breeds list. To enter a new body click on Add. Type the name of the body then click save. Fin types are added the same way via the Fin Types button.

Once you have a fish's body and fin entered into their respective tables you can then construct the lineage for that fish. To do so click add in the bottom right of the main Lineages screen. This will pop up a window to let you choose the details of the fish you wish to add. On the left side you can choose the Fish's fin and body type as well as the tank level you think it might require and the price of the fish. On the right side you can select the parent's fins and bodies. In the notes section you can enter any notes such as if this is a magic fish or a perfect fish or the strange chemical or mutation fish were used. Click save to save your fish.

Column Sorting
You can click on any column header to sort by that column. The color of the active sort column will be red and the column header will be surrounded with <>. If there's a + in the <> you're sorting in ascending order. If its a - its in descending order.

Searching
Whatever column is highlighted in red is the column that the search in the upper left corner of the screen will look in. You can enter in the first few characters of what you want to search for (i.e raz for razorback) and then hit enter or tab to execute the search.

Querying
This is the most complex function in the app. This basically allows you to do complex searching across multiple columns. For instance, you might wanna see all the combinations you have found for betas. Since either parent1 or parent2 could be a beta you have to query both columns at the same time to find all instances. The query would look like this

PARENT1BODY = BETA OR PARENT2BODY = BETA

If you wanted to only get breeds where both parents were betas you would replace OR with AND.

Suppose you wanted to query all the instances in which you've bred a pink beta with something. The query would be

PARENT1FINTYPE = PINK AND PARENT1BODY = BETA OR PARENT2FINTYPE = PINK AND PARENT2BODY = BETA

Suppose you wish to find all the entries where the price is over $100. The query would be

Price > 100

You can combine this with the query above to get all the combinations over $100 where a parent was a pink beta by querying with this

PRICE > 100 AND PARENT1FINTYPE = PINK AND PARENT1BODY = BETA OR PARENT2FINTYPE = PINK AND PARENT2BODY = BETA


The query tool acts like a filter. Only showing you the records which fit your query and hiding all others. To reset the query Click the white square to the left of the query or hit the F6 key.