Diversity Collection information model (version 0.9 beta):
Documentation of the information model

By G. Hagedorn, M. Weiss, 2002

This document contains a complete list of all entities and attributes used in the information model of this application module. It is primarily intended as a technical reference. It can also be helpful, however, in understanding the scope and usage of certain attributes. When you have a question like 'where does this information fit in', reading the attribute description may help you.

Besides the human readable documentation provided below, three additional technical documents are provided:

Index to entities

Collection
CollectionSpecimen
CollectionDuplicate
CollectionStorage
 CollectionImage
CollectionProject
CollectionGeography
LocalisationSystem
 Identification
IdentificationUnit
CollectionLookup

See also the separate alphabetical index to attribute names.

Collection

Definition of independent collections and a tree of subcollections (subcollections may contain subcollections).

Attributes and indices of the entity 'Collection'
Name Type Description / Default value & validation Rqrd./Index
CollectionID Long Unique reference ID for the collection (= Primary key). R I (P)
ParentCollectionID Long For a subcollection within another collection: CollectionID of the collection to which the subcollection belongs. For an independent collection: Null. - -
TopmostCollectionID Long For an independent collection or subcollection: CollectionID of the independent collection (highest level within the hierarchy). For an independent collection this will be equal to CollectionID. R -
CollectionName Text Name of the collection (e. g. 'Herbarium Kew') or subcollection (e. g. 'cone collection', 'alcohol preservations'). This text should be kept relatively short, use Description for additional information. R -
Description Memo A short description of the collection. - -
Room Text Optionally the number or a description of room(s) housing the (sub)collection. - -
Table validation rule:  ([ParentCollectionID] Is Not Null) Or ([TopmostCollectionID]=[CollectionID])
Index name:  Attributes & index properties
PrimaryKey:  CollectionID (Primary key; Unique values)
Relation type:  Fields involved
Referential integrity  Collection.CollectionID « Collection.TopmostCollectionID
Updates cascade  Collection.CollectionID « CollectionDuplicate.CollectionID
Updates & deletions cascade  Collection.CollectionID « Collection.ParentCollectionID
Updates & deletions cascade  Collection.CollectionID « CollectionStorage.CollectionID

CollectionSpecimen

A specimen (= collection unit) within a collection. This is the central object of the DiversityCollection database.

