Documentation created on 16. Feb. 2001; last update: 2005-03-30, email address revised 2010-08-05.
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 of related attributes may help you.
Besides the human readable documentation provided below, three more technical documents are provided:
Index of entities: TaxonomyName, TaxonomyActionOnName, TaxonomyOpinion, TaxonomySynonymy, TaxonomyHierarchy, TaxonomyChanges, TaxonomyCitedSpecimen, TaxonomyRank.
(You can click on the entities to go to the attribute tables.)
Taxonomy: Supertype entity, providing a nomenclatural ID for all names introduced as taxa (infraspecific, species, genus, family, etc.). Contains only objective information; all scientific opinion is placed in ...Opinion, ...Synonymy, & ...Hierarchy.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| NomID | Autonumber | Unique ID code for the nomenclatural name (primary key). Default value: GenUniqueID() |
- | I (U) |
| TaxonomicRank | Byte | Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank). | R | I |
| HigherTaxonName | Text (255) | If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc. | R | I (U) |
| SpeciesGenusID | Long | If rank is species or below: NomID code of the Genus name. Refers to TaxonomyName (= foreign key) where TaxonomicRank = genus. | R | I/I |
| SpeciesEpithet | Text (255) | If rank is species or below: Species epithet, for example 'alba' in 'Abies alba Miller' (currently accepted spelling). | R | I |
| CreationType | Text (1) | T: New taxon; C: new combination based on a previously publ. other name ('comb. nov.'), N: new name ('nom.nov.') introduced to replace a homonym (may occur for genera!), V: validation of previously invalidly published taxon name ('ex'), or U: for unknown. Default value: "U" |
R | - |
| BasionymNomID | Long | Basionym if CreationType is 'comb. nov.' or replacement ('nom. nov.'), of another name based on the same type material. Refers to ID code of TaxonomyName (= foreign key). | - | I/I |
| ValidatedNomID | Long | Validated name if CreationType is validation ('ex') of another name based on the same type material. Refers to ID code of TaxonomyName (= foreign key). | - | I/I |
| InfraspecificEpithet | Text (255) | If rank is infraspecific: Infraspecific epithet (currently accepted spelling). Note: the rank is known from required attribute TaxonomicRank in TaxonomyName (= the supertype entity). | - | I |
| InfraspecificAutonym | Boolean | If rank is infraspecific: The infraspecific name is an autonym (example: 'Abies alba Miller ssp. alba'; normal infraspecific example: 'Abies alba ssp. nebrodensis (Lojac.) Nitz.', note the placement of author names!). Default value: 0 |
- | - |
| TaxonAuthors | Text (255) | For all taxonomic ranks: Author(s) of the taxon, abbreviated according to authors standard, including basionym authors in '()', validating authors ('ex'), optionally including sanctioning authors or "in" authors. | - | - |
| ConceptSuffix | Text (255) | 'sensu' or 'emend.' author, or 's.str.'/'s.lat.'. Provided as sep. attribute to simplify later changes (multiple taxon concepts can be based on a single name, so this really belongs into a separate entity). Compare 'potential taxon' sensu Berendsohn! | - | - |
| TypeGenus_NomID | Long | If rank is suprageneric: Type genus of taxon. Refers to the ID code of TaxonomyName (= foreign key). | - | I/I |
| TypeSpecies_NomID | Long | If rank is genus or infrageneric: Type species of genus or infrageneric taxon. Refers to the ID code of TaxonomyName (= foreign key). | - | I/I |
| TypeSpecimenDeposition | Text (255) | If rank is species or below: Information on deposition of type material in a collection, entered exactly as written in the protologue (original taxon description). | - | - |
| TypeSpecimenLocation | Memo | If rank is species or below: Optional information on the geographic location of type material, entered exactly as written in the protologue (i.e. not as known from type specimen studied elsewhere!). | - | - |
| TypeSpecimenSubstrate | Memo | If rank is species or below: Optional information on substrate (anorganic, or living/dead plant, animal, or fungus) of type material, entered exactly as written in the protologue (i.e. not as known from type specimen studied elsewhere!). | - | - |
| TypeSpecimenCollectors | Memo | If rank is species or below: Optional information on collector(s) of type material (separate multiple collectors with a ";"), entered exactly as written in the protologue (i.e. not as known from type specimen studied elsewhere!). | - | - |
| TypeSpecimenInformation | Memo | If rank is species or below: Optional further information on type material, esp. collection date and number, entered exactly as written in the protologue (i.e. not as known from type specimen studied elsewhere!). | - | - |
| GenusIsAsexual | Boolean | If rank is genus: Checked (or true) ® this an anamorph genus, containing asexual forms only (relevant for fungi). The information can also be obtained from the taxonomic hierarchy; it is always added here to be available when the hierarchy is incomplete. Default value: Null |
- | - |
| ProtologueReportedCitation | Text (255) | Optional text of citation; used only when default reference description is unsatisfactorily (esp. abbreviated tax. literature book titles, exsiccata references). If present, this information is used in preference over the ProtologueRefDescription. | - | - |
| ProtologueRefID | Text (20) | Reference ID of the original description/protologue. Refers to the ID code of the main ReferenceTitle table in the reference module (= foreign key). | - | I |
| ProtologueRefDescriptionCache | Text (255) | Calculated: cached reference description, obtained through the ProtologueRefID from the references subsystems. | - | - |
| ProtologueRefPage | Text (50) | First page of protologue (original description) in the reference. | - | - |
| ProtologueRefReprintPagination | Boolean | If checked (or 'True'), the true page number of the protologue page is unknown and only a reprint page number (pagination starting w. 1...) can be given. In tax. monographs this situation is often indicated by 'extr.' or 'extractum' after the page number. | R | - |
| OriginalNameSpelling | Text (255) | Original spelling of taxonomic name in the protologue publication. Recorded only, if different from current taxon name. | - | - |
| OriginalTaxonPlacement | Text (255) | Taxonomic placement (e.g. family or division) mentioned in the original description. This is NOT the current taxonomic placement! | - | - |
| OriginalDiagnosisLatin | Memo | Optional: The full text of the Latin description/diagnosis in the protologue. | - | - |
| OriginalDiagnosisOther | Memo | Optional: The full text of the original description/diagnosis in the protologue, if a diagnosis in another language than Latin was provided. To be entered into the database only if no copyright is violated. | - | - |
| IndexingReference | Text (255) | Optional: A secondary reference indexing this taxon, e.g. Saccardo, Index of Fungi, etc. Entered as text, not as reference ID! | - | - |
| ImportedFrom | Text (50) | If imported from another database: The name of the database system or provider. Otherwise empty. | - | - |
| ImportedID | Text (255) | If imported from another database: An ID value to later re-identify the record in that database may be stored here. | - | - |
| IneditedResponsible | Text (50) | Empty for published names, filled w. the name of the responsible person for unpublished ('inedited') names entered in the database. These may not appear in any reports, until specifically requested for a report that will be used to publish the name. | - | - |
| Problem | Text (255) | Problem with data entry (not with the taxon). | - | - |
| LogCreated_User | Text (50) | 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 | - |
| LogCreated_Date | Date/Time | Date and time when record was first entered (typed or imported) into this system. Default value: Now() |
R | - |
| NameCache | Text (255) | Calculated: Full, standardized name for the new taxon, calculated from genus, species and infraspecific epithet and authors. The value is unique, since it includes the author for higher taxa (genera, families) as well as for species. | R | I (U) |
| NameCache_html | Text (255) | Calculated: Like NameCache, but italic and plain text is formatted using xhtml markup (/). | R | - |
| NameCache_NoAuthors | Text (255) | Calculated: Like NameCache, but without any authors. Duplicates may occur here, and taxa with homonyms can be detected using this attribute. Where no homonyms are found, names from other data sources may be compared based on this field alone. | R | I |
| NameCache_inverted | Text (255) | Calculated: Like NameCache, but for species or infraspecific taxa the lowest rank name is printed first ('species-epitheton, Genus' or 'variety (var.) species-epitheton, Genus'). | R | I (U) |
| Index name: | Attributes & index properties | |||
| Basionym_NomID: | BasionymNomID (Duplicates OK) | |||
| BasionymOrValidatedNomID: | ValidatedNomID (Duplicates OK) | |||
| Genus_NomID: | SpeciesGenusID (Duplicates OK) | |||
| HigherTaxonName: | HigherTaxonName (Unique values) | |||
| InfraspecificName: | InfraspecificEpithet (Duplicates OK) | |||
| NameCache: | NameCache (Unique values) | |||
| NameCache_inverted: | NameCache_inverted (Unique values) | |||
| NameCache_NoAuthors: | NameCache_NoAuthors (Duplicates OK) | |||
| PrimaryKey: | NomID (Primary key; Unique values) | |||
| ProtologueRefID: | ProtologueRefID (Duplicates OK) | |||
| SpeciesEpithet: | SpeciesEpithet (Duplicates OK) | |||
| TaxonomyNameTaxonomyName: | TypeGenus_NomID (Duplicates OK) | |||
| TaxonomyNameTaxonomyName1: | TypeSpecies_NomID (Duplicates OK) | |||
| TaxonomyNameTaxonomyName2: | SpeciesGenusID (Duplicates OK) | |||
| TaxonomyNameTaxonomyName3: | ValidatedNomID (Duplicates OK) | |||
| TaxonomyNameTaxonomyName4: | BasionymNomID (Duplicates OK) | |||
| TaxonomyRankTaxonomyName: | TaxonomicRank (Duplicates OK) | |||
| TypeGenus_NomID: | TypeGenus_NomID (Duplicates OK) | |||
| TypeSpecies_NomID: | TypeSpecies_NomID (Duplicates OK) | |||
| Relation type: | Fields involved | |||
| Simple relation (no integrity) | TaxonomyGenusNomID.NomID « TaxonomyName.TypeGenus_NomID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomyHierarchy.Parent_NomID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomyName.TypeGenus_NomID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomyName.TypeSpecies_NomID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomyName.SpeciesGenusID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomyName.ValidatedNomID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomyName.BasionymNomID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomySynonymy.NomID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomySynonymy.Accepted_NomID | |||
| Updates cascade | TaxonomyRank.RankID « TaxonomyName.TaxonomicRank | |||
| Simple relation (no integrity) | TaxonomySpeciesNomID.NomID « TaxonomyName.TypeSpecies_NomID | |||
| Deletions cascade | TaxonomyName.NomID « TaxonomyActionOnName.NomID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomyHierarchy.NomID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomyOpinion.NomID | |||
| Simple relation (no integrity) | TaxonomyGenusNomID.NomID « TaxonomyName.SpeciesGenusID | |||
Taxonomy: Secondary action, affecting the status of a taxon. Examples are neo-, lecto- or epitypifications and conservation/rejection.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| ActionID | Autonumber | Unique ID for this record. | - | I (U) |
| NomID | Long | The taxon concerning this action. Refers to the NomID code of TaxonomyName (= foreign key). | R | I/I |
| ActionType | Text (1) | Type of nomenclatural action: conservation, rejection, neo-, lecto- or epitypification, emendation. The sanctioning of a name should not be recorded here. | R | - |
| InternalNote | Memo | Additional information regarding the typification or conservation/rejection. | - | - |
| RefID | Text (20) | Reference ID of the reference containing the nomenclatural action defined in ActionType. Refers to the ID code of the main ReferenceTitle table in the reference module (= foreign key). | R | I |
| RefDescriptionCache | Text (255) | Calculated: cached reference description, obtained through the RefID from the references subsystems. | - | - |
| RefPage | Text (50) | Relevant detail in a nomenclatural action reference; usually number of the page on which the action is described. | - | - |
| LogCreated_User | Text (50) | 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 | - |
| LogCreated_Date | Date/Time | Date and time when record was first entered (typed or imported) into this system. Default value: Now() |
R | - |
| TypificationSpecimenDescription | Text (255) | Only for typification actions: A user readable description of the specimen to which the typification refers (collection acronym + storage code / name under which specimen is stored). | - | - |
| TypificationSpecimenID | Text (255) | Only for typification actions: If a specimen collection database subsystem is available, the relevant specimen unit identifier in that system is stored here (added in addition to a user readable TypificationSpecimenDescription). | - | I |
| Index name: | Attributes & index properties | |||
| NomID: | NomID (Duplicates OK) | |||
| PrimaryKey: | ActionID (Primary key; Unique values) | |||
| RefID: | RefID (Duplicates OK) | |||
| TaxonomyTaxonTaxonomyAction: | NomID (Duplicates OK) | |||
| TypificationSpecimenID: | TypificationSpecimenID (Duplicates OK) | |||
| Relation type: | Fields involved | |||
| Deletions cascade | TaxonomyName.NomID « TaxonomyActionOnName.NomID | |||
Taxonomy: Opinion or comment relating to the status (valid, accepted, etc.) of a nomenclatural name.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| OpinionID | Autonumber | Unique ID code for the opinion (primary key). Note that the combination of NomID, ProjectMarker, and Responsible must also be unique and not null (candidate key). Default value: GenUniqueID() |
- | I (U) |
| NomID | Long | The taxon this opinion refers to. Refers to the NomID code of TaxonomyName (= foreign key). | R | I |
| ProjectMarker | Text (25) | Each project can have a different opinion regarding synonmy. Refers to the common project definition in the user module. | R | I (UM) |
| Responsible | Text (50) | The person responsible for this opinion/assessment on a taxon. Validation rule: Not Is Null, validation message: Any opinion must be signed by a responsible person. |
R | - |
| Status | Text (1) | Status of taxonomic name: A=accepted, D=Doubtful, E=Excluded, etc. Synonyms of accepted taxa should have status A. The report may be grouped by this attributes. | - | I |
| ReportedTypes | Text (255) | List of known type specimens, use a '!' after collection name/abbreviation to indicate that this material has been studied by the responsible person. Included in the report. | - | - |
| ReportedNote | Memo | Taxonomic remarks that will be output after the taxon in a report. | - | - |
| InternalNote | Memo | An internal note of the responsible person concerning this name. This information is NOT included in any report. | R | - |
| RefID | Text (20) | If the opinion is based on a publication: the reference ID of that work. | - | I |
| RefDescriptionCache | Text (255) | If the opinion is based on a publication: the reference description of that work. | - | - |
| RefPage | Text (50) | If the opinion is based on a publication: relevant detail; usually page number where the opinion is published. | - | - |
| UserMarker1 | Text (50) | A temporary marker or keyword assigned by user for searching and sorting purposes while a group is reviewed. Any information can be entered here, but it will be visible only internally. | - | I |
| UserMarker2 | Text (50) | A temporary marker or keyword assigned by user for searching and sorting purposes while a group is reviewed. Any information can be entered here, but it will be visible only internally. | - | I |
| Problem | Text (255) | Temporary problem with data entry (not with the taxon, cmp. ReportedNote/InternalNote for permanent notes on problems). | - | - |
| CheckPlausible_User | Text (50) | Name of user responsible for a first plausibility or consistency check. User and Date are automatically filled if 'Original check' performed directly. | - | - |
| CheckPlausible_Date | Date/Time | Date and time when plausibility/consistency was checked (i.e. data entry rules and spelling errors checked, no comparison with original publication). | - | - |
| CheckOriginal_User | Text (50) | Name of user responsible for comparison of taxon record with original publication. | - | - |
| CheckOriginal_Date | Date/Time | Date and time when entry was compared with the original publication. | - | - |
| LogCreated_User | Text (50) | 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 | - |
| LogCreated_Date | Date/Time | Date and time when record was first entered (typed or imported) into this system. Default value: Now() |
R | - |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | OpinionID (Primary key; Unique values) | |||
| ProjectMarker: | ProjectMarker; Responsible; NomID (Unique values) | |||
| RefID: | RefID (Duplicates OK) | |||
| Status: | Status (Duplicates OK) | |||
| TaxonomyTaxonTaxonomyOpinion: | NomID (Duplicates OK) | |||
| UserMarker1: | UserMarker1 (Duplicates OK) | |||
| UserMarker2: | UserMarker2 (Duplicates OK) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | TaxonomyOpinion.OpinionID « TaxonomyCitedSpecimen.OpinionID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomyOpinion.NomID | |||
Taxonomy: Synonymization of species. Each responsible user can create an independent system.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| ProjectMarker | Text (25) | Each project can have a different opinion regarding synonmy. Refers to the common project definition in the user module. | R | I (UM) |
| NomID | Long | Synonym name. Refers to the NomID code of TaxonomyName (= foreign key). | R | I |
| ProParteMarker | Byte | 0 = only a single accepted name is possible for a given synonym. 1..255 = multiple valid names are allowed for pro parte ('p.p.') synonyms. Use 1 for the first pro parte name, 2 for the second, and so on. Please do not use 0 for 1st, 2nd, etc. name! Default value: 0 |
R | - |
| Accepted_NomID | Long | Accepted name within a project. Refers to the NomID code of TaxonomyName (= foreign key). | R | I/I |
| ObligateSynonym | Boolean | True (= checked) indicates an obligate synonym, based on the same type; False (= empty) a facultative (or taxonomic) synonym. Null (= gray checkbox) indicates that the synonymization status could not be decided. Default value: Null |
- | - |
| InternalNote | Memo | An internal note of the responsible person concerning this synonymization. This information is NOT included in any report. | R | - |
| RefID | Text (20) | If the synonymization is based on a publication: the reference ID of that work. Refers to the ID code of the main ReferenceTitle table in the reference module (= foreign key). | - | I |
| RefDescriptionCache | Text (255) | If the synonymization is based on a publication: the reference description of that work. | - | - |
| RefPage | Text (50) | If the synonymization is based on a publication: relevant detail; usually page number where the synonymization is published. | - | - |
| Responsible | Text (50) | The person responsible for this synonymy opinion. Validation rule: Not Is Null, validation message: Each synonymization must be signed by a responsible person. |
R | - |
| LogCreated_User | Text (50) | 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 | - |
| LogCreated_Date | Date/Time | Date and time when record was first entered (typed or imported) into this system. Default value: Now() |
R | - |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | ProjectMarker; NomID; ProParteMarker (Primary key; Unique values) | |||
| RefID: | RefID (Duplicates OK) | |||
| TaxonomyNameTaxonomySynonymy: | NomID (Duplicates OK) | |||
| TaxonomyNameTaxonomySynonymy1: | Accepted_NomID (Duplicates OK) | |||
| Valid_NomID: | Accepted_NomID (Duplicates OK) | |||
| Relation type: | Fields involved | |||
| Referential integrity | TaxonomyName.NomID « TaxonomySynonymy.NomID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomySynonymy.Accepted_NomID | |||
Taxonomy: Hierarchy above the species. Each responsible user can create an independent taxonomic system.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| ProjectMarker | Text (25) | Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the user module. | - | I (UM) |
| NomID | Long | Unique ID code of the higher taxon. Refers to the NomID code of TaxonomyName (= foreign key). | - | I/I |
| Parent_NomID | Long | Next higher taxon (e.g. the family or subfamily if this taxon is a genus). | R | I/I |
| ReportedNote | Text (255) | Taxonomic remarks that will be output after the taxon in a report. | - | - |
| InternalNote | Memo | An internal note of the responsible person concerning this taxon. This information is NOT included in any report. | - | - |
| RefID | Text (20) | If the classification is based on a publication: the reference ID of that work. | - | I |
| RefDescriptionCache | Text (255) | If the classification is based on a publication: the reference description of that work. | - | - |
| RefPage | Text (50) | If the classification is based on a publication: relevant detail; usually page number where the opinion is published. | - | - |
| Responsible | Text (50) | The person responsible for grouping this taxon into a higher taxon. Validation rule: Not Is Null, validation message: Each taxonomic opinion must be signed by a responsible person. |
R | - |
| LogCreated_User | Text (50) | 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. | - | - |
| LogCreated_Date | Date/Time | Date and time when record was first entered (typed or imported) into this system. Default value: Now() |
- | - |
| HierarchyListCache | Text (255) | CALCULATED FIELD: List of higher taxa for faster access: "div.; class; ord.; fam.". | - | - |
| Index name: | Attributes & index properties | |||
| NomID: | NomID (Duplicates OK) | |||
| Parent_NomID: | Parent_NomID (Duplicates OK) | |||
| PrimaryKey: | ProjectMarker; NomID (Primary key; Unique values) | |||
| RefID: | RefID (Duplicates OK) | |||
| TaxonomyNameTaxonomyHierarchy: | Parent_NomID (Duplicates OK) | |||
| TaxonomyTaxonTaxonomyHierarchy: | NomID (Duplicates OK) | |||
| Relation type: | Fields involved | |||
| Referential integrity | TaxonomyName.NomID « TaxonomyHierarchy.Parent_NomID | |||
| Referential integrity | TaxonomyName.NomID « TaxonomyHierarchy.NomID | |||
Taxonomy: A technical log of changes of taxonomic or nomenclatural information maintained automatically by the database (user, date, entities & attributes affected).
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| NomID | Long | The ID of the taxon that was changed by the user. Refers to the NomID code of TaxonomyName (= foreign key). | R | I |
| Changes | Memo | Attributes and data affected by changes, details of changes. | R | - |
| LogUpdated_User | Text (50) | Name of user who last updated the record. This is the operator (or typist) name, which may be different from the person responsible. | R | - |
| LogUpdated_Date | Date/Time | Date and time of last update of the record. | R | I (UM) |
| s_GUID | GUID | (system attribute used in database replication). Default value: GenGUID() |
- | I (U) |
| s_Generation | Long | (system attribute used in database replication). | - | I |
| s_Lineage | OLE Object | (system attribute used in database replication). | - | - |
| Index name: | Attributes & index properties | |||
| NomID: | NomID (Duplicates OK) | |||
| PrimaryKey: | LogUpdated_Date; NomID (Primary key; Unique values) | |||
| s_Generation: | s_Generation (Duplicates OK) | |||
| s_GUID: | s_GUID (Unique values) | |||
Taxonomy: Specimen (esp. type specimens) that have been studied or shall be cited in a taxonomic monograph.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| CitedSpecimenID | Autonumber | Unique ID for the record (primary key). | - | I (U) |
| OpinionID | Long | All cited specimens must refer to a taxonomic opinion that defines a NomID, project marker, and responsible scientist (foreign key). | R | I/I |
| CollectionAcronym | Text (50) | Standard abbreviation of the specimen collection from which the studied specimen was obtained (e.g. 'B' for Berlin herbarium). | - | - |
| CollectionSpecimenID | Text (255) | Used only when a specimen record is available in a compatible collection database subsystem; refers to CollectionSpecimenID in that system (foreign key). | - | I |
| TypeStatus | Text (255) | Type, holotype, syntype, paratype, isotype, lectotype, neotype, epitype, etc. | - | - |
| ReportedNote | Memo | Annotation regarding the studied specimen that will be output after the taxon in a report. | - | - |
| InternalNote | Memo | An internal note of the responsible person concerning the studied specimen. This information is NOT included in any report. | R | - |
| Studied | Boolean | False = the specimen is known to exist, but has not (perhaps not yet) been studied by the person named under Responsible. Default value: 0 |
R | - |
| IncludeInReport | Boolean | False = the information on the studied specimen is suppressed in reports, but can be maintained in the database. Default value: True |
R | - |
| Index name: | Attributes & index properties | |||
| CollectionSpecimenID: | CollectionSpecimenID (Duplicates OK) | |||
| OpinionID: | OpinionID (Duplicates OK) | |||
| PrimaryKey: | CitedSpecimenID (Primary key; Unique values) | |||
| TaxonomyOpinionTaxonomyCitedSpecimen: | OpinionID (Duplicates OK) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | TaxonomyOpinion.OpinionID « TaxonomyCitedSpecimen.OpinionID | |||
Taxonomy: tax. ranks ranging from subforma to superregnum.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RankID | Byte | The logical order of ranks (and display order), can be tested to find false hierarchizations or combinations Do not change the code, it is used in several restriction queries! | R | I (U) |
| RankCode | Text (20) | A unique user readable code for the taxonomic rank that is used in TaxonomyName. | R | - |
| Description | Text (255) | Single line description of the rank. | - | - |
| Output | Text (255) | Output elements for the rank, stored as a list of two elements (prefix string-semicolon-postfix string). | - | - |
| Notes | Text (255) | Internal development notes regarding the taxonomic rank. | - | - |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | RankID (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates cascade | TaxonomyRank.RankID « TaxonomyName.TaxonomicRank | |||
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: U = unique index, N = Null values are ignored in the index, M = the index contains more than one attribute. In the first column the names of attributes that are part of the primary key are underlined.
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.
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 16. Feb. 2001; last update: 2005-03-30, email address revised 2010-08-05.