Diversity Exsiccatae (version 1.3):
Documentation of the information model

By G. Hagedorn & D. Triebel, 2003

This document contains a complete list of all entities and attributes used in the information model of this application module. It is primarily intended as a technical reference. It can also be helpful, however, in understanding the scope and usage of certain attributes. When you have a question like 'where does this information fit in', reading the attribute description may help you.

Besides the human readable documentation provided below, three additional technical documents are provided:

Entity relationship diagram for Diversity Exsiccatae information model

Entity relationship diagram of Diversity Exsiccatae information model Entity Exsiccata, click to show attributes (reflexive relations to Entity Exsiccata itself!) Entity ExsiccataEditor, click to show attributes Entity ExsiccataExamples, click to show attributes Entity ExsiccataCountry, click to show attributes Entity ExsiccataRegion, click to show attributes

(You can click on the entities to go to the attribute tables.)

Index to entities: Exsiccata, ExsiccataEditor, ExsiccataCountry, ExsiccataRegion, ExsiccataExamples.

See also the separate alphabetical index to attribute names.

Exsiccata

An Exsiccata is a series of specimen issued in a publication like form. (Note: the examples within this entity are purposely denormalized!).

Attributes and indices of the entity 'Exsiccata'
Name Type Description / Default value & validation Rqrd./Index
ExsiccataID Long ID of the exsiccata (primary key).
Default value: =CLng(1+Rnd()*999999998), validation message: Only positive ID numbers are allowed.		 R I (P)
ExsAbbreviation Text Std. abbreviation (authors/editors, std. abbrev. of title).
Validation rule: Not (Like " *" Or Like "* ")		 R I
ExsTitle Text Exact title (create a new entry if title spelling changed considerably, link entries using PrecededBy/SupersededBy).
Validation rule: Not (Like " *" Or Like "* ")		 R I
EditingInstitution Text Issuing/Eding institution (If no editors are known, at least this must be entered).
Validation rule: Is Null Or Not (Like " *" Or Like "* ")		 - -
EditingLocationOri Text Original spelling of city/country where the exsiccata has been issued.
Validation rule: Is Null Or Not (Like " *" Or Like "* ")		 - -
EditingLocationEnglish Text Current English spelling of city/country where the exsiccata has been issued.
Validation rule: Is Null Or Not (Like " *" Or Like "* ")		 - -
PrecededBy Long An earlier exsiccata publication appeared under different title or editors (Reference to entry in this database). - I
SupersededBy Long A later exsiccata publication appeared under different title or editors (Reference to entry in this database). - I
ExsNumberFirst Text If known: number of the first exs. that was issued by the current editors under the current title.
Validation rule: Is Null Or Not (Like " *" Or Like "* ")		 - -
ExsNumberLast Text If known: number of the last exs. that was issued by the current editors under the current title.
Validation rule: Is Null Or Not (Like " *" Or Like "* ")		 - -
ExsPublYearFirst Text If known: publication year of the first exs. that was issued by the current editors under the current title.
Validation rule: Is Null Or Not (Like " *" Or Like "* ")		 - -
ExsPublYearLast Text If known: publication year of the last exs. that was issued by the current editors under the current title.
Validation rule: Is Null Or Not (Like " *" Or Like "* ")		 - -
Notes Memo Annotation, please add your name and a date for each annotation. - -
Problems Text Please explain here if you have a problem, this field will later be checked. - -
Fungi Integer check if exsiccatum covers fungal species (default) 1 or -1= Yes it does, 0=No it does not, Null/empty = don't know.
Default value: Null; Validation rule: (-1 Or 0) Or Is Null		 - -
Algae Integer check if exsiccatum covers Algae/Cyanophyta.
Default value: Null; Validation rule: (-1 Or 0) Or Is Null		 - -
Mosses Integer check if exsiccatum covers mosses/bryophytes.
Default value: Null; Validation rule: (-1 Or 0) Or Is Null		 - -
Pteridophytes Integer check if exsiccatum covers pteridophytes.
Default value: Null; Validation rule: (-1 Or 0) Or Is Null		 - -
HigherPlants Integer check if exsiccatum covers higher plants.
Default value: Null; Validation rule: (-1 Or 0) Or Is Null		 - -
InPfister85 Integer Exsiccate is included in publication by Pfister 1985.
Default value: Null; Validation rule: (-1 Or 0) Or Is Null		 - -
InSayre69 Integer Exsiccate is included in publication by Sayre 1969.
Default value: Null; Validation rule: (-1 Or 0) Or Is Null		 - -
InSayre71 Integer Exsiccate is included in publication by Sayre 1971.
Default value: Null; Validation rule: (-1 Or 0) Or Is Null		 - -
InSayre75 Integer Exsiccate is included in publication by Sayre 1975.
Default value: Null; Validation rule: (-1 Or 0) Or Is Null		 - -
Educational Integer Educational purpose of the exsiccata, 1 or -1= Yes, 0=No, Null/empty = don't know.
Default value: 0		 - -
Scientific Integer Scientific purpose of the exsiccata, 1 or -1= Yes, 0=No, Null/empty = don't know.
Default value: 0		 - -
GroupSpecific Integer 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.
Default value: 0		 - -
LichenSpecific Boolean check if exsiccatum covers Lichens. - -
Index name:  Attributes & index properties
ExsAbbrev:  ExsAbbreviation (Duplicates OK)
ExsTitle:  ExsTitle (Duplicates OK)
PrecededBy:  PrecededBy (Duplicates OK)
PrimaryKey:  ExsiccataID (Primary key; Unique values)
SupersededBy:  SupersededBy (Duplicates OK)
Relation type:  Attributes involved
Updates cascade  Exsiccata.ExsiccataID « Exsiccata.PrecededBy
Updates cascade  Exsiccata.ExsiccataID « Exsiccata.SupersededBy
Updates & deletions cascade  Exsiccata.ExsiccataID « ExsiccataEditor.ExsiccataID
Updates & deletions cascade  Exsiccata.ExsiccataID « ExsiccataExamples.ExsiccataID

