Diversity TaxonNames

Enumeration tables

The following objects are not included:

  • Logging tables
  • System objects
  • Objects marked as obsolete
  • Previous versions of objects

Table

Column Data type Description
Code nvarchar (50) A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.
Description nvarchar (800) Description of enumerated object, displayed in the user interface
DisplayText nvarchar (50) Short abbreviated description of the object, displayed in the user interface
DisplayOrder smallint The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.
DisplayEnable bit Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)
InternalNotes nvarchar (500) Internal development notes about usage, definition, etc. of an enumerated object
ParentCode nvarchar (50) The code of the superior entry, if a hierarchy within the entries is necessary
RowGUID uniqueidentifier -Default value: newsequentialid()

Content

Code Description DisplayText
1 Bacteriology Bacteriology
2 Botany (incl. Mycology) Botany (incl. Mycology)
3 Zoology Zoology
4 Biocode (for future use) Biocode (for future use)

Table CountryCode_Enum

2 letter codes for countries according to ISO 3166-1 alpha-2

Dependent tables:

  • TaxonCommonName

Content

Code Description DisplayText
AD Andorra Andorra
AE United Arab Emirates United Arab Emirates
AF Afghanistan Afghanistan
AG Antigua and Barbuda Antigua and Barbuda
AI Anguilla Anguilla
AL Albania Albania
AM Armenia Armenia
AO Angola Angola
AR Argentinia Argentinia
AS American Samoa American Samoa
AT Austria Austria
AU Australia Australia
AW Aruba Aruba
AZ Azerbaijan Azerbaijan
BA Bosnia and Herzegovina Bosnia and Herzegovina
BB Barbados Barbados
BD Bangladesh Bangladesh
BE Belgium Belgium
BF Burkina Faso Burkina Faso
BG Bulgaria Bulgaria
BH Bahrain Bahrain
BI Burundi Burundi
BJ Benin Benin
BM Bermuda Bermuda
BN Brunei Darussalam Brunei Darussalam
BO Bolivia Bolivia
BR Brazil Brazil
BS Bahamas Bahamas
BT Bhutan Bhutan
BW Botswana Botswana
BY Belarus Belarus
BZ Belize Belize
CA Canada Canada
CD congo The democratic republic of the congo The democratic republic of the
CF Central African Republic Central African Republic
CG Congo Congo
CH Switzerland Switzerland
CI Ivory Coast Ivory Coast
CK Cook Islands Cook Islands
CL Chile Chile
CM Cameroon Cameroon
CN China China
CO Colombia Colombia
CR Costa Rica Costa Rica
CU Cuba Cuba
CV Cape Verde Cape Verde
CX Christmas Island Christmas Island
CY Cyprus Cyprus
CZ Czech Republic Czech Republic
DE Germany Germany
DJ Djibouti Djibouti
DK Denmark Denmark
DM Dominica Dominica
DO Dominican Republic Dominican Republic
DZ Algeria Algeria
EC Ecuador Ecuador
EE Estonia Estonia
EG Egypt Egypt
ER Eritrea Eritrea
ES Spain Spain
ET Ethiopia Ethiopia
FI Finland Finland
FJ Fiji Fiji
FK Falkland Islands Falkland Islands
FO Faroe Islands Faroe Islands
FR France France
GA Gabon Gabon
GB United Kingdom United Kingdom
GD Grenada Grenada
GE Georgia Georgia
GF French Guiana French Guiana
GG Guernsey Guernsey
GH Ghana Ghana
GI Gibraltar Gibraltar
GL Greenland Greenland
GM Gambia Gambia
GN Guinea Guinea
GP Guadeloupe Guadeloupe
GR Greece Greece
GT Guatemala Guatemala
GU Guam Guam
GW Guinea-Bissau Guinea-Bissau
GY Guyana Guyana
HN Honduras Honduras
HR Croatia Croatia
HT Haiti Haiti
HU Hungary Hungary
ID Indonesia Indonesia
IE Ireland Ireland
IL Israel Israel
IM Isle of Man Isle of Man
IN India India
IQ Iraq Iraq
IR Iran Iran
IS Iceland Iceland
IT Italy Italy
JE Jersey Jersey
JM Jamaica Jamaica
JP Japan Japan
KE Kenya Kenya
KG Kyrgyzstan Kyrgyzstan
KH Cambodia Cambodia
KI Kiribati Kiribati
KM Comoros Comoros
KN Saint Kitts and Nevis Saint Kitts and Nevis
KY Cayman Islands Cayman Islands
KZ Kazakhstan Kazakhstan
LA Laos Laos
LB Lebanon Lebanon
LC Saint Lucia Saint Lucia
LI Liechtenstein Liechtenstein
LK Sri Lanka Sri Lanka
LR Liberia Liberia
LS Lesotho Lesotho
LT Lithuania Lithuania
LU Luxembourg Luxembourg
LV Latvia Latvia
LY Libya Libya
MA Morocco Morocco
MC Monaco Monaco
MD Moldova Moldova
MG Madagascar Madagascar
MH Marshall Islands Marshall Islands
MK Macedonia Macedonia
ML Mali Mali
MM Myanmar (Burma) Myanmar (Burma)
MN Mongolia Mongolia
MO Macao Macao
MP Northern Mariana Islands Northern Mariana Islands
MQ Martinique Martinique
MR Mauritania Mauritania
MS Montserrat Montserrat
MT Malta Malta
MU Mauritius Mauritius
MV Maldives Maldives
MW Malawi Malawi
MX Mexico Mexico
MY Malaysia Malaysia
MZ Mozambique Mozambique
NA Namibia Namibia
NC New Caledonia New Caledonia
NE Niger Niger
NF Norfolk Island Norfolk Island
NG Nigeria Nigeria
NI Nicaragua Nicaragua
NL Netherlands Netherlands
NO Norway Norway
NP Nepal Nepal
NR Nauru Nauru
NU Niue Niue
NZ New Zealand New Zealand
OM Oman Oman
PA Panama Panama
PE Peru Peru
PF French Polynesia French Polynesia
PG Papua New Guinea Papua New Guinea
PH Philippines Philippines
PK Pakistan Pakistan
PL Poland Poland
PN Pitcairn Pitcairn
PR Puerto Rico Puerto Rico
PT Portugal Portugal
PW Palau Palau
PY Paraguay Paraguay
QA Qatar Qatar
RE Reunion Reunion
RO Romania Romania
RU Russia Russia
RW Rwanda Rwanda
SA Saudi Arabia Saudi Arabia
SB Solomon Islands Solomon Islands
SC Seychelles Seychelles
SD Sudan Sudan
SE Sweden Sweden
SG Singapore Singapore
SH Saint Helena Saint Helena
SI Slovenia Slovenia
SK Slovak Republic Slovak Republic
SL Sierra Leone Sierra Leone
SM San Marino San Marino
SN Senegal Senegal
SO Somalia Somalia
SR Suriname Suriname
ST Sao Tome and Principe Sao Tome and Principe
SV El Salvador El Salvador
SZ Swaziland Swaziland
TC Turks and Caicos Islands Turks and Caicos Islands
TD Chad Chad
TG Togo Togo
TH Thailand Thailand
TJ Tajikistan Tajikistan
TK Tokelau Tokelau
TM Turkmenistan Turkmenistan
TN Tunisia Tunisia
TO Tonga Tonga
TR Turkey Turkey
TT Trinidad and Tobago Trinidad and Tobago
TV Tuvalu Tuvalu
TW Taiwan Taiwan
TZ Tanzania Tanzania
UA Ukrayina Ukrayina
UG Uganda Uganda
US United States United States
UY Uruguay Uruguay
UZ Uzbekistan Uzbekistan
VC Saint Vincent and the Grenadines Saint Vincent and the Grenadines
VE Venezuela Venezuela
VN Vietnam Vietnam
VU Vanuatu Vanuatu
WF Wallis and Futuna Wallis and Futuna
WS Samoa Samoa
YE Yemen Yemen
YT Mayotte Mayotte
ZA South Africa South Africa
ZM Zambia Zambia
ZW Zimbabwe Zimbabwe

