Overview DWB environment at SMNS

Server

Name
smns.diversityworkbench.de
MS SQL Server
2014 R2 (4x core2x licenses) = 8 virtual cores
Catalogues
Taxonomic Catalogues

Accounts

DWB
dbo_smns

Identifier am SMNS - was kommt wohin in DC?

FIXME

Grobe Einteilung: Informationen zu dem Specimen in einer anderen Datenbank: Relation

Identifier, den der Specimen sonst noch hat: External ID

Bewegung des gesamten Specimens: Transactions

  • NCBI/Genbank/BOLD Nummern ⇒ External Relations
  • Verlinkung zwischen den Abteilungen (Sektionen und Biobank) ⇒ Internal Relations (dazu im Import Wizard „Relation 1“ auswählen, IsInternalRelationCache anhaken und bei „For all“ das Kästchen leer lassen m()
  • Nummer aus einer früheren Sammlung ⇒ Despositors Accession. No. (Dep.No.)
  • mögliche External IDs (Stand 10. Juni 2020):
  • 2D Barcode (Biobank)
  • DOI
  • Extraction ID (Biobank)
  • Field No (specimen ID) (Number assigned to a specimen or a batch of specimens by the collector during the collection event)
  • IPEN Nummer (Number of the International Plant Exchange Network)
  • LSID (Life Science Identifiers)
  • Morph Voucher Number (The catalogue number of the morphological voucher in the collection, e.g. ZFMK-DIP-1234)
  • NCBI GBA (NCBI GenBankAccessionnumber - https://www.ncbi.nlm.nih.gov/nuccore/)
  • Ornithology Archive Number (Number used by section Ornithology)
  • Other Number (unspecified number)
  • other ZFMK Number (other used or former collection number for the same object (probably published))
  • Previous ID
  • Ring Number (A ring number for bird or bats)
  • Tissue Sample (Myriapoda)
  • UUID (Universally Unique Identifier)
  • ZFMK Document No. (Document number refering to permits stored in ZFMKs administration office)
  • Nagoya Protocol Dokumente ⇒ Transactions (wird gerade von Peter und Laura entwickelt)