task #7976
Updated by Andreas Müller over 5 years ago
Subticket for #1444: The taxon import in ERMS is the most complex one therefore we open a new ticket for it. Kingdoms: 1: - (Super)domain 2: Animalia 3: Plantae 4: Fungi 5: Protozoa 6: Bacteria 7: Chromista ?? 8: ?? 10: ?? 12: ?? 14: ?? are 8-14 relevant? they do not appear in any tu.tu_sp tree as root The Taxon table tu: id: the id tsn: ? (currently exported as extension) tu_name: the epithet or uninomial tu_displayname: full name without author (html?) tu_authority: author and year (without et. al.?) tu_parent: links to the parent, BUT for synonyms the parent is considered the name giving parent, e.g. for a species it is usually the genus given in the name and not the parent of the accepted name, for subgenus it is usually the genus; however, it is NOT always the case that the parent is name giving, there are also parent with no obvious relationship and therefore it is not clear what the parent relationship really means; tu_parent is always the last id in tu.tu_sp and therefore it is essential for creating the tree genus tu_parent: