Diversity Workbench: Schema for DiversityCollection, version 'beta'.
Document last revised on 16.Feb.2001 14:49
Copyright 2001 G. Hagedorn. All rights reserved.
Suggestions how to correct or improve the schema are welcome! Refers to ID of CollectionSpecimen (= foreign key). Name of the collecting person or group, e.g. "Miller, W.". Number assigned by the collector during the collection. Refers to ID of CollectionSpecimen (= foreign key). Accession number of the collection, e.g. "M-3890492". Name of the collection where the duplicate specimen is deposed. User defined notes. Refers to ID of CollectionSpecimen (= foreign key). Refers to ID of LocationIdentification (= foreign key). Either a named location selected from a thesaurus (e.g. "Germany, Bavaria, Kleindingharting") or values e.g. 100 - 200 m (for altitude range). Corresponding value to Location2 or ID of Thesaurus. Date of the determination of the geography. Person, team or organisation responsible for the data. Calculated altitude as parsed from the location fields. Calculated longitude as parsed from the location fields. Calculated latitude as parsed from the location fields. Refers to ID of CollectionSpecimen (= foreign key). ID of the image of the collection specimen. Only given if image refers to a single Unit of CollectionSpecimen, refers to ID of IdentificationUnit (= foreign key). The path and file name of the image. Project within DiversityCollection. Person responsible for the image. Notes concerning the image, e.g. scale, resolution. See CollectionProject for additional information. Name of the parameter, e.g. "TypeStatus". Value of the parameter, e.g. "holotypus". Description of the parameter. If this item can be edited by the user. Refers to ID of CollectionSpecimen (= foreign key). Material e.g. "drawings", "slides" etc. The place resp. taxon where the item is stored within the collection. Unique reference ID for the collection record (primary key). Calculated date, based on CollectionDay, -Month and -Year. The day of the collection event. The month of the collection event. The year of the collection event. Additional date information, e.g. "end of summer 1985". Locality and geo-ecological description of the locality as written on the original label. Title of label if different from ExsiccataTitle for printing labels. Will be printed on label after ExsiccataTitle. Whether the label is typed, typed with hand written comments of completely handwriting etc. The path and file name of the scan of the label. The state of the transcription of a label into the database: "Not started" / " incomplete" / "complete". User defined notes concerning the transcription of the label into the database. Accession number of the specimen within the collection, e.g. "M-0004752". The date, when the specimen was taken in the collection (format: YYYY/MM/DD). Name of the Collection, e.g. "Botanische Staatssammlung München". Standard abbreviation of the exsiccata. Number within the exsiccata. The name of the depositor resp. the herbarium if not the original collector, e.g. "Herbarium P. Döbbler". Accession number of the specimen within the herbarium where the specimen came from if not the original collection, e.g. "D-23948". Notes given by the collector, resp. found on the label. Additional notes made by the editor. Notes if the item is on loan resp. borrowed. Problems found with the specimen, e.g. doubtful identification, locality etc. Is set true if the label should be printed, is set false if the label should not be printed. Temporary storage of the data of the specimen which were selected for printing the labels. Refers to ID of CollectionSpecimen (= foreign key). Refers to ID of IdentificationUnit (= foreign key), specifies substrate. Accession number of the specimen within the collection. Name of the collection, e.g. "Botanische Staatssammlung München". Text printed as title of the label. Title of the exsiccate series. Number of the specimen within the exsiccate series. Taxonomic name of the specimen, published in the exsiccate series. The organism (growing on the substrate - if present). All organisms and substrates that where specified by identifications, following the first organism. Intermediate storage of the text of all organisms. The locality and habitat where the specimen has been collected. The persons or groups involved in the collection of the specimen. The date when the specimen has been collected. The number of the collected specimen assigned by the collector during the collection event. The persons or groups responsible for the identfication of the specimen. User defined notes. Refers to ID of CollectionSpecimen (= foreign key). Project to which the specimen belongs to as stored in the database DiversityUsers. ID of the exsiccatum. Std. abbreviation (authors/editors, std. abbrev. of title). Exact title (enter new entry if title spelling changed consistently). Issuing/Eding institution (If no editors are known, at least this must be entered). City/Country where the exs. has been issued. An earlier exsiccata publication appeared under different title or editors (Reference to entry in this database). A later exsiccata publication appeared under different title or editors (Reference to entry in this database). If known: number of the first exs. that was issued by the current editors under the current title. If known: number of the last exs. that was issued by the current editors under the current title. If known: publication year of the first exs. that was issued by the current editors under the current title. If known: publication year of the last exs. that was issued by the current editors under the current title. Annotation, please add your name and a date for each annotation. Please explain here if you have a problem, this field will later be checked. check if exsiccatum covers fungal species (default) 1 or -1= Yes it does, 0=No it does not, Null/empty = don't know. check if exsiccatum covers Algae/Cyanophyta. check if exsiccatum covers mosses/bryophytes. check if exsiccatum covers ferns. check if exsiccatum covers higher plants. 1st Example in M deposited under: title of example issue. 1st Example in M deposited under (scientific name). 2nd Example in M deposited under: title of example issue. 2nd Example in M deposited under (scientific name). 3rd Example in M deposited under: title of example issue. 3rd Example in M deposited under (scientific name) //Note: degenerated data model was introduced on purpose to keep database as simple as possible! included in Pfister 1985. included in Sayre 1969. Refers to ID of CollectionUnit (= foreign key). Refers to ID of CollectionSpecimen (= foreign key). Date and time of the determination. Qualifies whether the given date is an actual date or estimated etc. Not taxonomic name e.g. limestone, conifer, hardwood. Valid name of the species with author names of the taxon e.g. "Rosa canina L.". Category of the identification e.g. "determination"," confirmation", "absence". Defines the valid name for the organism. Can be set only once per organism. Source resp. literature used for the determination, e.g. "Schmeil-Fitschen 1995". The person or institution responsible for the determination. User defined notes, e.g. the reason for the new determination / change of the name etc. Defines the name under which the collection specimen is published within an exsiccate. Can be set only once per collection specimen. This organism is not present on the specimen, it was only observed by the collector. ID of an organism on the collection specimen. ID of the collection specimen. Group the object belongs to e.g. (1) plant, (2) fungus, (3) lichen, (4) animal, (5) procaryotic, (6) virus, (7) other, inorganic. Type of the published taxon e.g. holotype, syntype. Taxonomic name of the typified taxon. The IdentificationUnitID of the organism or substrate, where this organism is growing on (= foreign key). The part of the substrate, where the organism is growing on, e.g. "leaves" if only the leaves are colonized by the organism. The part of the lifecycle of the organism, e.g. "II, III" for spore generations of rusts or "seed", "seedling" etc. for higher plants. Notes concerning the organism, e.g. symptoms of infection like gall. Unique reference ID for the table LocalisationSystem (= primary key). Name of the system used for the determination of the place of the collection, e.g. "Gauss-Krüger", "MTB". Refers to ID of CoordinateSystem (= foreign key). User interface definition: locked status, label captions, etc. displayed in the form CollectionLocality. Despription of the localisation method. Unit used within the localisation system, e.g. "m" etc. The accuracy of values that can be reached with this method. Method for parsing the values typed in the fields [Location1, -2] in table [CollectionGeography]. Specifies if this item is enabled to be used within the database. Refers to ID of CollectionSpecimen (= foreign key). Type of the localisation system used, e.g. "Greenwich Coordinates". Group of the localisation system used, e.g. "Coordinates". Default values used within the DiversityCollection database. Unique reference ID for the parameters record. The person or institution responsible for the current manipulation of the data. Name of the Collection, e.g. "Botanische Staatssammlung München". Project as stored in DiversityUsers. The path of the logfile from where the data (LabelScan) will be imported into the database. The material of the specimen e.g. "drawings", "slides" etc. Group the object belongs to e.g. (1) plant, (2) fungus, (3) lichen, (4) animal, (5) procaryotic, (6) virus, (7) anorganic. Name of the collecting person or group, e.g. "Miller, W.". The last entered name for a fungus. Source resp. literature used for the determination of the fungus, e.g. "M. Moser (1978), Kleine Kryptogamenflora. Fischer, Stuttgart". The person or institution responsible for the determination of the fungus. The last entered name for a plant. Source resp. literature used for the determination of the plant, e.g. "E. Oberdorfer (1979), Pflanzensoziologische Exkursionsflora. Ulmer, Stuttgart". The person or institution responsible for the determination of the plant. The beginning of the barcode within the imported logfile. The length of the barcode within the imported logfile. The selected taxa, e.g. One fungus on One plant. The selected subset of the data, e.g. specimen with incomplete label transcription. The type of the source or target for the imported / exported data, e.g. "LabelScan". The marker, separating the datasets resp. indicating the beginning of a new dataset within a file. The path resp. folder where the label images are stored. (potential root element for the namespace of current database subsystem)