Documentation created on 30. Dec. 2002; last update: 2005-03-30, email address revised 2010-08-05.
By G. Hagedorn, 2002
This is a special "reduced" version to finish the primary tasks of the GLOPP project. A Coldfusion user interface was implemented and it will be used for data acquisition within the GLOPP project in the coming months.
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:
Index to entities: TaxonomyName, TaxonomyNameVariant, TaxonomySynonymy, TaxonomySynonymyRefs, TaxonomyNameVariant_Changes.
See also the separate alphabetical index to attribute names.
The main table containing one record for every published name. The data model is simplified and slightly changed to allow collaboration with the Index Fungorum (Paul Kirk).
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| NomID | Long | R | I (P) | |
| NameCache | Text | R | I | |
| Genus | Text | The genus name as text (i.e. this does not allow to distinguish generic homonyms!). Validation rule: Not Like "* *" Or (Like "× *" Or Like "x *" Or Like "* × *" Or Like "* x *"), validation message: The Genus name may not contain a blank! Note: blanks after hybrid indicators are allowed, e. g. "Aceras × Orchis". |
R | - |
| SpecificEpithet | Text | The species name part of the species name, e.g. 'alba' for 'Abies alba'. Validation rule: Not Like "* *" Or (Like "× *" Or Like "x *" Or Like "* × *" Or Like "* x *"), validation message: The Specific name may not contain a blank! Note: blanks after hybrid indicators are allowed, e. g. "× columbiana". |
R | - |
| TaxonomicRankString | Text | In funindex the rank field for species is empty and this field is called "Infraspecific Rank". | - | - |
| InfraspecificEpithet | Text | - | - | |
| BasionymAuthors | Text | The authors of a newly created name. | - | - |
| CombiningAuthors | Text | The name of the combining authors if the name is based on another older name (e.g. combined into a different genus). | - | - |
| PublishingAuthors | Text | If the authors of the taxon differ from the authors of the publication: the latter (... 'in' Publishing authors ...). | - | - |
| SanctioningAuthor | Text | Validation rule: Is Null Or 'Pers.' Or 'Fr.', validation message: Only Pers. for Persoon or Fr. for Fries are possible sanctioning authors. | - | - |
| LiteratureTitle | Text | - | - | |
| Volume | Text | - | - | |
| Issue | Text | - | - | |
| Page | Text | - | - | |
| YearOfPubl | Text | - | - | |
| YearOnPubl | Text | - | - | |
| IndexingReference | Text | - | - | |
| OriginalOrthography | Text | - | - | |
| NomenclaturalComment | Text | - | - | |
| SynonymyComment | Text | Especially exclusions, like 'non xy', ca. 808 records in version 10/2002. | - | - |
| EditorialComment | Text | Funindex editorial comment. | - | - |
| TypificationDetails | Text | - | - | |
| TypeSubstratum | Text | - | - | |
| TypeLocality | Text | - | - | |
| AnamorphTeleomorph | Text | - | - | |
| BasionymNomID | Long | - | I | |
| [LogUpdatedBy] | Long | Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible. | - | I |
| [LogUpdatedWhen] | Date/Time | Date and time when record was last updated. Default value: Now() |
- | - |
| Source | Text | Source: F = Index Fungorum/Paul Kirk, D = Dictionary, G = additions GLOPP Project. | - | - |
| NameCitedIn | Text | temporary information, deleted after name has been checked. | - | - |
| GenusID | Long | GenusID as NomID. This entry is optional in addition to Genus entered as text and allows to distinguish between genus homonyms. Default value: 0 |
- | - |
| Index name: | Attributes & index properties | |||
| BasionymNomID: | BasionymNomID (Duplicates OK) | |||
| LogUpdatedBy: | LogUpdatedBy (Duplicates OK) | |||
| NameCache: | NameCache (Duplicates OK) | |||
| PrimaryKey: | NomID (Primary key; Unique values) | |||
| Relation type: | Attributes involved | |||
| Referential integrity | TaxonomyName.NomID « TaxonomySynonymy.TaxonID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomySynonymy.AcceptedTaxonID | |||
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| NomID | Long | Refers to NomID in TaxonomyName (foreign key). | R | I/I(UM) |
| NameVariant | Text | One of 1 to several name variants for a taxonomic organism name. | R | I(UM) |
| IDsPerName | Byte+ | Calculated value! Number of NomIDs that have this name variant. Automatic assignment name to NomID is possible only if value = 1 (no homonyms). Default value: 0 |
R | I |
| ManualConnect | Boolean | Identifies variants which have been manually linked rather than created by an algorithm. Default value: True |
R | - |
| SaveToConnect | Boolean | Calculated value! A name is save to connect if IDs per Name is 1, and if it contains either authors or is an infraspecific taxon! Default value: False |
R | - |
| ID | Autonum | Unique artificial ID (primary key). Note: the combination NameVariant plus NomID is also unique (= is a candidate key). | R | I (P) |
| Index name: | Attributes & index properties | |||
| IDsPerName: | IDsPerName (Duplicates OK) | |||
| NameVariantPlusNomID: | NameVariant; NomID (Unique values) | |||
| NomID: | NomID (Duplicates OK) | |||
| PrimaryKey: | ID (Primary key; Unique values) | |||
Taxonomy: Synonymization of species. Each responsible user can create an independent system.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| SynID | Autonum | Unique ID. | R | I (P) |
| TaxonID | Long | Synonym name. Refers currently directly to a NomID rather than to a Taxon (-concept)-ID. | R | I |
| DisplayOrder | Long | Original order in synonymization reference. Number defining the sequence within an accepted name. Default value: 0 |
R | - |
| OriOrganismName | Text | Name exactly as it appear in the synonymization source. | R | - |
| OriNote | Text | A note of the responsible person concerning this synonymization that will be output in a report, e.g. 'fide Author 1999'. | - | - |
| AcceptedTaxonID | Long | ID of accepted name for the current name. Refers currently directly to a NomID rather than to a Taxon (-concept)-ID, use identical SynRef to convert. | R | I |
| SynRefID | Text | ReferenceID: Source publication where synonymization is published (not publication of name!). | - | I |
| SynRefCitation | Text | Free citation, esp. where a RefID is missing. Source publication where synonymization is published (not publication of name!). | - | I |
| SynRefDetail | Text | esp. page number on which the synonymization is published. | R | - |
| TypistsNotes | Text | An internal note of the responsible person concerning this synonymization. This information is NOT included in any report. | - | - |
| [LogCreatedBy] | Long | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible. | R | I |
| [LogCreatedWhen] | Date/Time | Date and time when record was first entered (typed or imported) into this system. Default value: Now() |
- | - |
| [LogUpdatedBy] | Long | Name of user who last updated the data. This is the operator (or typist) name, which may be different from the person responsible. | - | I |
| [LogUpdatedWhen] | Date/Time | Date and time when record was last updated. Default value: Now() |
- | - |
| Index name: | Attributes & index properties | |||
| AcceptedTaxonID: | AcceptedTaxonID (Duplicates OK) | |||
| LogCreatedBy: | LogCreatedBy (Duplicates OK) | |||
| LogUpdatedBy: | LogUpdatedBy (Duplicates OK) | |||
| NomID: | TaxonID (Duplicates OK) | |||
| PrimaryKey: | SynID (Primary key; Unique values) | |||
| RefID: | SynRefID (Duplicates OK) | |||
| SynRefCitation: | SynRefCitation (Duplicates OK) | |||
| Relation type: | Attributes involved | |||
| Referential integrity | TaxonomyName.NomID « TaxonomySynonymy.TaxonID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomySynonymy.AcceptedTaxonID | |||
Predefined references for a picklist.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| SynRefID | Text | ReferenceID: Source publication where synonymization is published (not publication of name!). | - | I |
| SynRefCitation | Text | Free citation, esp. where a RefID is missing. Source publication where synonymization is published (not publication of name!). | - | I |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | SynRefID (Primary key; Unique values) | |||
| RefID: | SynRefID (Duplicates OK) | |||
| SynRefCitation: | SynRefCitation (Duplicates OK) | |||
Development notes.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| ID | Autonum | R | I (P) | |
| Text | Memo | - | - | |
| Index name: | Attributes & index properties | |||
| ID: | ID (Duplicates OK) | |||
| PrimaryKey: | ID (Primary key; Unique values) | |||
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 30. Dec. 2002; last update: 2005-03-30, email address revised 2010-08-05.