Documentation created on 16. Feb. 2001 14:49; 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: CollectingPerson, CollectionDuplicate, CollectionGeography, CollectionImage, CollectionMaterial, CollectionSpecimen, DiversityProject, Exsiccata, Identification, IdentificationUnit, LocalisationSystem, LocalisationSystemType.
(You can click on the entities to go to the attribute tables.)
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| CollectionSpecimenID | Long | Refers to ID of CollectionSpecimen (= foreign key). Default value: 0 |
R | I/I/I (UM) |
| CollectorsName | Text (255) | Name of the collecting person or group, e.g. "Miller, W.". | - | I |
| CollectorsNumber | Text (255) | Number assigned by the collector during the collection. | - | - |
| Index name: | Attributes & index properties | |||
| CollectionSpecimenCollectingPerson: | CollectionSpecimenID (Duplicates OK) | |||
| CollectionSpecimenID: | CollectionSpecimenID (Duplicates OK) | |||
| CollectorsName: | CollectorsName (Duplicates OK) | |||
| PrimaryKey: | CollectionSpecimenID; CollectorsName (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | CollectionSpecimen.CollectionSpecimenID « CollectingPerson.CollectionSpecimenID | |||
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| CollectionSpecimenID | Long | Refers to ID of CollectionSpecimen (= foreign key). Default value: 0 |
- | I/I/I (UM) |
| AccessionNumber | Text (255) | Accession number of the collection, e.g. "M-3890492". | R | - |
| CollectionName | Text (255) | Name of the collection where the duplicate specimen is deposed. | - | - |
| Notes | Text (255) | User defined notes. | - | - |
| Index name: | Attributes & index properties | |||
| CollectionSpecimenCollectionDuplicate: | CollectionSpecimenID (Duplicates OK) | |||
| CollectionSpecimenID: | CollectionSpecimenID (Duplicates OK) | |||
| PrimaryKey: | CollectionSpecimenID; AccessionNumber (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | CollectionSpecimen.CollectionSpecimenID « CollectionDuplicate.CollectionSpecimenID | |||
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| CollectionSpecimenID | Long | Refers to ID of CollectionSpecimen (= foreign key). Default value: 0 |
- | I/I/I (UM) |
| LocalisationSystemID | Long | Refers to ID of LocationIdentification (= foreign key). Default value: 0 |
- | I/I |
| Location1 | Text (255) | Either a named location selected from a thesaurus (e.g. "Germany, Bavaria, Kleindingharting") or values e.g. 100 - 200 m (for altitude range). | - | - |
| Location2 | Text (255) | Corresponding value to Location2 or ID of Thesaurus. | - | - |
| DeterminationDate | Date/Time | Date of the determination of the geography. | - | - |
| Responsible | Text (255) | Person, team or organisation responsible for the data. | - | - |
| AverageAltitudeCache | Double | Calculated altitude as parsed from the location fields. Default value: 0 |
- | - |
| AverageLongitudeCache | Double | Calculated longitude as parsed from the location fields. Default value: 0 |
- | - |
| AverageLatitudeCache | Double | Calculated latitude as parsed from the location fields. Default value: 0 |
- | - |
| Index name: | Attributes & index properties | |||
| CollectionSpecimenCollectionGeography: | CollectionSpecimenID (Duplicates OK) | |||
| CollectionSpecimenID: | CollectionSpecimenID (Duplicates OK) | |||
| LocalisationSystemCollectionGeography: | LocalisationSystemID (Duplicates OK) | |||
| LocalisationSystemID: | LocalisationSystemID (Duplicates OK) | |||
| PrimaryKey: | CollectionSpecimenID; LocalisationSystemID (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | CollectionSpecimen.CollectionSpecimenID « CollectionGeography.CollectionSpecimenID | |||
| Updates & deletions cascade | LocalisationSystem.LocalisationSystemID « CollectionGeography.LocalisationSystemID | |||
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| CollectionSpecimenID | Long | Refers to ID of CollectionSpecimen (= foreign key). | - | I/I/I (UM) |
| CollectionImageID | Autonumber | ID of the image of the collection specimen. Default value: GenUniqueID() |
- | I |
| IdentificationUnitID | Long | Only given if image refers to a single Unit of CollectionSpecimen, refers to ID of IdentificationUnit (= foreign key). Default value: 0 |
- | I |
| ImagePath | Text (255) | The path and file name of the image. | - | - |
| CollectionProject | Text (255) | Project within DiversityCollection. | - | - |
| Responsible | Text (255) | Person responsible for the image. | - | - |
| Notes | Text (255) | Notes concerning the image, e.g. scale, resolution. See CollectionProject for additional information. | - | - |
| Index name: | Attributes & index properties | |||
| CollectionImageID: | CollectionImageID (Duplicates OK) | |||
| CollectionSpecimenCollectionImage: | CollectionSpecimenID (Duplicates OK) | |||
| CollectionSpecimenID: | CollectionSpecimenID (Duplicates OK) | |||
| IdentificationUnitID: | IdentificationUnitID (Duplicates OK) | |||
| PrimaryKey: | CollectionSpecimenID; CollectionImageID (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | CollectionSpecimen.CollectionSpecimenID « CollectionImage.CollectionSpecimenID | |||
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| Parameter | Text (255) | Name of the parameter, e.g. "TypeStatus". | - | I (UM) |
| Value | Text (255) | Value of the parameter, e.g. "holotypus". | - | - |
| Description | Text (255) | Description of the parameter. | - | - |
| EnableEditing | Boolean | If this item can be edited by the user. | - | - |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | Parameter; Value (Primary key; Unique values) | |||
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| CollectionSpecimenID | Long | Refers to ID of CollectionSpecimen (= foreign key). Default value: 0 |
- | I/I/I (UM) |
| MaterialCategory | Text (255) | Material e.g. "drawings", "slides" etc. Default value: "herbarium specimens" |
- | - |
| StorageLocation | Text (255) | The place resp. taxon where the item is stored within the collection. | - | - |
| Index name: | Attributes & index properties | |||
| CollectionSpecimenCollectionMaterial: | CollectionSpecimenID (Duplicates OK) | |||
| CollectionSpecimenID: | CollectionSpecimenID (Duplicates OK) | |||
| PrimaryKey: | CollectionSpecimenID; MaterialCategory (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | CollectionSpecimen.CollectionSpecimenID « CollectionMaterial.CollectionSpecimenID | |||
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| CollectionSpecimenID | Autonumber | Unique reference ID for the collection record (primary key). Default value: GenUniqueID() |
- | I (U)/I (U) |
| CollectionDate | Date/Time | Calculated date, based on CollectionDay, -Month and -Year. | - | - |
| CollectionDay | Long | The day of the collection event. | - | - |
| CollectionMonth | Long | The month of the collection event. | - | - |
| CollectionYear | Long | The year of the collection event. | - | - |
| CollectionDateSupplement | Text (255) | Additional date information, e.g. "end of summer 1985". | - | - |
| LocalityDescription | Text (255) | Locality and geo-ecological description of the locality as written on the original label. | - | - |
| LabelTitle | Text (255) | Title of label if different from ExsiccataTitle for printing labels. Will be printed on label after ExsiccataTitle. | - | - |
| LabelType | Text (255) | Whether the label is typed, typed with hand written comments of completely handwriting etc. | - | - |
| LabelScanPath | Text (255) | The path and file name of the scan of the label. | - | - |
| LabelTranscription | Text (255) | The state of the transcription of a label into the database: "Not started" / " incomplete" / "complete". | - | - |
| LabelTranscriptionNotes | Text (255) | User defined notes concerning the transcription of the label into the database. | - | - |
| AccessionNumber | Text (255) | Accession number of the specimen within the collection, e.g. "M-0004752". | - | I |
| AccessionDate | Text (255) | The date, when the specimen was taken in the collection (format: YYYY/MM/DD). | - | - |
| CollectionName | Text (255) | Name of the Collection, e.g. "Botanische Staatssammlung München". | - | - |
| ExsiccataTitle | Text (255) | Standard abbreviation of the exsiccata. | - | I |
| ExsiccataNumber | Text (255) | Number within the exsiccata. | - | - |
| DepositorsName | Text (255) | The name of the depositor resp. the herbarium if not the original collector, e.g. "Herbarium P. Döbbler". | - | - |
| DepositorsAccessionNumber | Text (255) | Accession number of the specimen within the herbarium where the specimen came from if not the original collection, e.g. "D-23948". | - | - |
| OriginalNotes | Memo | Notes given by the collector, resp. found on the label. | - | - |
| AdditionalNotes | Memo | Additional notes made by the editor. | - | - |
| LoanInformation | Text (255) | Notes if the item is on loan resp. borrowed. | - | - |
| Problems | Text (255) | Problems found with the specimen, e.g. doubtful identification, locality etc. | - | - |
| PrintLabel | Boolean | Is set true if the label should be printed, is set false if the label should not be printed. Default value: True |
- | - |
| Index name: | Attributes & index properties | |||
| AccessionNumber: | AccessionNumber (Duplicates OK) | |||
| CollectionSpecimenID: | CollectionSpecimenID (Unique values) | |||
| ExsiccataTitle: | ExsiccataTitle (Duplicates OK) | |||
| PrimaryKey: | CollectionSpecimenID (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | CollectionSpecimen.CollectionSpecimenID « CollectingPerson.CollectionSpecimenID | |||
| Updates & deletions cascade | CollectionSpecimen.CollectionSpecimenID « CollectionDuplicate.CollectionSpecimenID | |||
| Updates & deletions cascade | CollectionSpecimen.CollectionSpecimenID « CollectionGeography.CollectionSpecimenID | |||
| Updates & deletions cascade | CollectionSpecimen.CollectionSpecimenID « CollectionImage.CollectionSpecimenID | |||
| Updates & deletions cascade | CollectionSpecimen.CollectionSpecimenID « CollectionMaterial.CollectionSpecimenID | |||
| Updates & deletions cascade | CollectionSpecimen.CollectionSpecimenID « DiversityProject.CollectionSpecimenID | |||
| Updates & deletions cascade | CollectionSpecimen.CollectionSpecimenID « IdentificationUnit.CollectionSpecimenID | |||
Temporary storage of the data of the specimen which were selected for printing the labels.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| CollectionSpecimenID | Long | Refers to ID of CollectionSpecimen (= foreign key). | - | - |
| SubstrateID | Long | Refers to ID of IdentificationUnit (= foreign key), specifies substrate. Default value: 0 |
- | I |
| AccessionNumber | Text (255) | Accession number of the specimen within the collection. | - | - |
| CollectionName | Text (255) | Name of the collection, e.g. "Botanische Staatssammlung München". | - | - |
| LabelTitle | Text (255) | Text printed as title of the label. | - | - |
| ExsiccataTitle | Text (255) | Title of the exsiccate series. | - | - |
| ExsiccataNumber | Text (255) | Number of the specimen within the exsiccate series. | - | - |
| ExsiccataName | Text (255) | Taxonomic name of the specimen, published in the exsiccate series. | - | - |
| Organism | Text (255) | The organism (growing on the substrate - if present). | - | - |
| Substrate | Text (255) | All organisms and substrates that where specified by identifications, following the first organism. | - | - |
| Identification | Text (255) | Intermediate storage of the text of all organisms. | - | I |
| LocalityDescription | Text (255) | The locality and habitat where the specimen has been collected. | - | - |
| Collectors | Text (255) | The persons or groups involved in the collection of the specimen. | - | - |
| CollectionDate | Text (255) | The date when the specimen has been collected. | - | - |
| CollectorsNumber | Text (255) | The number of the collected specimen assigned by the collector during the collection event. | - | - |
| Determinators | Text (255) | The persons or groups responsible for the identfication of the specimen. | - | - |
| Notes | Text (255) | User defined notes. | - | - |
| Index name: | Attributes & index properties | |||
| Identification: | Identification (Duplicates OK) | |||
| SubstrateID: | SubstrateID (Duplicates OK) | |||
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| CollectionSpecimenID | Long | Refers to ID of CollectionSpecimen (= foreign key). | - | I/I/I (UM) |
| DiversityProject | Text (255) | Project to which the specimen belongs to as stored in the database DiversityUsers. | - | - |
| Index name: | Attributes & index properties | |||
| CollectionSpecimenDiversityProject: | CollectionSpecimenID (Duplicates OK) | |||
| CollectionSpecimenID: | CollectionSpecimenID (Duplicates OK) | |||
| PrimaryKey: | CollectionSpecimenID; DiversityProject (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | CollectionSpecimen.CollectionSpecimenID « DiversityProject.CollectionSpecimenID | |||
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| Exs_ID | Autonumber | ID of the exsiccatum. Default value: GenUniqueID() |
- | I (U) |
| ExsAbbrev | Text (255) | Std. abbreviation (authors/editors, std. abbrev. of title). | R | I |
| ExsTitle | Text (255) | Exact title (enter new entry if title spelling changed consistently). | R | I |
| ExsEditInstitution | Text (255) | Issuing/Eding institution (If no editors are known, at least this must be entered). | - | - |
| ExsEditLocation | Text (255) | City/Country where the exs. has been issued. | - | - |
| PrecededBy | Long | An earlier exsiccata publication appeared under different title or editors (Reference to entry in this database). | - | I |
| SupersededBy | Long | A later exsiccata publication appeared under different title or editors (Reference to entry in this database). | - | I |
| ExsNumberFirst | Text (50) | If known: number of the first exs. that was issued by the current editors under the current title. | - | - |
| ExsNumberLast | Text (50) | If known: number of the last exs. that was issued by the current editors under the current title. | - | - |
| ExsPublYrFirst | Text (50) | If known: publication year of the first exs. that was issued by the current editors under the current title. | - | - |
| ExsPublYrLast | Text (50) | If known: publication year of the last exs. that was issued by the current editors under the current title. | - | - |
| Notes | Text (255) | Annotation, please add your name and a date for each annotation. | - | - |
| Problems | Text (255) | Please explain here if you have a problem, this field will later be checked. | - | - |
| Fungi | Integer | check if exsiccatum covers fungal species (default) 1 or -1= Yes it does, 0=No it does not, Null/empty = don't know. Default value: -1 |
- | - |
| Algae | Integer | check if exsiccatum covers Algae/Cyanophyta. Default value: Null |
- | - |
| Mosses | Integer | check if exsiccatum covers mosses/bryophytes. Default value: Null |
- | - |
| Ferns | Integer | check if exsiccatum covers ferns. Default value: Null |
- | - |
| HigherPlants | Integer | check if exsiccatum covers higher plants. Default value: Null |
- | - |
| ExampleMNum | Text (255) | 1st Example in M deposited under: title of example issue. | - | I |
| ExampleMDep | Text (255) | 1st Example in M deposited under (scientific name). | - | - |
| ExampleMNum2 | Text (255) | 2nd Example in M deposited under: title of example issue. | - | - |
| ExampleMDep2 | Text (255) | 2nd Example in M deposited under (scientific name). | - | - |
| ExampleMNum3 | Text (255) | 3rd Example in M deposited under: title of example issue. | - | - |
| ExampleMDep3 | Text (255) | 3rd Example in M deposited under (scientific name) Note: degenerated data model was introduced on purpose to keep database as simple as possible! |
- | - |
| InPfister85 | Integer | included in Pfister 1985. Default value: Null |
- | - |
| InSayre69 | Integer | included in Sayre 1969. Default value: Null |
- | - |
| Index name: | Attributes & index properties | |||
| ExampleMNum: | ExampleMNum (Duplicates OK) | |||
| ExsAbbrev: | ExsAbbrev (Duplicates OK) | |||
| ExsTitle: | ExsTitle (Duplicates OK) | |||
| PrecededBy: | PrecededBy (Duplicates OK) | |||
| PrimaryKey: | Exs_ID (Primary key; Unique values) | |||
| SupersededBy: | SupersededBy (Duplicates OK) | |||
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| IdentificationUnitID | Long | Refers to ID of CollectionUnit (= foreign key). Default value: 0 |
- | I/I (M)/I (UM) |
| CollectionSpecimenID | Long | Refers to ID of CollectionSpecimen (= foreign key). Default value: 0 |
- | I |
| IdentificationDate | Date/Time | Date and time of the determination. Default value: Now() |
- | - |
| IdentificationDateCategory | Text (255) | Qualifies whether the given date is an actual date or estimated etc. Default value: "system" |
- | I |
| VernacularName | Text (255) | Not taxonomic name e.g. limestone, conifer, hardwood. | - | - |
| TaxonomicName | Text (255) | Valid name of the species with author names of the taxon e.g. "Rosa canina L.". | - | - |
| IdentificationCategory | Text (255) | Category of the identification e.g. "determination"," confirmation", "absence". | - | - |
| IsLastName | Boolean | Defines the valid name for the organism. Can be set only once per organism. | - | - |
| LiteratureUsed | Text (255) | Source resp. literature used for the determination, e.g. "Schmeil-Fitschen 1995". | - | - |
| Responsible | Text (255) | The person or institution responsible for the determination. | - | - |
| Notes | Text (255) | User defined notes, e.g. the reason for the new determination / change of the name etc. | - | - |
| IsExsiccataTaxon | Boolean | Defines the name under which the collection specimen is published within an exsiccate. Can be set only once per collection specimen. | - | - |
| OnlyObserved | Boolean | This organism is not present on the specimen, it was only observed by the collector. | - | - |
| Index name: | Attributes & index properties | |||
| CollectionSpecimenID: | CollectionSpecimenID (Duplicates OK) | |||
| IdentificationDateCategory: | IdentificationDateCategory (Duplicates OK) | |||
| IdentificationUnitID: | IdentificationUnitID (Duplicates OK) | |||
| IdentificationUnitIdentification: | IdentificationUnitID; CollectionSpecimenID (Duplicates OK) | |||
| PrimaryKey: | IdentificationUnitID; CollectionSpecimenID; IdentificationDate (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | IdentificationUnit.IdentificationUnitID « Identification.IdentificationUnitID; IdentificationUnit.CollectionSpecimenID « Identification.CollectionSpecimenID | |||
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| IdentificationUnitID | Autonumber | ID of an organism on the collection specimen. Default value: GenUniqueID() |
- | I/I (UM) |
| CollectionSpecimenID | Long | ID of the collection specimen. Default value: 0 |
- | I/I |
| TaxonomicGroup | Long | Group the object belongs to e.g. (1) plant, (2) fungus, (3) lichen, (4) animal, (5) procaryotic, (6) virus, (7) other, inorganic. Default value: 0 |
- | - |
| TypeStatus | Text (50) | Type of the published taxon e.g. holotype, syntype. | - | - |
| TypifiedTaxon | Text (50) | Taxonomic name of the typified taxon. | - | - |
| SubstrateAssociation | Long | The IdentificationUnitID of the organism or substrate, where this organism is growing on (= foreign key). Default value: 0 |
- | - |
| ColonisedPart | Text (50) | The part of the substrate, where the organism is growing on, e.g. "leaves" if only the leaves are colonized by the organism. | - | - |
| LifeCycle | Text (50) | The part of the lifecycle of the organism, e.g. "II, III" for spore generations of rusts or "seed", "seedling" etc. for higher plants. | - | - |
| Notes | Text (50) | Notes concerning the organism, e.g. symptoms of infection like gall. | - | - |
| Index name: | Attributes & index properties | |||
| CollectionSpecimenID: | CollectionSpecimenID (Duplicates OK) | |||
| CollectionSpecimenIdentificationUnit: | CollectionSpecimenID (Duplicates OK) | |||
| IdentificationUnitID: | IdentificationUnitID (Duplicates OK) | |||
| PrimaryKey: | IdentificationUnitID; CollectionSpecimenID (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | CollectionSpecimen.CollectionSpecimenID « IdentificationUnit.CollectionSpecimenID | |||
| Updates & deletions cascade | IdentificationUnit.IdentificationUnitID « Identification.IdentificationUnitID; IdentificationUnit.CollectionSpecimenID « Identification.CollectionSpecimenID | |||
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| LocalisationSystemID | Long | Unique reference ID for the table LocalisationSystem (= primary key). Default value: 0 |
- | I (U)/I (U) |
| LocalisationSystemName | Text (255) | Name of the system used for the determination of the place of the collection, e.g. "Gauss-Krüger", "MTB". | - | I |
| LocalisationSystemTypeID | Long | Refers to ID of CoordinateSystem (= foreign key). Default value: 0 |
- | I/I |
| InterfaceDefinitions | Text (255) | User interface definition: locked status, label captions, etc. displayed in the form CollectionLocality. | - | - |
| Description | Text (255) | Despription of the localisation method. | - | - |
| MeasurementUnit | Text (255) | Unit used within the localisation system, e.g. "m" etc. | - | - |
| AccuracyOfLocalisation | Text (255) | The accuracy of values that can be reached with this method. | - | - |
| ParsingMethod | Text (255) | Method for parsing the values typed in the fields [Location1, -2] in table [CollectionGeography]. | - | - |
| Enabled | Boolean | Specifies if this item is enabled to be used within the database. | - | - |
| Index name: | Attributes & index properties | |||
| CoordinateSystemID: | LocalisationSystemTypeID (Duplicates OK) | |||
| LocalisationMethod: | LocalisationSystemName (Duplicates OK) | |||
| LocalisationSystemID: | LocalisationSystemID (Unique values) | |||
| LocalisationSystemTypeLocalisationSystem: | LocalisationSystemTypeID (Duplicates OK) | |||
| PrimaryKey: | LocalisationSystemID (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | LocalisationSystem.LocalisationSystemID « CollectionGeography.LocalisationSystemID | |||
| Updates & deletions cascade | LocalisationSystemType.LocalisationSystemTypeID « LocalisationSystem.LocalisationSystemTypeID | |||
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| LocalisationSystemTypeID | Long | Refers to ID of CollectionSpecimen (= foreign key). Default value: 0 |
- | I (U)/I (U) |
| LocalisationSystemType | Text (255) | Type of the localisation system used, e.g. "Greenwich Coordinates". | - | I |
| LocalisationSystemGroup | Text (255) | Group of the localisation system used, e.g. "Coordinates". | - | - |
| Index name: | Attributes & index properties | |||
| CoordinateSystem: | LocalisationSystemType (Duplicates OK) | |||
| CoordinateSystemID: | LocalisationSystemTypeID (Unique values) | |||
| PrimaryKey: | LocalisationSystemTypeID (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | LocalisationSystemType.LocalisationSystemTypeID « LocalisationSystem.LocalisationSystemTypeID | |||
Default values used within the DiversityCollection database.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| ParameterID | Autonumber | Unique reference ID for the parameters record. | - | - |
| Responsible | Text (255) | The person or institution responsible for the current manipulation of the data. | - | - |
| CollectionName | Text (255) | Name of the Collection, e.g. "Botanische Staatssammlung München". | - | - |
| Project | Text (255) | Project as stored in DiversityUsers. | - | - |
| LogFilePath | Text (255) | The path of the logfile from where the data (LabelScan) will be imported into the database. | - | - |
| CollectionMaterial | Text (255) | The material of the specimen e.g. "drawings", "slides" etc. | - | - |
| TaxonGroup | Text (255) | Group the object belongs to e.g. (1) plant, (2) fungus, (3) lichen, (4) animal, (5) procaryotic, (6) virus, (7) anorganic. | - | - |
| Collector | Text (255) | Name of the collecting person or group, e.g. "Miller, W.". | - | - |
| FungusName | Text (255) | The last entered name for a fungus. | - | - |
| FungusLiterature | Text (255) | Source resp. literature used for the determination of the fungus, e.g. "M. Moser (1978), Kleine Kryptogamenflora. Fischer, Stuttgart". | - | - |
| FungusIdentifier | Text (255) | The person or institution responsible for the determination of the fungus. | - | - |
| PlantName | Text (255) | The last entered name for a plant. | - | - |
| PlantLiterature | Text (255) | Source resp. literature used for the determination of the plant, e.g. "E. Oberdorfer (1979), Pflanzensoziologische Exkursionsflora. Ulmer, Stuttgart". | - | - |
| PlantIdentifier | Text (255) | The person or institution responsible for the determination of the plant. | - | - |
| BarCodeStart | Text (255) | The beginning of the barcode within the imported logfile. | - | - |
| BarCodeLength | Text (255) | The length of the barcode within the imported logfile. | - | - |
| SelectedTaxa | Text (255) | The selected taxa, e.g. One fungus on One plant. | - | - |
| SelectedSpecimen | Text (255) | The selected subset of the data, e.g. specimen with incomplete label transcription. | - | - |
| SourceType | Text (255) | The type of the source or target for the imported / exported data, e.g. "LabelScan". | - | - |
| DataSetMarker | Text (255) | The marker, separating the datasets resp. indicating the beginning of a new dataset within a file. | - | - |
| LabelFolder | Text (255) | The path resp. folder where the label images are stored. | - | - |
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 14:49; last update: 2005-03-30, email address revised 2010-08-05.