Diversity Collection Cache

FUNCTIONS and PROCEDURES

The following objects are not included:

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

FUNCTIONS


Function BaseURLofSource

The URL of the source database as defined in the source database, e.g. http://tnt.diversityworkbench.de/collection

DataType: nvarchar (500)


Function DiversityWorkbenchModule

DataType: nvarchar (50)


Function HighResolutionImagePath

This function translates the path of an image into the corresponding path of a web resource with of high resolution version of the image. Currently only valid for installations on the SNSB-Server. May be changed to adapt to other installations

DataType: nvarchar (500)


Function ProjectsDatabase

The name of the DiversityProjects database where the project definition are found

DataType: nvarchar (255)


Function ServerURL

The URL of the server where the database is installed

DataType: nvarchar (255)


Function SourceDatabase

The name of the source database, e.g. DiversityCollection

DataType: nvarchar (255)


Function SourceDatabaseTrunk

The name of the source database without the leading “Diversity”, e.g. Collection

DataType: nvarchar (255)


Function Version

DataType: nvarchar (8)


PROCEDURES


Procedure procBcpExport


Procedure procBcpInitExport


Procedure procBcpRemoveFile


Procedure procBcpViewCreate


Procedure procProjectName


Procedure procTaxonNameHierarchy


Procedure procTransferAgent


Procedure procTransferAgentContactInformation


Procedure procTransferGazetteer


Procedure procTransferReferenceTitle


Procedure procTransferScientificTerm


Procedure procTransferTaxonSynonymy


Procedure procUnitIDforABCD