API

JsonCache

classDiagram
    class JsonCache {
        ID int
        DisplayText nvarchar 500
        LogUpdatedWhen datetime
        Data JSON
    }

This table is filled by stored procedure procFillJsonCache.

procFillJsonCache is started by trigger trgUpdTaxonName in table TaxonName

---
title: JsonCache
---
graph TD;
    TaxonName[TaxonName] -->|Update in table| trgUpdTaxonName(trgUpdTaxonName)
    trgUpdTaxonName --> procFillJsonCache(procFillJsonCache)
    procFillJsonCache -->JsonCache[table JsonCache]
    JsonCache --> JsonCache_Checklist[view JsonCache_Checklist]
    JsonCache --> JsonCache_Project[view JsonCache_Project]

Views

Views provide a selection of the JsonCache table restricted

JsonCache_Project

Data of table JsonCache linked to project

classDiagram
    class JsonCache_Project {
        ID int
        DisplayText nvarchar 500
        LogUpdatedWhen datetime
        Data JSON
        Project nvarchar 50
    }

JsonCache_Checklist

Data of table JsonCache linked to checklist

classDiagram
    class JsonCache_Checklist {
        ID int
        DisplayText nvarchar 500
        LogUpdatedWhen datetime
        Data JSON
        Checklist nvarchar 50
    }

Expamples

Containing analysis data:

[
  {
    "type": "Taxon",
    "id": 4403768,
    "attributes": {
      "FullName": "Anthrenus verbasci (Linnaeus, 1767)",
      "Rank": "sp.",
      "GenusOrSupragenericName": "Anthrenus",
      "SpeciesEpithet": "verbasci ",
      "Authors": "Linnaeus",
      "Publication": "",
      "Project": [ { "Project": "SNSBnames" } ],
      "Checklist": {
        "Analysis": [
          {
            "Checklist": "TaxRef_SNSB_NHC-Pests",
            "Analysis": "adult"
          },
          {
            "Checklist": "TaxRef_SNSB_NHC-Pests",
            "Analysis": "larva"
          },
          {
            "Checklist": "TaxRef_SNSB_NHC-Pests",
            "Analysis": "natural specimen itself",
            "Value": "present"
          },
          {
            "Checklist": "TaxRef_SNSB_NHC-Pests",
            "Analysis": "artifact",
            "Value": "present"
          },
          {
            "Checklist": "TaxRef_SNSB_NHC-Pests",
            "Analysis": "botanical Collections",
            "Value": "present"
          }
        ],
        "Distribution": [
          {
            "Checklist": "TaxRef_SNSB_NHC-Pests",
            "Place": "Europe"
          }
        ]
      },
      "Synonymy": [
        {
          "id": 4403768,
          "FullName": "Anthrenus verbasci (Linnaeus, 1767)",
          "Name": "Anthrenus verbasci ",
          "Type": "accepted name"
        }
      ],
      "Hierarchy": [
        {
          "id": 4403768,
          "FullName": "Anthrenus verbasci (Linnaeus, 1767)",
          "Name": "Anthrenus verbasci ",
          "Rank": "sp."
        },
        {
          "id": 4403933,
          "FullName": "Anthrenus Geoffroy, 1762",
          "Name": "Anthrenus",
          "Rank": "gen."
        },
        {
          "id": 4403854,
          "FullName": "Dermestidae",
          "Name": "Dermestidae",
          "Rank": "fam."
        },
        {
          "id": 4403769,
          "FullName": "Coleoptera Linneaus, 1758",
          "Name": "Coleoptera",
          "Rank": "ord."
        },
        {
          "id": 4403937,
          "FullName": "Insecta Linnaeus, 1758",
          "Name": "Insecta",
          "Rank": "cl."
        },
        {
          "id": 4403934,
          "FullName": "Arthropoda Gravenhorst, 1843",
          "Name": "Arthropoda",
          "Rank": "phyl.\/div."
        },
        {
          "id": 4403805,
          "FullName": "Animalia Linnaeus, 1758",
          "Name": "Animalia",
          "Rank": "reg."
        }
      ],
      "CommonNames": [
        {
          "CommonName": "varied carpet beetle",
          "LanguageCode": "en",
          "CountryCode": "GB"
        },
        {
          "CommonName": "Wollkrautblütenkäfer",
          "LanguageCode": "de",
          "CountryCode": "DE"
        }
      ],
      "Resource": [
        {
          "URI": "https:\/\/pictures.snsb.info\/IPM\/Wollkrautbluetenkaefer.png",
          "Title": "adult",
          "Type": "preview"
        },
        {
          "URI": "https:\/\/pictures.snsb.info\/IPM\/Wollkrautbluetenkaefer_Larve.png",
          "Title": "larva",
          "Type": "preview"
        },
        {
          "URI": "https:\/\/upload.wikimedia.org\/wikipedia\/commons\/0\/04\/Anthrenus_verbasci_-_larva_side_%28aka%29.jpg",
          "Title": "Wollkrautblütenkäfer (Anthrenus verbasci)",
          "Type": "image"
        },
        {
          "URI": "https:\/\/upload.wikimedia.org\/wikipedia\/commons\/thumb\/6\/64\/Anthrenus.verbasci.7060.jpg\/1280px-Anthrenus.verbasci.7060.jpg",
          "Title": "Wollkrautblütenkäfer (Anthrenus verbasci)",
          "Type": "image"
        },
        {
          "URI": "https:\/\/upload.wikimedia.org\/wikipedia\/commons\/thumb\/c\/c0\/Anthrenus_verbasci_%28Linn%C3%A9%2C_1767%29_%2827853635822%29.png\/697px-Anthrenus_verbasci_%28Linn%C3%A9%2C_1767%29_%2827853635822%29.png",
          "Title": "Wollkrautblütenkäfer (Anthrenus verbasci)",
          "Type": "image"
        },
        {
          "URI": "https:\/\/www.dsvonline.de\/fileadmin\/dsv\/docs\/pest-index\/wollkrautbluetenkaefer.pdf",
          "Title": "Deutscher Schädlingsbekämpfer Verband e.V.: Wollkrautblütenkäfer (Anthrenus verbasci)",
          "Type": "information"
        }
      ]
    }
  }
]

