Diversity Scientific Terms

TABLES, VIEWS, FUNCTIONS, PROCEDURES, ROLES

The following objects are not included:

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

TABLES

Table Section

A section of terms within a scientific terminology, e.g. the terms of a certain geographic area extracted from a terminology

Depending on:

• Terminology

Dependent tables:

• SectionTerm

Table SectionTerm

A term within a section of terms within a scientific terminology, e.g. the terms of a certain geographic area extracted from a terminology

Depending on:

• Section
• Term

Table Term

The scientific term within a scientific terminology, e.g. the name of a soil in soil sciences or the name of a mineral in mineralogy

Depending on:

• Terminology

Dependent tables:

• SectionTerm
• TermDependency
• TermProperty
• TermRepresentation

Table TermDependency

Dependency within terms

Depending on:

• Term

Table Terminology

A terminology used in a certain scientifc area, e.g. mineralogy, soil sciences, paleontology, stratigraphy

Depending on:

• LanguageCode_Enum

Dependent tables:

• Section
• Term
• TerminologyProperty
• TerminologyReference
• TerminologyUser

Table TerminologyProperty

Properties of scientific terms in a certain terminology, e.g. the specific weight of a mineral in mineralogy

Depending on:

• Terminology
• TerminologyPropertyDataType_Enum

Dependent tables:

• TerminologyPropertyValue
• TermProperty

Table TerminologyPropertyValue

Dedicated property values of a certain property of a scientific term

Depending on:

• TerminologyProperty

Table TerminologyReference

A TerminologyReference used in a certain scientifc area, e.g. mineralogy, soil sciences, paleontology, stratigraphy

Depending on:

• Terminology

Table TerminologyUser

Users with access to a terminology

Depending on:

• Terminology
• UserProxy

Table TermProperty

The property of a scientific term, e.g. the specific weight of a certain mineral in mineralogy

Depending on:

• Term
• TerminologyProperty

Table TermReference

A reference for a term used in a certain scientific area, e.g. mineralogy, soil sciences, paleontology, stratigraphy

Depending on:

• TermRepresentation

Table TermRepresentation

The representation of a scientific term within a scientific terminology in a certain language, e.g. the name of a soil in soil sciences in English or German

Depending on:

• LanguageCode_Enum
• Term

Dependent tables:

• TermReference
• TermResource

trgInsTermRepresentation

Table TermResource

A resource connected to the scientific term, e.g. a picture, video etc.

Depending on:

• TermRepresentation

VIEWS

View ProjectUser

Interface for handling Terminology as Project

Depending on:

• TerminologyUser

View TerminologyID_UserAvailable

The terminologies a user has access to

Depending on:

• Terminology
• TerminologyUser

View View_SectionTerm

Content of table SectionTerm for query

Depending on:

• Section
• SectionTerm
• TermRepresentation

View View_TermProperty

Providing content of table TermProperty including combined column DisplayText for query

Depending on:

• TermProperty
• TermRepresentation

View View_TermRanking

Combines ranking type of the term with hierarchy

Depending on:

• Term
• TermRepresentation

View View_TermRankingHierarchy

Providing content of table TermRepresentation including hierarchy of ranking terms combined with column DisplayText for query

Depending on:

• Term
• TermRepresentation

View View_TermReference

Providing content of table TermReference for query

Depending on:

• TermReference
• TermRepresentation

View View_TermResource

Providing content of table TermResource for query

Depending on:

• TermRepresentation
• TermResource

View ViewBaseURL

View for access via linked server

Depending on:

• BaseURL

View ViewDiversityWorkbenchModule

View for access via linked server

Depending on:

• DiversityWorkbenchModule

View ViewTermResource

View excluding XML column to provide access via linked server

Depending on:

• TermResource

FUNCTIONS

Function BaseURL

Provides the basic address for accessing the database

DataType: varchar (255)

Function DiversityMobile_Terminology

For Application DiversityMobile: Content of a Terminology

Depending on:

• BaseURL
• Term
• TermRepresentation

Function DiversityMobile_TermsList

Returns the scientific terms of a terminology

Depending on:

• BaseURL
• Term
• TermRepresentation

Function DiversityMobile_TermsListsForUser

Returns the datasources for the scientific terms lists for a user

Depending on:

• Terminology
• TerminologyUser

