Fish Collection NRM

The database is managed with The Artedian collection management system in MS-Access. The main tables describe collecting events and collection objects which are related on a one to many relationships.

The database is Darwin Core compatible but uses alternative table names and includes also loan routines, document management and other components of collection management. Principal items managed are objects (catalog number, identification, number of specimens, sex size, location in collection, collection space, preservative, identifier, etc.); localities (collecting events with date, collector, geographic information including coordinates, and more), collecting site habitat; loans (with extensive metadata), accession information (date of accession, donors, acquisition conditions etc., specimen preservation progress).