The database for DiversityCollection is based on Microsoft SQL-Server 2014 or higher.
The main tables of the database are CollectionEvent corresponding to the event of the collection and CollectionSpecimen holding the specimens collected. Connected to these tables you find tables for additional information.
The image below shows the main tables of the database.
The diagram shows the tables of the database marked according to their logical groups. In the center the table CollectionSpecimen holds specimen data e.g. the accession number. On the left you find the tables containing collection event data and on the right tables related to the organisms and their identifications . Further logical groups are collectors , projects , storage and transaction .
Further details: tables , application tables, access.