DiversityTaxonNames enumeration tables

DiversityTaxonNames enumeration tables

The following objects are not included:

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

CountryCode_Enum
LanguageCode_Enum
TaxonNameCreationType_Enum
TaxonNameListReferenceType_Enum
TaxonNameListSpecimenRole_Enum
TaxonNameNomenclaturalCode_Enum
TaxonNameNomenclaturalStatus_Enum
TaxonNameResourceType_Enum
TaxonNameRevisionLevel_Enum
TaxonNameSynonymisationType_Enum
TaxonNameTaxonomicRank_Enum

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

Table CountryCode_Enum

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

Dependent tables:

TaxonCommonName

Table LanguageCode_Enum

2 letter language codes according to ISO 639-1

Dependent tables:

TaxonCommonName

Table TaxonNameCreationType_Enum

Types of the creation of a taxonomic name

Dependent tables:

TaxonName

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

Table TaxonNameNomenclaturalStatus_Enum

Nomenclatural stati for taxonomic names

Dependent tables:

TaxonName

Table TaxonNameResourceType_Enum

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

Dependent tables:

TaxonNameResource

Table TaxonNameRevisionLevel_Enum

States of revision for the taxa

Dependent tables:

TaxonName

Table TaxonNameSynonymisationType_Enum

Types of the synonyms

Dependent tables:

TaxonSynonymy

Table TaxonNameTaxonomicRank_Enum

Taxonomic ranks of the taxa

Dependent tables:

TaxonName