DiversityTaxonNames

The following objects are not included:

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

TABLES

• ApplicationSearchSelectionStrings
• ProjectProxy
• ProjectUser
• ReplicationPublisher
• SynonymyListCache
• TaxonAcceptedName
• TaxonCommonName
• TaxonGeography
• TaxonHierarchy
• TaxonName
• TaxonNameExternalDatabase
• TaxonNameExternalID
• TaxonNameList
• TaxonNameListAnalysis
• TaxonNameListAnalysisCategory
• TaxonNameListAnalysisCategoryValue
• TaxonNameListArea
• TaxonNameListCollectionSpecimen
• TaxonNameListDistribution
• TaxonNameListImage
• TaxonNameListProjectProxy
• TaxonNameListReference
• TaxonNameListUser
• TaxonNameProject
• TaxonNameReference
• TaxonNameResource
• TaxonNameTypification
• TaxonSynonymy
• UserProxy



VIEWS

• AcceptedNameChanges
• ApplicationSearchSelectionStrings_Core
• GenusList
• NameID_UserAvailable
• ProjectList
• TaxonAcceptedName_Core
• TaxonAcceptedName_Indicated
• TaxonAcceptedNameList
• TaxonAcceptedNameListIncludeIgnored
• TaxonFamily
• TaxonGeography_Core
• TaxonHierarchy_Core
• TaxonListSynType
• TaxonName_Core
• TaxonName_Indicated
• TaxonNameExternalID_Core
• TaxonOrder
• TaxonSynonymy_Core
• TaxonSynonymy_Indicated
• TaxonSynonymyAcceptedNameID
• TaxonSynonymyList
• TaxonSynonymyListIncludeIgnored
• ViewBaseURL
• ViewDefaultProjectID
• ViewDiversityWorkbenchModule
• ViewTaxonNameResource



FUNCTIONS

• AcceptedNameID
• AnalysisCategoryHierarchyAll
• BaseURL
• DefaultProjectID
• DiversityMobile_TaxonList
• DiversityWorkbenchModule
• HierarchyCache
• HierarchyFamilyList
• HierarchyList
• HierarchyOrderList
• HierarchySuperiorList
• NameList
• NextNameID
• PrivacyConsentInfo
• SynonymyList
• SynonymyListIncludeIgnored
• TaxonChildNodes
• TaxonListLastUpdate
• TaxonListsForUser
• TaxonListsLastUpdate
• TaxonNameCache
• TaxonNameCacheSinAut
• TaxonNameListAnalysisCategoryChildNodes
• TaxonNameListAnalysisCategoryHierarchy
• TaxonNameListUserNameID
• UserID
• Version
• VersionClient



PROCEDURES

• procFillSynonymyListCache
• procHierarchyCache
• procSetVersionTaxonName
• procTaxonNameInsertCopy
• procTaxonNameInsertNew_3
• procTaxonNameListInsertCopy
• procTaxonNameListInsertReferenceCopy
• SetUserProjects



ROLES

• DiversityWorkbenchAdministrator
• DiversityWorkbenchEditor
• DiversityWorkbenchReplicator
• DiversityWorkbenchUser




TABLES

Table ApplicationSearchSelectionStrings

Manual edited queries for users



Column	Data type	Description	Nullable	Relation
UserName	varchar (50)	The name of the user who created this SQL string Default value: user_name()	NO	-
SQLStringIdentifier	varchar (50)	The identifier for the selection string as shown in user interface	NO	-
ItemTable	varchar (50)	The table from which the datasets should be selected	YES	-
SQLString	varchar (2000)	SQL string for selecting datasets from the database	YES	-
Description	nvarchar (MAX)	Description of the resultset and the purpose of the query	YES	-





Table ProjectProxy

Projects as retrieved from DiversityProjects



Column	Data type	Description	Nullable	Relation
ProjectID	int	ID of the project	NO	-
Project	nvarchar (50)	The name of the project	NO	-
ImageDescriptionTemplate	xml (MAX)	Template for the description of images	YES	-
ProjectURI	varchar (255)	The URI of the project, e.g. as provided by the module DiversityProjects.	YES	-





Table ProjectUser

User with access to a project



Column	Data type	Description	Nullable	Relation
LoginName	nvarchar (50)	ID of the User as stored in table UserProxy	NO	-
ProjectID	int	ID of the project. Foreign key, relates to PK of table ProjectProxy	NO	Refers to table ProjectProxy

Depending on:

• ProjectProxy




Table ReplicationPublisher

Source providing data for replication



Column	Data type	Description	Nullable	Relation
DatabaseName	varchar (255)	The name of the publishing database	NO	-
Server	varchar (255)	The name or address of the server where the publishing database is located	NO	-
Port	smallint	The port used by the server	YES	-





Table SynonymyListCache

Storing results of function SynonymyList



Column	Data type	Description	Nullable	Relation
ID	int	NameID of the selected taxon	NO	-
ProjectID	int	ProjectID of the synonymy	NO	-
NameID	int	ID of the synonymized name. Refers to the NameID of TaxonName (= foreign key).	NO	-
DisplayText	nvarchar (900)	A preformatet textstring for display in a synoymlist	YES	-
TaxonName	nvarchar (500)	The name of the taxon including the genus and the species epithet	YES	-
TaxonomicRank	nvarchar (50)	Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)	YES	-
InfraspecificEpithet	nvarchar (200)	The epithet of the infraspecific entity	YES	-
Authors	nvarchar (500)	The combined authors of this name	YES	-
SynonymText	nvarchar (500)	The text string containing the citation of the synonymisation	YES	-
Prefix	nvarchar (5)	The prefix as used in synonym lists	YES	-
Ord	int	The preferred sequence of the synonyms. The numbers in Ord correspond to the different kinds of the synonyms: -20 = Accepted name -10 = Basionym 0 = Homotypic Synonym > 0 = Heterotypic Synoyms > x + 1 = Isonym resp. Assigned to like 'duplicate', 'isonym', 'orthographic variant' (will be display after the name it is a variant of)	YES	-
YearOfPubl	int	The year when the name was published	YES	-
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)	YES	-
ConceptSuffix	nvarchar (200)	Empty for default and primary concept; else 's. lat.', 's. str.', 'sec.', 'sensu Muell.', 'emend.' , '(Auct.)' etc.	YES	-
ConceptNotes	nvarchar (500)	Notes on the concept of the name, e.g. incl. forms with black apothecia	YES	-
BasedOnNameID	int	The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID.	YES	-
SynType	nvarchar (50)	Type of the synonymization, e.g. 'heterotypic', 'homotypic'	YES	-
SynNameID	int	The ID of the synonym to which this name has been assigned to. Refers to the NameID of TaxonName (= foreign key).	NO	-
NameParentID	int	The NameID of the parent within the synonymy	YES	-





Table TaxonAcceptedName

TaxonAcceptedName contains the accepted names ("valid or preferred taxon names"). For each project, a name in "TaxonName" may either be accepted (a corresponding record in "TaxonAcceptedName" exists) or not. Examples for not accepted names are synonyms of accepted names and nomenclaturally rejected names.



Column	Data type	Description	Nullable	Relation
ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module. Default value: 0	NO	Refers to table ProjectProxy and table TaxonNameProject
NameID	int	ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).	NO	Refers to table TaxonNameProject
IgnoreButKeepForReference	tinyint	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. Default value: 0	NO	-
ConceptSuffix	nvarchar (200)	Empty for default and primary concept; else 's. lat.', 's. str.', 'sec.', 'sensu Muell.', 'emend.' , '(Auct.)' etc. Default value: ''	YES	-
ConceptNotes	nvarchar (500)	Notes on the concept of the name, e.g. incl. forms with black apothecia	YES	-
RefURI	varchar (255)	ReferenceURI: Source publication where synonymization is published (not publication of name!)	YES	-
RefText	nvarchar (255)	Free text, esp. where a RefURI is missing. Source publication where synonymization is published (not publication of name!)	YES	-
RefDetail	nvarchar (255)	Esp. page number on which the synonymization is published	YES	-
TypistsNotes	nvarchar (255)	An internal note of the responsible person concerning this synonymization. This information is NOT included in any report.	YES	-

Depending on:

• ProjectProxy
• TaxonNameProject

trgInsTaxonAcceptedName

Setting version of taxon



Table TaxonCommonName

TaxonCommonName contains the common names that are assigned to a scientific name.



Column	Data type	Description	Nullable	Relation
NameID	int	ID taxonomic name. Refers to the column NameID of the table TaxonName (= foreign key).	NO	Refers to table TaxonName
CommonName	nvarchar (220)	A common name of the taxonomic name	NO	-
LanguageCode	varchar (2)	The 2-letter code of the language of the common name according to ISO	NO	Refers to table LanguageCode_Enum
CountryCode	varchar (2)	The 2-letter code of the country where the common name is used according to ISO ISO 3166-1	NO	Refers to table CountryCode_Enum
ReferenceTitle	nvarchar (220)	The title of the reference where the common name was published	NO	-
ReferenceURI	varchar (255)	The URI of the reference e.g. as provided by the module DiversityReferences	YES	-
ReferenceDetails	nvarchar (500)	Esp. page number on which the common name is published	YES	-
SubjectContext	nvarchar (500)	The context in which the common name is used, e.g. pharmacy, food	YES	-
Transliteration	nvarchar (255)	Transliteration of the original name	YES	-
Notes	nvarchar (MAX)	Notes about the common name	YES	-

Depending on:

• CountryCode_Enum
• LanguageCode_Enum
• TaxonName

trgInsTaxonCommonName

Setting version of taxon



Table TaxonGeography

TaxonGeography is containing the information about the geographic distribution according to the protologue.



Column	Data type	Description	Nullable	Relation
NameID	int	ID of the name. Refers to the NameID of TaxonName (= foreign key).	NO	Refers to table TaxonName
PlaceURI	varchar (255)	URI (e.g. LSID) within e.g. the DiversityGazetteer for a place (which may have several names) as found in the protologue	NO	-
PlaceNameCache	nvarchar (100)	The name of the place	NO	-

Depending on:

• TaxonName

trgInsTaxonGeography

Setting version of taxon



Table TaxonHierarchy

TaxonHierarchy contains information about the hierarchical position of the taxa. For each project, a name may be referred to a single parent taxon. The attribute "NameParentID" may, however, be Null, in which case "HierarchyPositionIsUncertain" should be true.



Column	Data type	Description	Nullable	Relation
ProjectID	int	Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the DiversityProjects module. Default value: 0	NO	Refers to table ProjectProxy and table TaxonNameProject
NameID	int	Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).	NO	Refers to table TaxonNameProject
IgnoreButKeepForReference	tinyint	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. Default value: 0	NO	-
NameParentID	int	Next higher taxon (e.g. the family or subfamily if this taxon is a genus)	YES	-
HierarchyRefURI	varchar (255)	Reference URI: Source publication where the hierarchy is published (not publication of name!) as stored e.g. in DiversityReferences	YES	-
HierarchyRefText	nvarchar (255)	Free citation, esp. where a HierarchyRefURI is missing. Source publication where the hierarchy is published (not publication of name!)	YES	-
HierarchyRefDetail	nvarchar (255)	Esp. page number on which the hierarchy is published	YES	-
HierarchyPositionIsUncertain	bit	If the position of this taxon within this taxonomic group is uncertain. Default value: 0	YES	-
HierarchyTypistsNotes	nvarchar (255)	An internal note of the responsible person concerning this hierarchy. This information is NOT included in any report.	YES	-
HierarchyListCache	nvarchar (1000)	CALCULATED FIELD: List of higher taxa for faster access: "div.; class; ord.; fam."	YES	-

Depending on:

• ProjectProxy
• TaxonNameProject

trgInsTaxonHierarchy

Setting version of taxon and HierarchyListCache



Table TaxonName

TaxonName is the nomenclatural information. Most items are expected to be undisputed nomenclatural facts. Some data items include editorial opinion (nomenclatural status, but also the accepted spelling which may involve orthographical or grammatical corrections as required by ICBN). However, it is expected that within a project agreement can be achieved on the information contained in TaxonName, i.e. collaborators can "correct" information without consultation.



Column	Data type	Description	Nullable	Relation
NameID	int	The ID of a name in DiversityTaxonNames_Fungi (primary key)	NO	-
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)	YES	-
Version	smallint	The version of a name record (revision number, internally filled by system) Default value: (1)	YES	-
BasedOnNameID	int	The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID.	YES	Refers to table TaxonName
CreationType	nvarchar (50)	E.g.: taxon based on new type, combination based on a previously publ. name ('comb. nov.'), new name ('nom.nov.') introduced to replace a homonym (may occur for genera!), validation of previously invalidly publ. taxon name ('ex'), or unknown.	YES	Refers to table TaxonNameCreationType_Enum
TaxonomicRank	nvarchar (50)	Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank) Default value: N'sp.'	NO	Refers to table TaxonNameTaxonomicRank_Enum
GenusOrSupragenericName	nvarchar (200)	If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc.	NO	-
SpeciesGenusNameID	int	If rank is species or below: NameID of the Genus name. Refers to same table with TaxonomicRank = genus.	YES	Refers to table TaxonName
InfragenericEpithet	nvarchar (200)	If rank below genus and above species: Name of infrageneric taxon above species level (currently accepted spelling). Includes subgenus, series, etc.	YES	-
SpeciesEpithet	nvarchar (100)	The species name part of the species name, for example 'alba' in 'Abies alba'.	YES	-
InfraspecificEpithet	nvarchar (100)	The epithet of the infraspecific entity	YES	-
BasionymAuthors	nvarchar (100)	The authors of a newly created name. For all taxonomic ranks, only for 'comb. nov.' or 'nom. nov.': Author(s) of the basionym (will be displayed in '()', do not enter the parentheses), abbreviated according to authors standard	YES	-
CombiningAuthors	nvarchar (255)	The names of the combining authors if the name is base on another older name (e.g. combined into a different genus)	YES	-
PublishingAuthors	nvarchar (255)	If the authors of the taxon differ from the authors of the publication: the latter (...'in ' Publishing authors ... )	YES	-
SanctioningAuthor	nvarchar (100)	Sanctioning is a special instrument available for fungi to allow the starting date of taxonomy to be identical with higher plants, but preserve names used by Fries (Fr.) and Person (Pers.)	YES	-
NonNomenclaturalNameSuffix	nvarchar (200)	A suffix for concept names not included in any nomenclatural code. If present fields for authors and typification must be empty and NomenclaturalCode set to 'not under code'.	YES	-
IsRecombination	bit	True if the name is a recombination Default value: (0)	NO	-
IsHybrid	bit	If checked (or 'True'), the new taxon is a hybrid with or without a hybrid epithet. Default value: (0)	YES	-
HybridNameID1	int	If IsHybrid is checked (or 'True'): Name of hybrid species 1. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES	Refers to table TaxonName
HybridNameID2	int	If IsHybrid is checked (or 'True'): Name of hybrid species 2. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES	Refers to table TaxonName
HybridNameID3	int	If IsHybrid is checked (or 'True'): Name of hybrid species 3. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES	Refers to table TaxonName
HybridNameID4	int	If IsHybrid is checked (or 'True'): Name of hybrid species 4. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES	Refers to table TaxonName
ReferenceTitle	nvarchar (600)	The title of the publication where the name was published. Note this is only a cached value where ReferenceURI is present	YES	-
ReferenceURI	varchar (255)	URI (e.g. LSID) of Reference, referes to table ReferenceTitle in Database DiversityReferences: Source publication where name is published	YES	-
Volume	nvarchar (20)	The volume of the journal	YES	-
Issue	nvarchar (255)	The issue of the literature	YES	-
Pages	nvarchar (50)	The pages within the literature	YES	-
DetailLocation	nvarchar (200)	Additional information like plates etc.	YES	-
DayOfPubl	tinyint	The day when the name was published	YES	-
MonthOfPubl	tinyint	The month when the name was published	YES	-
YearOfPubl	smallint	The year when the name was published	YES	-
DateOfPublSupplement	nvarchar (200)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'	YES	-
YearOnPubl	smallint	The year cited on the original paper as year of publication	YES	-
DateOnPublSupplement	nvarchar (200)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'	YES	-
Protologue	nvarchar (MAX)	Full text of the protologue. If protologue is provided in Latin and in another language languages, both only the Latin or several languages may be stored together.	YES	-
ProtologueURI	varchar (255)	URI of externally available Protologue information (scanned image, full text from external provider, etc.)	YES	-
ProtologueResourceURI	varchar (255)	The ResourceID of an image of the protologue as stored in the module DiversityResources. Primary key of table Resource in the database DiversityResources.(= Foreign key)	YES	-
NameUsageReferences	nvarchar (255)	Indexing volumes like Index of Fungi or any Name usage that caused this name to be added to the database	YES	-
OriginalOrthography	nvarchar (255)	The original spelling of the name	YES	-
NomenclaturalCode	nvarchar (50)	Code of Nomenclature under which this taxon was created: 'Bacteriology', 'Botany' (incl. Mycology), 'Zoology', 'Biocode' (for future use), 'Non nomenclatural name'. Default value: 'Botany'	YES	Refers to table TaxonNameNomenclaturalCode_Enum
NomenclaturalStatus	nvarchar (50)	Categories for effective/valid/legitimate... esp. 'nom. illeg.', 'nom. inval.', 'nom. nudum', etc.	YES	Refers to table TaxonNameNomenclaturalStatus_Enum
NomenclaturalComment	nvarchar (MAX)	Comments on the nomenclature. e.g. 'according to ICBN Art. 39.1'	YES	-
Typification	nvarchar (50)	The status of the type specimen(s) as written in the protologue, e.g. holotype	YES	-
TypificationDetails	nvarchar (255)	Details concerning the typification as written in the protologue, e.g. if just parts of a specimen were accepted as the type	YES	-
TypificationReferenceTitle	nvarchar (255)	The title of the publication where the typification was published. Note this is only a cached value where Typification-LiteratureLink is present	YES	-
TypificationReferenceURI	varchar (255)	URI (e.g. LSID) of Reference, refers to e.g DiversityReferences: Source publication where the typification is published	YES	-
TypificationNotes	nvarchar (200)	Notes concerning the typification	YES	-
TypeSubstrate	nvarchar (255)	The substrate the type was growing on as written in the protologue	YES	-
TypeLocality	nvarchar (255)	The locality where the type was found as written in the protologue	YES	-
TypeSpecimenNotes	nvarchar (200)	Notes about the type specimen, e.g. the herbarium where a type specimen is located, Collector, collection date/number, etc.	YES	-
AnamorphTeleomorph	nvarchar (255)	If the name is related to a anamorph or a teleomorph as written in the protologue	YES	-
TypistNotes	nvarchar (200)	Additional notes and problems	YES	-
RevisionLevel	nvarchar (50)	The level of the revision of the taxonomic name, e.g. 'unchecked', 'fully checked'	YES	Refers to table TaxonNameRevisionLevel_Enum
IgnoreButKeepForReference	bit	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. Default value: (0)	YES	-
DataWithholdingReason	nvarchar (255)	If the dataset is withhold, the reason for withholding the data, otherwise null	YES	-
BasionymAuthorsYear	int	The year when the name was published by the authors of the Basionym	YES	-