Attributes and indices of the entity 'CollectionSpecimen'
Name Type Description / Default value & validation Rqrd./Index
CollectionSpecimenID Autonum Unique reference ID for the collection specimen record (primary key).
Default value: GenUniqueID()		 R I (P)
CollectionDate Date/Time Date of the collection event (calculated value based on CollectionDay, Month, and Year; if CollectionDay or month are missing they are assumed to be '1' for the purpose of date calculation). - -
CollectionDateCache Date/Time Date of the collection event (calculated value based on CollectionDay, Month, and Year; if day or month are missing they are assumed to be '1' for the purpose of the date calculation). - -
CollectionDay Byte+ The day of the date of the collection event.
Validation rule: Is Null, validation message: Only values between 1 and 31 are valid for a day!		 - -
CollectionMonth Byte+ The month of the date of the collection event.
Validation rule: Is Null, validation message: Only values between 1 and 12 are valid for a month!		 - -
CollectionYear Integer The year of the collection event. The year may be left empty if only the day or month are known.
Validation rule: (Year(Now())+1) Or Is Null, validation message: The year must have 4 digits, and it may not be a date in future.		 - -
CollectionDateSupplement Text Verbal or additional collection date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'. - -
LocalityDescription Text Locality and geo-ecological description of the locality, exactly as written on the original label (i.e. without corrections during data entry). - -
LabelTitle Text Title of label if different from ExsiccataTitle for printing labels. Will be printed on label after ExsiccataTitle. - -
LabelType Text Printed, typewritten, typewritten with handwriting added, entirely in handwriting, etc. - -
LabelScanPath Text The path and file name of the scan of the label underneath the folder where all labels are stored e.g. "/Fungi/Erysiphales/M-0010/M-001034.jpg". - -
LabelTranscription Text The state of the transcription of a label into the database: 'Not started' / 'incomplete' / 'complete'.
Validation rule: Is Null Or 'not started' Or 'incomplete' Or 'complete'		 - -
LabelTranscriptionNotes Text User defined notes concerning the transcription of the label into the database. - -
AccessionNumber Text Accession number of the specimen within the collection, e.g. "M-29834752". - I
AccessionDay Byte+ The day of the date when the specimen was acquired in the collection.
Validation rule: Is Null, validation message: Only values between 1 and 31 are valid for a day!		 - -
AccessionDate Text The date, when the specimen was acquired in the collection (format: YYYY/MM/DD) [NOTE: This should be changed to Day/Month/Year/Supplement fields!] - -
AccessionMonth Byte+ The month of the date when the specimen was acquired in the collection.
Validation rule: Is Null, validation message: Only values between 1 and 12 are valid for a month!		 - -
CollectionName Text Name of the Collection, e.g. 'Botanische Staatssammlung München'. - -
AccessionYear Integer The year when the specimen was acquired in the collection. The year may be left empty if only the day or month are known.
Validation rule: (Year(Now())+1) Or Is Null, validation message: The year must have 4 digits, and it may not be a date in future.		 - -
ExsiccataTitle Text If specimen is a exsiccata: Standard abbreviation of the exsiccata. - I
AccessionDateSupplement Text Verbal or additional accession date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'. - -
ExsiccataID Long If specimen is an exsiccata: Unique reference ID for the Exsiccata series as stored within the DiversityExsiccata database. - I
ExsiccataAbbreviation Text If specimen is an exsiccata: Standard abbreviation of the exsiccata (not necessarily a unique identifier; editors or publication places may change over time). - I
ExsiccataNumber Text If specimen is an exsiccata: Number of current specimen within the exsiccata series. - -
DepositorsName Text The name of the depositor(s) (person or organization responsible for deposition). Where entire collections are deposited, this should also contain the collection name (e.g. 'Herbarium P. Döbbler'). - -
DepositorsAccessionNumber Text Accession number of the specimen within the previous or original collection, e.g. 'D-23948'. - -
OriginalNotes Memo Notes found on the label of the specimen, by the original collector or from a later revision. - -
AdditionalNotes Memo Additional notes made by the editor of the specimen record, e. g. 'doubtful identification/locality'. - -
LoanInformation Text Notes if the item is on loan or has been borrowed. - -
Problems Text Description of a problem that occurred during data editing. Typically these entries should be deleted after help has been obtained. Do not enter scientific problems here; use AdditionalNotes for such permanent problems! - -
PrintLabel Boolean Is set to true if the label should be printed, is set to false if the label should not be printed.
Default value: True		 - -
[LogCreatedBy] Long ID of the user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible. - -
[LogCreatedWhen] Date/Time Date and time when record was first entered (= typed or imported) into this system. (Note: Updates are recorded in CollectionSpecimenChanges).
Default value: Now()		 R -
Index name:  Attributes & index properties
AccessionNumber:  AccessionNumber (Duplicates OK)
CollectionSpecimenID:  CollectionSpecimenID (Unique values)
ExsiccataID:  ExsiccataID (Duplicates OK)
ExsiccataTitle:  ExsiccataAbbreviation (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 « CollectionStorage.CollectionSpecimenID
Updates & deletions cascade  CollectionSpecimen.CollectionSpecimenID « CollectionProject.CollectionSpecimenID
Updates & deletions cascade  CollectionSpecimen.CollectionSpecimenID « IdentificationUnit.CollectionSpecimenID

CollectionDuplicate

Specimen duplicates that are stored in other collections.

Attributes and indices of the entity 'CollectionDuplicate'
Name Type Description / Default value & validation Rqrd./Index
CollectionSpecimenID Long Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key). R I/I(PM)
AccessionNumber Text Accession number as defined by the collection holding the duplicate of the current specimen. Example: 'M-3890492' when CollectionID points to the collection 'Bot. Staatssamml. München'. R I(PM)
CollectionID Long The collection holding a duplicate with the accession number above (Use IDs as stored in table Collections (= foreign key)). - -
Values currently
restricted to:
CollectionID   ParentCollectionID   TopmostCollectionID   CollectionName
1       1   Botanische Staatssammlung M�
2       2   Diatomeen-Sammlung R. Klee
3   1   1   Diatomeen-Sammlung F. J. Weinzierl
4   3   1   Einzelpr㯡rate
CollectionName Text Name of the collection holding the duplicate specimen. - -
Notes Text Notes regarding the duplicate in another collection. - -
Index name:  Attributes & index properties
CollectionSpecimenID:  CollectionSpecimenID (Duplicates OK)
PrimaryKey:  CollectionSpecimenID; AccessionNumber (Primary key; Unique values)
Relation type:  Fields involved
Updates cascade  Collection.CollectionID « CollectionDuplicate.CollectionID
Updates & deletions cascade  CollectionSpecimen.CollectionSpecimenID « CollectionDuplicate.CollectionSpecimenID