Table LanguageCode_Enum

2 letter language codes according to ISO 639-1

Dependent tables:

  • TaxonCommonName

Content

Code Description DisplayText
af Afrikaans Afrikaans
ar Arabic Arabic
az Azerbaijani Azerbaijani
be Byelorussian Byelorussian
bg Bulgarian Bulgarian
ca Catalan Catalan
cs Czech Czech
da Danish Danish
de German German
el Greek Greek
en English English
es Spanish Spanish
et Estonian Estonian
eu Basque Basque
fa Persian Persian
fi Finnish Finnish
fo Faeroese Faeroese
fr French French
gl Galician Galician
gu Gujarati Gujarati
he Hebräisch Hebräisch
hi Hindi Hindi
hr Croatian Croatian
hu Hungarian Hungarian
hy Armenian Armenian
id Indonesisch Indonesisch
is Icelandic Icelandic
it Italian Italian
ja Japanese Japanese
ka Georgian Georgian
kk Kazakh Kazakh
kn Kannada Kannada
ko Korean Korean
ky Kirghiz Kirghiz
lt Lithuanian Lithuanian
lv Latvian Latvian
mk Macedonian Macedonian
mn Mongolian Mongolian
mr Marathi Marathi
ms Malay Malay
nl Dutch Dutch
no Norwegian Norwegian
pa Punjabi Punjabi
pl Polish Polish
pt Portuguese Portuguese
ro Romanian Romanian
ru Russian Russian
sa Sanskrit Sanskrit
sk Slovak Slovak
sl Slovenian Slovenian
sq Albanian Albanian
sv Swedish Swedish
sw Swahili Swahili
ta Tamil Tamil
te Tegulu Tegulu
th Thai Thai
tr Turkish Turkish
tt Tatar Tatar
uk Ukrainian Ukrainian
ur Urdu Urdu
uz Uzbek Uzbek
vi Vietnamese Vietnamese