Depending on:

• TaxonNameCreationType_Enum
• TaxonNameNomenclaturalCode_Enum
• TaxonNameNomenclaturalStatus_Enum
• TaxonNameRevisionLevel_Enum
• TaxonNameTaxonomicRank_Enum

trgInsTaxonName

Setting TaxonNameCache



Table TaxonNameExternalDatabase

TaxonNameExternalDatabase document the sources of the names.



Column	Data type	Description	Nullable	Relation
ExternalDatabaseID	int	An ID to identify an external data collection of plant names (primary key, the ID has no meaning outside of the DiversityWorkbench system)	NO	-
ExternalDatabaseName	nvarchar (800)	The name of the data collection that has been integrated or can be linked to for further analysis	NO	-
ExternalDatabaseVersion	nvarchar (255)	The version of this data collection (either official version number, or dates when the collection was integrated)	YES	-
Rights	nvarchar (500)	A description of copyright agreements or permission to use data from the external database	YES	-
ExternalDatabaseAuthors	nvarchar (200)	The persons or institutions responsible for the external database	YES	-
ExternalDatabaseURI	nvarchar (300)	The URI of the database provider resp. the external database	YES	-
ExternalDatabaseInstitution	nvarchar (300)	The institution responsible for the external database	YES	-
InternalNotes	nvarchar (1500)	Additional notes concerning this data collection	YES	-
ExternalAttribute_NameID	nvarchar (255)	The table and field name in the external data collection to which TaxonNameExternalID refers	YES	-
PreferredSequence	tinyint	For selection in e.g. picklists: of several equal names only the name from the source with the lowest preferred sequence will be provided.	YES	-
Disabled	bit	If this source should be disabled for selection of names e.g. in picklists	YES	-





Table TaxonNameExternalID

TaxonNameExternalID document the source of a name together with the ID of the source.



Column	Data type	Description	Nullable	Relation
NameID	int	The ID of a name in DiversityTaxonNames (foreign key + part of primary key: the name string associated with NameID may occur in multiple external databases)	NO	Refers to table TaxonName
ExternalDatabaseID	int	The ID of an external taxonomic data collection as defined in TaxontNameExternalDatabase (foreign key + part of primary key)	NO	Refers to table TaxonNameExternalDatabase
ExternalNameURI	varchar (255)	The URI (e.g. a LSID) of the external name as defined in the external database	YES	-

Depending on:

• TaxonName
• TaxonNameExternalDatabase




Table TaxonNameList

The table is containing the names listed in e.g. a checklist corresponding to the project.



Column	Data type	Description	Nullable	Relation
NameID	int	ID of the name. Refers to the NameID of TaxonName (= foreign key).	NO	Refers to table TaxonName
ProjectID	int	Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module.	NO	Refers to table TaxonNameListProjectProxy
Notes	nvarchar (MAX)	An note concerning this entry.	YES	-

Depending on:

• TaxonName
• TaxonNameListProjectProxy




Table TaxonNameListAnalysis

Analysis values for list entries in the database, "Red list category: R", "Time of observation: Sept. - Nov."



Column	Data type	Description	Nullable	Relation
NameID	int	ID of the name. Refers to the NameID of TaxonName (= foreign key).	NO	Refers to table TaxonNameList and table TaxonNameListReference
ProjectID	int	Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module.	NO	Refers to table TaxonNameList and table TaxonNameListReference
TaxonNameListRefID	int	Unique ID of the reference within the list, refers to table TaxonNameListReference, part of primary key Default value: (-1)	NO	Refers to table TaxonNameListReference
AnalysisID	int	ID of the analysis (= foreign key)	NO	Refers to table TaxonNameListAnalysisCategory
AnalysisValue	nvarchar (MAX)	The result of the analysis	YES	-
Notes	nvarchar (MAX)	Notes concerning this analysis	YES	-

Depending on:

• TaxonNameList
• TaxonNameListAnalysisCategory
• TaxonNameListReference




Table TaxonNameListAnalysisCategory

Analysis types used within the database, e.g. "Red list category", "Frequency"



Column	Data type	Description	Nullable	Relation
AnalysisID	int	ID of the analysis (Primary key)	NO	-
AnalysisParentID	int	Analysis ID of the parent analysis if it belongs to a certain type documented in this table	YES	-
DisplayText	nvarchar (50)	Name of the analysis as e.g. shown in user interface	YES	-
Description	nvarchar (MAX)	Description of the analysis	YES	-
AnalysisURI	varchar (255)	URI referring to an external documentation of the analysis	YES	-
Notes	nvarchar (MAX)	Notes concerning this analysis	YES	-
ReferenceTitle	nvarchar (800)	The title of the publication where details about the analysis are published. Note this is only a cached value where ReferenceURI is present	YES	-
ReferenceURI	varchar (400)	URI (e.g. LSID) of Reference, referes to table ReferenceTitle in module DiversityReferences: Source publication where details about the analysis are published	YES	-
DataWithholdingReason	nvarchar (255)	If the data set is withhold, the reason for withholding the data, otherwise null	YES	-
SortingID	int	An ID for sorting the data	YES	-





Table TaxonNameListAnalysisCategoryValue

Value lists for analysis types with predefined values, e.g. "0, 1, 2, 3, ..." for Red list category. Includes description etc. for the values in the list.



Column	Data type	Description	Nullable	Relation
AnalysisID	int	ID of the analysis (Primary key)	NO	Refers to table TaxonNameListAnalysisCategory
AnalysisValue	nvarchar (255)	The categorized value of the analysis	NO	-
Description	nvarchar (500)	Description of enumerated object, displayed in the user interface	YES	-
DisplayText	nvarchar (50)	Short abbreviated description of the object, displayed in the user interface	YES	-
DisplayOrder	smallint	The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.	YES	-
Notes	nvarchar (500)	Internal development notes about usage, definition, etc. of an enumerated object	YES	-

Depending on:

• TaxonNameListAnalysisCategory




Table TaxonNameListArea

The area defined for the whole taxon list



Column	Data type	Description	Nullable	Relation
ProjectID	int	Each project can have a different opinion regarding the parameters defined for a list. Refers to the common project definition in the DiversityProjects module.	NO	Refers to table TaxonNameListProjectProxy
PlaceURI	varchar (255)	URI or identifier for a place (which may have several names) derived from e.g. TDWG	NO	-
PlaceNameCache	nvarchar (255)	The name of the place	YES	-
Notes	nvarchar (MAX)	An note concerning this entry.	YES	-

Depending on:

• TaxonNameListProjectProxy




Table TaxonNameListCollectionSpecimen

The collection specimens on which the taxon list is based



Column	Data type	Description	Nullable	Relation
NameID	int	ID of the name. Refers to the NameID of TaxonName (= foreign key).	NO	Refers to table TaxonNameList
ProjectID	int	ProjectID of the taxon list. Foreign key and part of primary key.	NO	Refers to table TaxonNameList
DisplayText	varchar (255)	The name of the collection specimen as shown e.g. in a user interface. Part of the primary key	NO	-
CollectionSpecimenURI	varchar (255)	URI of the collection specimen. May refer to the module CollectionSpecimen	YES	-
Role	nvarchar (50)	The role of the specimen in relation to the taxon list (= foreign key, see table TaxonNameListSpecimenRole_Enum)	YES	Refers to table TaxonNameListSpecimenRole_Enum
Description	nvarchar (MAX)	Description of the collection specimen	YES	-
PlaceURI	varchar (255)	URI or identifier for a place (which may have several names) derived from e.g. TDWG	YES	-
PlaceNameCache	nvarchar (255)	The name of the place	YES	-
Notes	nvarchar (MAX)	Notes about the collection specimen	YES	-

Depending on:

• TaxonNameList
• TaxonNameListSpecimenRole_Enum




Table TaxonNameListDistribution

The geographical distrbution for the organisms within the taxon list.



Column	Data type	Description	Nullable	Relation
NameID	int	ID of the name. Refers to the NameID of TaxonName (= foreign key).	NO	Refers to table TaxonNameList and table TaxonNameListReference
ProjectID	int	Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module.	NO	Refers to table TaxonNameList and table TaxonNameListReference
TaxonNameListRefID	int	Unique ID of the reference within the list, refers to table TaxonNameListReference, part of primary key Default value: (-1)	NO	Refers to table TaxonNameListReference
PlaceURI	varchar (255)	URI or identifier for a place (which may have several names) derived from e.g. TDWG Default value: ''	NO	-
PlaceNameCache	nvarchar (255)	The name of the place Default value: ''	NO	-
Notes	nvarchar (MAX)	Notes concerning this analysis	YES	-

Depending on:

• TaxonNameList
• TaxonNameListReference




Table TaxonNameListImage

Media, e.g. images of the organisms within the taxon list



Column	Data type	Description	Nullable	Relation
NameID	int	ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).	NO	Refers to table TaxonNameList
ProjectID	int	Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module.	NO	Refers to table TaxonNameList
URI	varchar (255)	The complete URI address of the image.	NO	-
Description	xml (MAX)	Description of the image	YES	-
Notes	nvarchar (MAX)	Notes concerning this analysis	YES	-

Depending on:

• TaxonNameList




Table TaxonNameListProjectProxy

The taxon lists defined within the database. Links to the module DiversityProject



Column	Data type	Description	Nullable	Relation
ProjectID	int	ID of the Project, Primary key. May be related to module DiversityProjects	NO	-
Project	nvarchar (50)	The name of the project. May be related to module DiversityProjets	NO	-
ProjectURI	varchar (255)	The URI of the project, e.g. as provided by the module DiversityProjects.	YES	-
TaxonomicGroup	nvarchar (50)	The taxonomic group as used in DiversityCollection resp. DiversityMobile	YES	-
DisplayText	nvarchar (50)	The text as shown in a user interface. Corresponds to ProjectTitle in DiversityProjects.Project	YES	-
DefaultProjectID	int	The ID of the default project where informations about e.g. the synonymy are taken from	YES	-





Table TaxonNameListReference

The reference where the taxon list resp. the name is published



Column	Data type	Description	Nullable	Relation
NameID	int	ID of the name. Refers to the NameID of TaxonName (= foreign key).	NO	Refers to table TaxonNameList
ProjectID	int	Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module.	NO	Refers to table TaxonNameList
TaxonNameListRefID	int	Unique ID of the reference within the list, part of primary key	NO	-
TaxonNameListRefText	nvarchar (800)	Free text, esp. where a TaxonNameListRefURI is missing. Source publication where distribution is published (not publication of name!)	NO	-
TaxonNameListRefURI	varchar (255)	Reference URI: Source publication where the distribution is published (not publication of name!) as stored e.g. in DiversityReferences	YES	-
TaxonNameListRefDetail	nvarchar (255)	Esp. page number on which the distribution is published	YES	-
ReferenceType	nvarchar (50)	The type of the reference, e.g. a webpage	YES	Refers to table TaxonNameListReferenceType_Enum
TaxonUsageContext	nvarchar (50)	The context of the usage of the taxonomic name within the reference, e.g. ecology	YES	-
Notes	nvarchar (MAX)	An note concerning this entry.	YES	-

Depending on:

• TaxonNameList
• TaxonNameListReferenceType_Enum




Table TaxonNameListUser

The table is containing the lists accessible for a user.



Column	Data type	Description	Nullable	Relation
LoginName	nvarchar (50)	Login of a user.	NO	-
ProjectID	int	Project accessible for a user. Refers to ProjectID in table TaxonNameList (= foreign key).	NO	Refers to table TaxonNameListProjectProxy

Depending on:

• TaxonNameListProjectProxy




Table TaxonNameProject

TaxonNameProject documents the projects of the names and provides access to the data.



Column	Data type	Description	Nullable	Relation
NameID	int	The ID of a name in DiversityTaxonNames (foreign key + part of primary key: the name may occur in multiple projects)	NO	Refers to table TaxonName
ProjectID	int	ID of the project. Refers to the common project definition in the DiversityProjects module. Default value: 0	NO	Refers to table ProjectProxy

Depending on:

• ProjectProxy
• TaxonName




Table TaxonNameReference

References related to a taxonomic name



Column	Data type	Description	Nullable	Relation
NameID	int	ID of the name. Refers to the NameID of TaxonName (= foreign key).	NO	Refers to table TaxonName
TaxonNameRefID	int	Unique ID of the reference, part of primary key	NO	-
TaxonNameRefText	nvarchar (800)	The citation text of the reference	NO	-
TaxonNameRefURI	varchar (500)	Reference URI: Link to the source where the publication as stored e.g. DiversityReferences	YES	-
TaxonNameRefDetail	nvarchar (255)	Esp. page number on which the distribution is published	YES	-
ReferenceType	nvarchar (50)	The type of the reference, e.g. a webpage	YES	Refers to table TaxonNameListReferenceType_Enum
Notes	nvarchar (MAX)	An note concerning this entry.	YES	-

Depending on:

• TaxonName
• TaxonNameListReferenceType_Enum




Table TaxonNameResource

