
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| UserName | varchar (50) | The name of the user who created this SQL string Default value: user_name() |
NO | - |
| SQLStringIdentifier | varchar (50) | The identifier for the selection string as shown in user interface | NO | - |
| ItemTable | varchar (50) | The table from which the datasets should be selected | YES | - |
| SQLString | varchar (2000) | SQL string for selecting datasets from the database | YES | - |
| Description | nvarchar (MAX) | Description of the resultset and the purpose of the query | YES | - |
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ProjectID | int | ID of the project | NO | - |
| Project | nvarchar (50) | The name of the project | NO | - |
| ImageDescriptionTemplate | xml (MAX) | Template for the description of images | YES | - |
| ProjectURI | varchar (255) | The URI of the project, e.g. as provided by the module DiversityProjects. | YES | - |
| 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 |
| 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 | - |
| 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 | - |
| 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 | - |
| 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 | - |
| 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 | - |
| 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 | - |
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| NameID | int | The ID of a name in DiversityTaxonNames_Fungi (primary key) | NO | - |
| TaxonNameCache | nvarchar (255) | A full unique version of the name. Generated by the database, not entered by the user (candidate key) | YES | - |
| Version | smallint | The version of a name record (revision number, internally filled by system) Default value: (1) |
YES | - |
| BasedOnNameID | int | The Basionym of this name, resp. the NameID of the Basionym. A name is a Basionym, if NameID = BasionymID. | YES | Refers to table TaxonName |
| CreationType | nvarchar (50) | E.g.: taxon based on new type, combination based on a previously publ. name ('comb. nov.'), new name ('nom.nov.') introduced to replace a homonym (may occur for genera!), validation of previously invalidly publ. taxon name ('ex'), or unknown. | YES | Refers to table TaxonNameCreationType_Enum |
| TaxonomicRank | nvarchar (50) | Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank) Default value: N'sp.' |
NO | Refers to table TaxonNameTaxonomicRank_Enum |
| GenusOrSupragenericName | nvarchar (200) | If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc. | NO | - |
| SpeciesGenusNameID | int | If rank is species or below: NameID of the Genus name. Refers to same table with TaxonomicRank = genus. | YES | Refers to table TaxonName |
| InfragenericEpithet | nvarchar (200) | If rank below genus and above species: Name of infrageneric taxon above species level (currently accepted spelling). Includes subgenus, series, etc. | YES | - |
| SpeciesEpithet | nvarchar (100) | The species name part of the species name, for example 'alba' in 'Abies alba'. | YES | - |
| InfraspecificEpithet | nvarchar (100) | The epithet of the infraspecific entity | YES | - |
| BasionymAuthors | nvarchar (100) | The authors of a newly created name. For all taxonomic ranks, only for 'comb. nov.' or 'nom. nov.': Author(s) of the basionym (will be displayed in '()', do not enter the parentheses), abbreviated according to authors standard | YES | - |
| CombiningAuthors | nvarchar (255) | The names of the combining authors if the name is base on another older name (e.g. combined into a different genus) | YES | - |
| PublishingAuthors | nvarchar (255) | If the authors of the taxon differ from the authors of the publication: the latter (...'in ' Publishing authors ... ) | YES | - |
| SanctioningAuthor | nvarchar (100) | Sanctioning is a special instrument available for fungi to allow the starting date of taxonomy to be identical with higher plants, but preserve names used by Fries (Fr.) and Person (Pers.) | YES | - |
| NonNomenclaturalNameSuffix | nvarchar (200) | A suffix for concept names not included in any nomenclatural code. If present fields for authors and typification must be empty and NomenclaturalCode set to 'not under code'. | YES | - |
| IsRecombination | bit | True if the name is a recombination Default value: (0) |
NO | - |
| IsHybrid | bit | If checked (or 'True'), the new taxon is a hybrid with or without a hybrid epithet. Default value: (0) |
YES | - |
| HybridNameID1 | int | If IsHybrid is checked (or 'True'): Name of hybrid species 1. Refers to NomID code of publ. TaxonomyName (= foreign key). | YES | Refers to table TaxonName |
| HybridNameID2 | int | If IsHybrid is checked (or 'True'): Name of hybrid species 2. Refers to NomID code of publ. TaxonomyName (= foreign key). | YES | Refers to table TaxonName |
| HybridNameID3 | int | If IsHybrid is checked (or 'True'): Name of hybrid species 3. Refers to NomID code of publ. TaxonomyName (= foreign key). | YES | Refers to table TaxonName |
| HybridNameID4 | int | If IsHybrid is checked (or 'True'): Name of hybrid species 4. Refers to NomID code of publ. TaxonomyName (= foreign key). | YES | Refers to table TaxonName |
| ReferenceTitle | nvarchar (600) | The title of the publication where the name was published. Note this is only a cached value where ReferenceURI is present | YES | - |
| ReferenceURI | varchar (255) | URI (e.g. LSID) of Reference, referes to table ReferenceTitle in Database DiversityReferences: Source publication where name is published | YES | - |
| Volume | nvarchar (20) | The volume of the journal | YES | - |
| Issue | nvarchar (255) | The issue of the literature | YES | - |
| Pages | nvarchar (50) | The pages within the literature | YES | - |
| DetailLocation | nvarchar (200) | Additional information like plates etc. | YES | - |
| DayOfPubl | tinyint | The day when the name was published | YES | - |
| MonthOfPubl | tinyint | The month when the name was published | YES | - |
| YearOfPubl | smallint | The year when the name was published | YES | - |
| DateOfPublSupplement | nvarchar (200) | Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892' | YES | - |
| YearOnPubl | smallint | The year cited on the original paper as year of publication | YES | - |
| DateOnPublSupplement | nvarchar (200) | Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892' | YES | - |
| Protologue | nvarchar (MAX) | Full text of the protologue. If protologue is provided in Latin and in another language languages, both only the Latin or several languages may be stored together. | YES | - |
| ProtologueURI | varchar (255) | URI of externally available Protologue information (scanned image, full text from external provider, etc.) | YES | - |
| ProtologueResourceURI | varchar (255) | The ResourceID of an image of the protologue as stored in the module DiversityResources. Primary key of table Resource in the database DiversityResources.(= Foreign key) | YES | - |
| NameUsageReferences | nvarchar (255) | Indexing volumes like Index of Fungi or any Name usage that caused this name to be added to the database | YES | - |
| OriginalOrthography | nvarchar (255) | The original spelling of the name | YES | - |
| NomenclaturalCode | nvarchar (50) | Code of Nomenclature under which this taxon was created: 'Bacteriology', 'Botany' (incl. Mycology), 'Zoology', 'Biocode' (for future use), 'Non nomenclatural name'. Default value: 'Botany' | YES | Refers to table TaxonNameNomenclaturalCode_Enum |
| NomenclaturalStatus | nvarchar (50) | Categories for effective/valid/legitimate... esp. 'nom. illeg.', 'nom. inval.', 'nom. nudum', etc. | YES | Refers to table TaxonNameNomenclaturalStatus_Enum |
| NomenclaturalComment | nvarchar (MAX) | Comments on the nomenclature. e.g. 'according to ICBN Art. 39.1' | YES | - |
| Typification | nvarchar (50) | The status of the type specimen(s) as written in the protologue, e.g. holotype | YES | - |
| TypificationDetails | nvarchar (255) | Details concerning the typification as written in the protologue, e.g. if just parts of a specimen were accepted as the type | YES | - |
| TypificationReferenceTitle | nvarchar (255) | The title of the publication where the typification was published. Note this is only a cached value where Typification-LiteratureLink is present | YES | - |
| TypificationReferenceURI | varchar (255) | URI (e.g. LSID) of Reference, refers to e.g DiversityReferences: Source publication where the typification is published | YES | - |
| TypificationNotes | nvarchar (200) | Notes concerning the typification | YES | - |
| TypeSubstrate | nvarchar (255) | The substrate the type was growing on as written in the protologue | YES | - |
| TypeLocality | nvarchar (255) | The locality where the type was found as written in the protologue | YES | - |
| TypeSpecimenNotes | nvarchar (200) | Notes about the type specimen, e.g. the herbarium where a type specimen is located, Collector, collection date/number, etc. | YES | - |
| AnamorphTeleomorph | nvarchar (255) | If the name is related to a anamorph or a teleomorph as written in the protologue | YES | - |
| TypistNotes | nvarchar (200) | Additional notes and problems | YES | - |
| RevisionLevel | nvarchar (50) | The level of the revision of the taxonomic name, e.g. 'unchecked', 'fully checked' | YES | Refers to table TaxonNameRevisionLevel_Enum |
| IgnoreButKeepForReference | bit | If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. Default value: (0) |
YES | - |
| DataWithholdingReason | nvarchar (255) | If the dataset is withhold, the reason for withholding the data, otherwise null | YES | - |
| BasionymAuthorsYear | int | The year when the name was published by the authors of the Basionym | YES | - |
| 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 | - |
| 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 | - |
| 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 | - |
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| NameID | int | ID of the name. Refers to the NameID of TaxonName (= foreign key). | NO | Refers to table TaxonNameList and table TaxonNameListReference |
| ProjectID | int | Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module. | NO | Refers to table TaxonNameList and table TaxonNameListReference |
| TaxonNameListRefID | int | Unique ID of the reference within the list, refers to table TaxonNameListReference, part of primary key Default value: (-1) |
NO | Refers to table TaxonNameListReference |
| AnalysisID | int | ID of the analysis (= foreign key) | NO | Refers to table TaxonNameListAnalysisCategory |
| AnalysisValue | nvarchar (MAX) | The result of the analysis | YES | - |
| Notes | nvarchar (MAX) | Notes concerning this analysis | YES | - |
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| AnalysisID | int | ID of the analysis (Primary key) | NO | - |
| AnalysisParentID | int | Analysis ID of the parent analysis if it belongs to a certain type documented in this table | YES | - |
| DisplayText | nvarchar (50) | Name of the analysis as e.g. shown in user interface | YES | - |
| Description | nvarchar (MAX) | Description of the analysis | YES | - |
| AnalysisURI | varchar (255) | URI referring to an external documentation of the analysis | YES | - |
| Notes | nvarchar (MAX) | Notes concerning this analysis | YES | - |
| ReferenceTitle | nvarchar (800) | The title of the publication where details about the analysis are published. Note this is only a cached value where ReferenceURI is present | YES | - |
| ReferenceURI | varchar (400) | URI (e.g. LSID) of Reference, referes to table ReferenceTitle in module DiversityReferences: Source publication where details about the analysis are published | YES | - |
| DataWithholdingReason | nvarchar (255) | If the data set is withhold, the reason for withholding the data, otherwise null | YES | - |
| SortingID | int | An ID for sorting the data | YES | - |
| 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 | - |
| 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 | - |
| 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 | - |
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| NameID | int | ID of the name. Refers to the NameID of TaxonName (= foreign key). | NO | Refers to table TaxonNameList and table TaxonNameListReference |
| ProjectID | int | Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module. | NO | Refers to table TaxonNameList and table TaxonNameListReference |
| TaxonNameListRefID | int | Unique ID of the reference within the list, refers to table TaxonNameListReference, part of primary key Default value: (-1) |
NO | Refers to table TaxonNameListReference |
| PlaceURI | varchar (255) | URI or identifier for a place (which may have several names) derived from e.g. TDWG Default value: '' |
NO | - |
| PlaceNameCache | nvarchar (255) | The name of the place Default value: '' |
NO | - |
| Notes | nvarchar (MAX) | Notes concerning this analysis | YES | - |
| 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 | - |
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ProjectID | int | ID of the Project, Primary key. May be related to module DiversityProjects | NO | - |
| Project | nvarchar (50) | The name of the project. May be related to module DiversityProjets | NO | - |
| ProjectURI | varchar (255) | The URI of the project, e.g. as provided by the module DiversityProjects. | YES | - |
| TaxonomicGroup | nvarchar (50) | The taxonomic group as used in DiversityCollection resp. DiversityMobile | YES | - |
| DisplayText | nvarchar (50) | The text as shown in a user interface. Corresponds to ProjectTitle in DiversityProjects.Project | YES | - |
| DefaultProjectID | int | The ID of the default project where informations about e.g. the synonymy are taken from | YES | - |
| 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 | - |
| 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 |
| 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 |
| 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 | - |
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| NameID | int | ID of the name. Refers to the NameID of TaxonName (= foreign key). | NO | Refers to table TaxonNameProject |
| ProjectID | int | ID of the project. Refers to the common project definition in the DiversityProjects module. | NO | Refers to table TaxonNameProject |
| URI | varchar (255) | The complete URI address of the resource. | NO | - |
| Description | xml (MAX) | Description of the resource | YES | - |
| Notes | nvarchar (MAX) | A note concerning this entry. | YES | - |
| Title | nvarchar (500) | Title of the resource | YES | - |
| IPR | nvarchar (500) | Intellectual Property Rights; the rights given to persons for their intellectual property | YES | - |
| Creator | nvarchar (500) | Person or organization originally creating the resource | YES | - |
| CreatorAgentURI | varchar (500) | Link to the module DiversityAgents | YES | - |
| CopyrightStatement | nvarchar (500) | Notice on rights held in and for the resource | YES | - |
| LicenseType | nvarchar (500) | Type of an official or legal permission to do or own a specified thing, e. g. Creative Common Licenses | YES | - |
| LicenseHolder | nvarchar (500) | The person or institution holding the license | YES | - |
| LicenseHolderAgentURI | varchar (500) | The link to a module containing further information on the person or institution holding the license | YES | - |
| LicenseYear | nvarchar (50) | The year of license declaration | YES | - |
| DisplayOrder | int | The sequence in which the resource should be displayed in a user interface Default value: (1) |
YES | - |
| DataWithholdingReason | nvarchar (255) | If the data set is withhold, the reason for withholding the data, otherwise null Default value: '' |
YES | - |
| ResourceType | nvarchar (50) | Type of the resource as defined in table TaxonNameResourceType_Enum | YES | Refers to table TaxonNameResourceType_Enum |
| 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 | - |
| 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 | - |
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| LoginName | nvarchar (50) | Login of the user | NO | - |
| CombinedNameCache | nvarchar (500) | Name provided e.g. by DiversityAgents | YES | - |
| Queries | xml (MAX) | Queries created by the user | YES | - |
| CurrentProjectID | int | ID of the project selected by the user | YES | - |
| AgentURI | varchar (255) | A link to a DiversityAgents module where further informations about the user is available. | YES | - |
| ID | int | ID of the user | NO | - |
| PrivacyConsent | bit | If the user consents the storage of his user name in the database | YES | - |
| PrivacyConsentDate | datetime | The time and date when the user consented or refused the storage of his user name in the database | YES | - |
| 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 |
| Column | Data type | Description | Nullable |
|---|---|---|---|
| SQLStringIdentifier | varchar (50) | The identifier for the selection string as shown in user interface | NO |
| ItemTable | varchar (50) | The table from which the datasets should be selected | YES |
| SQLString | varchar (2000) | SQL string for selecting datasets from the database | YES |
| Description | nvarchar (MAX) | Description of the resultset and the purpose of the query | YES |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| Column | Data type | Description | Nullable |
|---|---|---|---|
| BaseURL | varchar (255) | The BaseURL of the database | YES |
| Column | Data type | Description | Nullable |
|---|---|---|---|
| ProjectID | int | ID of the project. Foreign key, relates to PK of table ProjectProxy | YES |
| Column | Data type | Description | Nullable |
|---|---|---|---|
| DiversityWorkbenchModule | nvarchar (50) | The DiversityWorkbenchModule of the database = DiversityTaxonNames | YES |
| 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 |
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. |
| Column | DataType | Description |
|---|---|---|
| AnalysisID | int | ID of the analysis (Primary key) |
| AnalysisParentID | int | Analysis ID of the parent analysis if it belongs to a certain type documented in this table |
| DisplayText | nvarchar (50) | Name of the analysis as e.g. shown in user interface |
| Description | nvarchar (MAX) | Description of the analysis |
| Notes | nvarchar (MAX) | Notes concerning this analysis |
| AnalysisURI | varchar (255) | URI referring to an external documentation of the analysis |
| OnlyHierarchy | bit | Reserved for future application |
| DataWithholdingReason | nvarchar (255) | If the data set is withhold, the reason for withholding the data, otherwise null |
| SortingID | int | An ID for sorting the data |
| HierarchyDisplayText | varchar (900) | DisplayTexts of the hierarchy separated by " | " of all data related to an item |
DataType: varchar (255)
DataType: int
| 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 |
DataType: nvarchar (50)
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 |
| 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 |
| 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 " | " |
| 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 |
| 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 |
| 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 |
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 |
DataType: varchar (900)
| 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 |
| 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. |
| 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 " | " |
DataType: datetime
| Parameter | DataType | Description |
|---|---|---|
| @ListID | int | ProjectID as defined in table TaxonNameListProjectProxy |
| 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 |
| 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. |
DataType: nvarchar (255)
| Parameter | DataType | Description |
|---|---|---|
| @NameID | int | The ID of a name in DiversityTaxonNames_Fungi (primary key) |
DataType: nvarchar (255)
| Parameter | DataType | Description |
|---|---|---|
| @NameID | int | The ID of a name in DiversityTaxonNames_Fungi (primary key) |
| 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 |
| 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 |
| Column | DataType | Description |
|---|---|---|
| NameID | int | The ID of a name in DiversityTaxonNames_Fungi (primary key) |
DataType: int
DataType: nvarchar (8)
DataType: nvarchar (11)
| 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 |
| Parameter | DataType | Description |
|---|---|---|
| @ID | int | The NameID of the taxon |
| 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 |
| 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' |
| 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. |
| 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. |
| Parameter | DataType | Description |
|---|---|---|
| @User | varchar (50) | Login of the user |
| Permissions | SELECT | INSERT | UPDATE | DELETE | EXECUTE | Type |
|---|---|---|---|---|---|---|
| ApplicationSearchSelectionStrings | Diversity Workbench User | TABLE | ||||
| CountryCode_Enum | Diversity Workbench User | TABLE | ||||
| LanguageCode_Enum | Diversity Workbench User | TABLE | ||||
| ProjectProxy | Diversity Workbench User | • | • | • | TABLE | |
| ProjectUser | • | • | • | TABLE | ||
| ReplicationPublisher | • | • | • | • | TABLE | |
| SynonymyListCache | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | ||
| TaxonAcceptedName | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| TaxonAcceptedName_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| TaxonCommonName | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | • | TABLE | |
| TaxonCommonName_log | TABLE | |||||
| TaxonGeography | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| TaxonGeography_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| TaxonHierarchy | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| TaxonHierarchy_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| TaxonName | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | • | TABLE | |
| TaxonName_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| TaxonNameCreationType_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameExternalDatabase | Diversity Workbench User | • | • | • | TABLE | |
| TaxonNameExternalDatabase_log | TABLE | |||||
| TaxonNameExternalID | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | • | TABLE | |
| TaxonNameExternalID_log | TABLE | |||||
| TaxonNameList | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | • | TABLE | |
| TaxonNameList_log | Diversity Workbench User | Diversity Workbench Editor | TABLE | |||
| TaxonNameListAnalysis | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| TaxonNameListAnalysis_log | Diversity Workbench User | Diversity Workbench Editor | TABLE | |||
| TaxonNameListAnalysisCategory | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | • | TABLE | |
| TaxonNameListAnalysisCategory_log | Diversity Workbench User | Diversity Workbench Editor | TABLE | |||
| TaxonNameListAnalysisCategoryValue | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | • | TABLE | |
| TaxonNameListAnalysisCategoryValue_log | Diversity Workbench User | Diversity Workbench Editor | TABLE | |||
| TaxonNameListArea | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| TaxonNameListArea_log | Diversity Workbench User | Diversity Workbench Editor | TABLE | |||
| TaxonNameListCollectionSpecimen | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| TaxonNameListCollectionSpecimen_log | TABLE | |||||
| TaxonNameListDistribution | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| TaxonNameListDistribution_log | Diversity Workbench User | Diversity Workbench Editor | TABLE | |||
| TaxonNameListImage | TABLE | |||||
| TaxonNameListImage_log | TABLE | |||||
| TaxonNameListProjectProxy | Diversity Workbench User | • | • | • | TABLE | |
| TaxonNameListReference | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| TaxonNameListReference_log | Diversity Workbench User | Diversity Workbench Editor | TABLE | |||
| TaxonNameListReferenceType_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameListSpecimenRole_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameListUser | Diversity Workbench User | • | • | TABLE | ||
| TaxonNameNomenclaturalCode_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameNomenclaturalStatus_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameProject | Diversity Workbench User | Diversity Workbench Editor | • | TABLE | ||
| TaxonNameProject_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| TaxonNameReference | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | • | TABLE | |
| TaxonNameReference_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| TaxonNameResource | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| TaxonNameResource_log | Diversity Workbench User | Diversity Workbench Editor | TABLE | |||
| TaxonNameResourceType_Enum | Diversity Workbench User | • | • | TABLE | ||
| TaxonNameRevisionLevel_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameSynonymisationType_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameTaxonomicRank_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameTypification | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| TaxonNameTypification_log | Diversity Workbench User | Diversity Workbench Editor | TABLE | |||
| TaxonSynonymy | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| TaxonSynonymy_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| UserProxy | • | • | Diversity Workbench User | • | TABLE | |
| AcceptedNameChanges | Diversity Workbench User | VIEW | ||||
| ApplicationSearchSelectionStrings_Core | Diversity Workbench User | VIEW | ||||
| GenusList | VIEW | |||||
| NameID_UserAvailable | Diversity Workbench User | VIEW | ||||
| ProjectList | Diversity Workbench User | VIEW | ||||
| TaxonAcceptedName_Core | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | VIEW | |
| TaxonAcceptedName_Indicated | Diversity Workbench User | VIEW | ||||
| TaxonAcceptedNameList | Diversity Workbench User | VIEW | ||||
| TaxonAcceptedNameListIncludeIgnored | Diversity Workbench User | VIEW | ||||
| TaxonFamily | Diversity Workbench User | VIEW | ||||
| TaxonGeography_Core | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | VIEW | |
| TaxonHierarchy_Core | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | VIEW | |
| TaxonListSynType | Diversity Workbench User | VIEW | ||||
| TaxonName_Core | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | • | VIEW | |
| TaxonName_Indicated | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | • | VIEW | |
| TaxonNameExternalID_Core | Diversity Workbench User | VIEW | ||||
| TaxonOrder | Diversity Workbench User | VIEW | ||||
| TaxonSynonymy_Core | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | VIEW | |
| TaxonSynonymy_Indicated | Diversity Workbench User | VIEW | ||||
| TaxonSynonymyAcceptedNameID | Diversity Workbench User | VIEW | ||||
| TaxonSynonymyList | Diversity Workbench User | VIEW | ||||
| TaxonSynonymyListIncludeIgnored | Diversity Workbench User | VIEW | ||||
| ViewBaseURL | Diversity Workbench User | VIEW | ||||
| ViewDefaultProjectID | Diversity Workbench User | VIEW | ||||
| ViewDiversityWorkbenchModule | Diversity Workbench User | VIEW | ||||
| ViewTaxonNameResource | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | VIEW | |
| AcceptedNameID | Diversity Workbench User | FUNCTION | ||||
| AnalysisCategoryHierarchyAll | Diversity Workbench User | FUNCTION | ||||
| BaseURL | Diversity Workbench User | FUNCTION | ||||
| DefaultProjectID | Diversity Workbench User | FUNCTION | ||||
| DiversityMobile_TaxonList | Diversity Workbench User | FUNCTION | ||||
| DiversityWorkbenchModule | Diversity Workbench User | FUNCTION | ||||
| HierarchyCache | Diversity Workbench Editor | FUNCTION | ||||
| HierarchyFamilyList | Diversity Workbench User | FUNCTION | ||||
| HierarchyList | Diversity Workbench User | FUNCTION | ||||
| HierarchyOrderList | Diversity Workbench User | FUNCTION | ||||
| HierarchySuperiorList | Diversity Workbench User | FUNCTION | ||||
| NameList | Diversity Workbench User | FUNCTION | ||||
| NextNameID | Diversity Workbench Editor | FUNCTION | ||||
| PrivacyConsentInfo | Diversity Workbench User | FUNCTION | ||||
| SynonymyList | Diversity Workbench User | FUNCTION | ||||
| SynonymyListIncludeIgnored | Diversity Workbench User | FUNCTION | ||||
| TaxonChildNodes | Diversity Workbench User | FUNCTION | ||||
| TaxonListLastUpdate | Diversity Workbench User | FUNCTION | ||||
| TaxonListsForUser | Diversity Workbench User | FUNCTION | ||||
| TaxonListsLastUpdate | Diversity Workbench User | FUNCTION | ||||
| TaxonNameCache | Diversity Workbench User | FUNCTION | ||||
| TaxonNameCacheSinAut | Diversity Workbench User | FUNCTION | ||||
| TaxonNameListAnalysisCategoryChildNodes | Diversity Workbench User | FUNCTION | ||||
| TaxonNameListAnalysisCategoryHierarchy | Diversity Workbench User | FUNCTION | ||||
| TaxonNameListUserNameID | Diversity Workbench User | FUNCTION | ||||
| UserID | Diversity Workbench User | FUNCTION | ||||
| Version | Diversity Workbench User | FUNCTION | ||||
| VersionClient | Diversity Workbench User | FUNCTION | ||||
| procFillSynonymyListCache | Diversity Workbench Editor | PROCEDURE | ||||
| procHierarchyCache | Diversity Workbench Editor | PROCEDURE | ||||
| procSetVersionTaxonName | PROCEDURE | |||||
| procTaxonNameInsertCopy | Diversity Workbench Editor | PROCEDURE | ||||
| procTaxonNameInsertNew_3 | Diversity Workbench Editor | PROCEDURE | ||||
| procTaxonNameListInsertCopy | Diversity Workbench Editor | PROCEDURE | ||||
| procTaxonNameListInsertReferenceCopy | Diversity Workbench Editor | PROCEDURE | ||||
| SetUserProjects | PROCEDURE |
Inheriting from roles:
| Permissions | SELECT | INSERT | UPDATE | DELETE | EXECUTE | Type |
|---|---|---|---|---|---|---|
| ApplicationSearchSelectionStrings | Diversity Workbench User | TABLE | ||||
| CountryCode_Enum | Diversity Workbench User | TABLE | ||||
| LanguageCode_Enum | Diversity Workbench User | TABLE | ||||
| ProjectProxy | Diversity Workbench User | TABLE | ||||
| ProjectUser | Diversity Workbench User | TABLE | ||||
| ReplicationPublisher | TABLE | |||||
| SynonymyListCache | Diversity Workbench User | • | • | TABLE | ||
| TaxonAcceptedName | Diversity Workbench User | • | • | • | TABLE | |
| TaxonAcceptedName_log | • | • | TABLE | |||
| TaxonCommonName | Diversity Workbench User | • | • | TABLE | ||
| TaxonCommonName_log | TABLE | |||||
| TaxonGeography | Diversity Workbench User | • | • | • | TABLE | |
| TaxonGeography_log | • | • | TABLE | |||
| TaxonHierarchy | Diversity Workbench User | • | • | • | TABLE | |
| TaxonHierarchy_log | • | • | TABLE | |||
| TaxonName | Diversity Workbench User | • | • | TABLE | ||
| TaxonName_log | • | • | TABLE | |||
| TaxonNameCreationType_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameExternalDatabase | Diversity Workbench User | TABLE | ||||
| TaxonNameExternalDatabase_log | TABLE | |||||
| TaxonNameExternalID | Diversity Workbench User | • | • | • | TABLE | |
| TaxonNameExternalID_log | TABLE | |||||
| TaxonNameList | Diversity Workbench User | • | • | • | TABLE | |
| TaxonNameList_log | Diversity Workbench User | • | TABLE | |||
| TaxonNameListAnalysis | Diversity Workbench User | • | • | • | TABLE | |
| TaxonNameListAnalysis_log | Diversity Workbench User | • | TABLE | |||
| TaxonNameListAnalysisCategory | Diversity Workbench User | • | • | TABLE | ||
| TaxonNameListAnalysisCategory_log | Diversity Workbench User | • | TABLE | |||
| TaxonNameListAnalysisCategoryValue | Diversity Workbench User | • | • | TABLE | ||
| TaxonNameListAnalysisCategoryValue_log | Diversity Workbench User | • | TABLE | |||
| TaxonNameListArea | Diversity Workbench User | • | • | • | TABLE | |
| TaxonNameListArea_log | Diversity Workbench User | • | TABLE | |||
| TaxonNameListCollectionSpecimen | Diversity Workbench User | • | • | • | TABLE | |
| TaxonNameListCollectionSpecimen_log | TABLE | |||||
| TaxonNameListDistribution | Diversity Workbench User | • | • | • | TABLE | |
| TaxonNameListDistribution_log | Diversity Workbench User | • | TABLE | |||
| TaxonNameListImage | TABLE | |||||
| TaxonNameListImage_log | TABLE | |||||
| TaxonNameListProjectProxy | Diversity Workbench User | TABLE | ||||
| TaxonNameListReference | Diversity Workbench User | • | • | • | TABLE | |
| TaxonNameListReference_log | Diversity Workbench User | • | TABLE | |||
| TaxonNameListReferenceType_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameListSpecimenRole_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameListUser | Diversity Workbench User | TABLE | ||||
| TaxonNameNomenclaturalCode_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameNomenclaturalStatus_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameProject | Diversity Workbench User | • | TABLE | |||
| TaxonNameProject_log | • | • | TABLE | |||
| TaxonNameReference | Diversity Workbench User | • | • | TABLE | ||
| TaxonNameReference_log | • | • | TABLE | |||
| TaxonNameResource | Diversity Workbench User | • | • | • | TABLE | |
| TaxonNameResource_log | Diversity Workbench User | • | TABLE | |||
| TaxonNameResourceType_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameRevisionLevel_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameSynonymisationType_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameTaxonomicRank_Enum | Diversity Workbench User | TABLE | ||||
| TaxonNameTypification | • | • | • | • | TABLE | |
| TaxonNameTypification_log | Diversity Workbench User | • | TABLE | |||
| TaxonSynonymy | Diversity Workbench User | • | • | • | TABLE | |
| TaxonSynonymy_log | • | • | TABLE | |||
| UserProxy | Diversity Workbench User | Diversity Workbench User | TABLE | |||
| AcceptedNameChanges | Diversity Workbench User | VIEW | ||||
| ApplicationSearchSelectionStrings_Core | Diversity Workbench User | VIEW | ||||
| GenusList | VIEW | |||||
| NameID_UserAvailable | Diversity Workbench User | VIEW | ||||
| ProjectList | Diversity Workbench User | VIEW | ||||
| TaxonAcceptedName_Core | Diversity Workbench User | • | • | • | VIEW | |
| TaxonAcceptedName_Indicated | Diversity Workbench User | VIEW | ||||
| TaxonAcceptedNameList | Diversity Workbench User | VIEW | ||||
| TaxonAcceptedNameListIncludeIgnored | Diversity Workbench User | VIEW | ||||
| TaxonFamily | Diversity Workbench User | VIEW | ||||
| TaxonGeography_Core | Diversity Workbench User | • | • | • | VIEW | |
| TaxonHierarchy_Core | Diversity Workbench User | • | • | • | VIEW | |
| TaxonListSynType | Diversity Workbench User | VIEW | ||||
| TaxonName_Core | Diversity Workbench User | • | • | VIEW | ||
| TaxonName_Indicated | Diversity Workbench User | • | • | VIEW | ||
| TaxonNameExternalID_Core | Diversity Workbench User | VIEW | ||||
| TaxonOrder | Diversity Workbench User | VIEW | ||||
| TaxonSynonymy_Core | Diversity Workbench User | • | • | • | VIEW | |
| TaxonSynonymy_Indicated | Diversity Workbench User | VIEW | ||||
| TaxonSynonymyAcceptedNameID | Diversity Workbench User | VIEW | ||||
| TaxonSynonymyList | Diversity Workbench User | VIEW | ||||
| TaxonSynonymyListIncludeIgnored | Diversity Workbench User | VIEW | ||||
| ViewBaseURL | Diversity Workbench User | VIEW | ||||
| ViewDefaultProjectID | Diversity Workbench User | VIEW | ||||
| ViewDiversityWorkbenchModule | Diversity Workbench User | VIEW | ||||
| ViewTaxonNameResource | Diversity Workbench User | • | • | • | VIEW | |
| AcceptedNameID | Diversity Workbench User | FUNCTION | ||||
| AnalysisCategoryHierarchyAll | Diversity Workbench User | FUNCTION | ||||
| BaseURL | Diversity Workbench User | FUNCTION | ||||
| DefaultProjectID | Diversity Workbench User | FUNCTION | ||||
| DiversityMobile_TaxonList | Diversity Workbench User | FUNCTION | ||||
| DiversityWorkbenchModule | Diversity Workbench User | FUNCTION | ||||
| HierarchyCache | • | FUNCTION | ||||
| HierarchyFamilyList | Diversity Workbench User | FUNCTION | ||||
| HierarchyList | Diversity Workbench User | FUNCTION | ||||
| HierarchyOrderList | Diversity Workbench User | FUNCTION | ||||
| HierarchySuperiorList | Diversity Workbench User | FUNCTION | ||||
| NameList | Diversity Workbench User | FUNCTION | ||||
| NextNameID | • | FUNCTION | ||||
| PrivacyConsentInfo | Diversity Workbench User | FUNCTION | ||||
| SynonymyList | Diversity Workbench User | FUNCTION | ||||
| SynonymyListIncludeIgnored | Diversity Workbench User | FUNCTION | ||||
| TaxonChildNodes | Diversity Workbench User | FUNCTION | ||||
| TaxonListLastUpdate | Diversity Workbench User | FUNCTION | ||||
| TaxonListsForUser | Diversity Workbench User | FUNCTION | ||||
| TaxonListsLastUpdate | Diversity Workbench User | FUNCTION | ||||
| TaxonNameCache | Diversity Workbench User | FUNCTION | ||||
| TaxonNameCacheSinAut | Diversity Workbench User | FUNCTION | ||||
| TaxonNameListAnalysisCategoryChildNodes | Diversity Workbench User | FUNCTION | ||||
| TaxonNameListAnalysisCategoryHierarchy | Diversity Workbench User | FUNCTION | ||||
| TaxonNameListUserNameID | Diversity Workbench User | FUNCTION | ||||
| UserID | Diversity Workbench User | FUNCTION | ||||
| Version | Diversity Workbench User | FUNCTION | ||||
| VersionClient | Diversity Workbench User | FUNCTION | ||||
| procFillSynonymyListCache | • | PROCEDURE | ||||
| procHierarchyCache | • | PROCEDURE | ||||
| procSetVersionTaxonName | PROCEDURE | |||||
| procTaxonNameInsertCopy | • | PROCEDURE | ||||
| procTaxonNameInsertNew_3 | • | PROCEDURE | ||||
| procTaxonNameListInsertCopy | • | PROCEDURE | ||||
| procTaxonNameListInsertReferenceCopy | • | PROCEDURE | ||||
| SetUserProjects | PROCEDURE |
Inheriting from roles:
| Permissions | SELECT | INSERT | UPDATE | DELETE | EXECUTE | Type |
|---|---|---|---|---|---|---|
| ApplicationSearchSelectionStrings | TABLE | |||||
| CountryCode_Enum | TABLE | |||||
| LanguageCode_Enum | TABLE | |||||
| ProjectProxy | TABLE | |||||
| ProjectUser | TABLE | |||||
| ReplicationPublisher | TABLE | |||||
| SynonymyListCache | TABLE | |||||
| TaxonAcceptedName | TABLE | |||||
| TaxonAcceptedName_log | TABLE | |||||
| TaxonCommonName | TABLE | |||||
| TaxonCommonName_log | TABLE | |||||
| TaxonGeography | TABLE | |||||
| TaxonGeography_log | TABLE | |||||
| TaxonHierarchy | TABLE | |||||
| TaxonHierarchy_log | TABLE | |||||
| TaxonName | TABLE | |||||
| TaxonName_log | TABLE | |||||
| TaxonNameCreationType_Enum | TABLE | |||||
| TaxonNameExternalDatabase | TABLE | |||||
| TaxonNameExternalDatabase_log | TABLE | |||||
| TaxonNameExternalID | TABLE | |||||
| TaxonNameExternalID_log | TABLE | |||||
| TaxonNameList | TABLE | |||||
| TaxonNameList_log | TABLE | |||||
| TaxonNameListAnalysis | TABLE | |||||
| TaxonNameListAnalysis_log | TABLE | |||||
| TaxonNameListAnalysisCategory | TABLE | |||||
| TaxonNameListAnalysisCategory_log | TABLE | |||||
| TaxonNameListAnalysisCategoryValue | TABLE | |||||
| TaxonNameListAnalysisCategoryValue_log | TABLE | |||||
| TaxonNameListArea | TABLE | |||||
| TaxonNameListArea_log | TABLE | |||||
| TaxonNameListCollectionSpecimen | TABLE | |||||
| TaxonNameListCollectionSpecimen_log | TABLE | |||||
| TaxonNameListDistribution | TABLE | |||||
| TaxonNameListDistribution_log | TABLE | |||||
| TaxonNameListImage | TABLE | |||||
| TaxonNameListImage_log | TABLE | |||||
| TaxonNameListProjectProxy | TABLE | |||||
| TaxonNameListReference | TABLE | |||||
| TaxonNameListReference_log | TABLE | |||||
| TaxonNameListReferenceType_Enum | TABLE | |||||
| TaxonNameListSpecimenRole_Enum | TABLE | |||||
| TaxonNameListUser | TABLE | |||||
| TaxonNameNomenclaturalCode_Enum | TABLE | |||||
| TaxonNameNomenclaturalStatus_Enum | TABLE | |||||
| TaxonNameProject | • | TABLE | ||||
| TaxonNameProject_log | TABLE | |||||
| TaxonNameReference | TABLE | |||||
| TaxonNameReference_log | TABLE | |||||
| TaxonNameResource | TABLE | |||||
| TaxonNameResource_log | TABLE | |||||
| TaxonNameResourceType_Enum | TABLE | |||||
| TaxonNameRevisionLevel_Enum | TABLE | |||||
| TaxonNameSynonymisationType_Enum | TABLE | |||||
| TaxonNameTaxonomicRank_Enum | TABLE | |||||
| TaxonNameTypification | TABLE | |||||
| TaxonNameTypification_log | TABLE | |||||
| TaxonSynonymy | TABLE | |||||
| TaxonSynonymy_log | TABLE | |||||
| UserProxy | TABLE | |||||
| AcceptedNameChanges | VIEW | |||||
| ApplicationSearchSelectionStrings_Core | VIEW | |||||
| GenusList | VIEW | |||||
| NameID_UserAvailable | VIEW | |||||
| ProjectList | VIEW | |||||
| TaxonAcceptedName_Core | VIEW | |||||
| TaxonAcceptedName_Indicated | VIEW | |||||
| TaxonAcceptedNameList | VIEW | |||||
| TaxonAcceptedNameListIncludeIgnored | VIEW | |||||
| TaxonFamily | VIEW | |||||
| TaxonGeography_Core | VIEW | |||||
| TaxonHierarchy_Core | VIEW | |||||
| TaxonListSynType | VIEW | |||||
| TaxonName_Core | VIEW | |||||
| TaxonName_Indicated | VIEW | |||||
| TaxonNameExternalID_Core | VIEW | |||||
| TaxonOrder | VIEW | |||||
| TaxonSynonymy_Core | VIEW | |||||
| TaxonSynonymy_Indicated | VIEW | |||||
| TaxonSynonymyAcceptedNameID | VIEW | |||||
| TaxonSynonymyList | VIEW | |||||
| TaxonSynonymyListIncludeIgnored | VIEW | |||||
| ViewBaseURL | VIEW | |||||
| ViewDefaultProjectID | VIEW | |||||
| ViewDiversityWorkbenchModule | VIEW | |||||
| ViewTaxonNameResource | VIEW | |||||
| AcceptedNameID | FUNCTION | |||||
| AnalysisCategoryHierarchyAll | FUNCTION | |||||
| BaseURL | FUNCTION | |||||
| DefaultProjectID | FUNCTION | |||||
| DiversityMobile_TaxonList | FUNCTION | |||||
| DiversityWorkbenchModule | FUNCTION | |||||
| HierarchyCache | FUNCTION | |||||
| HierarchyFamilyList | FUNCTION | |||||
| HierarchyList | FUNCTION | |||||
| HierarchyOrderList | FUNCTION | |||||
| HierarchySuperiorList | FUNCTION | |||||
| NameList | FUNCTION | |||||
| NextNameID | FUNCTION | |||||
| PrivacyConsentInfo | FUNCTION | |||||
| SynonymyList | FUNCTION | |||||
| SynonymyListIncludeIgnored | FUNCTION | |||||
| TaxonChildNodes | FUNCTION | |||||
| TaxonListLastUpdate | FUNCTION | |||||
| TaxonListsForUser | FUNCTION | |||||
| TaxonListsLastUpdate | FUNCTION | |||||
| TaxonNameCache | FUNCTION | |||||
| TaxonNameCacheSinAut | FUNCTION | |||||
| TaxonNameListAnalysisCategoryChildNodes | FUNCTION | |||||
| TaxonNameListAnalysisCategoryHierarchy | FUNCTION | |||||
| TaxonNameListUserNameID | FUNCTION | |||||
| UserID | FUNCTION | |||||
| Version | FUNCTION | |||||
| VersionClient | FUNCTION | |||||
| procFillSynonymyListCache | PROCEDURE | |||||
| procHierarchyCache | PROCEDURE | |||||
| procSetVersionTaxonName | PROCEDURE | |||||
| procTaxonNameInsertCopy | PROCEDURE | |||||
| procTaxonNameInsertNew_3 | PROCEDURE | |||||
| procTaxonNameListInsertCopy | PROCEDURE | |||||
| procTaxonNameListInsertReferenceCopy | PROCEDURE | |||||
| SetUserProjects | PROCEDURE |
| Permissions | SELECT | INSERT | UPDATE | DELETE | EXECUTE | Type |
|---|---|---|---|---|---|---|
| ApplicationSearchSelectionStrings | • | TABLE | ||||
| CountryCode_Enum | • | TABLE | ||||
| LanguageCode_Enum | • | TABLE | ||||
| ProjectProxy | • | TABLE | ||||
| ProjectUser | • | TABLE | ||||
| ReplicationPublisher | TABLE | |||||
| SynonymyListCache | • | TABLE | ||||
| TaxonAcceptedName | • | TABLE | ||||
| TaxonAcceptedName_log | TABLE | |||||
| TaxonCommonName | • | TABLE | ||||
| TaxonCommonName_log | TABLE | |||||
| TaxonGeography | • | TABLE | ||||
| TaxonGeography_log | TABLE | |||||
| TaxonHierarchy | • | TABLE | ||||
| TaxonHierarchy_log | TABLE | |||||
| TaxonName | • | TABLE | ||||
| TaxonName_log | TABLE | |||||
| TaxonNameCreationType_Enum | • | TABLE | ||||
| TaxonNameExternalDatabase | • | TABLE | ||||
| TaxonNameExternalDatabase_log | TABLE | |||||
| TaxonNameExternalID | • | TABLE | ||||
| TaxonNameExternalID_log | TABLE | |||||
| TaxonNameList | • | TABLE | ||||
| TaxonNameList_log | • | TABLE | ||||
| TaxonNameListAnalysis | • | TABLE | ||||
| TaxonNameListAnalysis_log | • | TABLE | ||||
| TaxonNameListAnalysisCategory | • | TABLE | ||||
| TaxonNameListAnalysisCategory_log | • | TABLE | ||||
| TaxonNameListAnalysisCategoryValue | • | TABLE | ||||
| TaxonNameListAnalysisCategoryValue_log | • | TABLE | ||||
| TaxonNameListArea | • | TABLE | ||||
| TaxonNameListArea_log | • | TABLE | ||||
| TaxonNameListCollectionSpecimen | • | TABLE | ||||
| TaxonNameListCollectionSpecimen_log | TABLE | |||||
| TaxonNameListDistribution | • | TABLE | ||||
| TaxonNameListDistribution_log | • | TABLE | ||||
| TaxonNameListImage | TABLE | |||||
| TaxonNameListImage_log | TABLE | |||||
| TaxonNameListProjectProxy | • | TABLE | ||||
| TaxonNameListReference | • | TABLE | ||||
| TaxonNameListReference_log | • | TABLE | ||||
| TaxonNameListReferenceType_Enum | • | TABLE | ||||
| TaxonNameListSpecimenRole_Enum | • | TABLE | ||||
| TaxonNameListUser | • | TABLE | ||||
| TaxonNameNomenclaturalCode_Enum | • | TABLE | ||||
| TaxonNameNomenclaturalStatus_Enum | • | TABLE | ||||
| TaxonNameProject | • | TABLE | ||||
| TaxonNameProject_log | TABLE | |||||
| TaxonNameReference | • | TABLE | ||||
| TaxonNameReference_log | TABLE | |||||
| TaxonNameResource | • | TABLE | ||||
| TaxonNameResource_log | • | TABLE | ||||
| TaxonNameResourceType_Enum | • | TABLE | ||||
| TaxonNameRevisionLevel_Enum | • | TABLE | ||||
| TaxonNameSynonymisationType_Enum | • | TABLE | ||||
| TaxonNameTaxonomicRank_Enum | • | TABLE | ||||
| TaxonNameTypification | • | TABLE | ||||
| TaxonNameTypification_log | • | TABLE | ||||
| TaxonSynonymy | • | TABLE | ||||
| TaxonSynonymy_log | TABLE | |||||
| UserProxy | • | • | TABLE | |||
| AcceptedNameChanges | • | VIEW | ||||
| ApplicationSearchSelectionStrings_Core | • | VIEW | ||||
| GenusList | VIEW | |||||
| NameID_UserAvailable | • | VIEW | ||||
| ProjectList | • | VIEW | ||||
| TaxonAcceptedName_Core | • | VIEW | ||||
| TaxonAcceptedName_Indicated | • | VIEW | ||||
| TaxonAcceptedNameList | • | VIEW | ||||
| TaxonAcceptedNameListIncludeIgnored | • | VIEW | ||||
| TaxonFamily | • | VIEW | ||||
| TaxonGeography_Core | • | VIEW | ||||
| TaxonHierarchy_Core | • | VIEW | ||||
| TaxonListSynType | • | VIEW | ||||
| TaxonName_Core | • | VIEW | ||||
| TaxonName_Indicated | • | VIEW | ||||
| TaxonNameExternalID_Core | • | VIEW | ||||
| TaxonOrder | • | VIEW | ||||
| TaxonSynonymy_Core | • | VIEW | ||||
| TaxonSynonymy_Indicated | • | VIEW | ||||
| TaxonSynonymyAcceptedNameID | • | VIEW | ||||
| TaxonSynonymyList | • | VIEW | ||||
| TaxonSynonymyListIncludeIgnored | • | VIEW | ||||
| ViewBaseURL | • | VIEW | ||||
| ViewDefaultProjectID | • | VIEW | ||||
| ViewDiversityWorkbenchModule | • | VIEW | ||||
| ViewTaxonNameResource | • | VIEW | ||||
| AcceptedNameID | • | FUNCTION | ||||
| AnalysisCategoryHierarchyAll | • | FUNCTION | ||||
| BaseURL | • | FUNCTION | ||||
| DefaultProjectID | • | FUNCTION | ||||
| DiversityMobile_TaxonList | • | FUNCTION | ||||
| DiversityWorkbenchModule | • | FUNCTION | ||||
| HierarchyCache | FUNCTION | |||||
| HierarchyFamilyList | • | FUNCTION | ||||
| HierarchyList | • | FUNCTION | ||||
| HierarchyOrderList | • | FUNCTION | ||||
| HierarchySuperiorList | • | FUNCTION | ||||
| NameList | • | FUNCTION | ||||
| NextNameID | FUNCTION | |||||
| PrivacyConsentInfo | • | FUNCTION | ||||
| SynonymyList | • | FUNCTION | ||||
| SynonymyListIncludeIgnored | • | FUNCTION | ||||
| TaxonChildNodes | • | FUNCTION | ||||
| TaxonListLastUpdate | • | FUNCTION | ||||
| TaxonListsForUser | • | FUNCTION | ||||
| TaxonListsLastUpdate | • | FUNCTION | ||||
| TaxonNameCache | • | FUNCTION | ||||
| TaxonNameCacheSinAut | • | FUNCTION | ||||
| TaxonNameListAnalysisCategoryChildNodes | • | FUNCTION | ||||
| TaxonNameListAnalysisCategoryHierarchy | • | FUNCTION | ||||
| TaxonNameListUserNameID | • | FUNCTION | ||||
| UserID | • | FUNCTION | ||||
| Version | • | FUNCTION | ||||
| VersionClient | • | FUNCTION | ||||
| procFillSynonymyListCache | PROCEDURE | |||||
| procHierarchyCache | PROCEDURE | |||||
| procSetVersionTaxonName | PROCEDURE | |||||
| procTaxonNameInsertCopy | PROCEDURE | |||||
| procTaxonNameInsertNew_3 | PROCEDURE | |||||
| procTaxonNameListInsertCopy | PROCEDURE | |||||
| procTaxonNameListInsertReferenceCopy | PROCEDURE | |||||
| SetUserProjects | PROCEDURE |