Table TaxonNameCreationType_Enum

Types of the creation of a taxonomic name

Dependent tables:

  • TaxonName

Content

Code Description DisplayText
auto The name is an autonym, implicitly created through the creation of another taxon name – For example, if for “Poa alpina L.” a new subspecies “Poa alpina ssp. stefanovii Fiserova” is described, the autonym “Poa alpina L. ssp. alpina” is implicitly created as well. It is not published anywhere, and has no author on the subspecies (and neither author nor publication of Fiserova are given). auto
comb A new combination of a name into a different parent taxon that causes a name change. comb
combstat A new combination with a different name and change in rank of a taxon in a single nomenclatural action – For example, a subspecies in genus “Aus” is combined with genus “Bus” and the rank elevated to species at the same time. combstat
nom The name is a nomen novum (= replacement name, = avowed substitute). nom. nov.
sanct (Applicable only to Fungi:) The name is based on a prestarting-point name and sanctioned by the ICBN because is has been used in specific publications by Fries or Persoon. sanct
stat Change in rank of a taxon name, like a subspecies elevated to species rank, or a series to section. stat
tax Creation of a name at any rank, intended to represent a taxon that is new to science and based on an newly designated type. tax
validation The name is a validation of invalidly published names (sometimes expressed by “ex” in the author citation string). validation

Table TaxonNameListReferenceType_Enum

The types of the reference of the taxon list

Dependent tables:

  • TaxonNameListReference
  • TaxonNameReference

Table TaxonNameListSpecimenRole_Enum

Roles of collection specimen within a taxon list

Dependent tables:

  • TaxonNameListCollectionSpecimen

Table TaxonNameNomenclaturalCode_Enum

Codes of Nomenclature under which this taxa are created, e.g. Zoology

Dependent tables:

  • TaxonName

Content

Code Description DisplayText
1 Bacteriology Bacteriology
2 Botany (incl. Mycology) Botany (incl. Mycology)
3 Zoology Zoology
4 Biocode (for future use) Biocode (for future use)

Table TaxonNameNomenclaturalStatus_Enum

Nomenclatural stati for taxonomic names

Dependent tables:

  • TaxonName

Content

Code Description DisplayText
ad interim in the meantime ad interim
comb. combinatio = combination comb.
comb. ined. combinatio inedita = unpublished combination comb. ined.
comb. invalid. comb. invalid. comb. invalid.
comb. superfl. combinatio superflua = superfluous combination (if a combining author has missed on the pre-existence of the same combination, therefore creating an isonym) comb. superfl.
ined. indeditum = unpublished (name) ined.
nom. confus. nomen confusum = confused name nom. confus.
nom. cons. If a name of a family, genus, or species is accepted as a nomen conservandum the abbreviation “nom. cons.” should be added in a formal citation nom. cons.
nom. dub. nom. dub. nom. dub.
nom. excl. nom. excl. nom. excl.
nom. herb. nomen in herbario = name given on herbarium labels nom. herb.
nom. illeg. nomen illegitimum = illegitimate name (ICBN: 6.4, 52-54, App. VII) nom. illeg.
nom. inval. nom. invalid. nom. invalid.
nom. nov. nomen novum = new name, replacement name (ICBN: 45A.1, App. VII) nom. nov.
nom. nud. nom. nudum nom. nud.
nom. provis. nomen provisorium = provisional name nom. provis.
nom. rej. nomen rejiciendum = name, to be rejected (ICBN: 50E.2, 56, App.V, VII) nom. rej.
nom. superfl. nomen superfluum = superfluous name (ICBN: 52.1+3) nom. superfl.
pro syn. In the citation of a name that is not validly published because it was merely cited as a synonym, the words “as synonym” or “pro syn.” should be added pro syn.