Resouces related to the taxonomic name



Column	Data type	Description	Nullable	Relation
NameID	int	ID of the name. Refers to the NameID of TaxonName (= foreign key).	NO	Refers to table TaxonNameProject
ProjectID	int	ID of the project. Refers to the common project definition in the DiversityProjects module.	NO	Refers to table TaxonNameProject
URI	varchar (255)	The complete URI address of the resource.	NO	-
Description	xml (MAX)	Description of the resource	YES	-
Notes	nvarchar (MAX)	A note concerning this entry.	YES	-
Title	nvarchar (500)	Title of the resource	YES	-
IPR	nvarchar (500)	Intellectual Property Rights; the rights given to persons for their intellectual property	YES	-
Creator	nvarchar (500)	Person or organization originally creating the resource	YES	-
CreatorAgentURI	varchar (500)	Link to the module DiversityAgents	YES	-
CopyrightStatement	nvarchar (500)	Notice on rights held in and for the resource	YES	-
LicenseType	nvarchar (500)	Type of an official or legal permission to do or own a specified thing, e. g. Creative Common Licenses	YES	-
LicenseHolder	nvarchar (500)	The person or institution holding the license	YES	-
LicenseHolderAgentURI	varchar (500)	The link to a module containing further information on the person or institution holding the license	YES	-
LicenseYear	nvarchar (50)	The year of license declaration	YES	-
DisplayOrder	int	The sequence in which the resource should be displayed in a user interface Default value: (1)	YES	-
DataWithholdingReason	nvarchar (255)	If the data set is withhold, the reason for withholding the data, otherwise null Default value: ''	YES	-
ResourceType	nvarchar (50)	Type of the resource as defined in table TaxonNameResourceType_Enum	YES	Refers to table TaxonNameResourceType_Enum

Depending on:

• TaxonNameProject
• TaxonNameResourceType_Enum




Table TaxonNameTypification

The typification of a taxonomic name, e.g. where the type information of the name was published



Column	Data type	Description	Nullable	Relation
NameID	int	The ID of a name in DiversityTaxonNames_Fungi (primary key)	NO	Refers to table TaxonName
TypificationReferenceTitle	nvarchar (255)	The title of the publication where the typification was published. Note this is only a cached value where Typification-LiteratureLink is present	NO	-
TypificationReferenceURI	varchar (255)	URI (e.g. LSID) of Reference, refers to e.g DiversityReferences: Source publication where the typification is published	YES	-
Typification	nvarchar (500)	The status of the type specimen(s) as written in the protologue, e.g. holotype	YES	-
TypificationDetails	nvarchar (255)	Details concerning the typification as written in the protologue, e.g. if just parts of a specimen were accepted as the type	YES	-
TypificationNotes	nvarchar (200)	Notes concerning the typification	YES	-
TypeSubstrate	nvarchar (255)	The substrate the type was growing on as written in the protologue	YES	-
TypeLocality	nvarchar (255)	The locality where the type was found as written in the protologue	YES	-
TypeSpecimenNotes	nvarchar (500)	Notes about the type specimen, e.g. the herbarium where a type specimen is located, Collector, collection date/number, etc.	YES	-

Depending on:

• TaxonName




Table TaxonSynonymy

TaxonSynonymy contains names, which are synonym to other names. Here a single name may be a synonym of multiple accepted names ("pro parte synonym"). The "pro parte" or corresponding sensu information is captured in the "ConceptSuffix" attribute, which is part of the primary key.



Column	Data type	Description	Nullable	Relation
ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module. Default value: (0)	NO	Refers to table ProjectProxy and table TaxonNameProject
NameID	int	ID of the synonymized name. Refers to the NameID of TaxonName (= foreign key).	NO	Refers to table TaxonNameProject
SynNameID	int	The ID of the synonym to which this name has been assigned to. Refers to the NameID of TaxonName (= foreign key).	NO	Refers to table TaxonNameProject
IgnoreButKeepForReference	tinyint	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. Default value: (0)	NO	-
ConceptSuffix	nvarchar (200)	Empty for default and primary concept; else 's. lat.', 's. str.', 'sec.', 'sensu Muell.', 'emend.' , '(Auct.)' etc. Default value: ''	YES	-
ConceptNotes	nvarchar (500)	Notes on the concept of the name, e.g. incl. forms with black apothecia	YES	-
SynRefURI	varchar (255)	Reference URI: Source publication where synonymization is published (not publication of name!) as stored e.g. in DiversityReferences	YES	-
SynRefText	nvarchar (255)	Free text, esp. where a SynRefURI is missing. Source publication where synonymization is published (not publication of name!)	YES	-
SynRefDetail	nvarchar (255)	Esp. page number on which the synonymization is published	YES	-
SynTypistsNotes	nvarchar (255)	An internal note of the responsible person concerning this synonymization. This information is NOT included in any report.	YES	-
SynType	nvarchar (50)	Type of the synonymization, e.g. 'heterotypic', 'homotypic' Default value: 'unknown'	NO	Refers to table TaxonNameSynonymisationType_Enum
SynIsUncertain	bit	If the synoymization is uncertain. Corresponding to =? for heterotypic synonyms and ? if the type of the synonymisation is unknown. Homotypic synonyms can not be uncertain. Default value: (0)	YES	-

Depending on:

• ProjectProxy
• TaxonNameProject
• TaxonNameSynonymisationType_Enum

trgInsTaxonSynonymy

Setting version of taxon



Table UserProxy

Table holding user information related to DiversityAgents



Column	Data type	Description	Nullable	Relation
LoginName	nvarchar (50)	Login of the user	NO	-
CombinedNameCache	nvarchar (500)	Name provided e.g. by DiversityAgents	YES	-
Queries	xml (MAX)	Queries created by the user	YES	-
CurrentProjectID	int	ID of the project selected by the user	YES	-
AgentURI	varchar (255)	A link to a DiversityAgents module where further informations about the user is available.	YES	-
ID	int	ID of the user	NO	-
PrivacyConsent	bit	If the user consents the storage of his user name in the database	YES	-
PrivacyConsentDate	datetime	The time and date when the user consented or refused the storage of his user name in the database	YES	-





VIEWS

View AcceptedNameChanges

Listing NameID of previous accepted names and the NameID of the current accepted name



Column	Data type	Description	Nullable
ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.	YES
NameID	int	ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).	YES
IgnoreButKeepForReference	tinyint	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.	YES
LogDate	datetime	Date of the changes according to the log table	NO
LogID	int	ID of the changes in the log table	NO
CurrentAcceptedNameID	int	NameID of the accepted name	YES

Depending on:

• TaxonAcceptedName
• TaxonAcceptedName_log
• TaxonSynonymy




View ApplicationSearchSelectionStrings_Core

Manual edited queries for users



Column	Data type	Description	Nullable
SQLStringIdentifier	varchar (50)	The identifier for the selection string as shown in user interface	NO
ItemTable	varchar (50)	The table from which the datasets should be selected	YES
SQLString	varchar (2000)	SQL string for selecting datasets from the database	YES
Description	nvarchar (MAX)	Description of the resultset and the purpose of the query	YES

Depending on:

• ApplicationSearchSelectionStrings




View GenusList

All Taxa with rank genus



Column	Data type	Description	Nullable
NameID	int	The ID of a name in DiversityTaxonNames_Fungi (primary key)	NO
TaxonNameCache	nvarchar (200)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)	YES

Depending on:

• TaxonName




View NameID_UserAvailable

List of NameIDs accessible for the current user



Column	Data type	Description	Nullable
NameID	int	The ID of a name in DiversityTaxonNames (foreign key + part of primary key: the name may occur in multiple projects)	NO

Depending on:

• ProjectUser
• TaxonNameProject




View ProjectList

List of projects accessible for the current user



Column	Data type	Description	Nullable
Project	nvarchar (50)	The name of the project	NO
ProjectID	int	ID of the project	NO
ProjectURI	varchar (255)	The URI of the project, e.g. as provided by the module DiversityProjects.	YES

Depending on:

• ProjectProxy
• ProjectUser




View TaxonAcceptedName_Core

Content of TaxonAcceptedName restricted to datasets accessible for a user



Column	Data type	Description	Nullable
ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.	NO
NameID	int	ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).	NO
IgnoreButKeepForReference	tinyint	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.	NO
ConceptSuffix	nvarchar (200)	Empty for default and primary concept; else 's. lat.', 's. str.', 'sec.', 'sensu Muell.', 'emend.' , '(Auct.)' etc.	YES
ConceptNotes	nvarchar (500)	Notes on the concept of the name, e.g. incl. forms with black apothecia	YES
RefURI	varchar (255)	ReferenceURI: Source publication where synonymization is published (not publication of name!)	YES
RefText	nvarchar (255)	Free text, esp. where a RefURI is missing. Source publication where synonymization is published (not publication of name!)	YES
RefDetail	nvarchar (255)	Esp. page number on which the synonymization is published	YES
TypistsNotes	nvarchar (255)	An internal note of the responsible person concerning this synonymization. This information is NOT included in any report.	YES

Depending on:

• NameID_UserAvailable
• TaxonAcceptedName




View TaxonAcceptedName_Indicated

List of IDs of accepted names



Column	Data type	Description	Nullable
ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.	NO
NameID	int	ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).	NO
IgnoreButKeepForReference	tinyint	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.	NO
ConceptSuffix	nvarchar (200)	Empty for default and primary concept; else 's. lat.', 's. str.', 'sec.', 'sensu Muell.', 'emend.' , '(Auct.)' etc.	YES
ConceptNotes	nvarchar (500)	Notes on the concept of the name, e.g. incl. forms with black apothecia	YES
RefURI	varchar (255)	ReferenceURI: Source publication where synonymization is published (not publication of name!)	YES
RefText	nvarchar (255)	Free text, esp. where a RefURI is missing. Source publication where synonymization is published (not publication of name!)	YES
RefDetail	nvarchar (255)	Esp. page number on which the synonymization is published	YES
TypistsNotes	nvarchar (255)	An internal note of the responsible person concerning this synonymization. This information is NOT included in any report.	YES

Depending on:

• TaxonAcceptedName




View TaxonAcceptedNameList

List of accepted names excluding ignored names



Column	Data type	Description	Nullable
NameID	int	ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).	NO
DisplayText	nvarchar (4000)	Combining taxon, publication and nomenclatural information	YES
TaxonName	nvarchar (301)	Combining taxon information excluding authors	YES
TaxonomicRank	nvarchar (52)	Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)	NO
InfraspecificEpithet	nvarchar (101)	The epithet of the infraspecific entity	YES
Authors	nvarchar (719)	Combining all author information of the taxon	YES
SynonymText	nvarchar (1683)	Combining publication and nomenclatural information	YES
YearOfPubl	smallint	The year when the name was published	YES
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)	YES
ConceptSuffix	nvarchar (200)	Empty for default and primary concept; else 's. lat.', 's. str.', 'sec.', 'sensu Muell.', 'emend.' , '(Auct.)' etc.	YES
ConceptNotes	nvarchar (500)	Notes on the concept of the name, e.g. incl. forms with black apothecia	YES
BasedOnNameID	int	The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID.	YES
ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.	NO
NomenclaturalStatus	nvarchar (50)	Categories for effective/valid/legitimate... esp. 'nom. illeg.', 'nom. inval.', 'nom. nudum', etc.	YES

Depending on:

• TaxonAcceptedName
• TaxonName




View TaxonAcceptedNameListIncludeIgnored

List of accepted names including ignored names



Column	Data type	Description	Nullable
NameID	int	ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).	NO
DisplayText	nvarchar (2609)	Combining taxon, publication and nomenclatural information	YES
TaxonName	nvarchar (301)	Combining taxon information excluding authors	YES
TaxonomicRank	nvarchar (52)	Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)	NO
InfraspecificEpithet	nvarchar (101)	The epithet of the infraspecific entity	YES
Authors	nvarchar (719)	Combining all author information of the taxon	YES
SynonymText	nvarchar (1338)	Combining publication and nomenclatural information	YES
YearOfPubl	smallint	The year when the name was published	YES
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)	YES
ConceptSuffix	nvarchar (200)	Empty for default and primary concept; else 's. lat.', 's. str.', 'sec.', 'sensu Muell.', 'emend.' , '(Auct.)' etc.	YES
ConceptNotes	nvarchar (500)	Notes on the concept of the name, e.g. incl. forms with black apothecia	YES
BasedOnNameID	int	The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID.	YES
ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.	NO
NomenclaturalStatus	nvarchar (50)	Categories for effective/valid/legitimate... esp. 'nom. illeg.', 'nom. inval.', 'nom. nudum', etc.	YES
IgnoreButKeepForReference	bit	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.	YES

Depending on:

• TaxonAcceptedName
• TaxonName




View TaxonFamily

Family information for taxa



Column	Data type	Description	Nullable
NameID	int	Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).	NO
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)	YES
FamilyNameID	int	NameID for the family	YES
Family	nvarchar (200)	The name of the family	YES
IgnoreButKeepForReference	int	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.	NO

Depending on:

• TaxonHierarchy
• TaxonName
• TaxonNameTaxonomicRank_Enum




View TaxonGeography_Core

User available information of the geography



Column	Data type	Description	Nullable
NameID	int	ID of the name. Refers to the NameID of TaxonName (= foreign key).	NO
PlaceURI	varchar (255)	URI (e.g. LSID) within e.g. the DiversityGazetteer for a place (which may have several names) as found in the protologue	NO
PlaceNameCache	nvarchar (100)	The name of the place	YES

Depending on:

• NameID_UserAvailable
• TaxonGeography




View TaxonHierarchy_Core

User available information of the hierarchy



Column	Data type	Description	Nullable
ProjectID	int	Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the DiversityProjects module.	NO
NameID	int	Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).	NO
IgnoreButKeepForReference	tinyint	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.	NO
NameParentID	int	Next higher taxon (e.g. the family or subfamily if this taxon is a genus)	YES
HierarchyRefURI	varchar (255)	Reference URI: Source publication where the hierarchy is published (not publication of name!) as stored e.g. in DiversityReferences	YES
HierarchyRefText	nvarchar (255)	Free citation, esp. where a HierarchyRefURI is missing. Source publication where the hierarchy is published (not publication of name!)	YES
HierarchyRefDetail	nvarchar (255)	Esp. page number on which the hierarchy is published	YES
HierarchyPositionIsUncertain	bit	If the position of this taxon within this taxonomic group is uncertain.	YES
HierarchyTypistsNotes	nvarchar (255)	An internal note of the responsible person concerning this hierarchy. This information is NOT included in any report.	YES
HierarchyListCache	nvarchar (1000)	CALCULATED FIELD: List of higher taxa for faster access: "div.; class; ord.; fam."	YES

Depending on:

• NameID_UserAvailable
• TaxonHierarchy




View TaxonListSynType

Public available information for taxa including synonymy