CollectionStorage

Storage location and type of collection material of the specimen.

Attributes and indices of the entity 'CollectionStorage'
Name Type Description / Default value & validation Rqrd./Index
CollectionSpecimenID Long Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key). R I(PM)
CollectionID Long ID of the Collection as stored in table Collections (= Foreign key and part of primary key). R I(PM)
Values currently
restricted to:
CollectionID   ParentCollectionID   TopmostCollectionID   CollectionName
1       1   Botanische Staatssammlung M�
2       2   Diatomeen-Sammlung R. Klee
3   1   1   Diatomeen-Sammlung F. J. Weinzierl
4   3   1   Einzelpr㯡rate
StorageLocation Text A code identifying the place where the specimen is stored within the collection. Frequently the accepted scientific name is used as storage location code. - -
MaterialCategory Text Material category of specimen. Examples: 'herbarium sheets', 'drawings', 'microscopic slides' etc.
Default value: "herbarium sheets"		 - -
Index name:  Attributes & index properties
PrimaryKey:  CollectionSpecimenID; CollectionID (Primary key; Unique values)
Relation type:  Fields involved
Updates & deletions cascade  Collection.CollectionID « CollectionStorage.CollectionID
Updates & deletions cascade  CollectionSpecimen.CollectionSpecimenID « CollectionStorage.CollectionSpecimenID

CollectingPerson

Persons or groups involved in collecting specimens ('Collectors').

Attributes and indices of the entity 'CollectingPerson'
Name Type Description / Default value & validation Rqrd./Index
CollectionSpecimenID Long Refers to ID of CollectionSpecimen (= Foreign key and part of primary key). R I/I(PM)
CollectorsName Text Name of the collecting person. Example: 'Miller, W. I., Jr.'. Format: Last name, a comma, the first initial with period and blank, an optional middle initial, and an optional comma plus suffix (Jr./Sr./III./MD etc.).
Validation rule: Not (Like ' *' Or Like '* *' Or Like '*;*' Or Like '*&*' Or Like '*+*'), validation message: You may not use a semicolon (';'), an ampersand ('&'), a plus ('+'), or double blanks in collectors names. Also, do not start the entry with a blank!		 R I/I(PM)
CollectorsNumber Text Number assigned to a specimen or a batch of specimens by the collector during the collection event (= 'field number'). - -
CollectorsSequence Date/Time The order of collectors in a team. Automatically set by the database system (technical note: based on system date/time; counters are changed to random sequence when replicating the database!).
Default value: now(); Validation rule: >0		 R -
Index name:  Attributes & index properties
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

