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 |