Column	Data type	Description	Nullable
NameID	int	ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).	NO
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)	YES
BasedOnNameID	int	The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID.	YES
CreationType	nvarchar (50)	E.g.: taxon based on new type, combination based on a previously publ. name ('comb. nov.'), new name ('nom.nov.') introduced to replace a homonym (may occur for genera!), validation of previously invalidly publ. taxon name ('ex'), or unknown.	YES
TaxonomicRank	nvarchar (50)	Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)	NO
GenusOrSupragenericName	nvarchar (200)	If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc.	NO
SpeciesGenusNameID	int	If rank is species or below: NameID of the Genus name. Refers to same table with TaxonomicRank = genus.	YES
InfragenericEpithet	nvarchar (200)	If rank below genus and above species: Name of infrageneric taxon above species level (currently accepted spelling). Includes subgenus, series, etc.	YES
SpeciesEpithet	nvarchar (100)	The species name part of the species name, for example 'alba' in 'Abies alba'.	YES
InfraspecificEpithet	nvarchar (100)	The epithet of the infraspecific entity	YES
BasionymAuthors	nvarchar (100)	The authors of a newly created name. For all taxonomic ranks, only for 'comb. nov.' or 'nom. nov.': Author(s) of the basionym (will be displayed in '()', do not enter the parentheses), abbreviated according to authors standard	YES
CombiningAuthors	nvarchar (255)	The names of the combining authors if the name is base on another older name (e.g. combined into a different genus)	YES
PublishingAuthors	nvarchar (255)	If the authors of the taxon differ from the authors of the publication: the latter (...'in ' Publishing authors ... )	YES
SanctioningAuthor	nvarchar (100)	Sanctioning is a special instrument available for fungi to allow the starting date of taxonomy to be identical with higher plants, but preserve names used by Fries (Fr.) and Person (Pers.)	YES
NonNomenclaturalNameSuffix	nvarchar (200)	A suffix for concept names not included in any nomenclatural code. If present fields for authors and typification must be empty and NomenclaturalCode set to 'not under code'.	YES
IsHybrid	bit	If checked (or 'True'), the new taxon is a hybrid with or without a hybrid epithet.	YES
HybridNameID1	int	If IsHybrid is checked (or 'True'): Name of hybrid species 1. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES
HybridNameID2	int	If IsHybrid is checked (or 'True'): Name of hybrid species 2. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES
HybridNameID3	int	If IsHybrid is checked (or 'True'): Name of hybrid species 3. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES
HybridNameID4	int	If IsHybrid is checked (or 'True'): Name of hybrid species 4. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES
ReferenceTitle	nvarchar (600)	The title of the publication where the name was published. Note this is only a cached value where ReferenceURI is present	YES
ReferenceURI	varchar (255)	URI (e.g. LSID) of Reference, referes to table ReferenceTitle in Database DiversityReferences: Source publication where name is published	YES
Volume	nvarchar (20)	The volume of the journal	YES
Issue	nvarchar (255)	The issue of the literature	YES
Pages	nvarchar (50)	The pages within the literature	YES
YearOfPubl	smallint	The year when the name was published	YES
YearOnPubl	smallint	The year cited on the original paper as year of publication	YES
NameUsageReferences	nvarchar (255)	Indexing volumes like Index of Fungi or any Name usage that caused this name to be added to the database	YES
OriginalOrthography	nvarchar (255)	The original spelling of the name	YES
NomenclaturalCode	nvarchar (50)	Code of Nomenclature under which this taxon was created: 'Bacteriology', 'Botany' (incl. Mycology), 'Zoology', 'Biocode' (for future use), 'Non nomenclatural name'. Default value: 'Botany'	YES
NomenclaturalStatus	nvarchar (50)	Categories for effective/valid/legitimate... esp. 'nom. illeg.', 'nom. inval.', 'nom. nudum', etc.	YES
NomenclaturalComment	nvarchar (MAX)	Comments on the nomenclature. e.g. 'according to ICBN Art. 39.1'	YES
Typification	nvarchar (50)	The status of the type specimen(s) as written in the protologue, e.g. holotype	YES
TypificationDetails	nvarchar (255)	Details concerning the typification as written in the protologue, e.g. if just parts of a specimen were accepted as the type	YES
TypeSubstrate	nvarchar (255)	The substrate the type was growing on as written in the protologue	YES
TypeLocality	nvarchar (255)	The locality where the type was found as written in the protologue	YES
TypificationReferenceTitle	nvarchar (255)	The title of the publication where the typification was published. Note this is only a cached value where Typification-LiteratureLink is present	YES
TypificationReferenceURI	varchar (255)	URI (e.g. LSID) of Reference, refers to e.g DiversityReferences: Source publication where the typification is published	YES
TypificationNotes	nvarchar (200)	Notes concerning the typification	YES
AnamorphTeleomorph	nvarchar (255)	If the name is related to a anamorph or a teleomorph as written in the protologue	YES
TypistNotes	nvarchar (200)	Additional notes and problems	YES
SynType	nvarchar (50)	Type of the synonymization, e.g. 'heterotypic', 'homotypic'	YES
ValidSynType	nvarchar (50)	"accepted name" or type of the synonymy	YES
IgnoreAcceptedName	int	If accepted name is ignored (1 = ignored, 0 = not ignored)	NO
IgnoreSynonymy	int	If synonymy is ignored (1 = ignored, 0 = not ignored)	NO

Depending on:

• TaxonAcceptedName
• TaxonName
• TaxonSynonymy




View TaxonName_Core

User available taxa



Column	Data type	Description	Nullable
NameID	int	The ID of a name in DiversityTaxonNames_Fungi (primary key)	NO
Display	nvarchar (255)	Corresponds to TaxonNameCache	YES
DisplayEpithet	nvarchar (358)	SpeciesEpithet including information for whole taxon for query	YES
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)	YES
Version	smallint	The version of a name record (revision number, internally filled by system)	YES
BasedOnNameID	int	The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID.	YES
CreationType	nvarchar (50)	E.g.: taxon based on new type, combination based on a previously publ. name ('comb. nov.'), new name ('nom.nov.') introduced to replace a homonym (may occur for genera!), validation of previously invalidly publ. taxon name ('ex'), or unknown.	YES
TaxonomicRank	nvarchar (50)	Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)	NO
GenusOrSupragenericName	nvarchar (200)	If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc.	NO
SpeciesGenusNameID	int	If rank is species or below: NameID of the Genus name. Refers to same table with TaxonomicRank = genus.	YES
InfragenericEpithet	nvarchar (200)	If rank below genus and above species: Name of infrageneric taxon above species level (currently accepted spelling). Includes subgenus, series, etc.	YES
SpeciesEpithet	nvarchar (100)	The species name part of the species name, for example 'alba' in 'Abies alba'.	YES
InfraspecificEpithet	nvarchar (100)	The epithet of the infraspecific entity	YES
BasionymAuthors	nvarchar (100)	The authors of a newly created name. For all taxonomic ranks, only for 'comb. nov.' or 'nom. nov.': Author(s) of the basionym (will be displayed in '()', do not enter the parentheses), abbreviated according to authors standard	YES
CombiningAuthors	nvarchar (255)	The names of the combining authors if the name is base on another older name (e.g. combined into a different genus)	YES
PublishingAuthors	nvarchar (255)	If the authors of the taxon differ from the authors of the publication: the latter (...'in ' Publishing authors ... )	YES
SanctioningAuthor	nvarchar (100)	Sanctioning is a special instrument available for fungi to allow the starting date of taxonomy to be identical with higher plants, but preserve names used by Fries (Fr.) and Person (Pers.)	YES
NonNomenclaturalNameSuffix	nvarchar (200)	A suffix for concept names not included in any nomenclatural code. If present fields for authors and typification must be empty and NomenclaturalCode set to 'not under code'.	YES
IsHybrid	bit	If checked (or 'True'), the new taxon is a hybrid with or without a hybrid epithet.	YES
HybridNameID1	int	If IsHybrid is checked (or 'True'): Name of hybrid species 1. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES
HybridNameID2	int	If IsHybrid is checked (or 'True'): Name of hybrid species 2. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES
HybridNameID3	int	If IsHybrid is checked (or 'True'): Name of hybrid species 3. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES
HybridNameID4	int	If IsHybrid is checked (or 'True'): Name of hybrid species 4. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES
ReferenceTitle	nvarchar (600)	The title of the publication where the name was published. Note this is only a cached value where ReferenceURI is present	YES
ReferenceURI	varchar (255)	URI (e.g. LSID) of Reference, referes to table ReferenceTitle in Database DiversityReferences: Source publication where name is published	YES
Volume	nvarchar (20)	The volume of the journal	YES
Issue	nvarchar (255)	The issue of the literature	YES
Pages	nvarchar (50)	The pages within the literature	YES
DetailLocation	nvarchar (200)	Additional information like plates etc.	YES
DayOfPubl	tinyint	The day when the name was published	YES
MonthOfPubl	tinyint	The month when the name was published	YES
YearOfPubl	smallint	The year when the name was published	YES
DateOfPublSupplement	nvarchar (200)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'	YES
YearOnPubl	smallint	The year cited on the original paper as year of publication	YES
DateOnPublSupplement	nvarchar (200)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'	YES
Protologue	nvarchar (MAX)	Full text of the protologue. If protologue is provided in Latin and in another language languages, both only the Latin or several languages may be stored together.	YES
ProtologueURI	varchar (255)	URI of externally available Protologue information (scanned image, full text from external provider, etc.)	YES
ProtologueResourceURI	varchar (255)	The ResourceID of an image of the protologue as stored in the module DiversityResources. Primary key of table Resource in the database DiversityResources.(= Foreign key)	YES
NameUsageReferences	nvarchar (255)	Indexing volumes like Index of Fungi or any Name usage that caused this name to be added to the database	YES
OriginalOrthography	nvarchar (255)	The original spelling of the name	YES
NomenclaturalCode	nvarchar (50)	Code of Nomenclature under which this taxon was created: 'Bacteriology', 'Botany' (incl. Mycology), 'Zoology', 'Biocode' (for future use), 'Non nomenclatural name'. Default value: 'Botany'	YES
NomenclaturalStatus	nvarchar (50)	Categories for effective/valid/legitimate... esp. 'nom. illeg.', 'nom. inval.', 'nom. nudum', etc.	YES
NomenclaturalComment	nvarchar (MAX)	Comments on the nomenclature. e.g. 'according to ICBN Art. 39.1'	YES
Typification	nvarchar (50)	The status of the type specimen(s) as written in the protologue, e.g. holotype	YES
TypificationDetails	nvarchar (255)	Details concerning the typification as written in the protologue, e.g. if just parts of a specimen were accepted as the type	YES
TypificationReferenceTitle	nvarchar (255)	The title of the publication where the typification was published. Note this is only a cached value where Typification-LiteratureLink is present	YES
TypificationReferenceURI	varchar (255)	URI (e.g. LSID) of Reference, refers to e.g DiversityReferences: Source publication where the typification is published	YES
TypificationNotes	nvarchar (200)	Notes concerning the typification	YES
TypeSubstrate	nvarchar (255)	The substrate the type was growing on as written in the protologue	YES
TypeLocality	nvarchar (255)	The locality where the type was found as written in the protologue	YES
TypeSpecimenNotes	nvarchar (200)	Notes about the type specimen, e.g. the herbarium where a type specimen is located, Collector, collection date/number, etc.	YES
AnamorphTeleomorph	nvarchar (255)	If the name is related to a anamorph or a teleomorph as written in the protologue	YES
TypistNotes	nvarchar (200)	Additional notes and problems	YES
RevisionLevel	nvarchar (50)	The level of the revision of the taxonomic name, e.g. 'unchecked', 'fully checked'	YES
IgnoreButKeepForReference	bit	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.	YES

Depending on:

• NameID_UserAvailable
• TaxonName




View TaxonName_Indicated

Content of table TaxonName including synonymy information



Column	Data type	Description	Nullable
ProjectID	int	ID of the project. Refers to the common project definition in the DiversityProjects module.	NO
Display	nvarchar (263)	Content of column TaxonNameCache with synonymy prefix	YES
DisplayEpithet	nvarchar (366)	Content of column SpeciesEpithet with synonymy prefix and trailed by TaxonNameCache	YES
NameID	int	The ID of a name in DiversityTaxonNames_Fungi (primary key)	NO
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)	YES
Version	smallint	The version of a name record (revision number, internally filled by system)	YES
BasedOnNameID	int	The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID.	YES
CreationType	nvarchar (50)	E.g.: taxon based on new type, combination based on a previously publ. name ('comb. nov.'), new name ('nom.nov.') introduced to replace a homonym (may occur for genera!), validation of previously invalidly publ. taxon name ('ex'), or unknown.	YES
TaxonomicRank	nvarchar (50)	Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)	NO
GenusOrSupragenericName	nvarchar (200)	If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc.	NO
SpeciesGenusNameID	int	If rank is species or below: NameID of the Genus name. Refers to same table with TaxonomicRank = genus.	YES
InfragenericEpithet	nvarchar (200)	If rank below genus and above species: Name of infrageneric taxon above species level (currently accepted spelling). Includes subgenus, series, etc.	YES
SpeciesEpithet	nvarchar (100)	The species name part of the species name, for example 'alba' in 'Abies alba'.	YES
InfraspecificEpithet	nvarchar (100)	The epithet of the infraspecific entity	YES
BasionymAuthors	nvarchar (100)	The authors of a newly created name. For all taxonomic ranks, only for 'comb. nov.' or 'nom. nov.': Author(s) of the basionym (will be displayed in '()', do not enter the parentheses), abbreviated according to authors standard	YES
CombiningAuthors	nvarchar (255)	The names of the combining authors if the name is base on another older name (e.g. combined into a different genus)	YES
PublishingAuthors	nvarchar (255)	If the authors of the taxon differ from the authors of the publication: the latter (...'in ' Publishing authors ... )	YES
SanctioningAuthor	nvarchar (100)	Sanctioning is a special instrument available for fungi to allow the starting date of taxonomy to be identical with higher plants, but preserve names used by Fries (Fr.) and Person (Pers.)	YES
NonNomenclaturalNameSuffix	nvarchar (200)	A suffix for concept names not included in any nomenclatural code. If present fields for authors and typification must be empty and NomenclaturalCode set to 'not under code'.	YES
IsHybrid	bit	If checked (or 'True'), the new taxon is a hybrid with or without a hybrid epithet.	YES
HybridNameID1	int	If IsHybrid is checked (or 'True'): Name of hybrid species 1. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES
HybridNameID2	int	If IsHybrid is checked (or 'True'): Name of hybrid species 2. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES
HybridNameID3	int	If IsHybrid is checked (or 'True'): Name of hybrid species 3. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES
HybridNameID4	int	If IsHybrid is checked (or 'True'): Name of hybrid species 4. Refers to NomID code of publ. TaxonomyName (= foreign key).	YES
ReferenceTitle	nvarchar (600)	The title of the publication where the name was published. Note this is only a cached value where ReferenceURI is present	YES
ReferenceURI	varchar (255)	URI (e.g. LSID) of Reference, referes to table ReferenceTitle in Database DiversityReferences: Source publication where name is published	YES
Volume	nvarchar (20)	The volume of the journal	YES
Issue	nvarchar (255)	The issue of the literature	YES
Pages	nvarchar (50)	The pages within the literature	YES
DetailLocation	nvarchar (200)	Additional information like plates etc.	YES
DayOfPubl	tinyint	The day when the name was published	YES
MonthOfPubl	tinyint	The month when the name was published	YES
YearOfPubl	smallint	The year when the name was published	YES
DateOfPublSupplement	nvarchar (200)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'	YES
YearOnPubl	smallint	The year cited on the original paper as year of publication	YES
DateOnPublSupplement	nvarchar (200)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'	YES
Protologue	nvarchar (MAX)	Full text of the protologue. If protologue is provided in Latin and in another language languages, both only the Latin or several languages may be stored together.	YES
ProtologueURI	varchar (255)	URI of externally available Protologue information (scanned image, full text from external provider, etc.)	YES
ProtologueResourceURI	varchar (255)	The ResourceID of an image of the protologue as stored in the module DiversityResources. Primary key of table Resource in the database DiversityResources.(= Foreign key)	YES
NameUsageReferences	nvarchar (255)	Indexing volumes like Index of Fungi or any Name usage that caused this name to be added to the database	YES
OriginalOrthography	nvarchar (255)	The original spelling of the name	YES
NomenclaturalCode	nvarchar (50)	Code of Nomenclature under which this taxon was created: 'Bacteriology', 'Botany' (incl. Mycology), 'Zoology', 'Biocode' (for future use), 'Non nomenclatural name'. Default value: 'Botany'	YES
NomenclaturalStatus	nvarchar (50)	Categories for effective/valid/legitimate... esp. 'nom. illeg.', 'nom. inval.', 'nom. nudum', etc.	YES
NomenclaturalComment	nvarchar (MAX)	Comments on the nomenclature. e.g. 'according to ICBN Art. 39.1'	YES
Typification	nvarchar (50)	The status of the type specimen(s) as written in the protologue, e.g. holotype	YES
TypificationDetails	nvarchar (255)	Details concerning the typification as written in the protologue, e.g. if just parts of a specimen were accepted as the type	YES
TypificationReferenceTitle	nvarchar (255)	The title of the publication where the typification was published. Note this is only a cached value where Typification-LiteratureLink is present	YES
TypificationReferenceURI	varchar (255)	URI (e.g. LSID) of Reference, refers to e.g DiversityReferences: Source publication where the typification is published	YES
TypificationNotes	nvarchar (200)	Notes concerning the typification	YES
TypeSubstrate	nvarchar (255)	The substrate the type was growing on as written in the protologue	YES
TypeLocality	nvarchar (255)	The locality where the type was found as written in the protologue	YES
TypeSpecimenNotes	nvarchar (200)	Notes about the type specimen, e.g. the herbarium where a type specimen is located, Collector, collection date/number, etc.	YES
AnamorphTeleomorph	nvarchar (255)	If the name is related to a anamorph or a teleomorph as written in the protologue	YES
TypistNotes	nvarchar (200)	Additional notes and problems	YES
RevisionLevel	nvarchar (50)	The level of the revision of the taxonomic name, e.g. 'unchecked', 'fully checked'	YES
IgnoreButKeepForReference	bit	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.	YES

