Search the Community
Showing results for tags 'taxonomy'.
Found 1 result
Hi, I would like some advise on how to setup a database containing a (biology) taxonomy. I'll explain the idea. I will have a main table with information about a species and the taxonomy linked to this information. It's the taxonomy part that I'm not sure about what is the best way op setting it up. It contain species, genus, family and so on. (About 10 rank levels) After searching on the web I have the following ideas. 1. I make one table containing: ID, name, rank, parentID Then creating 10 (for each taxon rank) table occurrences relating parentID to ID. 2. Create 10 tables, one for each taxonomy rank with: ID, name, parentID and relate these also by parentID > ID. 3. I haven't figured out yet how this would workand what the advantage is, but I read about a join table used for a taxonomy ? So one table with name and rank and one with id and parentid ? One thing is that somethimes I will have a level in the taxonomy missing, for example, there will be a species name, and the next one will be a family name, so genus will not be used. This isn't a problem with option 1 as the parentID will be there. For option 2 that means I'll have to make an empty record (but with ID and parentID) to not break the chain. What option would you advise me to use ? Or suggesting another better option. ;-) I also want to make a single form to add a new species with the connecting taxon as easy as possible. Will these different options have a big influence on this or does it require a fair ammount of scripting anyway ? I hope you can help me selecting the best setup for my database.