Function DiversityWorkbenchModule

Returns name of Module: DiversityScientificTerms

DataType: nvarchar (50)

Function PrivacyConsentInfo

Providing common information about the storage and processing of personal data within the DiversityWorkbench

DataType: varchar (900)

Function TermChildNodes

Children of a given term

Depending on:

• Term
• TermChildNodes

Function TermHierarchy

Hierarchy for a given term

Depending on:

• Term
• TermChildNodes
• TermRepresentation

Function TerminologyDataLastChanges

Returns the data of the last changes for a given TerminologyID

DataType: datetime

Depending on:

• TermProperty
• TermReference
• TermRepresentation
• TermRepresentation_log
• TermResource

Function TerminologySize

Returns the number of datasets within a terminology e.g. to check if a direct creation of the hierarchy if feasible

DataType: int

Depending on:

• TermRepresentation

Function TermSuperiorNodes

Superior datasets for a term

Depending on:

• Term
• TermRepresentation

Function UserID

Providing the ID of the current user from UserProxy

DataType: int

Depending on:

• UserProxy

Function UserName

Providing the name of the user from UserProxy

DataType: nvarchar (50)

Depending on:

• UserProxy

Function Version

The version of the database

DataType: nvarchar (8)

Function VersionClient

The version of the client application compatible with the database

DataType: nvarchar (11)

PROCEDURES

Procedure procInsertTermCopy

Copy a dataset of table Term and depending data in tables TermRepresentation and TermProperty

Depending on:

• Term
• TermProperty
• TermRepresentation

Procedure procRefreshHierarchyCache

Refreshing the content in the columns HierarchyCache and HierarchyCacheDown in table TermRepresentation according to the hierarchy as stored in table Term

Depending on:

• Term
• TermRepresentation

Procedure SetUserProjects

Create database user and assign training projects

Depending on:

• UserProxy

ROLES

Role DiversityWorkbenchAdministrator

Role for the administration of the database

• DiversityWorkbenchEditor

Role DiversityWorkbenchEditor

Role for editing the data

• DiversityWorkbenchUser

Role DiversityWorkbenchTypist

Role with restricted access for editing the data

• DiversityWorkbenchUser

Role DiversityWorkbenchUser

Role with readonly access to the data

Diversity Scientific Terms

Enumeration tables

The following objects are not included:

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

Table

Table LanguageCode_Enum

The Code of a language according to ISO

Dependent tables:

• Terminology
• TermRepresentation

Table TerminologyPropertyDataType_Enum

Datatypes of a property of a terminology

Dependent tables:

• TerminologyProperty

Diversity Scientific Terms

No-SQL Interface

JSON Cache

Databases of the modules provid a No-SQL interface where the data of the main table and the depending tables are merged as JSON.

Table JsonCache

Content of table JsonCache restricted to public available data

procFillJsonCache is started by an update trigger trgUpd… of the main table in the database

Interface in clients

All modules provide data via a cache table. In the header of the clients you can inspect the content of the JsonCache with a click on the button. For modules with a difference between local and public data, you can inspect the content of the public data with a click of the right mouse button.

Update

Apart of the update via the Trigger (see below) you can update the JsonCache via the update button underneath the button.

To update the JsonCache for the whole database select Administration - JsonCache… from the menu. a window as shown below will open where you can update the JsonCache for single datasets or the whole database.

Summary

graph TD;
    TaxonName[Main table in database] 
    trgUpdTaxonName[trgUpd.. of main table in database]
    TaxonName --> |Update in table| trgUpdTaxonName
    proc[Procedure procFillJsonCache setting the content in table JsonCache]
    trgUpdTaxonName --> proc

graph TD;    
    Mainform[Main form]
    ButtonShow[Button show JsonCache of current dataset]
    Mainform --> ButtonShow
    Left[Show Data]
    ButtonShow --> |Left click| Left

graph TD;    
    Mainform[Main form]
    Admin[Administration menu]
    Mainform --> Admin
    Cache[JsonCache...]
    Admin --> Cache
    Adminform[Administration form]
    Cache --> Adminform
    AdminUpdateSingle[Update single dataset]
    Adminform --> AdminUpdateSingle
    AdminUpdateDB[Update for whole database] 
    Adminform --> AdminUpdateDB