Diversity Workbench: Schema for Diversity Exsiccatae information model, version '1.3'.
Document last revised on 28.Sep.2003 9:37
Copyright 2001-2002 G. Hagedorn. All rights reserved.
Suggestions how to correct or improve the schema are welcome! An Exsiccata is a series of specimen issued in a publication like form. (Note: the examples within this entity are purposely denormalized!). ID of the exsiccata (primary key). Std. abbreviation (authors/editors, std. abbrev. of title). Exact title (create a new entry if title spelling changed considerably, link entries using PrecededBy/SupersededBy). Issuing/Eding institution (If no editors are known, at least this must be entered). Original spelling of city/country where the exsiccata has been issued. Current English spelling of city/country where the exsiccata 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 pteridophytes. check if exsiccatum covers higher plants. Exsiccate is included in publication by Pfister 1985. Exsiccate is included in publication by Sayre 1969. Exsiccate is included in publication by Sayre 1971. Exsiccate is included in publication by Sayre 1975. Educational purpose of the exsiccata, 1 or -1= Yes, 0=No, Null/empty = don't know. Scientific purpose of the exsiccata, 1 or -1= Yes, 0=No, Null/empty = don't know. Exsiccata is restricted to a taxonomic entity or ecologically delimited group, e.g. family or lichens on leaves, 1 or -1= Yes, 0=No, Null/empty = don't know. check if exsiccatum covers Lichens. An editor that published an Exsiccata. Enter as last name, comma, first names, use blanks after comma and period. Reference to ExsiccataID in Exsiccata (foreign Key). (automatically set during entry, to maintain the sequence of editors). An Exsiccata is a series of specimen issued in a publication like form. (Note: the examples within this entity are purposely denormalized!). Reference to ExsiccataID in Exsiccata (foreign Key). The editing country of the exsiccata. An Exsiccata is a series of specimen issued in a publication like form. (Note: the examples within this entity are purposely denormalized!). Reference to ExsiccataID in Exsiccata (foreign Key). A region where the specimen within the exsiccata where collected. An Exsiccata is a series of specimen issued in a publication like form. (Note: the examples within this entity are purposely denormalized!). Reference to ExsiccataID in Exsiccata (foreign Key). A number that defines the sequence in which the examples have been added. Example: Name or Acronym of collection where the example issue is available. Default is M for München. Example: Number of example issue within the Exsiccata series. Example: Published taxon name of example issue. Example: Deposited under (scientific name indicating a storage location). Example: Path and file name for an image of the label of the exsiccata example issue. Optionally: The ID under which the example specimen is recorded in DiversityCollection. (potential root element for the namespace of current database subsystem)