Database

The image below shows the main datadomains within DiversityCollection.

The diagram shows the main 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.

Additional tables not included in the diagram above e.g. for the Task are shown in the chapters below.

The database for DiversityCollection based on Microsoft SQL-Server 2016 or above.