Depending on:

• ProjectList
• TaxonAcceptedName_Indicated
• TaxonName
• TaxonNameProject
• TaxonSynonymy_Indicated




View TaxonNameExternalID_Core

User available content of table TaxonNameExternalID



Column	Data type	Description	Nullable
NameID	int	The ID of a name in DiversityTaxonNames (foreign key + part of primary key: the name string associated with NameID may occur in multiple external databases)	NO
ExternalDatabaseID	int	The ID of an external taxonomic data collection as defined in TaxontNameExternalDatabase (foreign key + part of primary key)	NO
ExternalNameURI	varchar (255)	The URI (e.g. a LSID) of the external name as defined in the external database	YES

Depending on:

• NameID_UserAvailable
• TaxonNameExternalID




View TaxonOrder

Not ignored Order for taxa



Column	Data type	Description	Nullable
NameID	int	Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).	NO
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)	YES
OrderNameID	int	The NameID of the Order	YES
Order	nvarchar (200)	The Name of the Order	YES
IgnoreButKeepForReference	int	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.	NO

Depending on:

• TaxonHierarchy
• TaxonName




View TaxonSynonymy_Core

User available content of table TaxonSynonymy



Column	Data type	Description	Nullable
ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.	NO
NameID	int	ID of the synonymized name. Refers to the NameID of TaxonName (= foreign key).	NO
SynNameID	int	The ID of the synonym to which this name has been assigned to. Refers to the NameID of TaxonName (= foreign key).	NO
IgnoreButKeepForReference	tinyint	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.	NO
ConceptSuffix	nvarchar (200)	Empty for default and primary concept; else 's. lat.', 's. str.', 'sec.', 'sensu Muell.', 'emend.' , '(Auct.)' etc.	NO
ConceptNotes	nvarchar (500)	Notes on the concept of the name, e.g. incl. forms with black apothecia	YES
SynRefURI	varchar (255)	Reference URI: Source publication where synonymization is published (not publication of name!) as stored e.g. in DiversityReferences	YES
SynRefText	nvarchar (255)	Free text, esp. where a SynRefURI is missing. Source publication where synonymization is published (not publication of name!)	YES
SynRefDetail	nvarchar (255)	Esp. page number on which the synonymization is published	YES
SynTypistsNotes	nvarchar (255)	An internal note of the responsible person concerning this synonymization. This information is NOT included in any report.	YES
SynType	nvarchar (50)	Type of the synonymization, e.g. 'heterotypic', 'homotypic'	YES
SynIsUncertain	bit	If the synoymization is uncertain. Corresponding to =? for heterotypic synonyms and ? if the type of the synonymisation is unknown. Homotypic synonyms can not be uncertain.	YES

Depending on:

• NameID_UserAvailable
• TaxonSynonymy




View TaxonSynonymy_Indicated

Prefix information for Synonyms



Column	Data type	Description	Nullable
ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.	NO
NameID	int	ID of the synonymized name. Refers to the NameID of TaxonName (= foreign key).	NO
SynType	nvarchar (50)	Type of the synonymization, e.g. 'heterotypic', 'homotypic'	YES
Prefix	nvarchar (4)	Prefix for Synonyms as displayed in query	YES
Indent	varchar (4)	Indent for Synonyms as displayed in query	YES

Depending on:

• TaxonSynonymy




View TaxonSynonymyAcceptedNameID

Accepted names for synonyms



Column	Data type	Description	Nullable
ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.	NO
NameID	int	ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).	NO
AcceptedNameID	int	ID of the accepted name	YES

Depending on:

• TaxonAcceptedName
• TaxonSynonymy




View TaxonSynonymyList

Taxon information including synonymy for not ignored data



Column	Data type	Description	Nullable
NameID	int	The ID of a name in DiversityTaxonNames_Fungi (primary key)	NO
DisplayText	nvarchar (4000)	Taxon name including publication and nomenclatural information	YES
TaxonName	nvarchar (301)	Taxonomic name excluding authors	YES
TaxonomicRank	nvarchar (52)	Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)	NO
InfraspecificEpithet	nvarchar (101)	The epithet of the infraspecific entity	YES
Authors	nvarchar (922)	Combining all author information of the taxon	YES
SynonymText	nvarchar (1683)	Combining publication and nomenclatural information	YES
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)	YES
YearOfPubl	smallint	The year when the name was published	YES
SynIsUncertain	bit	If the synoymization is uncertain. Corresponding to =? for heterotypic synonyms and ? if the type of the synonymisation is unknown. Homotypic synonyms can not be uncertain.	YES
BasedOnNameID	int	The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID.	YES
ConceptSuffix	nvarchar (200)	Empty for default and primary concept; else 's. lat.', 's. str.', 'sec.', 'sensu Muell.', 'emend.' , '(Auct.)' etc.	YES
ConceptNotes	nvarchar (500)	Notes on the concept of the name, e.g. incl. forms with black apothecia	YES
SynType	nvarchar (50)	Type of the synonymization, e.g. 'heterotypic', 'homotypic'	NO
SynNameID	int	The ID of the synonym to which this name has been assigned to. Refers to the NameID of TaxonName (= foreign key).	NO
ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.	NO
NomenclaturalStatus	nvarchar (50)	Categories for effective/valid/legitimate... esp. 'nom. illeg.', 'nom. inval.', 'nom. nudum', etc.	YES

Depending on:

• TaxonName
• TaxonSynonymy




View TaxonSynonymyListIncludeIgnored

Taxon information including synonymy and including ignored data



Column	Data type	Description	Nullable
NameID	int	The ID of a name in DiversityTaxonNames_Fungi (primary key)	NO
DisplayText	nvarchar (2613)	Taxon name including publication and nomenclatural information	YES
TaxonName	nvarchar (301)	Taxonomic name excluding authors	YES
TaxonomicRank	nvarchar (52)	Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)	NO
InfraspecificEpithet	nvarchar (101)	The epithet of the infraspecific entity	YES
Authors	nvarchar (922)	Combining all author information of the taxon	YES
SynonymText	nvarchar (1338)	Combining publication and nomenclatural information	YES
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)	YES
YearOfPubl	smallint	The year when the name was published	YES
SynIsUncertain	bit	If the synoymization is uncertain. Corresponding to =? for heterotypic synonyms and ? if the type of the synonymisation is unknown. Homotypic synonyms can not be uncertain.	YES
BasedOnNameID	int	The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID.	YES
ConceptSuffix	nvarchar (200)	Empty for default and primary concept; else 's. lat.', 's. str.', 'sec.', 'sensu Muell.', 'emend.' , '(Auct.)' etc.	YES
ConceptNotes	nvarchar (500)	Notes on the concept of the name, e.g. incl. forms with black apothecia	YES
SynType	nvarchar (50)	Type of the synonymization, e.g. 'heterotypic', 'homotypic'	NO
SynNameID	int	The ID of the synonym to which this name has been assigned to. Refers to the NameID of TaxonName (= foreign key).	NO
ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.	NO
NomenclaturalStatus	nvarchar (50)	Categories for effective/valid/legitimate... esp. 'nom. illeg.', 'nom. inval.', 'nom. nudum', etc.	YES
IgnoreButKeepForReference	bit	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.	YES

Depending on:

• TaxonName
• TaxonSynonymy




View ViewBaseURL

Result of function dbo.BaseURL() for linked servers



Column	Data type	Description	Nullable
BaseURL	varchar (255)	The BaseURL of the database	YES

Depending on:

• BaseURL




View ViewDefaultProjectID

Result of function dbo.DefaultProjectID() for linked servers



Column	Data type	Description	Nullable
ProjectID	int	ID of the project. Foreign key, relates to PK of table ProjectProxy	YES

Depending on:

• DefaultProjectID




View ViewDiversityWorkbenchModule

Result of function dbo.DiversityWorkbenchModule() for linked servers



Column	Data type	Description	Nullable
DiversityWorkbenchModule	nvarchar (50)	The DiversityWorkbenchModule of the database = DiversityTaxonNames	YES

Depending on:

• DiversityWorkbenchModule




View ViewTaxonNameResource

A View for TaxonNameResource excluding XML columns



Column	Data type	Description	Nullable
NameID	int	ID of the name. Refers to the NameID of TaxonName (= foreign key).	NO
ProjectID	int	ID of the project. Refers to the common project definition in the DiversityProjects module.	NO
URI	varchar (255)	The complete URI address of the resource.	NO
Notes	nvarchar (MAX)	A note concerning this entry.	YES
Title	nvarchar (500)	Title of the resource	YES
IPR	nvarchar (500)	Intellectual Property Rights; the rights given to persons for their intellectual property	YES
Creator	nvarchar (500)	Person or organization originally creating the resource	YES
CreatorAgentURI	varchar (500)	Link to the module DiversityAgents	YES
CopyrightStatement	nvarchar (500)	Notice on rights held in and for the resource	YES
LicenseType	nvarchar (500)	Type of an official or legal permission to do or own a specified thing, e. g. Creative Common Licenses	YES
LicenseHolder	nvarchar (500)	The person or institution holding the license	YES
LicenseHolderAgentURI	varchar (500)	The link to a module containing further information on the person or institution holding the license	YES
LicenseYear	nvarchar (50)	The year of license declaration	YES
DisplayOrder	int	The sequence in which the resource should be displayed in a user interface	YES
DataWithholdingReason	nvarchar (255)	If the data set is withhold, the reason for withholding the data, otherwise null	YES
ResourceType	nvarchar (50)	Type of the resource as defined in table TaxonNameResourceType_Enum	YES

Depending on:

• TaxonNameResource




FUNCTIONS

Function AcceptedNameID

Returns ID of accepted name if any is found, otherwise NULL



DataType: int





Parameter	DataType	Description
@NameID	int	ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).
@ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.

Depending on:

• DefaultProjectID
• TaxonAcceptedName
• TaxonName
• TaxonSynonymy






Function AnalysisCategoryHierarchyAll

Returns a table that lists all the analysis categorys.



Column	DataType	Description
AnalysisID	int	ID of the analysis (Primary key)
AnalysisParentID	int	Analysis ID of the parent analysis if it belongs to a certain type documented in this table
DisplayText	nvarchar (50)	Name of the analysis as e.g. shown in user interface
Description	nvarchar (MAX)	Description of the analysis
Notes	nvarchar (MAX)	Notes concerning this analysis
AnalysisURI	varchar (255)	URI referring to an external documentation of the analysis
OnlyHierarchy	bit	Reserved for future application
DataWithholdingReason	nvarchar (255)	If the data set is withhold, the reason for withholding the data, otherwise null
SortingID	int	An ID for sorting the data
HierarchyDisplayText	varchar (900)	DisplayTexts of the hierarchy separated by " | " of all data related to an item

Depending on:

• TaxonNameListAnalysisCategory






Function BaseURL

Returns BaseURL for the database



DataType: varchar (255)







Function DefaultProjectID

ID of the current project selected by the user



DataType: int

Depending on:

• ProjectUser
• UserProxy






Function DiversityMobile_TaxonList

Returns a result set that lists all taxa in a given project resp. list



Parameter	DataType	Description
@ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.
@ListID	int	The ID of the List corresponding to column ProjectID in table TaxonNameList





Column	DataType	Description
NameURI	varchar (255)	Combines content of dbo.BaseURL() and NameID of the taxon
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)
TaxonNameSinAuthors	nvarchar (255)	Taxonomic name excluding authors
GenusOrSupragenericName	nvarchar (255)	If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc.
SpeciesEpithet	nvarchar (255)	The species name part of the species name, for example 'alba' in 'Abies alba'.
InfraspecificEpithet	nvarchar (255)	The epithet of the infraspecific entity
Synonymy	varchar (50)	Simple synonymy information for the taxon as either "Accepted" or "Synonym"
Family	nvarchar (255)	Family of the taxon
Order	nvarchar (255)	Order of the taxon

Depending on:

• BaseURL
• TaxonAcceptedName
• TaxonHierarchy
• TaxonName
• TaxonNameList
• TaxonNameProject
• TaxonSynonymy






Function DiversityWorkbenchModule

Returns the DiversityWorkbenchModule = "DiversityTaxonNames"



DataType: nvarchar (50)







Function HierarchyCache

Returns a string of all the taxa superior to a given taxon separated with the value of parameter @Separator



DataType: nvarchar (-1)





Parameter	DataType	Description
@NameID	int	Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).
@DiversityProjectID	int	ID of the project
@Separator	char (1)	Separator for the hierarchy levels

Depending on:

• ProjectList
• TaxonHierarchy
• TaxonHierarchy_Core
• TaxonName
• TaxonNameProject






Function HierarchyFamilyList

Returns a result set that lists all families of the taxa in a given project



Parameter	DataType	Description
@ProjectID	int	Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the DiversityProjects module.





Column	DataType	Description
NameID	int	Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).
TaxonNameCache	nvarchar (500)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)
FamilyNameID	int	NameID of the family
Family	nvarchar (500)	The name of the family

Depending on:

• TaxonHierarchy
• TaxonName






Function HierarchyList

Returns a result set that lists hierarchy of the taxa in a given project



Parameter	DataType	Description
@ProjectID	int	Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the DiversityProjects module.





Column	DataType	Description
NameID	int	Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).
TaxonNameCache	nvarchar (500)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)
Hierarchy	nvarchar (2000)	Hierarchy above the taxon separated by " | "

Depending on:

• TaxonHierarchy
• TaxonName
• TaxonNameTaxonomicRank_Enum






Function HierarchyOrderList

Returns a result set that lists all orders of the taxa in a given project.



Parameter	DataType	Description
@ProjectID	int	Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the DiversityProjects module.





Column	DataType	Description
NameID	int	Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).
TaxonNameCache	nvarchar (500)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)
OrderNameID	int	NameID of the order
Order	nvarchar (500)	Name of the order

Depending on:

• TaxonHierarchy
• TaxonName






Function HierarchySuperiorList

Returns a result set that lists all the taxa superior to a given taxon



Parameter	DataType	Description
@NameID	int	Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).
@ProjectID	int	Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the DiversityProjects module.





Column	DataType	Description
NameID	int	Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).
NameParentID	int	Next higher taxon (e.g. the family or subfamily if this taxon is a genus)
Seq	int	The sequence for the hierarchy starting with 1 for the Taxon corresponding to the given NameID
TaxonNameCache	nchar (500)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)
Taxon	nvarchar (500)	Taxon excluding authors
TaxonomicRank	nvarchar (50)	Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)
TaxonomicRankDisplayText	nvarchar (50)	The taxonomic rank in the case of a infraspecific taxon

Depending on:

• TaxonHierarchy
• TaxonHierarchy_Core
• TaxonName
• TaxonNameTaxonomicRank_Enum






Function NameList

Returns a result set that lists all the taxa starting with a string corresponding to @NameStart and including the taxon corresponding to @NameID



Parameter	DataType	Description
@NameID	int	The ID of a name in DiversityTaxonNames_Fungi (primary key)
@NameStart	nvarchar (255)	Initial string of the taxon (TaxonNameCache)





Column	DataType	Description
NameID	int	The ID of a name in DiversityTaxonNames_Fungi (primary key)
TaxonName	nvarchar (200)	Content of column TaxonNameCache

