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