Containing synonymy data:

[
  {
    "type": "Taxon",
    "id": 4404053,
    "attributes": {
      "FullName": "Stachybotrys lobulata Berk.",
      "Rank": "sp.",
      "GenusOrSupragenericName": "Stachybotrys",
      "SpeciesEpithet": "lobulata",
      "Authors": "Berk.",
      "Publication": "",
      "Project": [ { "Project": "SNSBnames" } ],
      "Synonymy": [
        {
          "id": 4404055,
          "FullName": "Stachybotrys chartarum (Ehrenb.) S.Hughes",
          "Name": "Stachybotrys chartarum",
          "Type": "accepted name"
        },
        {
          "id": 4404054,
          "FullName": "Stachybotrys lobulatus (Berk.) Berk.",
          "Name": "Stachybotrys lobulatus",
          "Type": "heterotypic"
        },
        {
          "id": 4404053,
          "FullName": "Stachybotrys lobulata Berk.",
          "Name": "Stachybotrys lobulata",
          "Type": "orthographic variant"
        }
      ],
      "Hierarchy": [
        {
          "id": 4404053,
          "FullName": "Stachybotrys lobulata Berk.",
          "Name": "Stachybotrys lobulata",
          "Rank": "sp."
        },
        {
          "id": 4404047,
          "FullName": "Stachybotrys Corda",
          "Name": "Stachybotrys",
          "Rank": "gen."
        },
        {
          "id": 4404048,
          "FullName": "Stachybotryaceae",
          "Name": "Stachybotryaceae",
          "Rank": "fam."
        },
        {
          "id": 4404044,
          "FullName": "Hypocreales",
          "Name": "Hypocreales",
          "Rank": "ord."
        },
        {
          "id": 4403986,
          "FullName": "Sordariomycetes",
          "Name": "Sordariomycetes",
          "Rank": "cl."
        },
        {
          "id": 4403962,
          "FullName": "Ascomycota",
          "Name": "Ascomycota",
          "Rank": "phyl.\/div."
        },
        {
          "id": 4403961,
          "FullName": "Fungi",
          "Name": "Fungi",
          "Rank": "reg."
        }
      ]
    }
  }
]

OpenAPI

… hier kommt mal swagger hin sobald verfügbar