Depending on:

• TaxonName






Function NextNameID

Returns the next free NameID in the table TaxonName for the taxonomic group



DataType: int





Parameter	DataType	Description
@InitialNameID	int	ID of the name where the query should start
@TaxonomicGroup	nvarchar (50)	TaxonomicGroup of the name. Ranges for the groups: Biota: 0 Myxomycetes: 1 - 99 999 Plants: 100 000 - 999 999 Lichens: 1 000 000 - 1 999 999 Fungi: 2 000 000 - 2 999 999 Vertebrata: 3 000 000 - 3 999 999

Depending on:

• TaxonName






Function PrivacyConsentInfo

Website with information about the privacy consent. Default = http://diversityworkbench.net/Portal/Default_Agreement_on_Processing_of_Personal_Data_in_DWB_Software



DataType: varchar (900)







Function SynonymyList

Returns a result set that lists all the Synonyms for a given name



Parameter	DataType	Description
@NameID	int	ID of the synonymized name. Refers to the NameID of TaxonName (= foreign key).
@ProjectID	int	ProjectID of the synonymy
@Level	int	the depth of the synonymy that should be requested. 0 = only linked via the basionym. Default = 3





Column	DataType	Description
NameID	int	ID of the synonymized name. Refers to the NameID of TaxonName (= foreign key).
DisplayText	nvarchar (900)	A preformatet textstring for display in a synoymlist
TaxonName	nvarchar (500)	The name of the taxon including the genus and the species epithet
TaxonomicRank	nvarchar (50)	Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)
InfraspecificEpithet	nvarchar (200)	The epithet of the infraspecific entity
Authors	nvarchar (500)	The combined authors of this name
SynonymText	nvarchar (500)	The text string containing the citation of the synonymisation
Prefix	nvarchar (5)	The prefix as used in synonym lists
Ord	int	The preferred sequence of the synonyms. The numbers in Ord correspond to the different kinds of the synonyms: -20 = Accepted name -10 = Basionym 0 = Homotypic Synonym > 0 = Heterotypic Synoyms > x + 1 = Isonym resp. Assigned to like 'duplicate', 'isonym', 'orthographic variant' (will be display after the name it is a variant of)
YearOfPubl	int	The year when the name was published
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)
ConceptSuffix	nvarchar (200)	Empty for default and primary concept; else 's. lat.', 's. str.', 'sec.', 'sensu Muell.', 'emend.' , '(Auct.)' etc.
ConceptNotes	nvarchar (500)	Notes on the concept of the name, e.g. incl. forms with black apothecia
BasedOnNameID	int	The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID.
SynType	nvarchar (50)	Type of the synonymization, e.g. 'heterotypic', 'homotypic'
SynNameID	int	The ID of the synonym to which this name has been assigned to. Refers to the NameID of TaxonName (= foreign key).
NameParentID	int	The NameID of the parent within the synonymy

Depending on:

• DefaultProjectID
• SynonymyListCache
• TaxonAcceptedName
• TaxonAcceptedNameList
• TaxonName
• TaxonSynonymy
• TaxonSynonymyList






Function SynonymyListIncludeIgnored

Returns a result set that lists all the Synonyms for a given name



Parameter	DataType	Description
@NameID	int	ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).
@ProjectID	int	Each project can have a different opinion regarding synonmy. Refers to the common project definition in the DiversityProjects module.
@Level	int	the depth of the synonymy that should be requested. 0 = only linked via the basionym. Default = 3





Column	DataType	Description
NameID	int	ID of the accepted name. Refers to the NameID of TaxonName (= foreign key).
DisplayText	nvarchar (900)	A preformatet textstring for display in a synoymlist
TaxonName	nvarchar (500)	The name of the taxon including the genus and the species epithet
TaxonomicRank	nvarchar (50)	Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)
InfraspecificEpithet	nvarchar (200)	The epithet of the infraspecific entity
Authors	nvarchar (500)	The combined authors of this name
SynonymText	nvarchar (500)	The text string containing the citation of the synonymisation
Prefix	nvarchar (5)	The prefix as used in synonym lists
Ord	int	The preferred sequence of the synonyms. The numbers in Ord correspond to the different kinds of the synonyms: -20 = Accepted name -10 = Basionym 0 = Homotypic Synonym > 0 = Heterotypic Synoyms > x + 1 = Isonym resp. Assigned to like 'duplicate', 'isonym', 'orthographic variant' (will be display after the name it is a variant of)
YearOfPubl	int	The year when the name was published
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)
ConceptSuffix	nvarchar (200)	Empty for default and primary concept; else 's. lat.', 's. str.', 'sec.', 'sensu Muell.', 'emend.' , '(Auct.)' etc.
ConceptNotes	nvarchar (500)	Notes on the concept of the name, e.g. incl. forms with black apothecia
BasedOnNameID	int	The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID.
SynType	nvarchar (50)	Type of the synonymization, e.g. 'heterotypic', 'homotypic'
SynNameID	int	The ID of the synonym to which this name has been assigned to. Refers to the NameID of TaxonName (= foreign key).
NameParentID	int	-
IgnoreButKeepForReference	bit	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.

Depending on:

• DefaultProjectID
• TaxonAcceptedName
• TaxonAcceptedNameListIncludeIgnored
• TaxonName
• TaxonSynonymy
• TaxonSynonymyListIncludeIgnored






Function TaxonChildNodes

Returns the list of taxa within the hierarchy underneath the taxon with the given NameID



Parameter	DataType	Description
@NameID	int	The NameID of the taxon for which the hierarchy should be retrieved
@ProjectID	int	The ProjectID of the taxon for which the hierarchy should be retrieved





Column	DataType	Description
NameID	int	Unique NameID code of the higher taxon. Refers to the NameID code of LichenName (= foreign key).
TaxonNameCache	nvarchar (255)	A full unique version of the name. Generated by the database, not entered by the user (candidate key)
Version	smallint	The version of a name record (revision number, internally filled by system)
BasedOnNameID	int	The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID.
CreationType	nvarchar (50)	E.g.: taxon based on new type, combination based on a previously publ. name ('comb. nov.'), new name ('nom.nov.') introduced to replace a homonym (may occur for genera!), validation of previously invalidly publ. taxon name ('ex'), or unknown.
TaxonomicRank	nvarchar (50)	Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank)
GenusOrSupragenericName	nvarchar (200)	If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc.
SpeciesGenusNameID	int	If rank is species or below: NameID of the Genus name. Refers to same table with TaxonomicRank = genus.
InfragenericEpithet	nvarchar (200)	If rank below genus and above species: Name of infrageneric taxon above species level (currently accepted spelling). Includes subgenus, series, etc.
SpeciesEpithet	nvarchar (100)	The species name part of the species name, for example 'alba' in 'Abies alba'.
InfraspecificEpithet	nvarchar (100)	The epithet of the infraspecific entity
BasionymAuthors	nvarchar (100)	The authors of a newly created name. For all taxonomic ranks, only for 'comb. nov.' or 'nom. nov.': Author(s) of the basionym (will be displayed in '()', do not enter the parentheses), abbreviated according to authors standard
CombiningAuthors	nvarchar (255)	The names of the combining authors if the name is base on another older name (e.g. combined into a different genus)
PublishingAuthors	nvarchar (255)	If the authors of the taxon differ from the authors of the publication: the latter (...'in ' Publishing authors ... )
SanctioningAuthor	nvarchar (100)	Sanctioning is a special instrument available for fungi to allow the starting date of taxonomy to be identical with higher plants, but preserve names used by Fries (Fr.) and Person (Pers.)
NonNomenclaturalNameSuffix	nvarchar (200)	A suffix for concept names not included in any nomenclatural code. If present fields for authors and typification must be empty and NomenclaturalCode set to 'not under code'.
IsRecombination	bit	True if the name is a recombination
IsHybrid	bit	If checked (or 'True'), the new taxon is a hybrid with or without a hybrid epithet.
HybridNameID1	int	If IsHybrid is checked (or 'True'): Name of hybrid species 1. Refers to NomID code of publ. TaxonomyName (= foreign key).
HybridNameID2	int	If IsHybrid is checked (or 'True'): Name of hybrid species 2. Refers to NomID code of publ. TaxonomyName (= foreign key).
HybridNameID3	int	If IsHybrid is checked (or 'True'): Name of hybrid species 3. Refers to NomID code of publ. TaxonomyName (= foreign key).
HybridNameID4	int	If IsHybrid is checked (or 'True'): Name of hybrid species 4. Refers to NomID code of publ. TaxonomyName (= foreign key).
ReferenceTitle	nvarchar (600)	The title of the publication where the name was published. Note this is only a cached value where ReferenceURI is present
ReferenceURI	varchar (255)	URI (e.g. LSID) of Reference, referes to table ReferenceTitle in Database DiversityReferences: Source publication where name is published
Volume	nvarchar (20)	The volume of the journal
Issue	nvarchar (255)	The issue of the literature
Pages	nvarchar (50)	The pages within the literature
DetailLocation	nvarchar (200)	Additional information like plates etc.
DayOfPubl	tinyint	The day when the name was published
MonthOfPubl	tinyint	The month when the name was published
YearOfPubl	smallint	The year when the name was published
DateOfPublSupplement	nvarchar (200)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'
YearOnPubl	smallint	The year cited on the original paper as year of publication
DateOnPublSupplement	nvarchar (200)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'
Protologue	nvarchar (MAX)	Full text of the protologue. If protologue is provided in Latin and in another language languages, both only the Latin or several languages may be stored together.
ProtologueURI	varchar (255)	URI of externally available Protologue information (scanned image, full text from external provider, etc.)
ProtologueResourceURI	varchar (255)	The ResourceID of an image of the protologue as stored in the module DiversityResources. Primary key of table Resource in the database DiversityResources.(= Foreign key)
NameUsageReferences	nvarchar (255)	Indexing volumes like Index of Fungi or any Name usage that caused this name to be added to the database
OriginalOrthography	nvarchar (255)	The original spelling of the name
NomenclaturalCode	nvarchar (50)	Code of Nomenclature under which this taxon was created: 'Bacteriology', 'Botany' (incl. Mycology), 'Zoology', 'Biocode' (for future use), 'Non nomenclatural name'. Default value: 'Botany'
NomenclaturalStatus	nvarchar (50)	Categories for effective/valid/legitimate... esp. 'nom. illeg.', 'nom. inval.', 'nom. nudum', etc.
NomenclaturalComment	nvarchar (MAX)	Comments on the nomenclature. e.g. 'according to ICBN Art. 39.1'
Typification	nvarchar (50)	The status of the type specimen(s) as written in the protologue, e.g. holotype
TypificationDetails	nvarchar (255)	Details concerning the typification as written in the protologue, e.g. if just parts of a specimen were accepted as the type
TypificationReferenceTitle	nvarchar (255)	The title of the publication where the typification was published. Note this is only a cached value where Typification-LiteratureLink is present
TypificationReferenceURI	varchar (255)	URI (e.g. LSID) of Reference, refers to e.g DiversityReferences: Source publication where the typification is published
TypificationNotes	nvarchar (200)	Notes concerning the typification
TypeSubstrate	nvarchar (255)	The substrate the type was growing on as written in the protologue
TypeLocality	nvarchar (255)	The locality where the type was found as written in the protologue
TypeSpecimenNotes	nvarchar (200)	Notes about the type specimen, e.g. the herbarium where a type specimen is located, Collector, collection date/number, etc.
AnamorphTeleomorph	nvarchar (255)	If the name is related to a anamorph or a teleomorph as written in the protologue
TypistNotes	nvarchar (200)	Additional notes and problems
RevisionLevel	nvarchar (50)	The level of the revision of the taxonomic name, e.g. 'unchecked', 'fully checked'
IgnoreButKeepForReference	bit	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.
DataWithholdingReason	nvarchar (255)	If the dataset is withhold, the reason for withholding the data, otherwise null
BasionymAuthorsYear	int	The year when the name was published by the authors of the Basionym
FamiliyCache	nvarchar (50)	Name of the family
OrderCache	nvarchar (50)	Name of the order
HierarchyCache	nvarchar (MAX)	Hierarchy above the current taxon starting at top level and separated via " | "

Depending on:

• TaxonHierarchy
• TaxonName






Function TaxonListLastUpdate

Returns the last date when any list related data were updated



DataType: datetime





Parameter	DataType	Description
@ListID	int	ProjectID as defined in table TaxonNameListProjectProxy

Depending on:

• TaxonNameList
• TaxonNameListAnalysis
• TaxonNameListArea
• TaxonNameListCollectionSpecimen
• TaxonNameListDistribution
• TaxonNameListReference






Function TaxonListsForUser

Returns the taxon lists for a user as defined in table TaxonNameListUser



Parameter	DataType	Description
@Login	nvarchar (50)	Login of the user as stored in table TaxonNameListUser





Column	DataType	Description
ProjectID	int	ID of the Project, Primary key. May be related to module DiversityProjects
DataSource	nvarchar (50)	The project as defined in table TaxonNameListProjectProxy
DisplayText	nvarchar (50)	The text as shown in a user interface. Corresponds to ProjectTitle in DiversityProjects.Project
TaxonomicGroup	nvarchar (50)	The taxonomic group as used in DiversityCollection resp. DiversityMobile
DefaultProjectID	int	The ID of the default project where informations about e.g. the synonymy are taken from

Depending on:

• TaxonNameListProjectProxy
• TaxonNameListUser






Function TaxonListsLastUpdate

Function providing informations needed by the webservice: Returns a result set that lists all the taxon lists and the date of their last change



Column	DataType	Description
maxlog	smalldatetime	Date of the last change of a TaxonList
projectid	int	Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module.

Depending on:

• TaxonName
• TaxonName_Log
• TaxonNameList






Function TaxonNameCache

Returns the TaxonNameCache for a taxon



DataType: nvarchar (255)





Parameter	DataType	Description
@NameID	int	The ID of a name in DiversityTaxonNames_Fungi (primary key)

Depending on:

• TaxonName






Function TaxonNameCacheSinAut

returns the TaxonName for a taxon excluding authors



DataType: nvarchar (255)





Parameter	DataType	Description
@NameID	int	The ID of a name in DiversityTaxonNames_Fungi (primary key)

Depending on:

• TaxonName






Function TaxonNameListAnalysisCategoryChildNodes

Returns a result set that lists all analysis items within a hierarchy starting at the topmost item related to the given item



Parameter	DataType	Description
@ID	int	AnalysisID of the analysis for which the child nodes should be returned





Column	DataType	Description
AnalysisID	int	ID of the analysis (Primary key)
AnalysisParentID	int	Analysis ID of the parent analysis if it belongs to a certain type documented in this table
DisplayText	nvarchar (50)	Name of the analysis as e.g. shown in user interface
Description	nvarchar (500)	Description of the analysis
Notes	nvarchar (1000)	Notes concerning this analysis
AnalysisURI	varchar (255)	URI referring to an external documentation of the analysis
ReferenceTitle	nvarchar (800)	The title of the publication where details about the analysis are published. Note this is only a cached value where ReferenceURI is present
ReferenceURI	varchar (400)	URI (e.g. LSID) of Reference, referes to table ReferenceTitle in module DiversityReferences: Source publication where details about the analysis are published
DataWithholdingReason	nvarchar (255)	If the data set is withhold, the reason for withholding the data, otherwise null
SortingID	int	An ID for sorting the data

Depending on:

• TaxonNameListAnalysisCategory






Function TaxonNameListAnalysisCategoryHierarchy

Returns a table that lists all the analysis items related to the given analysis



Parameter	DataType	Description
@AnalysisID	int	ID of the analysis (Primary key)