Table TaxonNameResourceType_Enum

The type of an resource of a taxon, e.g. preview

Dependent tables:

  • TaxonNameResource

Content

Code Description DisplayText
audio E.g. audio file related to a taxon sound
drawing Original line or color drawing and painting of a taxon drawing, painting
image Still image of any raster or vector format without any further information regarding the content type, e. g. graphic designs, plans and maps, vector graphics 2D, 3D models image
information Any resource provided for the taxon, e.g. websites containing further information information
preview A small version of an image used as preview for an image preview
supporting files text-xml or text-WKT encoded files, assigned to multimedia objects supporting files
video E. g. video file related to a taxon video

Table TaxonNameRevisionLevel_Enum

States of revision for the taxa

Dependent tables:

  • TaxonName

Content

Code Description DisplayText
effectively published effectively published (ICBN Art. 29-31) effectively published (ICBN Art. 29-31)
final revision final revision final revision
review required review required review required
validly published validly published (ICBN Art. 32-45) validly published (ICBN Art. 32-45)

Table TaxonNameSynonymisationType_Enum

Types of the synonyms

Dependent tables:

  • TaxonSynonymy

Content

Code Description DisplayText
duplicate name is a duplicate of an other name, e.g. for imports of the same name from different sources duplicate
heterotypic heterotypic, the names have different basionyms heterotypic
homotypic homotypic, the names have the same basionym homotypic
isonym variant spelled exactly as another name but with deviating citation of the author(s), might be a name with wrong citation of the publishing or recombining author(s) or a even a isonym sensu ICBN isonym
orthographic variant variant spelled different as another name orthographic variant
unknown unknown if synonym is heterotypic or homotypic unknown

Table TaxonNameTaxonomicRank_Enum

Taxonomic ranks of the taxa

Dependent tables:

  • TaxonName

Content

Code Description DisplayText
agg. species aggregate species aggregate
aggr. species aggregate species aggregate
biovar. bio-variety bio-variety
cand. candidate candidate
cl. class class
convar. convar convar
cult. cultivar cultivar
cultivar. group cultivar-group cultivar-group
dom. domain (= empire) domain (= empire)
f. form form
f. sp. special form special form
fam. family family
gen. genus genus
graft-chimaera graft-chimaera graft-chimaera
grex infraspecific aggregate grex
infracl. infraclass infraclass
infrafam. infrafamily infrafamily
infragen. infragenus infragenus
infraord. infraorder infraorder
infraphyl./div. infraphylum (= infradivision) infraphylum (= infradivision)
infrareg. infrakingdom infrakingdom
infrasp. infraspecies infraspecies
infratrib. infratribe infratribe
ord. order order
pathovar. patho-variety patho-variety
phyl./div. phylum (= division) phylum (= division)
reg. kingdom kingdom
sect. section section
ser. series series
sp. species species
sp. group species group species group
subcl. subclass subclass
subfam. subfamily subfamily
subfm. subform subform
subgen. subgenus subgenus
subord. suborder suborder
subphyl./div. subphylum (= subdivision) subphylum (= subdivision)
subreg. subkingdom subkingdom
subsect. subsection subsection
subser. subseries subseries
subsp. subspecies subspecies
subsubfm. subsubform subsubform
subtrib. subtribe subtribe
subvar. sub-variety sub-variety
supercl. superclass superclass
superfam. superfamily superfamily
superord. superorder superorder
superphyl./div. superphylum (= superdivision) superphylum (= superdivision)
superreg. super kingdom super kingdom
supertrib. supertribe supertribe
tax. infragen. infrageneric tax. of undefined rank infrageneric tax. of undefined rank
tax. infrasp. infraspecific tax. of undefined rank infraspecific tax. of undefined rank
tax. supragen. suprageneric tax. of undefined rank suprageneric tax. of undefined rank
trib. tribe tribe
var. variety variety