CollectionImage

Images of the collection specimen.

Attributes and indices of the entity 'CollectionImage'
Name Type Description / Default value & validation Rqrd./Index
CollectionSpecimenID Long Refers to the ID of CollectionSpecimen (= Foreign key). R I/I(PM)
ImagePath Text The file name and path of the image relative to the main folder for all images e.g. '/Fungi/Ascomycetes/Erysiphales/ErysipheGraminis.jpg' (within the globally defined server/path combination). R I(PM)
IdentificationUnitID Long If image refers to only on out of several identification units for a specimen, refers to the ID of an IdentificationUnit for a CollectionSpecimen (= foreign key). - I
ResourceCollection Text [UNFINISHED] Link to ResourceCollection, defining copyright, scan resolution, scale (if identical for all images), etc. - -
Responsible Long ID of the Person responsible for including the image in the data collection. - -
ImageTitle Text The title of the image. - -
Creator Text Optional: Author(s), photographer, director, etc. Person(s) or institution(s) responsible for the creation of the abstract resource item (not of the instance, e.g. a scan of an image). [DC11!] - -
Notes Text Notes concerning the image, e.g. scale, resolution. See CollectionProject for additional information. - -
CreationDate Date/Time Creation date (optionally also time) of the original resource. For digitized resources this should refer to the original creation (of the abstract item, e.g. when picture was drawn or photographed), not the digitization process. - -
CreationMetadata Text Optional: additional information regarding the creation process, e.g. image lens, scale, exposure time, etc. - -
Rights Text Optional: Information about rights (copyright, intellectual property) held in and over the resource. Enter esp. name of person or institution holding the copyright. Leave empty if unknown or if rights are globally described in resource collection. [DC11!] - -
Index name:  Attributes & index properties
CollectionSpecimenID:  CollectionSpecimenID (Duplicates OK)
IdentificationUnitID:  IdentificationUnitID (Duplicates OK)
PrimaryKey:  CollectionSpecimenID; ImagePath (Primary key; Unique values)
Relation type:  Fields involved
Updates & deletions cascade  CollectionSpecimen.CollectionSpecimenID « CollectionImage.CollectionSpecimenID
Simple relation (no integrity)  IdentificationUnit.IdentificationUnitID « CollectionImage.IdentificationUnitID; IdentificationUnit.CollectionSpecimenID « CollectionImage.CollectionSpecimenID

CollectionProject

Projects as stored within the database DiversityUsers to which the collection specimen belongs to.

Attributes and indices of the entity 'CollectionProject'
Name Type Description / Default value & validation Rqrd./Index
CollectionSpecimenID Long Refers to the ID of CollectionSpecimen (= Foreign key). R I/I(PM)
DiversityProject Text Project to which the specimen belongs (Projects are defined in DiversityUsers). R I/I(PM)
Index name:  Attributes & index properties
CollectionSpecimenID:  CollectionSpecimenID (Duplicates OK)
DiversityProject:  DiversityProject (Duplicates OK)
PrimaryKey:  CollectionSpecimenID; DiversityProject (Primary key; Unique values)
Relation type:  Fields involved
Updates & deletions cascade  CollectionSpecimen.CollectionSpecimenID « CollectionProject.CollectionSpecimenID

CollectionGeography

Geographical data of the locality where the specimen were collected.

