Diversity Taxon Names
Internals
For users that need more detailed information about the software including database design etc.
Subsections of Internals
Diversity Taxon Names
Database
The database for DiversityTaxonNames is based on Microsoft SQL-Server 2008 or higher. The names of the taxa were separated for practical reasons in several databases, each comprising a certain range of taxa. There is one master version, DiversityTaxonNames, containing the names of all databases and several databases containing the complete datasets including synonymy, hierarchy etc. for the following groups:
| Database | Taxa | Source |
|---|---|---|
| DiversityTaxonNames_Fungi | higher fungi including lichens | LIAS |
| DiversityTaxonNames_Myxomycetes | slime moulds | NomenMyx |
| DiversityTaxonNames_Plants | higher plants | Species 2000, Tropicos, IPNI, Precis, … |
| DiversityTaxonNames_Vertebrates | vertebrates | SAPM, … |
To access any database, you must specify the server where the database
is located. For the configuration of this connection click on the
button or choose Connection,
Database… from the menu. If you got a new version of the client
you can transfer the settings for the previous version: Choose
Connetion → Transfer previous settings from the menu. (see
Database access for details)
Organisation of the data
The data are organised in several groups, data connected with the name , data based on the opinion of an editor within a projects , the source of the data and the lists .
TaxonName related data
TaxonName, TaxonCommonName, TaxonNameTypification and TaxonGeography are containing 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.
Project related data
TaxonNameProject document the projects of the names. The access for the users is determined by the projects.
Editor opinion
The tables TaxonHierarchy, TaxonNameResource, TaxonAcceptedName and TaxonSynonymy - represent a higher level of taxonomic opinion, where different editors and different digitized data sources need to be kept separate. This is achieved by making a “Project” attribute part of the primary key. Editors that wish to collaborate and form agreement may work in a single project, editors that desire to define separate opinions work in separate projects. Furthermore, if the opinion is based on published information, the reference and page number may be recorded (in …RefText, …RefID, …RefDetail). The duality of representing editorial opinion and remaining true to a digitized sources causes some problems. For example, a species accepted in a referenced source may not longer be accepted by the project editors. To avoid a further complication of the model, the “IgnoreButKeepForReference” attribute (default “false”) may be set to “true”, indicating that the statement is true from the perspective of the referenced source, but should be ignored when representing editorial opinion.
- 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.
- TaxonNameResource contains links to resources, e.g. images of the taxa.
- 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.
- 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.
External sources
TaxonNameExternalID and TaxonNameExternalDatabase document the sources of the names.
Lists
The tables TaxonNameList… contain informations connected to e.g. checklists. In addition to the restriction to projects the access of users may be restricted to certain lists.
Overview of the main tables of the database
For details about the tables see Data tables and Enumeration tables.
Subsections of Database
Diversity TaxonNames
TABLES, VIEWS, FUNCTIONS, PROCEDURES, ROLES
The following objects are not included:
- Logging tables
- Enumeration tables
- System objects
- Objects marked as obsolete
- Previous versions of objects
TABLES
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 |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | YES | - |
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 | - |
| LogCreatedWhen | datetime | Point in time when this data set was createdDefault value: getdate() | YES | - |
| LogCreatedBy | nvarchar (50) | Name of the creator of this data setDefault value: user_name() | YES | - |
| LogUpdatedWhen | datetime | Point in time when this data set was updated lastDefault value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of the person to update this data set lastDefault value: user_name() | 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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when record was last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 | - |
| LogInsertedBy | nvarchar (50) | Who inserted this datasetDefault value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | The time when this dataset was insertedDefault value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Who was the last to update this datasetDefault value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | The last time when this dataset was updatedDefault value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | YES | - |
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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when record was last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 recombinationDefault 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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when record was last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 | - |
| LogCreatedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data.Default value: user_name() | YES | - |
| LogCreatedWhen | datetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data.Default value: user_name() | YES | - |
| LogUpdatedWhen | datetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 | - |
| LogCreatedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data.Default value: user_name() | YES | - |
| LogCreatedWhen | datetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data.Default value: user_name() | YES | - |
| LogUpdatedWhen | datetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 keyDefault 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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 | - |
| LogCreatedWhen | datetime | The time when this dataset was createdDefault value: getdate() | YES | - |
| LogCreatedBy | nvarchar (50) | Who created this datasetDefault value: user_name() | YES | - |
| LogUpdatedWhen | datetime | The last time when this dataset was updatedDefault value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Who was the last to update this datasetDefault value: user_name() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 keyDefault 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. TDWGDefault value: '’ | NO | - |
| PlaceNameCache | nvarchar (255) | The name of the placeDefault value: '’ | NO | - |
| Notes | nvarchar (MAX) | Notes concerning this analysis | YES | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | YES | - |
Depending on:
- TaxonNameList
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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 |
| LogInsertedWhen | datetime | The time when this dataset was insertedDefault value: getdate() | YES | - |
| LogInsertedBy | nvarchar (50) | Who inserted this datasetDefault value: user_name() | YES | - |
| LogUpdatedWhen | datetime | The last time when this dataset was updatedDefault value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Who was the last to update this datasetDefault value: user_name() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | YES | - |
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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 interfaceDefault value: (1) | YES | - |
| DataWithholdingReason | nvarchar (255) | If the data set is withhold, the reason for withholding the data, otherwise nullDefault 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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when record was last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | 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 | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: user_name() | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when record was last updated.Default value: getdate() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | YES | - |
Depending on:
- ProjectProxy
- TaxonNameProject
- TaxonNameSynonymisationType_Enum
trgInsTaxonSynonymy
Setting version of taxon
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 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 " |
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
| Content of cell | Permission |
|---|---|
| Not granted | |
| Name of other role | Inherited from other role |
| • | Granted |
Role DiversityWorkbenchAdministrator
Role for administration of the database content
| Permissions | SELECT | INSERT | UPDATE | DELETE | EXECUTE | Type |
|---|---|---|---|---|---|---|
| CountryCode_Enum | Diversity Workbench User | TABLE | ||||
| LanguageCode_Enum | 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 | |||||
| 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 | |||
| AcceptedNameChanges | 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
Role DiversityWorkbenchEditor
Role for editing the user dependent content of the database
| Permissions | SELECT | INSERT | UPDATE | DELETE | EXECUTE | Type |
|---|---|---|---|---|---|---|
| CountryCode_Enum | Diversity Workbench User | TABLE | ||||
| LanguageCode_Enum | 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 | |||||
| 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 | |||
| AcceptedNameChanges | 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
Role DiversityWorkbenchReplicator
Role involved in the replication of data
| Permissions | SELECT | INSERT | UPDATE | DELETE | EXECUTE | Type |
|---|---|---|---|---|---|---|
| CountryCode_Enum | TABLE | |||||
| LanguageCode_Enum | 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 | |||||
| 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 | |||||
| AcceptedNameChanges | 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 |
Role DiversityWorkbenchUser
Role with read only access to the data
| Permissions | SELECT | INSERT | UPDATE | DELETE | EXECUTE | Type |
|---|---|---|---|---|---|---|
| CountryCode_Enum | • | TABLE | ||||
| LanguageCode_Enum | • | 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 | |||||
| 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 | |||||
| AcceptedNameChanges | • | 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 |
Diversity TaxonNames
Enumeration tables
The following objects are not included:
- Logging tables
- System objects
- Objects marked as obsolete
- Previous versions of objects
Table
| Column | Data type | Description |
|---|---|---|
| Code | nvarchar (50) | A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it. |
| Description | nvarchar (800) | Description of enumerated object, displayed in the user interface |
| DisplayText | nvarchar (50) | Short abbreviated description of the object, displayed in the user interface |
| DisplayOrder | smallint | The order in which the entries are displayed. The order may be changed at any time, but all values must be unique. |
| DisplayEnable | bit | Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box) |
| InternalNotes | nvarchar (500) | Internal development notes about usage, definition, etc. of an enumerated object |
| ParentCode | nvarchar (50) | The code of the superior entry, if a hierarchy within the entries is necessary |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() |
Content
| Code | Description | DisplayText |
|---|---|---|
| 1 | Bacteriology | Bacteriology |
| 2 | Botany (incl. Mycology) | Botany (incl. Mycology) |
| 3 | Zoology | Zoology |
| 4 | Biocode (for future use) | Biocode (for future use) |
Table CountryCode_Enum
2 letter codes for countries according to ISO 3166-1 alpha-2
Dependent tables:
- TaxonCommonName
Content
| Code | Description | DisplayText |
|---|---|---|
| AD | Andorra | Andorra |
| AE | United Arab Emirates | United Arab Emirates |
| AF | Afghanistan | Afghanistan |
| AG | Antigua and Barbuda | Antigua and Barbuda |
| AI | Anguilla | Anguilla |
| AL | Albania | Albania |
| AM | Armenia | Armenia |
| AO | Angola | Angola |
| AR | Argentinia | Argentinia |
| AS | American Samoa | American Samoa |
| AT | Austria | Austria |
| AU | Australia | Australia |
| AW | Aruba | Aruba |
| AZ | Azerbaijan | Azerbaijan |
| BA | Bosnia and Herzegovina | Bosnia and Herzegovina |
| BB | Barbados | Barbados |
| BD | Bangladesh | Bangladesh |
| BE | Belgium | Belgium |
| BF | Burkina Faso | Burkina Faso |
| BG | Bulgaria | Bulgaria |
| BH | Bahrain | Bahrain |
| BI | Burundi | Burundi |
| BJ | Benin | Benin |
| BM | Bermuda | Bermuda |
| BN | Brunei Darussalam | Brunei Darussalam |
| BO | Bolivia | Bolivia |
| BR | Brazil | Brazil |
| BS | Bahamas | Bahamas |
| BT | Bhutan | Bhutan |
| BW | Botswana | Botswana |
| BY | Belarus | Belarus |
| BZ | Belize | Belize |
| CA | Canada | Canada |
| CD | congo The democratic republic of the | congo The democratic republic of the |
| CF | Central African Republic | Central African Republic |
| CG | Congo | Congo |
| CH | Switzerland | Switzerland |
| CI | Ivory Coast | Ivory Coast |
| CK | Cook Islands | Cook Islands |
| CL | Chile | Chile |
| CM | Cameroon | Cameroon |
| CN | China | China |
| CO | Colombia | Colombia |
| CR | Costa Rica | Costa Rica |
| CU | Cuba | Cuba |
| CV | Cape Verde | Cape Verde |
| CX | Christmas Island | Christmas Island |
| CY | Cyprus | Cyprus |
| CZ | Czech Republic | Czech Republic |
| DE | Germany | Germany |
| DJ | Djibouti | Djibouti |
| DK | Denmark | Denmark |
| DM | Dominica | Dominica |
| DO | Dominican Republic | Dominican Republic |
| DZ | Algeria | Algeria |
| EC | Ecuador | Ecuador |
| EE | Estonia | Estonia |
| EG | Egypt | Egypt |
| ER | Eritrea | Eritrea |
| ES | Spain | Spain |
| ET | Ethiopia | Ethiopia |
| FI | Finland | Finland |
| FJ | Fiji | Fiji |
| FK | Falkland Islands | Falkland Islands |
| FO | Faroe Islands | Faroe Islands |
| FR | France | France |
| GA | Gabon | Gabon |
| GB | United Kingdom | United Kingdom |
| GD | Grenada | Grenada |
| GE | Georgia | Georgia |
| GF | French Guiana | French Guiana |
| GG | Guernsey | Guernsey |
| GH | Ghana | Ghana |
| GI | Gibraltar | Gibraltar |
| GL | Greenland | Greenland |
| GM | Gambia | Gambia |
| GN | Guinea | Guinea |
| GP | Guadeloupe | Guadeloupe |
| GR | Greece | Greece |
| GT | Guatemala | Guatemala |
| GU | Guam | Guam |
| GW | Guinea-Bissau | Guinea-Bissau |
| GY | Guyana | Guyana |
| HN | Honduras | Honduras |
| HR | Croatia | Croatia |
| HT | Haiti | Haiti |
| HU | Hungary | Hungary |
| ID | Indonesia | Indonesia |
| IE | Ireland | Ireland |
| IL | Israel | Israel |
| IM | Isle of Man | Isle of Man |
| IN | India | India |
| IQ | Iraq | Iraq |
| IR | Iran | Iran |
| IS | Iceland | Iceland |
| IT | Italy | Italy |
| JE | Jersey | Jersey |
| JM | Jamaica | Jamaica |
| JP | Japan | Japan |
| KE | Kenya | Kenya |
| KG | Kyrgyzstan | Kyrgyzstan |
| KH | Cambodia | Cambodia |
| KI | Kiribati | Kiribati |
| KM | Comoros | Comoros |
| KN | Saint Kitts and Nevis | Saint Kitts and Nevis |
| KY | Cayman Islands | Cayman Islands |
| KZ | Kazakhstan | Kazakhstan |
| LA | Laos | Laos |
| LB | Lebanon | Lebanon |
| LC | Saint Lucia | Saint Lucia |
| LI | Liechtenstein | Liechtenstein |
| LK | Sri Lanka | Sri Lanka |
| LR | Liberia | Liberia |
| LS | Lesotho | Lesotho |
| LT | Lithuania | Lithuania |
| LU | Luxembourg | Luxembourg |
| LV | Latvia | Latvia |
| LY | Libya | Libya |
| MA | Morocco | Morocco |
| MC | Monaco | Monaco |
| MD | Moldova | Moldova |
| MG | Madagascar | Madagascar |
| MH | Marshall Islands | Marshall Islands |
| MK | Macedonia | Macedonia |
| ML | Mali | Mali |
| MM | Myanmar (Burma) | Myanmar (Burma) |
| MN | Mongolia | Mongolia |
| MO | Macao | Macao |
| MP | Northern Mariana Islands | Northern Mariana Islands |
| MQ | Martinique | Martinique |
| MR | Mauritania | Mauritania |
| MS | Montserrat | Montserrat |
| MT | Malta | Malta |
| MU | Mauritius | Mauritius |
| MV | Maldives | Maldives |
| MW | Malawi | Malawi |
| MX | Mexico | Mexico |
| MY | Malaysia | Malaysia |
| MZ | Mozambique | Mozambique |
| NA | Namibia | Namibia |
| NC | New Caledonia | New Caledonia |
| NE | Niger | Niger |
| NF | Norfolk Island | Norfolk Island |
| NG | Nigeria | Nigeria |
| NI | Nicaragua | Nicaragua |
| NL | Netherlands | Netherlands |
| NO | Norway | Norway |
| NP | Nepal | Nepal |
| NR | Nauru | Nauru |
| NU | Niue | Niue |
| NZ | New Zealand | New Zealand |
| OM | Oman | Oman |
| PA | Panama | Panama |
| PE | Peru | Peru |
| PF | French Polynesia | French Polynesia |
| PG | Papua New Guinea | Papua New Guinea |
| PH | Philippines | Philippines |
| PK | Pakistan | Pakistan |
| PL | Poland | Poland |
| PN | Pitcairn | Pitcairn |
| PR | Puerto Rico | Puerto Rico |
| PT | Portugal | Portugal |
| PW | Palau | Palau |
| PY | Paraguay | Paraguay |
| QA | Qatar | Qatar |
| RE | Reunion | Reunion |
| RO | Romania | Romania |
| RU | Russia | Russia |
| RW | Rwanda | Rwanda |
| SA | Saudi Arabia | Saudi Arabia |
| SB | Solomon Islands | Solomon Islands |
| SC | Seychelles | Seychelles |
| SD | Sudan | Sudan |
| SE | Sweden | Sweden |
| SG | Singapore | Singapore |
| SH | Saint Helena | Saint Helena |
| SI | Slovenia | Slovenia |
| SK | Slovak Republic | Slovak Republic |
| SL | Sierra Leone | Sierra Leone |
| SM | San Marino | San Marino |
| SN | Senegal | Senegal |
| SO | Somalia | Somalia |
| SR | Suriname | Suriname |
| ST | Sao Tome and Principe | Sao Tome and Principe |
| SV | El Salvador | El Salvador |
| SZ | Swaziland | Swaziland |
| TC | Turks and Caicos Islands | Turks and Caicos Islands |
| TD | Chad | Chad |
| TG | Togo | Togo |
| TH | Thailand | Thailand |
| TJ | Tajikistan | Tajikistan |
| TK | Tokelau | Tokelau |
| TM | Turkmenistan | Turkmenistan |
| TN | Tunisia | Tunisia |
| TO | Tonga | Tonga |
| TR | Turkey | Turkey |
| TT | Trinidad and Tobago | Trinidad and Tobago |
| TV | Tuvalu | Tuvalu |
| TW | Taiwan | Taiwan |
| TZ | Tanzania | Tanzania |
| UA | Ukrayina | Ukrayina |
| UG | Uganda | Uganda |
| US | United States | United States |
| UY | Uruguay | Uruguay |
| UZ | Uzbekistan | Uzbekistan |
| VC | Saint Vincent and the Grenadines | Saint Vincent and the Grenadines |
| VE | Venezuela | Venezuela |
| VN | Vietnam | Vietnam |
| VU | Vanuatu | Vanuatu |
| WF | Wallis and Futuna | Wallis and Futuna |
| WS | Samoa | Samoa |
| YE | Yemen | Yemen |
| YT | Mayotte | Mayotte |
| ZA | South Africa | South Africa |
| ZM | Zambia | Zambia |
| ZW | Zimbabwe | Zimbabwe |
Table LanguageCode_Enum
2 letter language codes according to ISO 639-1
Dependent tables:
- TaxonCommonName
Content
| Code | Description | DisplayText |
|---|---|---|
| af | Afrikaans | Afrikaans |
| ar | Arabic | Arabic |
| az | Azerbaijani | Azerbaijani |
| be | Byelorussian | Byelorussian |
| bg | Bulgarian | Bulgarian |
| ca | Catalan | Catalan |
| cs | Czech | Czech |
| da | Danish | Danish |
| de | German | German |
| el | Greek | Greek |
| en | English | English |
| es | Spanish | Spanish |
| et | Estonian | Estonian |
| eu | Basque | Basque |
| fa | Persian | Persian |
| fi | Finnish | Finnish |
| fo | Faeroese | Faeroese |
| fr | French | French |
| gl | Galician | Galician |
| gu | Gujarati | Gujarati |
| he | Hebräisch | Hebräisch |
| hi | Hindi | Hindi |
| hr | Croatian | Croatian |
| hu | Hungarian | Hungarian |
| hy | Armenian | Armenian |
| id | Indonesisch | Indonesisch |
| is | Icelandic | Icelandic |
| it | Italian | Italian |
| ja | Japanese | Japanese |
| ka | Georgian | Georgian |
| kk | Kazakh | Kazakh |
| kn | Kannada | Kannada |
| ko | Korean | Korean |
| ky | Kirghiz | Kirghiz |
| lt | Lithuanian | Lithuanian |
| lv | Latvian | Latvian |
| mk | Macedonian | Macedonian |
| mn | Mongolian | Mongolian |
| mr | Marathi | Marathi |
| ms | Malay | Malay |
| nl | Dutch | Dutch |
| no | Norwegian | Norwegian |
| pa | Punjabi | Punjabi |
| pl | Polish | Polish |
| pt | Portuguese | Portuguese |
| ro | Romanian | Romanian |
| ru | Russian | Russian |
| sa | Sanskrit | Sanskrit |
| sk | Slovak | Slovak |
| sl | Slovenian | Slovenian |
| sq | Albanian | Albanian |
| sv | Swedish | Swedish |
| sw | Swahili | Swahili |
| ta | Tamil | Tamil |
| te | Tegulu | Tegulu |
| th | Thai | Thai |
| tr | Turkish | Turkish |
| tt | Tatar | Tatar |
| uk | Ukrainian | Ukrainian |
| ur | Urdu | Urdu |
| uz | Uzbek | Uzbek |
| vi | Vietnamese | Vietnamese |
Table TaxonNameCreationType_Enum
Types of the creation of a taxonomic name
Dependent tables:
- TaxonName
Content
| Code | Description | DisplayText |
|---|---|---|
| auto | The name is an autonym, implicitly created through the creation of another taxon name – For example, if for “Poa alpina L.” a new subspecies “Poa alpina ssp. stefanovii Fiserova” is described, the autonym “Poa alpina L. ssp. alpina” is implicitly created as well. It is not published anywhere, and has no author on the subspecies (and neither author nor publication of Fiserova are given). | auto |
| comb | A new combination of a name into a different parent taxon that causes a name change. | comb |
| combstat | A new combination with a different name and change in rank of a taxon in a single nomenclatural action – For example, a subspecies in genus “Aus” is combined with genus “Bus” and the rank elevated to species at the same time. | combstat |
| nom | The name is a nomen novum (= replacement name, = avowed substitute). | nom. nov. |
| sanct | (Applicable only to Fungi:) The name is based on a prestarting-point name and sanctioned by the ICBN because is has been used in specific publications by Fries or Persoon. | sanct |
| stat | Change in rank of a taxon name, like a subspecies elevated to species rank, or a series to section. | stat |
| tax | Creation of a name at any rank, intended to represent a taxon that is new to science and based on an newly designated type. | tax |
| validation | The name is a validation of invalidly published names (sometimes expressed by “ex” in the author citation string). | validation |
Table TaxonNameListReferenceType_Enum
The types of the reference of the taxon list
Dependent tables:
- TaxonNameListReference
- TaxonNameReference
Table TaxonNameListSpecimenRole_Enum
Roles of collection specimen within a taxon list
Dependent tables:
- TaxonNameListCollectionSpecimen
Table TaxonNameNomenclaturalCode_Enum
Codes of Nomenclature under which this taxa are created, e.g. Zoology
Dependent tables:
- TaxonName
Content
| Code | Description | DisplayText |
|---|---|---|
| 1 | Bacteriology | Bacteriology |
| 2 | Botany (incl. Mycology) | Botany (incl. Mycology) |
| 3 | Zoology | Zoology |
| 4 | Biocode (for future use) | Biocode (for future use) |
Table TaxonNameNomenclaturalStatus_Enum
Nomenclatural stati for taxonomic names
Dependent tables:
- TaxonName
Content
| Code | Description | DisplayText |
|---|---|---|
| ad interim | in the meantime | ad interim |
| comb. | combinatio = combination | comb. |
| comb. ined. | combinatio inedita = unpublished combination | comb. ined. |
| comb. invalid. | comb. invalid. | comb. invalid. |
| comb. superfl. | combinatio superflua = superfluous combination (if a combining author has missed on the pre-existence of the same combination, therefore creating an isonym) | comb. superfl. |
| ined. | indeditum = unpublished (name) | ined. |
| nom. confus. | nomen confusum = confused name | nom. confus. |
| nom. cons. | If a name of a family, genus, or species is accepted as a nomen conservandum the abbreviation “nom. cons.” should be added in a formal citation | nom. cons. |
| nom. dub. | nom. dub. | nom. dub. |
| nom. excl. | nom. excl. | nom. excl. |
| nom. herb. | nomen in herbario = name given on herbarium labels | nom. herb. |
| nom. illeg. | nomen illegitimum = illegitimate name (ICBN: 6.4, 52-54, App. VII) | nom. illeg. |
| nom. inval. | nom. invalid. | nom. invalid. |
| nom. nov. | nomen novum = new name, replacement name (ICBN: 45A.1, App. VII) | nom. nov. |
| nom. nud. | nom. nudum | nom. nud. |
| nom. provis. | nomen provisorium = provisional name | nom. provis. |
| nom. rej. | nomen rejiciendum = name, to be rejected (ICBN: 50E.2, 56, App.V, VII) | nom. rej. |
| nom. superfl. | nomen superfluum = superfluous name (ICBN: 52.1+3) | nom. superfl. |
| pro syn. | In the citation of a name that is not validly published because it was merely cited as a synonym, the words “as synonym” or “pro syn.” should be added | pro syn. |
Table TaxonNameResourceType_Enum
The type of an resource of a taxon, e.g. preview
Dependent tables:
- TaxonNameResource
Content
| Code | Description | DisplayText |
|---|---|---|
| audio | E.g. audio file related to a taxon | sound |
| drawing | Original line or color drawing and painting of a taxon | drawing, painting |
| image | Still image of any raster or vector format without any further information regarding the content type, e. g. graphic designs, plans and maps, vector graphics 2D, 3D models | image |
| information | Any resource provided for the taxon, e.g. websites containing further information | information |
| preview | A small version of an image used as preview for an image | preview |
| supporting files | text-xml or text-WKT encoded files, assigned to multimedia objects | supporting files |
| video | E. g. video file related to a taxon | video |
Table TaxonNameRevisionLevel_Enum
States of revision for the taxa
Dependent tables:
- TaxonName
Content
| Code | Description | DisplayText |
|---|---|---|
| effectively published | effectively published (ICBN Art. 29-31) | effectively published (ICBN Art. 29-31) |
| final revision | final revision | final revision |
| review required | review required | review required |
| validly published | validly published (ICBN Art. 32-45) | validly published (ICBN Art. 32-45) |
Table TaxonNameSynonymisationType_Enum
Types of the synonyms
Dependent tables:
- TaxonSynonymy
Content
| Code | Description | DisplayText |
|---|---|---|
| duplicate | name is a duplicate of an other name, e.g. for imports of the same name from different sources | duplicate |
| heterotypic | heterotypic, the names have different basionyms | heterotypic |
| homotypic | homotypic, the names have the same basionym | homotypic |
| isonym | variant spelled exactly as another name but with deviating citation of the author(s), might be a name with wrong citation of the publishing or recombining author(s) or a even a isonym sensu ICBN | isonym |
| orthographic variant | variant spelled different as another name | orthographic variant |
| unknown | unknown if synonym is heterotypic or homotypic | unknown |
Table TaxonNameTaxonomicRank_Enum
Taxonomic ranks of the taxa
Dependent tables:
- TaxonName
Content
| Code | Description | DisplayText |
|---|---|---|
| agg. | species aggregate | species aggregate |
| aggr. | species aggregate | species aggregate |
| biovar. | bio-variety | bio-variety |
| cand. | candidate | candidate |
| cl. | class | class |
| convar. | convar | convar |
| cult. | cultivar | cultivar |
| cultivar. group | cultivar-group | cultivar-group |
| dom. | domain (= empire) | domain (= empire) |
| f. | form | form |
| f. sp. | special form | special form |
| fam. | family | family |
| gen. | genus | genus |
| graft-chimaera | graft-chimaera | graft-chimaera |
| grex | infraspecific aggregate | grex |
| infracl. | infraclass | infraclass |
| infrafam. | infrafamily | infrafamily |
| infragen. | infragenus | infragenus |
| infraord. | infraorder | infraorder |
| infraphyl./div. | infraphylum (= infradivision) | infraphylum (= infradivision) |
| infrareg. | infrakingdom | infrakingdom |
| infrasp. | infraspecies | infraspecies |
| infratrib. | infratribe | infratribe |
| ord. | order | order |
| pathovar. | patho-variety | patho-variety |
| phyl./div. | phylum (= division) | phylum (= division) |
| reg. | kingdom | kingdom |
| sect. | section | section |
| ser. | series | series |
| sp. | species | species |
| sp. group | species group | species group |
| subcl. | subclass | subclass |
| subfam. | subfamily | subfamily |
| subfm. | subform | subform |
| subgen. | subgenus | subgenus |
| subord. | suborder | suborder |
| subphyl./div. | subphylum (= subdivision) | subphylum (= subdivision) |
| subreg. | subkingdom | subkingdom |
| subsect. | subsection | subsection |
| subser. | subseries | subseries |
| subsp. | subspecies | subspecies |
| subsubfm. | subsubform | subsubform |
| subtrib. | subtribe | subtribe |
| subvar. | sub-variety | sub-variety |
| supercl. | superclass | superclass |
| superfam. | superfamily | superfamily |
| superord. | superorder | superorder |
| superphyl./div. | superphylum (= superdivision) | superphylum (= superdivision) |
| superreg. | super kingdom | super kingdom |
| supertrib. | supertribe | supertribe |
| tax. infragen. | infrageneric tax. of undefined rank | infrageneric tax. of undefined rank |
| tax. infrasp. | infraspecific tax. of undefined rank | infraspecific tax. of undefined rank |
| tax. supragen. | suprageneric tax. of undefined rank | suprageneric tax. of undefined rank |
| trib. | tribe | tribe |
| var. | variety | variety |
Diversity TaxonNames
No-SQL Interface
JSON Cache
Databases of the modules provid a No-SQL interface where the data of the main table and the depending tables are merged as JSON.
Table JsonCache
Content of table JsonCache restricted to public available data
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ID | int | Unique ID for the Dataset, Primary key | NO | ID of the source |
| URI | varchar (500) | The URL as combination of BaseURL and ID | NO | BaseURL and ID of the source |
| DisplayText | nvarchar (500) | Representation in the interface | NO | Main table of the source |
| LogUpdatedWhen | datetime | Date and time when the data were last updated | NO | - |
| Data | json | Data related to the current dataset | NO | - |
procFillJsonCache is started by an update trigger trgUpd… of the main table in the database
Interface in clients
All modules provide data via a cache table. In the header of the clients you can inspect the content of the JsonCache with a click on the button. For modules with a difference between local and public data, you can inspect the content of the public data with a click of the right mouse button.
Update
Apart of the update via the Trigger (see below) you can update the JsonCache via the 
update button underneath the button.
To update the JsonCache for the whole database select Administration - JsonCache… from the menu. a window as shown below will open where you can update the JsonCache for single datasets or the whole database.
Summary
graph TD;
TaxonName[Main table in database]
trgUpdTaxonName[trgUpd.. of main table in database]
TaxonName --> |Update in table| trgUpdTaxonName
proc[Procedure procFillJsonCache setting the content in table JsonCache]
trgUpdTaxonName --> proc
graph TD;
Mainform[Main form]
ButtonShow[Button show JsonCache of current dataset]
Mainform --> ButtonShow
Left[Show Data]
ButtonShow --> |Left click| Left
graph TD;
Mainform[Main form]
Admin[Administration menu]
Mainform --> Admin
Cache[JsonCache...]
Admin --> Cache
Adminform[Administration form]
Cache --> Adminform
AdminUpdateSingle[Update single dataset]
Adminform --> AdminUpdateSingle
AdminUpdateDB[Update for whole database]
Adminform --> AdminUpdateDB
Example
The JsonCache of the current dataset will be shown as in the example below:
[
{
"Type": "Taxon",
"ID": 4403792,
"Attributes": {
"FullName": "Arachnida Cuvier, 1812",
"Rank": "cl.",
"GenusOrSupragenericName": "Arachnida",
"Authors": "Cuvier",
"Publication": ". 1812",
"Project": [
{
"Project": "SNSBnames"
}
],
"Checklist": {
"Analysis": [
{
"Checklist": "TaxRef_SNSB_NHC-Pests",
"Analysis": "IPM | Group",
"Value": "70"
},
{
"Checklist": "TaxRef_SNSB_NHC-Beneficials",
"Analysis": "IPM | Group",
"Value": "70"
},
{
"Checklist": "TaxRef_SNSB_NHC-Bycatchs",
"Analysis": "IPM | Group",
"Value": "70"
}
]
},
"Synonymy": [
{
"ID": 4403792,
"FullName": "Arachnida Cuvier, 1812",
"Name": "Arachnida",
"Type": "accepted name"
}
],
"HierarchyListCache": [
{
"HierarchyListCache": "Animalia | Arthropoda | Arachnida"
}
],
"Hierarchy": [
{
"ID": 4403792,
"FullName": "Arachnida Cuvier, 1812",
"Name": "Arachnida",
"Rank": "cl."
},
{
"ID": 4403934,
"FullName": "Arthropoda Gravenhorst, 1843",
"Name": "Arthropoda",
"Rank": "phyl./div."
},
{
"ID": 4403805,
"FullName": "Animalia Linnaeus, 1758",
"Name": "Animalia",
"Rank": "reg."
}
],
"CommonNames": [
{
"CommonName": "spider",
"LanguageCode": "en",
"CountryCode": "GB",
"Context": "IPM"
},
{
"CommonName": "Spinnentier",
"LanguageCode": "de",
"CountryCode": "DE",
"Context": "IPM"
}
],
"Resource": [
{
"URI": "https://museumsschaedlinge.de/gaeste/",
"Title": "diverse animals that migrate or are introduced into buildings seasonally, generally don't casue any damage to objects",
"Type": "information"
}
]
}
}
]Diversity Taxon Names
Workbench
The Diversity Workbench is composed of components for building and managing biodiversity information, each of which focuses on a particular domain. Each component can provide services to the other components. DiversityTaxonNames can link data to the modules DiversityProjects, DiversityGazetteer, DiversityAgents, DiversityCollection and DiversityReferences as illustrated in the image below. DiversityTaxonNames itself is a source for other modules like DiversityCollection and DiversityDescriptions.
The modules communicate with each other to provide their services for the other modules.
Subsections of Workbench
Diversity Taxon Names
Modules
The Diversity Workbench is a set of components for building and managing biodiversity information, each of which focuses on a particular domain. To see the open connections to other modules, choose Connection - Module connections …. from the menu. Each component can provide services to the other components. The optional links to other modules within the Diversity Workbench are shown in the image below.
- Links to DiversityGazetteer
- Links to DiversityReferences
- Links to DiversityProjects
- Links to DiversityCollection
Diversity Taxon Names
Descriptions
If you are connected to a DiversityDescriptions database (see menu
Connection - Module connections … ), and you select the option
Scan module
DiversityDescriptions the program will search in all available
databases for descriptions linked to the current name. If you select an
entry from the list the basic data as provided by the module
DiversityDescriptions are shown. To see the details of the data you have
to set the link to the software DiversityDescriptions.exe with a click
on the 
botton (see below).
After this link is set, you can click on the
botton to open the software with the details of the selected dataset
(see below). For an introduction see a short tutorial
.
Diversity Taxon Names
Specimen
If you are connected to a DiversityCollection database (see menu
Connection → Module connections … ), and you select the option
Scan module
DiversityCollection the program will search in all available
databases for specimen linked to the current name. With the option
Restrict to type
specimen you can restrict this search to type specimen. If you
select an entry from the list the basic data as provided by the module
DiversityCollection are shown. To see the details of the data you have
to set the link to the software DiversityCollection.exe with a click on
the botton (see below).
All DiversityCollection databases listed in the connections will be scanned for links to the selected name (see above). To see the details select the entry in the tree (see below).
A click on the button will open the client of
DiversityCollection with the respective dataset (see below. In case the
installation path of DiversityCollection is not detected by default, you
will be asked to enter it. If the option
Restrict to type specimen is selected, only type specimen will be
listed. For an introduction see a short tutorial.
To forward changes in DiversityTaxonNames to databases containing data
linked to data in e.g. DiversityCollection you must include the
corresponding databases as described here. After
changes in the data the
button will be marked with a pink
background
indicating the option to update
the linked data. Click on the
button to perform the update as
described here
.
Diversity Taxon Names
Settings
The settings for the software are stored in a directory created by the application, e.g. C:\Users\[LoginName]\AppData\Local\DiversityWorkbench\[DiversityWorkbenchModule].exe_Url_0he1anjeninqrrxpdywiwnwxaqvlezn3\4.4.13.0 where [LoginName] is the name of the user and [DiversityWorkbenchModule] the name of the Diversity Workbench module e.g. DiversityCollection. This directory contains the file user.config where all settings are stored in xml format. An example for the content in the module DiversityCollection is shown below:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<sectionGroup name="userSettings">
<section name="DiversityWorkbench.WorkbenchSettings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />
</sectionGroup>
</configSections>
<userSettings>
<DiversityWorkbench.WorkbenchSettings>
<setting name="ModuleName" serializeAs="String">
<value>DiversityCollection</value>
</setting>
<setting name="GenerateTraceFile" serializeAs="String">
<value>False</value>
</setting>
<setting name="DatabaseServer" serializeAs="String">
<value>zsm.diversityworkbench.de</value>
</setting>
<setting name="IsTrustedConnection" serializeAs="String">
<value>True</value>
</setting>
<setting name="DatabaseName" serializeAs="String">
<value>DiversityCollection</value>
</setting>
<setting name="QueryMaxResults" serializeAs="String">
<value>100</value>
</setting>
<setting name="DatabasePort" serializeAs="String">
<value>5432</value>
</setting>
<setting name="DatabaseUser" serializeAs="String">
<value>User</value>
</setting>
<setting name="ResourcesDirectory" serializeAs="String">
<value>Home</value>
</setting>
<setting name="HowToCopyAppToUserDirectory" serializeAs="String">
<value>Missing</value>
</setting>
</DiversityWorkbench.WorkbenchSettings>
<DiversityCollection.Forms.FormCollectionSpecimenSettings>
<setting name="SplitContainerData_SplitterDistance" serializeAs="String">
<value>270</value>
</setting>
<setting name="QueryConditionVisibility" serializeAs="String">
<value>10000100011000010000000000001000000001100000000000000000000000000001110000110110000000000000000000000000000000000000000000000000000000000000000000000000011100001000000000000000010000000000000000001000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000</value>
</setting>
<setting name="ImageDisplay" serializeAs="String">
<value>Hidden</value>
</setting>
<setting name="AskOnExit" serializeAs="String">
<value>True</value>
</setting>
</DiversityCollection.Forms.FormCollectionSpecimenSettings>
</userSettings>
</configuration>