Column	DataType	Description
AnalysisID	int	ID of the analysis (Primary key)
AnalysisParentID	int	Analysis ID of the parent analysis if it belongs to a certain type documented in this table
DisplayText	nvarchar (50)	Name of the analysis as e.g. shown in user interface
Description	nvarchar (500)	Description of the analysis
Notes	nvarchar (1000)	Notes concerning this analysis
AnalysisURI	varchar (255)	URI referring to an external documentation of the analysis
ReferenceTitle	nvarchar (800)	The title of the publication where details about the analysis are published. Note this is only a cached value where ReferenceURI is present
ReferenceURI	varchar (400)	URI (e.g. LSID) of Reference, referes to table ReferenceTitle in module DiversityReferences: Source publication where details about the analysis are published
DataWithholdingReason	nvarchar (255)	If the data set is withhold, the reason for withholding the data, otherwise null
SortingID	int	An ID for sorting the data

Depending on:

• TaxonNameListAnalysisCategory
• TaxonNameListAnalysisCategoryChildNodes






Function TaxonNameListUserNameID

Returns a result set that lists all the NameIDs for a user related to the taxon lists



Column	DataType	Description
NameID	int	The ID of a name in DiversityTaxonNames_Fungi (primary key)

Depending on:

• TaxonName
• TaxonNameList
• TaxonNameListUser






Function UserID

ID of the User as stored in table UserProxy



DataType: int

Depending on:

• UserProxy






Function Version

Version of the database



DataType: nvarchar (8)







Function VersionClient

Version of the client compatible with the database



DataType: nvarchar (11)







PROCEDURES

Procedure procFillSynonymyListCache

Fills table SynonymyListCache for the given NameID or any if missing and ProjectID or any if missing



Parameter	DataType	Description
@ProjectID	int	The ProjectID of the taxon for which the hierarchy should be retrieved
@NameID	int	The NameID of the taxon for which the hierarchy should be retrieved
@Level	int	The level how deep the hierarchy should extracted

Depending on:

• ProjectProxy
• SynonymyList
• SynonymyListCache
• TaxonName






Procedure procHierarchyCache

Update of the hierarchy cache for all entries with disabled triggers to avoid increase of logfile entries

Depending on:

• HierarchyList
• TaxonHierarchy






Procedure procSetVersionTaxonName

Setting the value for column Version in table TaxonName



Parameter	DataType	Description
@ID	int	The NameID of the taxon

Depending on:

• TaxonName






Procedure procTaxonNameInsertCopy

Copy all entries of a name into a new dataset



Parameter	DataType	Description
@NameID	int	The ID of a name in DiversityTaxonNames (foreign key + part of primary key: the name may occur in multiple projects)
@OriginalNameID	int	The NameID of the dataset that should be copied
@Projects	varchar (8000)	List of comma separated ProjectIDs that should be copied

Depending on:

• DefaultProjectID
• NextNameID
• ProjectList
• TaxonHierarchy_Core
• TaxonName_Core
• TaxonNameProject






Procedure procTaxonNameInsertNew_3

Inserts a new dataset in the table TaxonName



Parameter	DataType	Description
@NameID	int	The ID of a name in DiversityTaxonNames_Fungi (primary key)
@Projects	varchar (8000)	Comma separated list of the project IDs for which the new taxon should be inserted
@NomenclaturalCode	int	Code of Nomenclature under which this taxon was created: 'Bacteriology', 'Botany' (incl. Mycology), 'Zoology', 'Biocode' (for future use), 'Non nomenclatural name'. Default value: 'Botany'

Depending on:

• TaxonName
• TaxonNameProject






Procedure procTaxonNameListInsertCopy

Copy all list entries of a name into the list of the current name



Parameter	DataType	Description
@NameID	int	ID of the name. Refers to the NameID of TaxonName (= foreign key).
@OriginalNameID	int	The NameID of the dataset that should be copied
@ProjectID	int	Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module.

Depending on:

• TaxonNameList
• TaxonNameListAnalysis
• TaxonNameListCollectionSpecimen
• TaxonNameListDistribution
• TaxonNameListReference






Procedure procTaxonNameListInsertReferenceCopy

Copy all list entries of a name into the list of the current name



Parameter	DataType	Description
@NameID	int	ID of the name. Refers to the NameID of TaxonName (= foreign key).
@O_TaxonNameListRefID	int	The PK of the reference that should be copied
@ProjectID	int	Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module.

Depending on:

• TaxonNameList
• TaxonNameListAnalysis
• TaxonNameListDistribution
• TaxonNameListReference






Procedure SetUserProjects

Create database user and assign training projects



Parameter	DataType	Description
@User	varchar (50)	Login of the user

Depending on:

• UserProxy






ROLES

DiversityWorkbenchAdministrator

Role for administration of the database content



Permissions	SELECT	INSERT	UPDATE	DELETE	EXECUTE	Type
ApplicationSearchSelectionStrings	Diversity Workbench User					TABLE
CountryCode_Enum	Diversity Workbench User					TABLE
LanguageCode_Enum	Diversity Workbench User					TABLE
ProjectProxy	Diversity Workbench User	•	•	•		TABLE
ProjectUser	•	•		•		TABLE
ReplicationPublisher	•	•	•	•		TABLE
SynonymyListCache	Diversity Workbench User	Diversity Workbench Editor		Diversity Workbench Editor		TABLE
TaxonAcceptedName	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
TaxonAcceptedName_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
TaxonCommonName	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	•		TABLE
TaxonCommonName_log						TABLE
TaxonGeography	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
TaxonGeography_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
TaxonHierarchy	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
TaxonHierarchy_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
TaxonName	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	•		TABLE
TaxonName_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
TaxonNameCreationType_Enum	Diversity Workbench User					TABLE
TaxonNameExternalDatabase	Diversity Workbench User	•	•	•		TABLE
TaxonNameExternalDatabase_log						TABLE
TaxonNameExternalID	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	•		TABLE
TaxonNameExternalID_log						TABLE
TaxonNameList	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	•		TABLE
TaxonNameList_log	Diversity Workbench User	Diversity Workbench Editor				TABLE
TaxonNameListAnalysis	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
TaxonNameListAnalysis_log	Diversity Workbench User	Diversity Workbench Editor				TABLE
TaxonNameListAnalysisCategory	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	•		TABLE
TaxonNameListAnalysisCategory_log	Diversity Workbench User	Diversity Workbench Editor				TABLE
TaxonNameListAnalysisCategoryValue	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	•		TABLE
TaxonNameListAnalysisCategoryValue_log	Diversity Workbench User	Diversity Workbench Editor				TABLE
TaxonNameListArea	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
TaxonNameListArea_log	Diversity Workbench User	Diversity Workbench Editor				TABLE
TaxonNameListCollectionSpecimen	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
TaxonNameListCollectionSpecimen_log						TABLE
TaxonNameListDistribution	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
TaxonNameListDistribution_log	Diversity Workbench User	Diversity Workbench Editor				TABLE
TaxonNameListImage						TABLE
TaxonNameListImage_log						TABLE
TaxonNameListProjectProxy	Diversity Workbench User	•	•	•		TABLE
TaxonNameListReference	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
TaxonNameListReference_log	Diversity Workbench User	Diversity Workbench Editor				TABLE
TaxonNameListReferenceType_Enum	Diversity Workbench User					TABLE
TaxonNameListSpecimenRole_Enum	Diversity Workbench User					TABLE
TaxonNameListUser	Diversity Workbench User	•		•		TABLE
TaxonNameNomenclaturalCode_Enum	Diversity Workbench User					TABLE
TaxonNameNomenclaturalStatus_Enum	Diversity Workbench User					TABLE
TaxonNameProject	Diversity Workbench User	Diversity Workbench Editor		•		TABLE
TaxonNameProject_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
TaxonNameReference	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	•		TABLE
TaxonNameReference_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
TaxonNameResource	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
TaxonNameResource_log	Diversity Workbench User	Diversity Workbench Editor				TABLE
TaxonNameResourceType_Enum	Diversity Workbench User	•	•			TABLE
TaxonNameRevisionLevel_Enum	Diversity Workbench User					TABLE
TaxonNameSynonymisationType_Enum	Diversity Workbench User					TABLE
TaxonNameTaxonomicRank_Enum	Diversity Workbench User					TABLE
TaxonNameTypification	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
TaxonNameTypification_log	Diversity Workbench User	Diversity Workbench Editor				TABLE
TaxonSynonymy	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
TaxonSynonymy_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
UserProxy	•	•	Diversity Workbench User	•		TABLE
AcceptedNameChanges	Diversity Workbench User					VIEW
ApplicationSearchSelectionStrings_Core	Diversity Workbench User					VIEW
GenusList						VIEW
NameID_UserAvailable	Diversity Workbench User					VIEW
ProjectList	Diversity Workbench User					VIEW
TaxonAcceptedName_Core	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		VIEW
TaxonAcceptedName_Indicated	Diversity Workbench User					VIEW
TaxonAcceptedNameList	Diversity Workbench User					VIEW
TaxonAcceptedNameListIncludeIgnored	Diversity Workbench User					VIEW
TaxonFamily	Diversity Workbench User					VIEW
TaxonGeography_Core	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		VIEW
TaxonHierarchy_Core	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		VIEW
TaxonListSynType	Diversity Workbench User					VIEW
TaxonName_Core	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	•		VIEW
TaxonName_Indicated	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	•		VIEW
TaxonNameExternalID_Core	Diversity Workbench User					VIEW
TaxonOrder	Diversity Workbench User					VIEW
TaxonSynonymy_Core	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		VIEW
TaxonSynonymy_Indicated	Diversity Workbench User					VIEW
TaxonSynonymyAcceptedNameID	Diversity Workbench User					VIEW
TaxonSynonymyList	Diversity Workbench User					VIEW
TaxonSynonymyListIncludeIgnored	Diversity Workbench User					VIEW
ViewBaseURL	Diversity Workbench User					VIEW
ViewDefaultProjectID	Diversity Workbench User					VIEW
ViewDiversityWorkbenchModule	Diversity Workbench User					VIEW
ViewTaxonNameResource	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		VIEW
AcceptedNameID					Diversity Workbench User	FUNCTION
AnalysisCategoryHierarchyAll	Diversity Workbench User					FUNCTION
BaseURL					Diversity Workbench User	FUNCTION
DefaultProjectID					Diversity Workbench User	FUNCTION
DiversityMobile_TaxonList	Diversity Workbench User					FUNCTION
DiversityWorkbenchModule					Diversity Workbench User	FUNCTION
HierarchyCache					Diversity Workbench Editor	FUNCTION
HierarchyFamilyList	Diversity Workbench User					FUNCTION
HierarchyList	Diversity Workbench User					FUNCTION
HierarchyOrderList	Diversity Workbench User					FUNCTION
HierarchySuperiorList	Diversity Workbench User					FUNCTION
NameList	Diversity Workbench User					FUNCTION
NextNameID					Diversity Workbench Editor	FUNCTION
PrivacyConsentInfo					Diversity Workbench User	FUNCTION
SynonymyList	Diversity Workbench User					FUNCTION
SynonymyListIncludeIgnored	Diversity Workbench User					FUNCTION
TaxonChildNodes	Diversity Workbench User					FUNCTION
TaxonListLastUpdate					Diversity Workbench User	FUNCTION
TaxonListsForUser	Diversity Workbench User					FUNCTION
TaxonListsLastUpdate	Diversity Workbench User					FUNCTION
TaxonNameCache					Diversity Workbench User	FUNCTION
TaxonNameCacheSinAut					Diversity Workbench User	FUNCTION
TaxonNameListAnalysisCategoryChildNodes	Diversity Workbench User					FUNCTION
TaxonNameListAnalysisCategoryHierarchy	Diversity Workbench User					FUNCTION
TaxonNameListUserNameID	Diversity Workbench User					FUNCTION
UserID					Diversity Workbench User	FUNCTION
Version					Diversity Workbench User	FUNCTION
VersionClient					Diversity Workbench User	FUNCTION
procFillSynonymyListCache					Diversity Workbench Editor	PROCEDURE
procHierarchyCache					Diversity Workbench Editor	PROCEDURE
procSetVersionTaxonName						PROCEDURE
procTaxonNameInsertCopy					Diversity Workbench Editor	PROCEDURE
procTaxonNameInsertNew_3					Diversity Workbench Editor	PROCEDURE
procTaxonNameListInsertCopy					Diversity Workbench Editor	PROCEDURE
procTaxonNameListInsertReferenceCopy					Diversity Workbench Editor	PROCEDURE
SetUserProjects						PROCEDURE

Inheriting from roles:

• DiversityWorkbenchEditor






DiversityWorkbenchEditor

Role for editing the user dependent content of the database