Attributes and indices of the entity 'CollectionGeography'
Name Type Description / Default value & validation Rqrd./Index
CollectionSpecimenID Long Refers to the ID of CollectionSpecimen (= Foreign key and part of primary key). R I/I(PM)
LocalisationSystemID Long Refers to the ID of LocationIdentification (= Foreign key and part of primary key). R I/I(PM)
Location1 Text Either a named location selected from a thesaurus (e. g. 'Germany, Bavaria, Kleindingharting') or altitude range or other values (e. g. 100-200 m). - -
Location2 Text Corresponding value to Location1 or ID of thesaurus. - -
DeterminationDate Date/Time Date of the determination of the geographical localisation. - -
Responsible Text Person, team or organisation responsible for the data (free text, not provided by security provider like DiversityUsers). - -
AverageAltitudeCache Double Calculated altitude as parsed from the location fields. - -
AverageLongitudeCache Double Calculated longitude as parsed from the location fields. - -
AverageLatitudeCache Double Calculated latitude as parsed from the location fields. - -
Index name:  Attributes & index properties
CollectionSpecimenID:  CollectionSpecimenID (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

LocalisationSystem

Localisation system used for the determination of the geographical data.

Attributes and indices of the entity 'LocalisationSystem'
Name Type Description / Default value & validation Rqrd./Index
LocalisationSystemID Long Unique ID for the localisation system (= Primary key). R I (P)
LocalisationSystemName Text Name of the system used for the determination of the place of the collection, e. g. Gauss-Krüger, MTB, GIS. R I
LocalisationSystemTypeID Long Refers to the ID of a LocalisationSystemType (= Foreign key). R I
InterfaceDefinitions Text User interface definition: locked status, label captions, etc.; used e. g. in the form CollectionLocality. - -
Description Text Description of the localisation method. - -
MeasurementUnit Text Measurement unit used within the localisation system, e.g. m, miles etc. Metric units should be preferred. - -
AccuracyOfLocalisation Text A description of the accuracy of values that can be reached with this method. - -
ParsingMethod Text Internal value, specifying a programming method used for parsing text in fields Location1/Location2 in table CollectionGeography. - -
Enabled Boolean Specifies if this item is enabled to be used within the database. LocalisationSystems can be disabled to avoid seeing them, but to keep the definition for the future. R -
Index name:  Attributes & index properties
CoordinateSystemID:  LocalisationSystemTypeID (Duplicates OK)
LocalisationMethod:  LocalisationSystemName (Duplicates OK)
LocalisationSystemID:  LocalisationSystemID (Unique values)
PrimaryKey:  LocalisationSystemID (Primary key; Unique values)
Relation type:  Fields involved
Updates & deletions cascade  LocalisationSystem.LocalisationSystemID « CollectionGeography.LocalisationSystemID
Updates & deletions cascade  LocalisationSystemType.LocalisationSystemTypeID « LocalisationSystem.LocalisationSystemTypeID

LocalisationSystemType

Coordinate systems etc. used by the localisation systems.

Attributes and indices of the entity 'LocalisationSystemType'
Name Type Description / Default value & validation Rqrd./Index
LocalisationSystemTypeID Long Unique ID for localisation system type (= Primary key). R I (P)
LocalisationSystemType Text Type of the localisation system used, e. g. Greenwich coordinates. R I
LocalisationSystemGroup Text Group of the localisation system used, e. g. 'Coordinates'.
Validation rule: 'Named Area' Or 'Raster' Or 'Altitude' Or 'Coordinates', validation message: Only certain predefined values are allowed here.		 R -
Values currently
restricted to:
Named Area  
Raster  
Altitude  
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

Identification

Identifications of the identification units.

Attributes and indices of the entity 'Identification'
Name Type Description / Default value & validation Rqrd./Index
IdentificationUnitID Long Refers to the ID of CollectionUnit (= foreign key and part of primary key). R I/I(PM)
CollectionSpecimenID Long Refers to the ID of CollectionSpecimen (= foreign key and part of primary key). R I/I(PM)
IdentificationSequence Date/Time Date and time the identification was entered into the system, defines the ordering of identifications (= part of primary key). Note: this is usually not the date the identification occurred!
Default value: Now()		 R I(PM)
IdentificationDateCache Date/Time Date of the identification event (calculated value based on IdentificationDay, Month, and Year; if day or month are missing they are assumed to be '1' for the purpose of the date calculation). - -
IdentificationDay Byte+ The day of the identification event.
Validation rule: Is Null, validation message: Only values between 1 and 31 are valid for a day!		 - -
IdentificationMonth Byte+ The month of the identification event.
Validation rule: Is Null, validation message: Only values between 1 and 12 are valid for a month!		 - -
IdentificationYear Integer The year of the identification event. The year may be empty if only the day or month are known.
Validation rule: (Year(Now())+1) Or Is Null, validation message: The year must have 4 digits, and it may not be a date in future.		 - -
IdentificationDateSupplement Text Verbal or additional identification date information, e.g. 'end of summer 1985', 'first quarter', '1888-1892'. - -
VernacularName Text Name other than a taxonomic (= scientific) name, e.g. 'pine', 'limestone', 'conifer', 'hardwood'. - -
TaxonomicName Text Valid name of the species (including the taxonomic author where available. Example: 'Rosa canina L.'. - -
NomID Long Unique ID code of the taxon. Refers to the NomID code of TaxonomyName (= foreign key) in the DiversityTaxonomy component.
Default value: 0		 - I
NomSignature Long Signature of the taxonomic name thesaurus from which NomID is derived.
Default value: 0		 - -
IdentificationCategory Text Category of the identification e.g. 'determination', 'confirmation', 'absence'. - -
IdentificationQualifier Text Qualification of the identification e.g. "cf."," aff.", "sp. nov.". - -
IsLastName Boolean Defines the valid name for the organism. Can be set only once per organism. - -
LiteratureUsed Text Publications or authorititative opinions of scientist used during the identification process. Example: enter 'Schmeil-Fitschen 1995' if this field flora was used. - -
Notes Text User defined notes, e.g. the reason for a re-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. - -
Responsible_TEMP Text USE THIS TO MIGRATE TEXT INFORMATION TO USERIDs! The person or institution responsible for the determination. - -
ResponsibleName Text Name of the person or institution responsible for the determination. - -
Responsible Long The person or institution responsible for the determination. R -
[LogCreatedBy] Long ID 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 -
[LogCreatedWhen] 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 (Duplicates OK)
IdentificationUnitID:  IdentificationUnitID (Duplicates OK)
NomID:  NomID (Duplicates OK)
PrimaryKey:  IdentificationUnitID; CollectionSpecimenID; IdentificationSequence (Primary key; Unique values)
Relation type:  Fields involved
Updates & deletions cascade  IdentificationUnit.IdentificationUnitID « Identification.IdentificationUnitID; IdentificationUnit.CollectionSpecimenID « Identification.CollectionSpecimenID

IdentificationUnit

Organism that is present in or on a collection specimen.

Attributes and indices of the entity 'IdentificationUnit'
Name Type Description / Default value & validation Rqrd./Index
IdentificationUnitID Autonum ID of the identification unit (= part of Primary key). Usually one of possibly several organisms present on the collection specimen. Example: parasite with hyperparasite on leaf = 3 units,
Default value: GenUniqueID()		 R I/I(PM)
CollectionSpecimenID Long ID of the collection specimen on which the identification unit is present (= Foreign key and part of primary key). R I/I(PM)
TaxonomicGroup Long Taxonomic group the organism identified by this unit belongs to. Groups are (1) plant, (2) fungus, (3) lichen, (4) animal, (5) prokaryotic, (6) virus, (7) other. R -
Values currently
restricted to:
1   plant  
2   fungus  
3   lichen  
4   animal  
5   procaryotic  
6   virus  
7   other  
OnlyObserved Boolean True if the organism was only observed rather than collected. It is therefore not present on the preserved specimen. Example: Tree under which the collected mycorrhizal fungus grew.
Default value: False		 R -
TypeStatus Text If identification unit is type of a taxonomic name: holotype, syntype, etc. - -
TypifiedTaxon Text Scientific name of the taxon typified by this identification unit. - -
SubstrateAssociation Long The IdentificationUnitID of the organism or substrate, on which this organism is growing (= foreign key). - I
ColonisedPart Text If a SubstrateAssociation exists: part of the substrate that is affected in the interaction (e.g. 'leaves'). - -
LifeStage Text Examples: 'II, III' for spore generations of rusts or 'seed', 'seedling' etc. for higher plants. - -
Notes Text Further information on the identification unit or interaction, e. g. infection symptoms like 'producing galls'. - -
Table validation rule:  ([TypeStatus] Is Null And [TypifiedTaxon] Is Null) Or ([TypeStatus] Is Not Null And [TypifiedTaxon] Is Not Null)
Table validation text:  You cannot use TypeStatus without TypifiedTaxon and vice versa.
Index name:  Attributes & index properties
CollectionSpecimenID:  CollectionSpecimenID (Duplicates OK)
IdentificationUnitID:  IdentificationUnitID (Duplicates OK)
IdentificationUnitSubstrate...:  SubstrateAssociation (Duplicates OK)
PrimaryKey:  IdentificationUnitID; CollectionSpecimenID (Primary key; Unique values)
Relation type:  Fields involved
Updates & deletions cascade  CollectionSpecimen.CollectionSpecimenID « IdentificationUnit.CollectionSpecimenID
Simple relation (no integrity)  IdentificationUnit.IdentificationUnitID « CollectionImage.IdentificationUnitID; IdentificationUnit.CollectionSpecimenID « CollectionImage.CollectionSpecimenID
Updates & deletions cascade  IdentificationUnit.IdentificationUnitID « Identification.IdentificationUnitID; IdentificationUnit.CollectionSpecimenID « Identification.CollectionSpecimenID
Simple relation (no integrity)  IdentificationUnit.IdentificationUnitID « IdentificationUnit.SubstrateAssociation; IdentificationUnit.CollectionSpecimenID « IdentificationUnit.CollectionSpecimenID

CollectionLookup

Internal lists of values or text strings, used, e.g., to provide data for pick lists.

Attributes and indices of the entity 'CollectionLookup'
Name Type Description / Default value & validation Rqrd./Index
Parameter Text Name of the parameter, e.g. "TypeStatus". R I(PM)
Value Text Value of the parameter, e.g. "holotypus". R I(PM)
Description Text Description of the parameter. - -
EnableEditing Boolean True if this item can be edited by the user. - -
Index name:  Attributes & index properties
PrimaryKey:  Parameter; Value (Primary key; Unique values)

Footnotes: The following abbreviations have been used in the tables: R: It is required to enter data in this field. I: The field is indexed to enable faster searching. Different types of indices are denoted by additional letters in parentheses: P = attribute is part of the primary key (values in the index must be unique), U = values in the index must be unique, N = Null values are ignored in the index, M = the index contains more than one attribute, + = the attribute is involved in more than one multiple-field index. The names of attributes that are part of the primary key are underlined in the first column.

Attribute names of system fields and logging fields (record creation or updating) are enclosed in square brackets: [].

Data types: 'Text (255)' indicates a text of varying length for which no specific design restrictions have been formulated. 255 characters should be read as a proposed technical maximum limit, that can be changed if required by the database management system. In contrast, 'Memo' is explicitly defined as text of unlimited length. All text is Unicode text. Numeric types: BigInt = 8 byte integer, Long = 4 byte integer, Integer or Int = 2 byte integer, Byte = 1 byte integer. A + (e.g. Byte+) indicates that the integer is unsigned and only positive values are allowed.

We are interested in your opinion. If you see any problems with the model that you would like to bring to our attention, please contact us by sending an email to name@gmail.com, please replace name with g.m.hagedorn!

Documentation created on 15. Nov. 2002 9:24; last update: 2005-03-30, email address revised 2010-08-05.

This work is licensed under a Creative Commons License Valid XHTML 1.0! Valid CSS1!