ExsiccataEditor

An editor that published an Exsiccata.

Attributes and indices of the entity 'ExsiccataEditor'
Name Type Description / Default value & validation Rqrd./Index
Name Text Enter as last name, comma, first names, use blanks after comma and period.
Validation rule: Not (Like " *" Or Like "* ")		 R I(PM)
ExsiccataID Long Reference to ExsiccataID in Exsiccata (foreign Key). R I/I(PM)
Sequence Date/Time (automatically set during entry, to maintain the sequence of editors).
Default value: =Now()		 R -
Index name:  Attributes & index properties
ExsiccataID:  ExsiccataID (Duplicates OK)
PrimaryKey:  Name; ExsiccataID (Primary key; Unique values)
Relation type:  Attributes involved
Updates & deletions cascade  Exsiccata.ExsiccataID « ExsiccataEditor.ExsiccataID

ExsiccataCountry

An Exsiccata is a series of specimen issued in a publication like form. (Note: the examples within this entity are purposely denormalized!).

Attributes and indices of the entity 'ExsiccataCountry'
Name Type Description / Default value & validation Rqrd./Index
ExsiccataID Long Reference to ExsiccataID in Exsiccata (foreign Key). R I(PM)
Country Text The editing country of the exsiccata. R I(PM)
Index name:  Attributes & index properties
PrimaryKey:  ExsiccataID; Country (Primary key; Unique values)

ExsiccataRegion

An Exsiccata is a series of specimen issued in a publication like form. (Note: the examples within this entity are purposely denormalized!).

Attributes and indices of the entity 'ExsiccataRegion'
Name Type Description / Default value & validation Rqrd./Index
ExsiccataID Long Reference to ExsiccataID in Exsiccata (foreign Key). R I(PM)
Region Text A region where the specimen within the exsiccata where collected. R I(PM)
Index name:  Attributes & index properties
PrimaryKey:  ExsiccataID; Region (Primary key; Unique values)

ExsiccataExamples

An Exsiccata is a series of specimen issued in a publication like form. (Note: the examples within this entity are purposely denormalized!).

Attributes and indices of the entity 'ExsiccataExamples'
Name Type Description / Default value & validation Rqrd./Index
ExsiccataID Long Reference to ExsiccataID in Exsiccata (foreign Key). R I(PM)
ExampleID Long A number that defines the sequence in which the examples have been added.
Default value: =CLng((Now()-58600)*99999)		 R I(PM)
CollName Text Example: Name or Acronym of collection where the example issue is available. Default is M for München.
Default value: "M"; Validation rule: Is Null Or Not (Like " *" Or Like "* ")		 - -
Number Text Example: Number of example issue within the Exsiccata series.
Validation rule: Is Null Or Not (Like " *" Or Like "* ")		 - -
PublishedName Text Example: Published taxon name of example issue.
Validation rule: Is Null Or Not (Like " *" Or Like "* ")		 - -
StorageLocation Text Example: Deposited under (scientific name indicating a storage location).
Validation rule: Is Null Or Not (Like " *" Or Like "* ")		 - -
ImageFile Text Example: Path and file name for an image of the label of the exsiccata example issue.
Validation rule: Is Null Or Not (Like " *" Or Like "* ")		 - -
CollectionSpecimenID Long Optionally: The ID under which the example specimen is recorded in DiversityCollection. - I (UN)
Index name:  Attributes & index properties
CollectionSpecimenID:  CollectionSpecimenID (Unique values; Ignore Nulls)
PrimaryKey:  ExsiccataID; ExampleID (Primary key; Unique values)
Relation type:  Attributes involved
Updates & deletions cascade  Exsiccata.ExsiccataID « ExsiccataExamples.ExsiccataID

Footnotes: The following abbreviations have been used in the tables: R: It is required to enter data in this field. I: The field is indexed to enable faster searching. Different types of indices are denoted by additional letters in parentheses: P = attribute is part of the primary key (values in the index must be unique), U = values in the index must be unique, N = Null values are ignored in the index, M = the index contains more than one attribute, + = the attribute is involved in more than one multiple-field index. The names of attributes that are part of the primary key are underlined in the first column.

Attribute names of system fields and logging fields (record creation or updating) are enclosed in square brackets: [].

Data types: 'Text (255)' indicates a text of varying length for which no specific design restrictions have been formulated. 255 characters should be read as a proposed technical maximum limit, that can be changed if required by the database management system. In contrast, 'Memo' is explicitly defined as text of unlimited length. All text is Unicode text. Numeric types: BigInt = 8 byte integer, Long = 4 byte integer, Integer or Int = 2 byte integer, Byte = 1 byte integer. A + (e.g. Byte+) indicates that the integer is unsigned and only positive values are allowed.

We are interested in your opinion. If you see any problems with the model that you would like to bring to our attention, please contact us by sending an email to name@gmail.com, please replace name with g.m.hagedorn!

Documentation created on 24. Sep. 2003 9:37; last update: 2005-03-30, email address revised 2010-08-05.

This work is licensed under a Creative Commons License Valid XHTML 1.0! Valid CSS1!