Permissions	SELECT	INSERT	UPDATE	DELETE	EXECUTE	Type
ApplicationSearchSelectionStrings	Diversity Workbench User					TABLE
CountryCode_Enum	Diversity Workbench User					TABLE
LanguageCode_Enum	Diversity Workbench User					TABLE
ProjectProxy	Diversity Workbench User					TABLE
ProjectUser	Diversity Workbench User					TABLE
ReplicationPublisher						TABLE
SynonymyListCache	Diversity Workbench User	•		•		TABLE
TaxonAcceptedName	Diversity Workbench User	•	•	•		TABLE
TaxonAcceptedName_log	•	•				TABLE
TaxonCommonName	Diversity Workbench User	•	•			TABLE
TaxonCommonName_log						TABLE
TaxonGeography	Diversity Workbench User	•	•	•		TABLE
TaxonGeography_log	•	•				TABLE
TaxonHierarchy	Diversity Workbench User	•	•	•		TABLE
TaxonHierarchy_log	•	•				TABLE
TaxonName	Diversity Workbench User	•	•			TABLE
TaxonName_log	•	•				TABLE
TaxonNameCreationType_Enum	Diversity Workbench User					TABLE
TaxonNameExternalDatabase	Diversity Workbench User					TABLE
TaxonNameExternalDatabase_log						TABLE
TaxonNameExternalID	Diversity Workbench User	•	•	•		TABLE
TaxonNameExternalID_log						TABLE
TaxonNameList	Diversity Workbench User	•	•	•		TABLE
TaxonNameList_log	Diversity Workbench User	•				TABLE
TaxonNameListAnalysis	Diversity Workbench User	•	•	•		TABLE
TaxonNameListAnalysis_log	Diversity Workbench User	•				TABLE
TaxonNameListAnalysisCategory	Diversity Workbench User	•	•			TABLE
TaxonNameListAnalysisCategory_log	Diversity Workbench User	•				TABLE
TaxonNameListAnalysisCategoryValue	Diversity Workbench User	•	•			TABLE
TaxonNameListAnalysisCategoryValue_log	Diversity Workbench User	•				TABLE
TaxonNameListArea	Diversity Workbench User	•	•	•		TABLE
TaxonNameListArea_log	Diversity Workbench User	•				TABLE
TaxonNameListCollectionSpecimen	Diversity Workbench User	•	•	•		TABLE
TaxonNameListCollectionSpecimen_log						TABLE
TaxonNameListDistribution	Diversity Workbench User	•	•	•		TABLE
TaxonNameListDistribution_log	Diversity Workbench User	•				TABLE
TaxonNameListImage						TABLE
TaxonNameListImage_log						TABLE
TaxonNameListProjectProxy	Diversity Workbench User					TABLE
TaxonNameListReference	Diversity Workbench User	•	•	•		TABLE
TaxonNameListReference_log	Diversity Workbench User	•				TABLE
TaxonNameListReferenceType_Enum	Diversity Workbench User					TABLE
TaxonNameListSpecimenRole_Enum	Diversity Workbench User					TABLE
TaxonNameListUser	Diversity Workbench User					TABLE
TaxonNameNomenclaturalCode_Enum	Diversity Workbench User					TABLE
TaxonNameNomenclaturalStatus_Enum	Diversity Workbench User					TABLE
TaxonNameProject	Diversity Workbench User	•				TABLE
TaxonNameProject_log	•	•				TABLE
TaxonNameReference	Diversity Workbench User	•	•			TABLE
TaxonNameReference_log	•	•				TABLE
TaxonNameResource	Diversity Workbench User	•	•	•		TABLE
TaxonNameResource_log	Diversity Workbench User	•				TABLE
TaxonNameResourceType_Enum	Diversity Workbench User					TABLE
TaxonNameRevisionLevel_Enum	Diversity Workbench User					TABLE
TaxonNameSynonymisationType_Enum	Diversity Workbench User					TABLE
TaxonNameTaxonomicRank_Enum	Diversity Workbench User					TABLE
TaxonNameTypification	•	•	•	•		TABLE
TaxonNameTypification_log	Diversity Workbench User	•				TABLE
TaxonSynonymy	Diversity Workbench User	•	•	•		TABLE
TaxonSynonymy_log	•	•				TABLE
UserProxy	Diversity Workbench User		Diversity Workbench User			TABLE
AcceptedNameChanges	Diversity Workbench User					VIEW
ApplicationSearchSelectionStrings_Core	Diversity Workbench User					VIEW
GenusList						VIEW
NameID_UserAvailable	Diversity Workbench User					VIEW
ProjectList	Diversity Workbench User					VIEW
TaxonAcceptedName_Core	Diversity Workbench User	•	•	•		VIEW
TaxonAcceptedName_Indicated	Diversity Workbench User					VIEW
TaxonAcceptedNameList	Diversity Workbench User					VIEW
TaxonAcceptedNameListIncludeIgnored	Diversity Workbench User					VIEW
TaxonFamily	Diversity Workbench User					VIEW
TaxonGeography_Core	Diversity Workbench User	•	•	•		VIEW
TaxonHierarchy_Core	Diversity Workbench User	•	•	•		VIEW
TaxonListSynType	Diversity Workbench User					VIEW
TaxonName_Core	Diversity Workbench User	•	•			VIEW
TaxonName_Indicated	Diversity Workbench User	•	•			VIEW
TaxonNameExternalID_Core	Diversity Workbench User					VIEW
TaxonOrder	Diversity Workbench User					VIEW
TaxonSynonymy_Core	Diversity Workbench User	•	•	•		VIEW
TaxonSynonymy_Indicated	Diversity Workbench User					VIEW
TaxonSynonymyAcceptedNameID	Diversity Workbench User					VIEW
TaxonSynonymyList	Diversity Workbench User					VIEW
TaxonSynonymyListIncludeIgnored	Diversity Workbench User					VIEW
ViewBaseURL	Diversity Workbench User					VIEW
ViewDefaultProjectID	Diversity Workbench User					VIEW
ViewDiversityWorkbenchModule	Diversity Workbench User					VIEW
ViewTaxonNameResource	Diversity Workbench User	•	•	•		VIEW
AcceptedNameID					Diversity Workbench User	FUNCTION
AnalysisCategoryHierarchyAll	Diversity Workbench User					FUNCTION
BaseURL					Diversity Workbench User	FUNCTION
DefaultProjectID					Diversity Workbench User	FUNCTION
DiversityMobile_TaxonList	Diversity Workbench User					FUNCTION
DiversityWorkbenchModule					Diversity Workbench User	FUNCTION
HierarchyCache					•	FUNCTION
HierarchyFamilyList	Diversity Workbench User					FUNCTION
HierarchyList	Diversity Workbench User					FUNCTION
HierarchyOrderList	Diversity Workbench User					FUNCTION
HierarchySuperiorList	Diversity Workbench User					FUNCTION
NameList	Diversity Workbench User					FUNCTION
NextNameID					•	FUNCTION
PrivacyConsentInfo					Diversity Workbench User	FUNCTION
SynonymyList	Diversity Workbench User					FUNCTION
SynonymyListIncludeIgnored	Diversity Workbench User					FUNCTION
TaxonChildNodes	Diversity Workbench User					FUNCTION
TaxonListLastUpdate					Diversity Workbench User	FUNCTION
TaxonListsForUser	Diversity Workbench User					FUNCTION
TaxonListsLastUpdate	Diversity Workbench User					FUNCTION
TaxonNameCache					Diversity Workbench User	FUNCTION
TaxonNameCacheSinAut					Diversity Workbench User	FUNCTION
TaxonNameListAnalysisCategoryChildNodes	Diversity Workbench User					FUNCTION
TaxonNameListAnalysisCategoryHierarchy	Diversity Workbench User					FUNCTION
TaxonNameListUserNameID	Diversity Workbench User					FUNCTION
UserID					Diversity Workbench User	FUNCTION
Version					Diversity Workbench User	FUNCTION
VersionClient					Diversity Workbench User	FUNCTION
procFillSynonymyListCache					•	PROCEDURE
procHierarchyCache					•	PROCEDURE
procSetVersionTaxonName						PROCEDURE
procTaxonNameInsertCopy					•	PROCEDURE
procTaxonNameInsertNew_3					•	PROCEDURE
procTaxonNameListInsertCopy					•	PROCEDURE
procTaxonNameListInsertReferenceCopy					•	PROCEDURE
SetUserProjects						PROCEDURE

Inheriting from roles:

• DiversityWorkbenchUser






DiversityWorkbenchReplicator

Role involved in the replication of data



Permissions	SELECT	INSERT	UPDATE	DELETE	EXECUTE	Type
ApplicationSearchSelectionStrings						TABLE
CountryCode_Enum						TABLE
LanguageCode_Enum						TABLE
ProjectProxy						TABLE
ProjectUser						TABLE
ReplicationPublisher						TABLE
SynonymyListCache						TABLE
TaxonAcceptedName						TABLE
TaxonAcceptedName_log						TABLE
TaxonCommonName						TABLE
TaxonCommonName_log						TABLE
TaxonGeography						TABLE
TaxonGeography_log						TABLE
TaxonHierarchy						TABLE
TaxonHierarchy_log						TABLE
TaxonName						TABLE
TaxonName_log						TABLE
TaxonNameCreationType_Enum						TABLE
TaxonNameExternalDatabase						TABLE
TaxonNameExternalDatabase_log						TABLE
TaxonNameExternalID						TABLE
TaxonNameExternalID_log						TABLE
TaxonNameList						TABLE
TaxonNameList_log						TABLE
TaxonNameListAnalysis						TABLE
TaxonNameListAnalysis_log						TABLE
TaxonNameListAnalysisCategory						TABLE
TaxonNameListAnalysisCategory_log						TABLE
TaxonNameListAnalysisCategoryValue						TABLE
TaxonNameListAnalysisCategoryValue_log						TABLE
TaxonNameListArea						TABLE
TaxonNameListArea_log						TABLE
TaxonNameListCollectionSpecimen						TABLE
TaxonNameListCollectionSpecimen_log						TABLE
TaxonNameListDistribution						TABLE
TaxonNameListDistribution_log						TABLE
TaxonNameListImage						TABLE
TaxonNameListImage_log						TABLE
TaxonNameListProjectProxy						TABLE
TaxonNameListReference						TABLE
TaxonNameListReference_log						TABLE
TaxonNameListReferenceType_Enum						TABLE
TaxonNameListSpecimenRole_Enum						TABLE
TaxonNameListUser						TABLE
TaxonNameNomenclaturalCode_Enum						TABLE
TaxonNameNomenclaturalStatus_Enum						TABLE
TaxonNameProject			•			TABLE
TaxonNameProject_log						TABLE
TaxonNameReference						TABLE
TaxonNameReference_log						TABLE
TaxonNameResource						TABLE
TaxonNameResource_log						TABLE
TaxonNameResourceType_Enum						TABLE
TaxonNameRevisionLevel_Enum						TABLE
TaxonNameSynonymisationType_Enum						TABLE
TaxonNameTaxonomicRank_Enum						TABLE
TaxonNameTypification						TABLE
TaxonNameTypification_log						TABLE
TaxonSynonymy						TABLE
TaxonSynonymy_log						TABLE
UserProxy						TABLE
AcceptedNameChanges						VIEW
ApplicationSearchSelectionStrings_Core						VIEW
GenusList						VIEW
NameID_UserAvailable						VIEW
ProjectList						VIEW
TaxonAcceptedName_Core						VIEW
TaxonAcceptedName_Indicated						VIEW
TaxonAcceptedNameList						VIEW
TaxonAcceptedNameListIncludeIgnored						VIEW
TaxonFamily						VIEW
TaxonGeography_Core						VIEW
TaxonHierarchy_Core						VIEW
TaxonListSynType						VIEW
TaxonName_Core						VIEW
TaxonName_Indicated						VIEW
TaxonNameExternalID_Core						VIEW
TaxonOrder						VIEW
TaxonSynonymy_Core						VIEW
TaxonSynonymy_Indicated						VIEW
TaxonSynonymyAcceptedNameID						VIEW
TaxonSynonymyList						VIEW
TaxonSynonymyListIncludeIgnored						VIEW
ViewBaseURL						VIEW
ViewDefaultProjectID						VIEW
ViewDiversityWorkbenchModule						VIEW
ViewTaxonNameResource						VIEW
AcceptedNameID						FUNCTION
AnalysisCategoryHierarchyAll						FUNCTION
BaseURL						FUNCTION
DefaultProjectID						FUNCTION
DiversityMobile_TaxonList						FUNCTION
DiversityWorkbenchModule						FUNCTION
HierarchyCache						FUNCTION
HierarchyFamilyList						FUNCTION
HierarchyList						FUNCTION
HierarchyOrderList						FUNCTION
HierarchySuperiorList						FUNCTION
NameList						FUNCTION
NextNameID						FUNCTION
PrivacyConsentInfo						FUNCTION
SynonymyList						FUNCTION
SynonymyListIncludeIgnored						FUNCTION
TaxonChildNodes						FUNCTION
TaxonListLastUpdate						FUNCTION
TaxonListsForUser						FUNCTION
TaxonListsLastUpdate						FUNCTION
TaxonNameCache						FUNCTION
TaxonNameCacheSinAut						FUNCTION
TaxonNameListAnalysisCategoryChildNodes						FUNCTION
TaxonNameListAnalysisCategoryHierarchy						FUNCTION
TaxonNameListUserNameID						FUNCTION
UserID						FUNCTION
Version						FUNCTION
VersionClient						FUNCTION
procFillSynonymyListCache						PROCEDURE
procHierarchyCache						PROCEDURE
procSetVersionTaxonName						PROCEDURE
procTaxonNameInsertCopy						PROCEDURE
procTaxonNameInsertNew_3						PROCEDURE
procTaxonNameListInsertCopy						PROCEDURE
procTaxonNameListInsertReferenceCopy						PROCEDURE
SetUserProjects						PROCEDURE







DiversityWorkbenchUser

Role with read only access to the data



Permissions	SELECT	INSERT	UPDATE	DELETE	EXECUTE	Type
ApplicationSearchSelectionStrings	•					TABLE
CountryCode_Enum	•					TABLE
LanguageCode_Enum	•					TABLE
ProjectProxy	•					TABLE
ProjectUser	•					TABLE
ReplicationPublisher						TABLE
SynonymyListCache	•					TABLE
TaxonAcceptedName	•					TABLE
TaxonAcceptedName_log						TABLE
TaxonCommonName	•					TABLE
TaxonCommonName_log						TABLE
TaxonGeography	•					TABLE
TaxonGeography_log						TABLE
TaxonHierarchy	•					TABLE
TaxonHierarchy_log						TABLE
TaxonName	•					TABLE
TaxonName_log						TABLE
TaxonNameCreationType_Enum	•					TABLE
TaxonNameExternalDatabase	•					TABLE
TaxonNameExternalDatabase_log						TABLE
TaxonNameExternalID	•					TABLE
TaxonNameExternalID_log						TABLE
TaxonNameList	•					TABLE
TaxonNameList_log	•					TABLE
TaxonNameListAnalysis	•					TABLE
TaxonNameListAnalysis_log	•					TABLE
TaxonNameListAnalysisCategory	•					TABLE
TaxonNameListAnalysisCategory_log	•					TABLE
TaxonNameListAnalysisCategoryValue	•					TABLE
TaxonNameListAnalysisCategoryValue_log	•					TABLE
TaxonNameListArea	•					TABLE
TaxonNameListArea_log	•					TABLE
TaxonNameListCollectionSpecimen	•					TABLE
TaxonNameListCollectionSpecimen_log						TABLE
TaxonNameListDistribution	•					TABLE
TaxonNameListDistribution_log	•					TABLE
TaxonNameListImage						TABLE
TaxonNameListImage_log						TABLE
TaxonNameListProjectProxy	•					TABLE
TaxonNameListReference	•					TABLE
TaxonNameListReference_log	•					TABLE
TaxonNameListReferenceType_Enum	•					TABLE
TaxonNameListSpecimenRole_Enum	•					TABLE
TaxonNameListUser	•					TABLE
TaxonNameNomenclaturalCode_Enum	•					TABLE
TaxonNameNomenclaturalStatus_Enum	•					TABLE
TaxonNameProject	•					TABLE
TaxonNameProject_log						TABLE
TaxonNameReference	•					TABLE
TaxonNameReference_log						TABLE
TaxonNameResource	•					TABLE
TaxonNameResource_log	•					TABLE
TaxonNameResourceType_Enum	•					TABLE
TaxonNameRevisionLevel_Enum	•					TABLE
TaxonNameSynonymisationType_Enum	•					TABLE
TaxonNameTaxonomicRank_Enum	•					TABLE
TaxonNameTypification	•					TABLE
TaxonNameTypification_log	•					TABLE
TaxonSynonymy	•					TABLE
TaxonSynonymy_log						TABLE
UserProxy	•		•			TABLE
AcceptedNameChanges	•					VIEW
ApplicationSearchSelectionStrings_Core	•					VIEW
GenusList						VIEW
NameID_UserAvailable	•					VIEW
ProjectList	•					VIEW
TaxonAcceptedName_Core	•					VIEW
TaxonAcceptedName_Indicated	•					VIEW
TaxonAcceptedNameList	•					VIEW
TaxonAcceptedNameListIncludeIgnored	•					VIEW
TaxonFamily	•					VIEW
TaxonGeography_Core	•					VIEW
TaxonHierarchy_Core	•					VIEW
TaxonListSynType	•					VIEW
TaxonName_Core	•					VIEW
TaxonName_Indicated	•					VIEW
TaxonNameExternalID_Core	•					VIEW
TaxonOrder	•					VIEW
TaxonSynonymy_Core	•					VIEW
TaxonSynonymy_Indicated	•					VIEW
TaxonSynonymyAcceptedNameID	•					VIEW
TaxonSynonymyList	•					VIEW
TaxonSynonymyListIncludeIgnored	•					VIEW
ViewBaseURL	•					VIEW
ViewDefaultProjectID	•					VIEW
ViewDiversityWorkbenchModule	•					VIEW
ViewTaxonNameResource	•					VIEW
AcceptedNameID					•	FUNCTION
AnalysisCategoryHierarchyAll	•					FUNCTION
BaseURL					•	FUNCTION
DefaultProjectID					•	FUNCTION
DiversityMobile_TaxonList	•					FUNCTION
DiversityWorkbenchModule					•	FUNCTION
HierarchyCache						FUNCTION
HierarchyFamilyList	•					FUNCTION
HierarchyList	•					FUNCTION
HierarchyOrderList	•					FUNCTION
HierarchySuperiorList	•					FUNCTION
NameList	•					FUNCTION
NextNameID						FUNCTION
PrivacyConsentInfo					•	FUNCTION
SynonymyList	•					FUNCTION
SynonymyListIncludeIgnored	•					FUNCTION
TaxonChildNodes	•					FUNCTION
TaxonListLastUpdate					•	FUNCTION
TaxonListsForUser	•					FUNCTION
TaxonListsLastUpdate	•					FUNCTION
TaxonNameCache					•	FUNCTION
TaxonNameCacheSinAut					•	FUNCTION
TaxonNameListAnalysisCategoryChildNodes	•					FUNCTION
TaxonNameListAnalysisCategoryHierarchy	•					FUNCTION
TaxonNameListUserNameID	•					FUNCTION
UserID					•	FUNCTION
Version					•	FUNCTION
VersionClient					•	FUNCTION
procFillSynonymyListCache						PROCEDURE
procHierarchyCache						PROCEDURE
procSetVersionTaxonName						PROCEDURE
procTaxonNameInsertCopy						PROCEDURE
procTaxonNameInsertNew_3						PROCEDURE
procTaxonNameListInsertCopy						PROCEDURE
procTaxonNameListInsertReferenceCopy						PROCEDURE
SetUserProjects						PROCEDURE