Documentation created on 5. May 2001; last update: 2005-03-30, email address revised 2010-08-05.
By G. Hagedorn, 2001
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: IndexingSource, IndexingSourceAnnotation, OrganismInteractionConditions, OrganismInteractionInterpretation, OrganismInteractionObservation, OrganismInteractionReference, OrganismInteractionType, OrganismPart, OrganismResource, OrganismStage.
(You can click on the entities to go to the attribute tables.)
A source (reference or specimen) for 1 to many OrganismInteractionObservation or OrganismResource (esp. images) records.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| SourceID | Autonumber | A number that uniquely identifies a source for indexing projects, e.g. indexing organism interactions or images (primary key). Default value: GenUniqueID() |
- | I (U) |
| SourceCategory | Byte | Required classification of the information source (reference, label, etc.) for special indexing records (e.g. organism interaction observations). | R | I |
| QualityCategory | Byte | Optional: Data quality of this source. The values must come from the associated pick list. | - | I |
| QualityNotes | Memo | Additional notes referring to the estimation of data quality for this source. | - | - |
| RefID | Text (20) | 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). | - | I (U) |
| RefDescriptionCache | Text (255) | If source is a publication: a short human readable description of the reference, obtained through the RefID from the reference subsystem (calculated field). | - | - |
| CollectionAbbreviation | Text (100) | 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. | - | - |
| CollectionSpecimenID | Text (255) | 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). | - | I (UN) |
| CollectionSpecimenDescription | Text (255) | 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. | - | - |
| AreaCoordinateSystem | Text (255) | The point coordinate system used in the attribute 'OriAreaCoordinates' of the entity 'OrganismInteractionObservation'. | - | - |
| AreaGridCoordSystem | Text (255) | The grid cell coordinate system used in the attribute 'OriAreaGridCoord' of the entity 'OrganismInteractionObservation'. | - | - |
| DefaultInteractionType | Byte | If organism interactions (incl. geogr. distribution) are indexed: the default interaction type used for new observations recorded from this source. | - | I |
| DefaultInteractionConditions | Byte | If organism interactions (incl. geogr. distribution) are indexed: the default interaction conditions used for new observations recorded from this source. Default value: 10 |
- | I |
| DefaultResourceCategory | Byte | If resources (esp. images printed in a book) are indexed: the default resource category used for new observations recorded from this source. | - | I |
| 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 | |||
| CollectionSpecimenID: | CollectionSpecimenID (Unique values; Ignore Nulls) | |||
| OrganismInteractionConditio...: | DefaultInteractionConditions (Duplicates OK) | |||
| OrganismInteractionTypeInde...: | DefaultInteractionType (Duplicates OK) | |||
| PrimaryKey: | SourceID (Primary key; Unique values) | |||
| RefID: | RefID (Unique values) | |||
| USys_SpecialIndexingObjects...: | SourceCategory (Duplicates OK) | |||
| USys_SpecialIndexingObjects...: | DefaultResourceCategory (Duplicates OK) | |||
| USys_SpecialIndexingQuality...: | QualityCategory (Duplicates OK) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | IndexingSource.SourceID « IndexingSourceAnnotation.SourceID | |||
| Updates cascade | IndexingSource.SourceID « OrganismInteractionObservation.SourceID | |||
| Updates cascade | IndexingSource.SourceID « OrganismResource.SourceID | |||
| Updates cascade | OrganismInteractionConditions.ConditionID « IndexingSource.DefaultInteractionConditions | |||
| Updates cascade | OrganismInteractionType.InteractionTypeID « IndexingSource.DefaultInteractionType | |||
| Updates cascade | USys_SpecialIndexingObjects.CategoryID « IndexingSource.SourceCategory | |||
| Updates cascade | USys_SpecialIndexingObjects.CategoryID « IndexingSource.DefaultResourceCategory | |||
| Updates cascade | USys_SpecialIndexingQuality.QualityCategoryID « IndexingSource.QualityCategory | |||
Annotation concerning a single information source, esp. regarding data entry or import, editing acknowledgements, or copyright agreements.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| SourceID | Long | Source ID, links annotation with 'IndexingSource' (= foreign key). | R | I/I (UM) |
| AnnotationDate | Date/Time | The date when the annotation was entered into the system. Default value: Now() |
R | - |
| AnnotationType | Text (255) | Type of annotation, esp. 'data capture notes', 'data import notes', 'editing notes', 'copyright agreements', etc. | R | - |
| Responsible | Text (50) | Person responsible for the source annotation. | R | - |
| Annotation | Memo | The text of the annotation. Internal information, no web access! | R | - |
| Index name: | Attributes & index properties | |||
| IndexingSourceIndexingSourc...: | SourceID (Duplicates OK) | |||
| PrimaryKey: | SourceID; AnnotationDate (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | IndexingSource.SourceID « IndexingSourceAnnotation.SourceID | |||
Definitions of types of condition for organism interactions (natural, commercial growth, garden/zoo, experimental, etc.).
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| ConditionID | Byte | Unique ID number of this interaction condition (primary key). | R | I (U) |
| ConditionAbbreviation | Text (15) | Short code for the interaction condition, displayed to user. | R | - |
| ConditionDescription | Text (255) | Description of interaction condition. | R | - |
| ConditionNotes | Memo | Internal development notes about an interaction condition. | - | - |
| DisplayOrder | Long | The order in which the entries are displayed. Validation rule: >0 |
R | I (U) |
| DisplayEnable | Boolean | The entries are displayed only if marked here. Default value: -1 |
R | - |
| Index name: | Attributes & index properties | |||
| DisplayOrder: | DisplayOrder (Unique values) | |||
| PrimaryKey: | ConditionID (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates cascade | OrganismInteractionConditions.ConditionID « IndexingSource.DefaultInteractionConditions | |||
| Updates cascade | OrganismInteractionConditions.ConditionID « OrganismInteractionInterpretation.EdtInteractionConditions | |||
| Updates cascade | OrganismInteractionConditions.ConditionID « OrganismInteractionObservation.OriInteractionConditions | |||
Interpretation and evaluation by a scientist of an organism interaction in OrganismInteractionObservation.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| SourceID | Long | Source ID, links observations with a reference (literature reference, specimen label, etc. ) in 'IndexingSource' (= foreign key). | R | I (M)/I (UM) |
| ObservationDisplayOrder | Long | Refers to DisplayOrder of 'OrganismInteractionObservation', thus identifying a single observation record (= foreign key). | R | - |
| EdtDate | Date/Time | Date and time when the last editing was performed. Default value: Now() |
- | - |
| EdtInteractionType | Byte | Organism interaction type (e.g. parasitism, mutualism, etc.). Refers to categories defined in 'OrganismInteractionType' (= foreign key). | R | I |
| EdtInteractionConditions | Byte | Conditions under which the interaction occurred (e.g. 'natural', 'artificial', 'experimental'). Refers to conditions defined in 'OrganismInteractionConditions' (= foreign key). | R | I |
| EdtOrganism | Text (255) | 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! | - | I (N) |
| EdtOrganismQuality | Byte | 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! | - | I |
| EdtOrganismStage | Long | Life- or spore stages of 1st organism in standard (constrained) terminology. | - | I (N)/I |
| EdtOrganismPart | Long | Part/organ of 1st organism in standard (constrained) terminology (example: pycnidia on twigs...). | - | I/I |
| EdtOrganismNotes | Memo | Notes/remarks regarding the evaluation/interpretation of 1st organism, its stages, parts and identification quality. | - | - |
| EdtOrganism2 | Text (255) | 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! | - | I (N) |
| EdtOrganism2Quality | Byte | 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! | - | I |
| EdtOrganism2Stage | Long | Affected life stages of 2nd organism (e.g. host plant) in standard (constrained) terminology. Examples for plants: seedling, young plant, grown plant, etc. | - | I (N)/I |
| EdtOrganism2Part | Long | Part/organ of 2nd organism in standard (constrained) terminology (example: root, stem, leaf, flower, etc.). | - | I (N)/I |
| EdtOrganism2Notes | Memo | Notes/remarks regarding the evaluation/interpretation of OriOrganism2, its stages, parts and identification quality. | - | - |
| EdtArea | Text (255) | OriArea interpreted as standard geographic area (current English area name as verified in a gazetteer of geographic names). | - | I (N) |
| EdtAreaQuality | Byte | Estimation of quality of area interpretation, either due to doubt by original author or due to problems in interpretation. | - | I |
| EdtAreaNote | Memo | Notes/remarks regarding the evaluation/interpretation of 'OriArea' to 'EdtArea'. | - | - |
| Problem | Text (255) | Use this field to document a problem with the application during data entry, or make notes to yourself. | - | - |
| EdtResponsible | Text (50) | Person responsible for the editing of an organism interaction observation (e.g. interpreting host and parasite name or identification quality, the geographic area, etc.). | 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 | |||
| EdtArea: | EdtArea (Duplicates OK; Ignore Nulls) | |||
| EdtOrganism: | EdtOrganism (Duplicates OK; Ignore Nulls) | |||
| EdtOrganism2: | EdtOrganism2 (Duplicates OK; Ignore Nulls) | |||
| EdtOrganism2Part: | EdtOrganism2Part (Duplicates OK; Ignore Nulls) | |||
| EdtOrganism2Stage: | EdtOrganism2Stage (Duplicates OK; Ignore Nulls) | |||
| EdtOrganismPart: | EdtOrganismPart (Duplicates OK) | |||
| EdtOrganismStage: | EdtOrganismStage (Duplicates OK; Ignore Nulls) | |||
| OrganismInteractionConditio...: | EdtInteractionConditions (Duplicates OK) | |||
| OrganismInteractionObservat...: | SourceID; ObservationDisplayOrder (Duplicates OK) | |||
| OrganismInteractionTypeOrga...: | EdtInteractionType (Duplicates OK) | |||
| OrganismPartOrganismInterac...: | EdtOrganism2Part (Duplicates OK) | |||
| OrganismPartOrganismInterac...: | EdtOrganismPart (Duplicates OK) | |||
| OrganismStageOrganismIntera...: | EdtOrganismStage (Duplicates OK) | |||
| OrganismStageOrganismIntera...: | EdtOrganism2Stage (Duplicates OK) | |||
| PrimaryKey: | SourceID; ObservationDisplayOrder; EdtDate (Primary key; Unique values) | |||
| USys_SpecialIndexingQuality...: | EdtOrganismQuality (Duplicates OK) | |||
| USys_SpecialIndexingQuality...: | EdtOrganism2Quality (Duplicates OK) | |||
| USys_SpecialIndexingQuality...: | EdtAreaQuality (Duplicates OK) | |||
| Relation type: | Fields involved | |||
| Updates cascade | OrganismInteractionConditions.ConditionID « OrganismInteractionInterpretation.EdtInteractionConditions | |||
| Updates & deletions cascade | OrganismInteractionObservation.SourceID « OrganismInteractionInterpretation.SourceID; OrganismInteractionObservation.DisplayOrder « OrganismInteractionInterpretation.ObservationDisplayOrder | |||
| Updates cascade | OrganismInteractionType.InteractionTypeID « OrganismInteractionInterpretation.EdtInteractionType | |||
| Updates cascade | OrganismPart.OrganismPartID « OrganismInteractionInterpretation.EdtOrganism2Part | |||
| Updates cascade | OrganismPart.OrganismPartID « OrganismInteractionInterpretation.EdtOrganismPart | |||
| Updates cascade | OrganismStage.OrganismStageID « OrganismInteractionInterpretation.EdtOrganismStage | |||
| Updates cascade | OrganismStage.OrganismStageID « OrganismInteractionInterpretation.EdtOrganism2Stage | |||
| Updates cascade | USys_SpecialIndexingQuality.QualityCategoryID « OrganismInteractionInterpretation.EdtOrganismQuality | |||
| Updates cascade | USys_SpecialIndexingQuality.QualityCategoryID « OrganismInteractionInterpretation.EdtOrganism2Quality | |||
| Updates cascade | USys_SpecialIndexingQuality.QualityCategoryID « OrganismInteractionInterpretation.EdtAreaQuality | |||
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. .
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| SourceID | Long | Source ID, links observations with a reference (literature reference, specimen label, etc. ) in 'IndexingSource' (= foreign key). | R | I/I (UM) |
| DisplayOrder | Long | 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. | R | - |
| SourceDetail | Text (50) | 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. | - | - |
| SourceDetailNumCache | Long | (Calculated field, set to the numeric integer part of SourceDetailText, esp. page numbers. Only positive integer numbers can be stored here.). Default value: 0; Validation rule: >=0 |
R | - |
| OriInteractionType | Byte | Organism interaction type (e.g. parasitism, mutualism, etc.). Refers to categories defined in 'OrganismInteractionType' (= foreign key). | R | I |
| OriInteractionConditions | Byte | Conditions under which the interaction occurred (e.g. 'natural', 'artificial', 'experimental'). Refers to conditions defined in 'OrganismInteractionConditions' (= foreign key). | R | I |
| OriInteractionNote | Text (255) | Additional notes on interaction type (e.g. 'only on dead twigs') and interaction conditions (e.g. 'from bot. garden') present in the original source. | - | - |
| OriOrganism | Text (255) | 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]'. | R | I |
| OriOrganismStages | Text (255) | 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. | - | I (N) |
| OriOrganismParts | Text (255) | Part(s) of primary organism. Examples for parasitic fungi: 'pycnidia', 'apothecia', etc. Data entered exactly as in the original source, not translated to English. | - | I |
| OriOrganismCitedSynonyms | Text (255) | 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). | - | I (N) |
| OriOrganismHigherTaxa | Text (255) | The higher taxa given in the original source for the primary organism (optional, entered only if considered relevant). | - | - |
| OriOrganism2 | Text (255) | 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! | - | I |
| OriOrganism2Stages | Text (255) | 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. | - | I (N) |
| OriOrganism2Parts | Text (255) | 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. | - | I (N) |
| OriOrganism2CitedSynonyms | Text (255) | 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). | - | I (N) |
| OriOrganism2HigherTaxa | Text (255) | The higher taxa given in the original source for the associated organism (optional, entered only if considered relevant). | - | - |
| OriArea | Text (255) | Geographical area as written in the original source (in the original form and language, not translated to standard terminology, compare EdtArea). | - | I (N) |
| OriAreaDetail | Text (255) | 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'. | - | - |
| OriAreaPointCoordinates | Text (255) | 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. | - | - |
| OriAreaGridCoordinates | Text (255) | 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. | - | - |
| OriNotes | Memo | Additional information or annotations as they appear in the original source. | - | - |
| OriSymptoms | Memo | Optionally: symptoms given by original author for a specific observation. Symptoms may depend on the host, and even on the geographical origin! | - | - |
| OriDescriptionPresent | Boolean | Optionally: information whether morphological descriptions for OriOrganism are present; these may e.g. be important for the interpretation of the taxonomic concept. Default value: 0 |
R | - |
| OriCollectors | Text (255) | Optionally: collector(s) of the original material (also: exsiccatum information), if cited in the source reference. | - | - |
| OriCollectionDate | Text (255) | 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'). | - | - |
| 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 | |||
| IndexingSourceOrganismInter...: | SourceID (Duplicates OK) | |||
| OrganismInteractionConditio...: | OriInteractionConditions (Duplicates OK) | |||
| OrganismInteractionTypeOrga...: | OriInteractionType (Duplicates OK) | |||
| OriArea: | OriArea (Duplicates OK; Ignore Nulls) | |||
| OriOrganism: | OriOrganism (Duplicates OK) | |||
| OriOrganism2: | OriOrganism2 (Duplicates OK) | |||
| OriOrganism2CitedSynonyms: | OriOrganism2CitedSynonyms (Duplicates OK; Ignore Nulls) | |||
| OriOrganism2Part: | OriOrganism2Parts (Duplicates OK; Ignore Nulls) | |||
| OriOrganism2Stage: | OriOrganism2Stages (Duplicates OK; Ignore Nulls) | |||
| OriOrganismCitedSynonyms: | OriOrganismCitedSynonyms (Duplicates OK; Ignore Nulls) | |||
| OriOrganismPart: | OriOrganismParts (Duplicates OK) | |||
| OriOrganismStage: | OriOrganismStages (Duplicates OK; Ignore Nulls) | |||
| PrimaryKey: | SourceID; DisplayOrder (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates cascade | IndexingSource.SourceID « OrganismInteractionObservation.SourceID | |||
| Updates cascade | OrganismInteractionConditions.ConditionID « OrganismInteractionObservation.OriInteractionConditions | |||
| Updates & deletions cascade | OrganismInteractionObservation.SourceID « OrganismInteractionInterpretation.SourceID; OrganismInteractionObservation.DisplayOrder « OrganismInteractionInterpretation.ObservationDisplayOrder | |||
| Updates & deletions cascade | OrganismInteractionObservation.SourceID « OrganismInteractionReference.SourceID; OrganismInteractionObservation.DisplayOrder « OrganismInteractionReference.ObservationDisplayOrder | |||
| Updates cascade | OrganismInteractionType.InteractionTypeID « OrganismInteractionObservation.OriInteractionType | |||
Each interaction observation ('OrganismInteractionObservation') may quote several references.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| SourceID | Long | Source ID, links observations with a reference (literature reference, specimen label, etc. ) in 'IndexingSource' (= foreign key). | R | I (M)/I/I (UM) |
| ObservationDisplayOrder | Long | Refers to 'DisplayOrder' of 'OrganismInteractionObservation' (= foreign key). | R | - |
| OriCitedReference | Text (255) | 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). | R | - |
| CitedRefID | Text (20) | The reference ID (RefID) of those references that can be identified in the linked references module (= foreign key). | - | I |
| CitedRefDescriptionCache | Text (255) | A short human readable description of the reference, obtained through the RefID from the reference subsystem (calculated field). | - | - |
| CitedRefDetail | Text (255) | 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. | - | - |
| TranscriptionNotes | Memo | Notes and comments, esp. regarding problems or doubt in the association between the original work and the. | - | - |
| TranscriptionResponsible | Text (50) | Person responsible for the transcription of OriCitedReference to CitedReferenceID. | - | - |
| TranscriptionOperator | Text (50) | 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. | - | - |
| TranscriptionDate | Date/Time | Date and time when transcription occurred. Default value: Now() |
R | - |
| Index name: | Attributes & index properties | |||
| CitedReferenceID: | CitedRefID (Duplicates OK) | |||
| OrganismInteractionObservat...: | SourceID; ObservationDisplayOrder (Duplicates OK) | |||
| OrganismInteractionReferenc...: | SourceID (Duplicates OK) | |||
| PrimaryKey: | SourceID; ObservationDisplayOrder; OriCitedReference (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | OrganismInteractionObservation.SourceID « OrganismInteractionReference.SourceID; OrganismInteractionObservation.DisplayOrder « OrganismInteractionReference.ObservationDisplayOrder | |||
Definitions of types of organism interactions (parasitism, mutualism, etc.).
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| InteractionTypeID | Byte | Unique ID number of this interaction type (primary key). | R | I (U) |
| InteractionAbbreviation | Text (20) | Short code for the interaction type, displayed to user. | R | - |
| InteractionDescription | Text (255) | Description of interaction type (e.g. parasitism, mutualism, etc.). | R | - |
| Org1CustomLabel | Text (255) | Label displayed in user interface for primary organism. The default label is used when left empty. | - | - |
| Org2CustomLabel | Text (255) | Label displayed in user interface for associated organism (Organism2). The default label is used when left empty. | - | - |
| Org1Group | Text (255) | The organism group, as used in parts definitions. Empty if all groups apply. | - | - |
| Org2Group | Text (255) | The organism group for 2nd organism, as used in parts definitions. Empty if all groups apply. | - | - |
| InteractionNotes | Memo | Internal development notes about an interaction type. | - | - |
| ParentType | Byte | Defines a more widely defined interaction type that include the current type. | - | I |
| DisplayOrder | Long | The order in which the entries are displayed. Validation rule: >0 |
R | I (U) |
| DisplayEnable | Boolean | The entries are displayed only if marked here. | R | - |
| Index name: | Attributes & index properties | |||
| DisplayOrder: | DisplayOrder (Unique values) | |||
| OrganismInteractionTypeOrga...: | ParentType (Duplicates OK) | |||
| PrimaryKey: | InteractionTypeID (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates cascade | OrganismInteractionType.InteractionTypeID « IndexingSource.DefaultInteractionType | |||
| Updates cascade | OrganismInteractionType.InteractionTypeID « OrganismInteractionInterpretation.EdtInteractionType | |||
| Updates cascade | OrganismInteractionType.InteractionTypeID « OrganismInteractionObservation.OriInteractionType | |||
| Updates cascade | OrganismInteractionType.InteractionTypeID « OrganismInteractionType.ParentType | |||
Definitions of organism parts (or 'organs') in standard (constrained) terminology. A set of parts can and should be defined separately for each organism group.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| OrganismPartID | Autonumber | A number that uniquely identifies an organism part (primary key). Default value: GenUniqueID() |
- | I (U) |
| OrganismGroup | Text (255) | The type of organism to which a set of part descriptions is applicable (plant, fungus, etc.). Default value: "plant" |
R | I (UM) |
| OrganismPart | Text (20) | Defines a part (or 'organ') of an organism of OrganismGroup in a standard (constrained) terminology. Abbreviated text displayed to user. | - | - |
| Description | Text (255) | Supplementary explanation of the entry. | - | - |
| DescriptionDe | Text (255) | Supplementary explanation of the entry (German). | - | - |
| Notes | Text (255) | Internal development notes. | - | - |
| ParentPartID | Long | Defines a parent organism part that includes the current part. | - | I |
| DisplayOrder | Long | The order in which the entries are displayed. Validation rule: >0 |
R | I (U) |
| DisplayEnable | Boolean | The entries are displayed only if marked here. Default value: -1 |
R | - |
| Index name: | Attributes & index properties | |||
| DisplayOrder: | DisplayOrder (Unique values) | |||
| OrganismPartOrganismPart: | ParentPartID (Duplicates OK) | |||
| PrimaryKey: | OrganismPartID (Primary key; Unique values) | |||
| Unique: | OrganismGroup; OrganismPart (Unique values) | |||
| Relation type: | Fields involved | |||
| Updates cascade | OrganismPart.OrganismPartID « OrganismInteractionInterpretation.EdtOrganism2Part | |||
| Updates cascade | OrganismPart.OrganismPartID « OrganismInteractionInterpretation.EdtOrganismPart | |||
| Updates cascade | OrganismPart.OrganismPartID « OrganismPart.ParentPartID | |||
Index of resources describing organisms, esp. images, drawings, photographs. The source reference is described in 'IndexingSource'.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| SourceID | Long | Source ID, links resource with a reference (literature reference, specimen label, etc. ) in 'IndexingSource' (= foreign key). | R | I/I (UM) |
| DisplayOrder | Long | 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. | R | - |
| SourceDetail | Text (50) | 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. | - | - |
| SourceDetailNumCache | Long | (Calculated field, set to the numeric integer part of SourceDetailText, esp. page numbers. Only positive integer numbers can be stored here.). Default value: 0; Validation rule: >=0 |
R | - |
| ResourceCategory | Byte | Resource category (e.g. drawing, photograph, b/w or color). | R | I |
| ResourceNumber | Text (255) | Number of figure etc. as used in the source. Example: 'Fig. 23'. | - | - |
| OriOrganism | Text (255) | 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]'. | R | I |
| EdtOrganism | Text (255) | 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! | - | I |
| EdtOrganismNotes | Memo | Notes/remarks regarding the evaluation/interpretation of organism, its parts and identification quality. | - | - |
| OriOrganismParts | Text (255) | Organism parts. Example for parasitic fungi: 'pycnidia;apothecia', etc. Entered as ';' separated list using English terminology. | - | I |
| OriOrganismCitedSynonyms | Text (255) | 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). | - | I |
| OriNotes | Memo | Additional information or annotations as they appear in the original source. | - | - |
| 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 | - |
| Filename | Text (255) | 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!). | - | - |
| Index name: | Attributes & index properties | |||
| EdtOrganism: | EdtOrganism (Duplicates OK) | |||
| IndexingSourceOrganismResource: | SourceID (Duplicates OK) | |||
| OriOrganism: | OriOrganism (Duplicates OK) | |||
| OriOrganismCitedSynonyms: | OriOrganismCitedSynonyms (Duplicates OK) | |||
| OriOrganismPart: | OriOrganismParts (Duplicates OK) | |||
| PrimaryKey: | SourceID; DisplayOrder (Primary key; Unique values) | |||
| USys_SpecialIndexingObjects...: | ResourceCategory (Duplicates OK) | |||
| Relation type: | Fields involved | |||
| Updates cascade | IndexingSource.SourceID « OrganismResource.SourceID | |||
| Updates cascade | USys_SpecialIndexingObjects.CategoryID « OrganismResource.ResourceCategory | |||
Definitions of organism life stages in standard (constrained) terminology. A set of life stages can and should be defined separately for each organism group.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| OrganismStageID | Autonumber | A number that uniquely identifies an organism life stage (primary key). Default value: GenUniqueID() |
- | I (U) |
| OrganismGroup | Text (255) | The type of organism to which a set of life stage categories is applicable (plant, fungus, etc.). | R | I (UM) |
| OrganismStage | Text (20) | 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. | - | - |
| Description | Text (255) | Supplementary explanation of the entry. | - | - |
| DescriptionDe | Text (255) | Supplementary explanation of the entry (German). | - | - |
| Notes | Text (255) | Internal development notes. | - | - |
| DisplayOrder | Long | The order in which the entries are displayed. Validation rule: >0 |
R | I (U) |
| DisplayEnable | Boolean | The entries are displayed only if marked here. Default value: -1 |
R | - |
| StandardStage | Text (255) | (rust standard stage transformation prepared by M. Scholler). | - | - |
| Index name: | Attributes & index properties | |||
| DisplayOrder: | DisplayOrder (Unique values) | |||
| OrganismStageID: | OrganismStageID (Primary key; Unique values) | |||
| Unique: | OrganismGroup; OrganismStage (Unique values) | |||
| Relation type: | Fields involved | |||
| Updates cascade | OrganismStage.OrganismStageID « OrganismInteractionInterpretation.EdtOrganismStage | |||
| Updates cascade | OrganismStage.OrganismStageID « OrganismInteractionInterpretation.EdtOrganism2Stage | |||
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 5. May 2001; last update: 2005-03-30, email address revised 2010-08-05.