Diversity Workbench: Schema for DiversityReferencesData_Indexing, version '0.9'.
Document last revised on 5.Mai.2001 23:59
Copyright 2001 G. Hagedorn. All rights reserved.
Suggestions how to correct or improve the schema are welcome! A source (reference or specimen) for 1 to many OrganismInteractionObservation or OrganismResource (esp. images) records. A number that uniquely identifies a source for indexing projects, e.g. indexing organism interactions or images (primary key). Required classification of the information source (reference, label, etc.) for special indexing records (e.g. organism interaction observations). Optional: Data quality of this source. The values must come from the associated pick list. Additional notes referring to the estimation of data quality for this source. If source is a publication: the reference ID of that work. Refers to the ID code of the main ReferenceTitle table in the reference module (= foreign key). If source is a publication: a short human readable description of the reference, obtained through the RefID from the reference subsystem (calculated field). If source is a specimen: Standard abbreviation of the collection from which the specimen was obtained (e.g. 'B' for Berlin herbarium). The full name is used if no acronym is available. If source is a specimen: Used only when a specimen record is available in a compatible collection database subsystem; refers to CollectionSpecimenID in that system (foreign key). If source is a specimen: Optionally used for accession number or storage location name (which may be different from current scientific name!), esp. if CollectionSpecimenID cannot be used because no compatible collection database subsystem is available. The point coordinate system used in the attribute 'OriAreaCoordinates' of the entity 'OrganismInteractionObservation'. The grid cell coordinate system used in the attribute 'OriAreaGridCoord' of the entity 'OrganismInteractionObservation'. If organism interactions (incl. geogr. distribution) are indexed: the default interaction type used for new observations recorded from this source. If organism interactions (incl. geogr. distribution) are indexed: the default interaction conditions used for new observations recorded from this source. If resources (esp. images printed in a book) are indexed: the default resource category used for new observations recorded from this source. 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. Date and time when record was first entered (= typed or imported) into this system. Annotation concerning a single information source, esp. regarding data entry or import, editing acknowledgements, or copyright agreements. Source ID, links annotation with 'IndexingSource' (= foreign key). The date when the annotation was entered into the system. Type of annotation, esp. 'data capture notes', 'data import notes', 'editing notes', 'copyright agreements', etc. Person responsible for the source annotation. The text of the annotation. Internal information, no web access! Definitions of types of condition for organism interactions (natural, commercial growth, garden/zoo, experimental, etc.). Unique ID number of this interaction condition (primary key). Short code for the interaction condition, displayed to user. Description of interaction condition. Internal development notes about an interaction condition. The order in which the entries are displayed. The entries are displayed only if marked here. Interpretation and evaluation by a scientist of an organism interaction in OrganismInteractionObservation. Source ID, links observations with a reference (literature reference, specimen label, etc. ) in 'IndexingSource' (= foreign key). Refers to DisplayOrder of 'OrganismInteractionObservation', thus identifying a single observation record (= foreign key). Date and time when the last editing was performed. Organism interaction type (e.g. parasitism, mutualism, etc.). Refers to categories defined in 'OrganismInteractionType' (= foreign key). Conditions under which the interaction occurred (e.g. 'natural', 'artificial', 'experimental'). Refers to conditions defined in 'OrganismInteractionConditions' (= foreign key). OriOrganism interpreted as standard name. Enter the name as closely as possible, enter valid name of a synonym only if synonymization is not already defined in the tax. thesaurus! Estimation of identification quality of 1st organism, either due to doubt by original author (e.g. a "cf. name" given) or due to problems in interpretation. Note that there is a separate category for type material! Life- or spore stages of 1st organism in standard (constrained) terminology. Part/organ of 1st organism in standard (constrained) terminology (example: pycnidia on twigs...). Notes/remarks regarding the evaluation/interpretation of 1st organism, its stages, parts and identification quality. OriOrganism2 interpreted. Enter the name as closely as possible, enter valid name of a synonym only of synonymization is not already defined in the tax. thesaurus! Estimation of identification quality of EdtOrganism2, either due to doubt by original author (e.g. a "cf. name" given) or due to problems in interpretation. Note that there is a separate category for type material! Affected life stages of 2nd organism (e.g. host plant) in standard (constrained) terminology. Examples for plants: seedling, young plant, grown plant, etc. Part/organ of 2nd organism in standard (constrained) terminology (example: root, stem, leaf, flower, etc.). Notes/remarks regarding the evaluation/interpretation of OriOrganism2, its stages, parts and identification quality. OriArea interpreted as standard geographic area (current English area name as verified in a gazetteer of geographic names). Estimation of quality of area interpretation, either due to doubt by original author or due to problems in interpretation. Notes/remarks regarding the evaluation/interpretation of 'OriArea' to 'EdtArea'. Use this field to document a problem with the application during data entry, or make notes to yourself. Person responsible for the editing of an organism interaction observation (e.g. interpreting host and parasite name or identification quality, the geographic area, etc.). 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. Date and time when record was first entered (= typed or imported) into this system. Interaction observations (parasitism, mutualism, etc.) as reported in a specific source reference concerning 1 or 2 organisms (and optionally a geographic area), including information about affected parts, life stages, symptoms, etc. . Source ID, links observations with a reference (literature reference, specimen label, etc. ) in 'IndexingSource' (= foreign key). Defines ordering of observations. A simple sequence with step 100 is automatically created for new records; records can be moved or inserted between existing records by changing this number. Information where observation can be found in source. In the case of page numbers (incl. roman numbers) simply enter the number, else precede with 'Tab.', 'Fig.', etc. (Calculated field, set to the numeric integer part of SourceDetailText, esp. page numbers. Only positive integer numbers can be stored here.). Organism interaction type (e.g. parasitism, mutualism, etc.). Refers to categories defined in 'OrganismInteractionType' (= foreign key). Conditions under which the interaction occurred (e.g. 'natural', 'artificial', 'experimental'). Refers to conditions defined in 'OrganismInteractionConditions' (= foreign key). Additional notes on interaction type (e.g. 'only on dead twigs') and interaction conditions (e.g. 'from bot. garden') present in the original source. Name of the primary organism (e.g. a parasite), exactly as present in the original source, without corrections. If a common name is given in addition to a scientific name, it should be included in brackets: 'Acer saccharum [sugar maple]'. Life stage(s) or spore stages (multiple stages separated with semicolon): anamorph/teleomorph, presence of spore stages like beta conidia; in rusts: aecia/uredinia/telia etc. Data entered exactly as in the original source, not translated to English. Part(s) of primary organism. Examples for parasitic fungi: 'pycnidia', 'apothecia', etc. Data entered exactly as in the original source, not translated to English. Synonyms given in the original publication. Include indications of doubt like '?', use '=' and '≡' (use '3=' if '≡' is unavailable). Use ';' between names. Knowledge of these synonyms may help in understanding the taxon concepts of the original author(s). The higher taxa given in the original source for the primary organism (optional, entered only if considered relevant). Name of the associated organism (e.g. a host/substrate), exactly as present in source, including common/vernacular names in '()'. If only a common name is given in the original source, the scientific name should not be added from other sources! Life stage(s) of associated organism affected by the interaction. Examples for plants: 'seed', 'seedling', 'young plant', etc. Data entered exactly as in the original source, not translated to English. Part(s) of associated organism affected by interaction. Examples for plants: 'root', 'stem', 'leaf', 'flower', etc. Data entered exactly as in the original source, not translated to English. Synonyms given in the original publication. Include indications of doubt like '?', use '=' and '≡' (use '3=' if '≡' is unavailable). Use ';' between names. Knowledge of these synonyms may help in understanding the taxon concepts of the original author(s). The higher taxa given in the original source for the associated organism (optional, entered only if considered relevant). Geographical area as written in the original source (in the original form and language, not translated to standard terminology, compare EdtArea). Details of the geographical area/location; Normally everything below the county or city should be considered a detail. Example: '2 km S of mill pond'. Geographical area coordinates (excluding grid data) for an observation, exactly as given in the source. The coordinate system should normally be specified a single time in AreaCoordinateSystem of IndexingSource. Geographical area grid cell coordinates for an observation, exactly as given in the source. The grid system should normally be specified a single time in AreaGridCoordSystem of IndexingSource. Additional information or annotations as they appear in the original source. Optionally: symptoms given by original author for a specific observation. Symptoms may depend on the host, and even on the geographical origin! Optionally: information whether morphological descriptions for OriOrganism are present; these may e.g. be important for the interpretation of the taxonomic concept. Optionally: collector(s) of the original material (also: exsiccatum information), if cited in the source reference. Optionally: a string specifying a collection date, range, or date parts. Examples: '5-7.1940', '6-9' (i.e. only the months are known). Use the sequence day-month-year (with century, i.e. not '30.12.98'). 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. Date and time when record was first entered (= typed or imported) into this system. Each interaction observation ('OrganismInteractionObservation') may quote several references. Source ID, links observations with a reference (literature reference, specimen label, etc. ) in 'IndexingSource' (= foreign key). Refers to 'DisplayOrder' of 'OrganismInteractionObservation' (= foreign key). The text of a literature or specimen reference cited for an interaction observation, exactly as given in the source. Examples: 'Miller (1920a)', '[471]', or 'H.WB. 4225' (for a specimen). The reference ID (RefID) of those references that can be identified in the linked references module (= foreign key). A short human readable description of the reference, obtained through the RefID from the reference subsystem (calculated field). Detail of cited reference (esp. a page number) on which the referenced information can be found. Do not confuse with the page number of the work evaluated itself (= citing reference), comp. SourceDetail. Notes and comments, esp. regarding problems or doubt in the association between the original work and the. Person responsible for the transcription of OriCitedReference to CitedReferenceID. Name of user who first entered (typed or imported) the transcription (not the entry of 'OriCitedReference'). This is the operator (or typist) name, which may be different from the person responsible. Date and time when transcription occurred. Definitions of types of organism interactions (parasitism, mutualism, etc.). Unique ID number of this interaction type (primary key). Short code for the interaction type, displayed to user. Description of interaction type (e.g. parasitism, mutualism, etc.). Label displayed in user interface for primary organism. The default label is used when left empty. Label displayed in user interface for associated organism (Organism2). The default label is used when left empty. The organism group, as used in parts definitions. Empty if all groups apply. The organism group for 2nd organism, as used in parts definitions. Empty if all groups apply. Internal development notes about an interaction type. Defines a more widely defined interaction type that include the current type. The order in which the entries are displayed. The entries are displayed only if marked here. Definitions of organism parts (or 'organs') in standard (constrained) terminology. A set of parts can and should be defined separately for each organism group. A number that uniquely identifies an organism part (primary key). The type of organism to which a set of part descriptions is applicable (plant, fungus, etc.). Defines a part (or 'organ') of an organism of OrganismGroup in a standard (constrained) terminology. Abbreviated text displayed to user. Supplementary explanation of the entry. Supplementary explanation of the entry (German). Internal development notes. Defines a parent organism part that includes the current part. The order in which the entries are displayed. The entries are displayed only if marked here. #####. A number that uniquely identifies an organism part (primary key). The type of organism to which a set of part descriptions is applicable (plant, fungus, etc.). Defines a part (or 'organ') of an organism of OrganismGroup in a standard (constrained) terminology. Abbreviated text displayed to user. Supplementary explanation of the entry. Internal development notes. Defines a parent organism part that includes the current part. The order in which the entries are displayed. The entries are displayed only if marked here. #####. A number that uniquely identifies an organism part (primary key). The type of organism to which a set of part descriptions is applicable (plant, fungus, etc.). Defines a part (or 'organ') of an organism of OrganismGroup in a standard (constrained) terminology. Abbreviated text displayed to user. Supplementary explanation of the entry. Internal development notes. Defines a parent organism part that includes the current part. The order in which the entries are displayed. The entries are displayed only if marked here. Index of resources describing organisms, esp. images, drawings, photographs. The source reference is described in 'IndexingSource'. Source ID, links resource with a reference (literature reference, specimen label, etc. ) in 'IndexingSource' (= foreign key). Defines ordering of resources (e.g. images). A simple sequence with step 100 is automatically created for new records; records can be moved or inserted between existing records by changing this number. Information where resources (e.g. images) can be found in source. In the case of page numbers (incl. roman numbers) simply enter the number, else precede with 'Tab.', 'Fig.', etc. (Calculated field, set to the numeric integer part of SourceDetailText, esp. page numbers. Only positive integer numbers can be stored here.). Resource category (e.g. drawing, photograph, b/w or color). Number of figure etc. as used in the source. Example: 'Fig. 23'. Name of the organism described by the resource (e.g. illustrated), exactly as in source, without corrections. If a common name is given in addition to a scientific name, it should be included in brackets: 'Acer saccharum [sugar maple]'. OriOrganism interpreted as standard name. Enter the name as closely as possible, enter valid name of a synonym only if synonymization is not already defined in the tax. thesaurus! Notes/remarks regarding the evaluation/interpretation of organism, its parts and identification quality. Organism parts. Example for parasitic fungi: 'pycnidia;apothecia', etc. Entered as ';' separated list using English terminology. Synonyms given in the original publication. Include indications of doubt like '?', use '=' and '≡' (use '3=' if '≡' is unavailable). Use ';' between names. Knowledge of these synonyms may help in understanding the taxon concepts of the original author(s). Additional information or annotations as they appear in the original source. 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. Date and time when record was first entered (= typed or imported) into this system. The file and pathname (or URL) in cases were the resouce has already been digitized (e.g. scanned image) AND copyright is available (document copyright issues under source!). Definitions of organism life stages in standard (constrained) terminology. A set of life stages can and should be defined separately for each organism group. A number that uniquely identifies an organism life stage (primary key). The type of organism to which a set of life stage categories is applicable (plant, fungus, etc.). Life stage to which the organism interaction applies (e.g. developmental stage like seedling, young, adult plant) of an OrganismGroup in a standard (constrained) terminology. Supplementary explanation of the entry. Supplementary explanation of the entry (German). Internal development notes. The order in which the entries are displayed. The entries are displayed only if marked here. (rust standard stage transformation prepared by M. Scholler). rust stage combination. Transformation (mainly after Scholler, 1996: 17). Description German. Description English. (potential root element for the namespace of current database subsystem)