/* SQL DDL: Create an implementation of the model using the SQL Data Definition Language */ /* Note: You may want to change some field types to improve the implementation on your DBMS */ /* Comments such as this may not be supported by your system and may have to be removed */ /* Note: Tested with MS SQL Server 2000 and PostgreSQL. The following changes must be made: */ /* MS SQL Server 2000: replace the data type BOOLEAN with BIT */ /* MS SQL Server 2000: replace the SQL92 constant 'current_timestamp' with 'GETDATE()' (= date and time) */ /* MS SQL Server 2000: remove comments around the block of 'exec' statements at end of file to enable creation of column descriptions */ /* PostgreSQL: National Character etc. indicates Unicode text. For Postgres you should create the entire database as Unicode and the 'National' must be removed from the SQL code */ /* PostgreSQL: replace the data type CHARACTER VARYING with VARCHAR */ /* PostgreSQL: replace the data type DATETIME with TIMESTAMP */ /* PostgreSQL: replace the SQL92 constant 'current_timestamp' with 'timestamp('now')' (= date and time) */ /* Note: CREATE INDEX (other than primary, foreign, or unique key constraints) are missing at the moment; to be added later */ /* Generated on 5.Mai.2001 23:59 by Diversity Workbench: Diversity Information Model Documenter, Vers. 1.6 (G. Hagedorn) */ /*=== Table: IndexingSource ===*/ /* A source (reference or specimen) for 1 to many OrganismInteractionObservation or OrganismResource (esp. images) records. */ /* SourceID: A number that uniquely identifies a source for indexing projects, e.g. indexing organism interactions or images (primary key). */ /* SourceCategory: Required classification of the information source (reference, label, etc.) for special indexing records (e.g. organism interaction observations). */ /* QualityCategory: Optional: Data quality of this source. The values must come from the associated pick list. */ /* QualityNotes: Additional notes referring to the estimation of data quality for this source. */ /* RefID: If source is a publication: the reference ID of that work. Refers to the ID code of the main ReferenceTitle table in the reference module (= foreign key). */ /* RefDescriptionCache: If source is a publication: a short human readable description of the reference, obtained through the RefID from the reference subsystem (calculated field). */ /* CollectionAbbreviation: If source is a specimen: Standard abbreviation of the collection from which the specimen was obtained (e.g. 'B' for Berlin herbarium). The full name is used if no acronym is available. */ /* CollectionSpecimenID: If source is a specimen: Used only when a specimen record is available in a compatible collection database subsystem; refers to CollectionSpecimenID in that system (foreign key). */ /* CollectionSpecimenDescription: If source is a specimen: Optionally used for accession number or storage location name (which may be different from current scientific name!), esp. if CollectionSpecimenID cannot be used because no compatible collection database subsystem is available. */ /* AreaCoordinateSystem: The point coordinate system used in the attribute 'OriAreaCoordinates' of the entity 'OrganismInteractionObservation'. */ /* AreaGridCoordSystem: The grid cell coordinate system used in the attribute 'OriAreaGridCoord' of the entity 'OrganismInteractionObservation'. */ /* DefaultInteractionType: If organism interactions (incl. geogr. distribution) are indexed: the default interaction type used for new observations recorded from this source. */ /* DefaultInteractionConditions: If organism interactions (incl. geogr. distribution) are indexed: the default interaction conditions used for new observations recorded from this source. */ /* DefaultResourceCategory: If resources (esp. images printed in a book) are indexed: the default resource category used for new observations recorded from this source. */ /* LogCreated_User: Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible. */ /* LogCreated_Date: Date and time when record was first entered (= typed or imported) into this system. */ CREATE TABLE IndexingSource ( SourceID INTEGER IDENTITY NOT NULL PRIMARY KEY, SourceCategory TINYINT NOT NULL, QualityCategory TINYINT NULL, QualityNotes NATIONAL TEXT NULL, RefID NATIONAL CHARACTER VARYING(20) NULL UNIQUE, RefDescriptionCache NATIONAL CHARACTER VARYING(255) NULL, CollectionAbbreviation NATIONAL CHARACTER VARYING(100) NULL, CollectionSpecimenID NATIONAL CHARACTER VARYING(255) NULL UNIQUE, CollectionSpecimenDescription NATIONAL CHARACTER VARYING(255) NULL, AreaCoordinateSystem NATIONAL CHARACTER VARYING(255) NULL, AreaGridCoordSystem NATIONAL CHARACTER VARYING(255) NULL, DefaultInteractionType TINYINT NULL, DefaultInteractionConditions TINYINT NULL DEFAULT 10, DefaultResourceCategory TINYINT NULL, LogCreated_User NATIONAL CHARACTER VARYING(50) NOT NULL, LogCreated_Date DATETIME NOT NULL DEFAULT current_timestamp ) /*=== Table: IndexingSourceAnnotation ===*/ /* Annotation concerning a single information source, esp. regarding data entry or import, editing acknowledgements, or copyright agreements. */ /* SourceID: Source ID, links annotation with 'IndexingSource' (= foreign key). */ /* AnnotationDate: The date when the annotation was entered into the system. */ /* AnnotationType: Type of annotation, esp. 'data capture notes', 'data import notes', 'editing notes', 'copyright agreements', etc. */ /* Responsible: Person responsible for the source annotation. */ /* Annotation: The text of the annotation. Internal information, no web access! */ CREATE TABLE IndexingSourceAnnotation ( SourceID INTEGER NOT NULL, AnnotationDate DATETIME NOT NULL DEFAULT current_timestamp, AnnotationType NATIONAL CHARACTER VARYING(255) NOT NULL, Responsible NATIONAL CHARACTER VARYING(50) NOT NULL, Annotation NATIONAL TEXT NOT NULL, PRIMARY KEY (SourceID,AnnotationDate) ) /*=== Table: OrganismInteractionConditions ===*/ /* Definitions of types of condition for organism interactions (natural, commercial growth, garden/zoo, experimental, etc.). */ /* ConditionID: Unique ID number of this interaction condition (primary key). */ /* ConditionAbbreviation: Short code for the interaction condition, displayed to user. */ /* ConditionDescription: Description of interaction condition. */ /* ConditionNotes: Internal development notes about an interaction condition. */ /* DisplayOrder: The order in which the entries are displayed. */ /* DisplayEnable: The entries are displayed only if marked here. */ CREATE TABLE OrganismInteractionConditions ( ConditionID TINYINT NOT NULL PRIMARY KEY, ConditionAbbreviation NATIONAL CHARACTER VARYING(15) NOT NULL, ConditionDescription NATIONAL CHARACTER VARYING(255) NOT NULL, ConditionNotes NATIONAL TEXT NULL, DisplayOrder INTEGER NOT NULL UNIQUE, DisplayEnable BOOLEAN NOT NULL DEFAULT -1 ) /*=== Table: OrganismInteractionInterpretation ===*/ /* Interpretation and evaluation by a scientist of an organism interaction in OrganismInteractionObservation. */ /* SourceID: Source ID, links observations with a reference (literature reference, specimen label, etc. ) in 'IndexingSource' (= foreign key). */ /* ObservationDisplayOrder: Refers to DisplayOrder of 'OrganismInteractionObservation', thus identifying a single observation record (= foreign key). */ /* EdtDate: Date and time when the last editing was performed. */ /* EdtInteractionType: Organism interaction type (e.g. parasitism, mutualism, etc.). Refers to categories defined in 'OrganismInteractionType' (= foreign key). */ /* EdtInteractionConditions: Conditions under which the interaction occurred (e.g. 'natural', 'artificial', 'experimental'). Refers to conditions defined in 'OrganismInteractionConditions' (= foreign key). */ /* EdtOrganism: OriOrganism interpreted as standard name. Enter the name as closely as possible, enter valid name of a synonym only if synonymization is not already defined in the tax. thesaurus! */ /* EdtOrganismQuality: Estimation of identification quality of 1st organism, either due to doubt by original author (e.g. a "cf. name" given) or due to problems in interpretation. Note that there is a separate category for type material! */ /* EdtOrganismStage: Life- or spore stages of 1st organism in standard (constrained) terminology. */ /* EdtOrganismPart: Part/organ of 1st organism in standard (constrained) terminology (example: pycnidia on twigs...). */ /* EdtOrganismNotes: Notes/remarks regarding the evaluation/interpretation of 1st organism, its stages, parts and identification quality. */ /* EdtOrganism2: OriOrganism2 interpreted. Enter the name as closely as possible, enter valid name of a synonym only of synonymization is not already defined in the tax. thesaurus! */ /* EdtOrganism2Quality: Estimation of identification quality of EdtOrganism2, either due to doubt by original author (e.g. a "cf. name" given) or due to problems in interpretation. Note that there is a separate category for type material! */ /* EdtOrganism2Stage: Affected life stages of 2nd organism (e.g. host plant) in standard (constrained) terminology. Examples for plants: seedling, young plant, grown plant, etc. */ /* EdtOrganism2Part: Part/organ of 2nd organism in standard (constrained) terminology (example: root, stem, leaf, flower, etc.). */ /* EdtOrganism2Notes: Notes/remarks regarding the evaluation/interpretation of OriOrganism2, its stages, parts and identification quality. */ /* EdtArea: OriArea interpreted as standard geographic area (current English area name as verified in a gazetteer of geographic names). */ /* EdtAreaQuality: Estimation of quality of area interpretation, either due to doubt by original author or due to problems in interpretation. */ /* EdtAreaNote: Notes/remarks regarding the evaluation/interpretation of 'OriArea' to 'EdtArea'. */ /* Problem: Use this field to document a problem with the application during data entry, or make notes to yourself. */ /* EdtResponsible: Person responsible for the editing of an organism interaction observation (e.g. interpreting host and parasite name or identification quality, the geographic area, etc.). */ /* LogCreated_User: Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible. */ /* LogCreated_Date: Date and time when record was first entered (= typed or imported) into this system. */ CREATE TABLE OrganismInteractionInterpretation ( SourceID INTEGER NOT NULL, ObservationDisplayOrder INTEGER NOT NULL, EdtDate DATETIME NOT NULL DEFAULT current_timestamp, EdtInteractionType TINYINT NOT NULL, EdtInteractionConditions TINYINT NOT NULL, EdtOrganism NATIONAL CHARACTER VARYING(255) NULL, EdtOrganismQuality TINYINT NULL, EdtOrganismStage INTEGER NULL, EdtOrganismPart INTEGER NULL, EdtOrganismNotes NATIONAL TEXT NULL, EdtOrganism2 NATIONAL CHARACTER VARYING(255) NULL, EdtOrganism2Quality TINYINT NULL, EdtOrganism2Stage INTEGER NULL, EdtOrganism2Part INTEGER NULL, EdtOrganism2Notes NATIONAL TEXT NULL, EdtArea NATIONAL CHARACTER VARYING(255) NULL, EdtAreaQuality TINYINT NULL, EdtAreaNote NATIONAL TEXT NULL, Problem NATIONAL CHARACTER VARYING(255) NULL, EdtResponsible NATIONAL CHARACTER VARYING(50) NOT NULL, LogCreated_User NATIONAL CHARACTER VARYING(50) NOT NULL, LogCreated_Date DATETIME NOT NULL DEFAULT current_timestamp, PRIMARY KEY (SourceID,ObservationDisplayOrder,EdtDate) ) /*=== Table: OrganismInteractionObservation ===*/ /* Interaction observations (parasitism, mutualism, etc.) as reported in a specific source reference concerning 1 or 2 organisms (and optionally a geographic area), including information about affected parts, life stages, symptoms, etc. . */ /* SourceID: Source ID, links observations with a reference (literature reference, specimen label, etc. ) in 'IndexingSource' (= foreign key). */ /* DisplayOrder: Defines ordering of observations. A simple sequence with step 100 is automatically created for new records; records can be moved or inserted between existing records by changing this number. */ /* SourceDetail: Information where observation can be found in source. In the case of page numbers (incl. roman numbers) simply enter the number, else precede with 'Tab.', 'Fig.', etc. */ /* SourceDetailNumCache: (Calculated field, set to the numeric integer part of SourceDetailText, esp. page numbers. Only positive integer numbers can be stored here.). */ /* OriInteractionType: Organism interaction type (e.g. parasitism, mutualism, etc.). Refers to categories defined in 'OrganismInteractionType' (= foreign key). */ /* OriInteractionConditions: Conditions under which the interaction occurred (e.g. 'natural', 'artificial', 'experimental'). Refers to conditions defined in 'OrganismInteractionConditions' (= foreign key). */ /* OriInteractionNote: Additional notes on interaction type (e.g. 'only on dead twigs') and interaction conditions (e.g. 'from bot. garden') present in the original source. */ /* OriOrganism: Name of the primary organism (e.g. a parasite), exactly as present in the original source, without corrections. If a common name is given in addition to a scientific name, it should be included in brackets: 'Acer saccharum [sugar maple]'. */ /* OriOrganismStages: Life stage(s) or spore stages (multiple stages separated with semicolon): anamorph/teleomorph, presence of spore stages like beta conidia; in rusts: aecia/uredinia/telia etc. Data entered exactly as in the original source, not translated to English. */ /* OriOrganismParts: Part(s) of primary organism. Examples for parasitic fungi: 'pycnidia', 'apothecia', etc. Data entered exactly as in the original source, not translated to English. */ /* OriOrganismCitedSynonyms: Synonyms given in the original publication. Include indications of doubt like '?', use '=' and '=' (use '3=' if '=' is unavailable). Use ';' between names. Knowledge of these synonyms may help in understanding the taxon concepts of the original author(s). */ /* OriOrganismHigherTaxa: The higher taxa given in the original source for the primary organism (optional, entered only if considered relevant). */ /* OriOrganism2: Name of the associated organism (e.g. a host/substrate), exactly as present in source, including common/vernacular names in '()'. If only a common name is given in the original source, the scientific name should not be added from other sources! */ /* OriOrganism2Stages: Life stage(s) of associated organism affected by the interaction. Examples for plants: 'seed', 'seedling', 'young plant', etc. Data entered exactly as in the original source, not translated to English. */ /* OriOrganism2Parts: Part(s) of associated organism affected by interaction. Examples for plants: 'root', 'stem', 'leaf', 'flower', etc. Data entered exactly as in the original source, not translated to English. */ /* OriOrganism2CitedSynonyms: Synonyms given in the original publication. Include indications of doubt like '?', use '=' and '=' (use '3=' if '=' is unavailable). Use ';' between names. Knowledge of these synonyms may help in understanding the taxon concepts of the original author(s). */ /* OriOrganism2HigherTaxa: The higher taxa given in the original source for the associated organism (optional, entered only if considered relevant). */ /* OriArea: Geographical area as written in the original source (in the original form and language, not translated to standard terminology, compare EdtArea). */ /* OriAreaDetail: Details of the geographical area/location; Normally everything below the county or city should be considered a detail. Example: '2 km S of mill pond'. */ /* OriAreaPointCoordinates: Geographical area coordinates (excluding grid data) for an observation, exactly as given in the source. The coordinate system should normally be specified a single time in AreaCoordinateSystem of IndexingSource. */ /* OriAreaGridCoordinates: Geographical area grid cell coordinates for an observation, exactly as given in the source. The grid system should normally be specified a single time in AreaGridCoordSystem of IndexingSource. */ /* OriNotes: Additional information or annotations as they appear in the original source. */ /* OriSymptoms: Optionally: symptoms given by original author for a specific observation. Symptoms may depend on the host, and even on the geographical origin! */ /* OriDescriptionPresent: Optionally: information whether morphological descriptions for OriOrganism are present; these may e.g. be important for the interpretation of the taxonomic concept. */ /* OriCollectors: Optionally: collector(s) of the original material (also: exsiccatum information), if cited in the source reference. */ /* OriCollectionDate: Optionally: a string specifying a collection date, range, or date parts. Examples: '5-7.1940', '6-9' (i.e. only the months are known). Use the sequence day-month-year (with century, i.e. not '30.12.98'). */ /* LogCreated_User: Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible. */ /* LogCreated_Date: Date and time when record was first entered (= typed or imported) into this system. */ CREATE TABLE OrganismInteractionObservation ( SourceID INTEGER NOT NULL, DisplayOrder INTEGER NOT NULL, SourceDetail NATIONAL CHARACTER VARYING(50) NULL, SourceDetailNumCache INTEGER NOT NULL DEFAULT 0, OriInteractionType TINYINT NOT NULL, OriInteractionConditions TINYINT NOT NULL, OriInteractionNote NATIONAL CHARACTER VARYING(255) NULL, OriOrganism NATIONAL CHARACTER VARYING(255) NOT NULL, OriOrganismStages NATIONAL CHARACTER VARYING(255) NULL, OriOrganismParts NATIONAL CHARACTER VARYING(255) NULL, OriOrganismCitedSynonyms NATIONAL CHARACTER VARYING(255) NULL, OriOrganismHigherTaxa NATIONAL CHARACTER VARYING(255) NULL, OriOrganism2 NATIONAL CHARACTER VARYING(255) NULL, OriOrganism2Stages NATIONAL CHARACTER VARYING(255) NULL, OriOrganism2Parts NATIONAL CHARACTER VARYING(255) NULL, OriOrganism2CitedSynonyms NATIONAL CHARACTER VARYING(255) NULL, OriOrganism2HigherTaxa NATIONAL CHARACTER VARYING(255) NULL, OriArea NATIONAL CHARACTER VARYING(255) NULL, OriAreaDetail NATIONAL CHARACTER VARYING(255) NULL, OriAreaPointCoordinates NATIONAL CHARACTER VARYING(255) NULL, OriAreaGridCoordinates NATIONAL CHARACTER VARYING(255) NULL, OriNotes NATIONAL TEXT NULL, OriSymptoms NATIONAL TEXT NULL, OriDescriptionPresent BOOLEAN NOT NULL DEFAULT 0, OriCollectors NATIONAL CHARACTER VARYING(255) NULL, OriCollectionDate NATIONAL CHARACTER VARYING(255) NULL, LogCreated_User NATIONAL CHARACTER VARYING(50) NOT NULL, LogCreated_Date DATETIME NOT NULL DEFAULT current_timestamp, PRIMARY KEY (SourceID,DisplayOrder) ) /*=== Table: OrganismInteractionReference ===*/ /* Each interaction observation ('OrganismInteractionObservation') may quote several references. */ /* SourceID: Source ID, links observations with a reference (literature reference, specimen label, etc. ) in 'IndexingSource' (= foreign key). */ /* ObservationDisplayOrder: Refers to 'DisplayOrder' of 'OrganismInteractionObservation' (= foreign key). */ /* OriCitedReference: The text of a literature or specimen reference cited for an interaction observation, exactly as given in the source. Examples: 'Miller (1920a)', '[471]', or 'H.WB. 4225' (for a specimen). */ /* CitedRefID: The reference ID (RefID) of those references that can be identified in the linked references module (= foreign key). */ /* CitedRefDescriptionCache: A short human readable description of the reference, obtained through the RefID from the reference subsystem (calculated field). */ /* CitedRefDetail: Detail of cited reference (esp. a page number) on which the referenced information can be found. Do not confuse with the page number of the work evaluated itself (= citing reference), comp. SourceDetail. */ /* TranscriptionNotes: Notes and comments, esp. regarding problems or doubt in the association between the original work and the. */ /* TranscriptionResponsible: Person responsible for the transcription of OriCitedReference to CitedReferenceID. */ /* TranscriptionOperator: Name of user who first entered (typed or imported) the transcription (not the entry of 'OriCitedReference'). This is the operator (or typist) name, which may be different from the person responsible. */ /* TranscriptionDate: Date and time when transcription occurred. */ CREATE TABLE OrganismInteractionReference ( SourceID INTEGER NOT NULL, ObservationDisplayOrder INTEGER NOT NULL, OriCitedReference NATIONAL CHARACTER VARYING(255) NOT NULL, CitedRefID NATIONAL CHARACTER VARYING(20) NULL, CitedRefDescriptionCache NATIONAL CHARACTER VARYING(255) NULL, CitedRefDetail NATIONAL CHARACTER VARYING(255) NULL, TranscriptionNotes NATIONAL TEXT NULL, TranscriptionResponsible NATIONAL CHARACTER VARYING(50) NULL, TranscriptionOperator NATIONAL CHARACTER VARYING(50) NULL, TranscriptionDate DATETIME NOT NULL DEFAULT current_timestamp, PRIMARY KEY (SourceID,ObservationDisplayOrder,OriCitedReference) ) /*=== Table: OrganismInteractionType ===*/ /* Definitions of types of organism interactions (parasitism, mutualism, etc.). */ /* InteractionTypeID: Unique ID number of this interaction type (primary key). */ /* InteractionAbbreviation: Short code for the interaction type, displayed to user. */ /* InteractionDescription: Description of interaction type (e.g. parasitism, mutualism, etc.). */ /* Org1CustomLabel: Label displayed in user interface for primary organism. The default label is used when left empty. */ /* Org2CustomLabel: Label displayed in user interface for associated organism (Organism2). The default label is used when left empty. */ /* Org1Group: The organism group, as used in parts definitions. Empty if all groups apply. */ /* Org2Group: The organism group for 2nd organism, as used in parts definitions. Empty if all groups apply. */ /* InteractionNotes: Internal development notes about an interaction type. */ /* ParentType: Defines a more widely defined interaction type that include the current type. */ /* DisplayOrder: The order in which the entries are displayed. */ /* DisplayEnable: The entries are displayed only if marked here. */ CREATE TABLE OrganismInteractionType ( InteractionTypeID TINYINT NOT NULL PRIMARY KEY, InteractionAbbreviation NATIONAL CHARACTER VARYING(20) NOT NULL, InteractionDescription NATIONAL CHARACTER VARYING(255) NOT NULL, Org1CustomLabel NATIONAL CHARACTER VARYING(255) NULL, Org2CustomLabel NATIONAL CHARACTER VARYING(255) NULL, Org1Group NATIONAL CHARACTER VARYING(255) NULL, Org2Group NATIONAL CHARACTER VARYING(255) NULL, InteractionNotes NATIONAL TEXT NULL, ParentType TINYINT NULL, DisplayOrder INTEGER NOT NULL UNIQUE, DisplayEnable BOOLEAN NOT NULL ) /*=== Table: OrganismPart ===*/ /* Definitions of organism parts (or 'organs') in standard (constrained) terminology. A set of parts can and should be defined separately for each organism group. */ /* OrganismPartID: A number that uniquely identifies an organism part (primary key). */ /* OrganismGroup: The type of organism to which a set of part descriptions is applicable (plant, fungus, etc.). */ /* OrganismPart: Defines a part (or 'organ') of an organism of OrganismGroup in a standard (constrained) terminology. Abbreviated text displayed to user. */ /* Description: Supplementary explanation of the entry. */ /* DescriptionDe: Supplementary explanation of the entry (German). */ /* Notes: Internal development notes. */ /* ParentPartID: Defines a parent organism part that includes the current part. */ /* DisplayOrder: The order in which the entries are displayed. */ /* DisplayEnable: The entries are displayed only if marked here. */ CREATE TABLE OrganismPart ( OrganismPartID INTEGER IDENTITY NOT NULL PRIMARY KEY, OrganismGroup NATIONAL CHARACTER VARYING(255) NOT NULL UNIQUE DEFAULT 'plant', OrganismPart NATIONAL CHARACTER VARYING(20) NULL UNIQUE, Description NATIONAL CHARACTER VARYING(255) NULL, DescriptionDe NATIONAL CHARACTER VARYING(255) NULL, Notes NATIONAL CHARACTER VARYING(255) NULL, ParentPartID INTEGER NULL, DisplayOrder INTEGER NOT NULL UNIQUE, DisplayEnable BOOLEAN NOT NULL DEFAULT -1 ) /*=== Table: OrganismPartCombination ===*/ /* #####. */ /* OrganismPartID: A number that uniquely identifies an organism part (primary key). */ /* OrganismGroup: The type of organism to which a set of part descriptions is applicable (plant, fungus, etc.). */ /* OrganismPart: Defines a part (or 'organ') of an organism of OrganismGroup in a standard (constrained) terminology. Abbreviated text displayed to user. */ /* Description: Supplementary explanation of the entry. */ /* Notes: Internal development notes. */ /* ParentPartID: Defines a parent organism part that includes the current part. */ /* DisplayOrder: The order in which the entries are displayed. */ /* DisplayEnable: The entries are displayed only if marked here. */ CREATE TABLE OrganismPartCombination ( OrganismPartID INTEGER IDENTITY NOT NULL PRIMARY KEY, OrganismGroup NATIONAL CHARACTER VARYING(255) NOT NULL UNIQUE DEFAULT 'plant', OrganismPart NATIONAL CHARACTER VARYING(20) NULL UNIQUE, Description NATIONAL CHARACTER VARYING(255) NULL, Notes NATIONAL CHARACTER VARYING(255) NULL, ParentPartID INTEGER NULL, DisplayOrder INTEGER NOT NULL, DisplayEnable BOOLEAN NOT NULL DEFAULT -1 ) /*=== Table: OrganismPartElement ===*/ /* #####. */ /* OrganismPartID: A number that uniquely identifies an organism part (primary key). */ /* OrganismGroup: The type of organism to which a set of part descriptions is applicable (plant, fungus, etc.). */ /* OrganismPart: Defines a part (or 'organ') of an organism of OrganismGroup in a standard (constrained) terminology. Abbreviated text displayed to user. */ /* Description: Supplementary explanation of the entry. */ /* Notes: Internal development notes. */ /* ParentPartID: Defines a parent organism part that includes the current part. */ /* DisplayOrder: The order in which the entries are displayed. */ /* DisplayEnable: The entries are displayed only if marked here. */ CREATE TABLE OrganismPartElement ( OrganismPartID INTEGER IDENTITY NOT NULL PRIMARY KEY, OrganismGroup NATIONAL CHARACTER VARYING(255) NOT NULL UNIQUE DEFAULT 'plant', OrganismPart NATIONAL CHARACTER VARYING(20) NULL UNIQUE, Description NATIONAL CHARACTER VARYING(255) NULL, Notes NATIONAL CHARACTER VARYING(255) NULL, ParentPartID INTEGER NULL, DisplayOrder INTEGER NOT NULL, DisplayEnable BOOLEAN NOT NULL DEFAULT -1 ) /*=== Table: OrganismResource ===*/ /* Index of resources describing organisms, esp. images, drawings, photographs. The source reference is described in 'IndexingSource'. */ /* SourceID: Source ID, links resource with a reference (literature reference, specimen label, etc. ) in 'IndexingSource' (= foreign key). */ /* DisplayOrder: Defines ordering of resources (e.g. images). A simple sequence with step 100 is automatically created for new records; records can be moved or inserted between existing records by changing this number. */ /* SourceDetail: Information where resources (e.g. images) can be found in source. In the case of page numbers (incl. roman numbers) simply enter the number, else precede with 'Tab.', 'Fig.', etc. */ /* SourceDetailNumCache: (Calculated field, set to the numeric integer part of SourceDetailText, esp. page numbers. Only positive integer numbers can be stored here.). */ /* ResourceCategory: Resource category (e.g. drawing, photograph, b/w or color). */ /* ResourceNumber: Number of figure etc. as used in the source. Example: 'Fig. 23'. */ /* OriOrganism: Name of the organism described by the resource (e.g. illustrated), exactly as in source, without corrections. If a common name is given in addition to a scientific name, it should be included in brackets: 'Acer saccharum [sugar maple]'. */ /* EdtOrganism: OriOrganism interpreted as standard name. Enter the name as closely as possible, enter valid name of a synonym only if synonymization is not already defined in the tax. thesaurus! */ /* EdtOrganismNotes: Notes/remarks regarding the evaluation/interpretation of organism, its parts and identification quality. */ /* OriOrganismParts: Organism parts. Example for parasitic fungi: 'pycnidia;apothecia', etc. Entered as ';' separated list using English terminology. */ /* OriOrganismCitedSynonyms: Synonyms given in the original publication. Include indications of doubt like '?', use '=' and '=' (use '3=' if '=' is unavailable). Use ';' between names. Knowledge of these synonyms may help in understanding the taxon concepts of the original author(s). */ /* OriNotes: Additional information or annotations as they appear in the original source. */ /* LogCreated_User: Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible. */ /* LogCreated_Date: Date and time when record was first entered (= typed or imported) into this system. */ /* Filename: The file and pathname (or URL) in cases were the resouce has already been digitized (e.g. scanned image) AND copyright is available (document copyright issues under source!). */ CREATE TABLE OrganismResource ( SourceID INTEGER NOT NULL, DisplayOrder INTEGER NOT NULL, SourceDetail NATIONAL CHARACTER VARYING(50) NULL, SourceDetailNumCache INTEGER NOT NULL DEFAULT 0, ResourceCategory TINYINT NOT NULL, ResourceNumber NATIONAL CHARACTER VARYING(255) NULL, OriOrganism NATIONAL CHARACTER VARYING(255) NOT NULL, EdtOrganism NATIONAL CHARACTER VARYING(255) NULL, EdtOrganismNotes NATIONAL TEXT NULL, OriOrganismParts NATIONAL CHARACTER VARYING(255) NULL, OriOrganismCitedSynonyms NATIONAL CHARACTER VARYING(255) NULL, OriNotes NATIONAL TEXT NULL, LogCreated_User NATIONAL CHARACTER VARYING(50) NOT NULL, LogCreated_Date DATETIME NOT NULL DEFAULT current_timestamp, Filename NATIONAL CHARACTER VARYING(255) NULL, PRIMARY KEY (SourceID,DisplayOrder) ) /*=== Table: OrganismStage ===*/ /* Definitions of organism life stages in standard (constrained) terminology. A set of life stages can and should be defined separately for each organism group. */ /* OrganismStageID: A number that uniquely identifies an organism life stage (primary key). */ /* OrganismGroup: The type of organism to which a set of life stage categories is applicable (plant, fungus, etc.). */ /* OrganismStage: Life stage to which the organism interaction applies (e.g. developmental stage like seedling, young, adult plant) of an OrganismGroup in a standard (constrained) terminology. */ /* Description: Supplementary explanation of the entry. */ /* DescriptionDe: Supplementary explanation of the entry (German). */ /* Notes: Internal development notes. */ /* DisplayOrder: The order in which the entries are displayed. */ /* DisplayEnable: The entries are displayed only if marked here. */ /* StandardStage: (rust standard stage transformation prepared by M. Scholler). */ CREATE TABLE OrganismStage ( OrganismStageID INTEGER IDENTITY NOT NULL PRIMARY KEY, OrganismGroup NATIONAL CHARACTER VARYING(255) NOT NULL UNIQUE, OrganismStage NATIONAL CHARACTER VARYING(20) NULL UNIQUE, Description NATIONAL CHARACTER VARYING(255) NULL, DescriptionDe NATIONAL CHARACTER VARYING(255) NULL, Notes NATIONAL CHARACTER VARYING(255) NULL, DisplayOrder INTEGER NOT NULL UNIQUE, DisplayEnable BOOLEAN NOT NULL DEFAULT -1, StandardStage NATIONAL CHARACTER VARYING(255) NULL ) /*=== Table: SchollerRustStages ===*/ /* */ /* Stage: rust stage combination. */ /* Transformation: Transformation (mainly after Scholler, 1996: 17). */ /* DescriptionDe: Description German. */ /* Description: Description English. */ CREATE TABLE SchollerRustStages ( ID INTEGER IDENTITY NOT NULL PRIMARY KEY, Stage NATIONAL CHARACTER VARYING(255) NULL, Transformation NATIONAL CHARACTER VARYING(255) NULL, DescriptionDe NATIONAL CHARACTER VARYING(255) NULL, Description NATIONAL CHARACTER VARYING(255) NULL ) ALTER TABLE IndexingSource ADD FOREIGN KEY (DefaultInteractionConditions) REFERENCES OrganismInteractionConditions (ConditionID) ON UPDATE CASCADE, FOREIGN KEY (DefaultInteractionType) REFERENCES OrganismInteractionType (InteractionTypeID) ON UPDATE CASCADE, FOREIGN KEY (SourceCategory) REFERENCES USys_SpecialIndexingObjects (CategoryID) ON UPDATE CASCADE, FOREIGN KEY (DefaultResourceCategory) REFERENCES USys_SpecialIndexingObjects (CategoryID) ON UPDATE CASCADE, FOREIGN KEY (QualityCategory) REFERENCES USys_SpecialIndexingQuality (QualityCategoryID) ON UPDATE CASCADE ALTER TABLE IndexingSourceAnnotation ADD FOREIGN KEY (SourceID) REFERENCES IndexingSource (SourceID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE OrganismInteractionInterpretation ADD FOREIGN KEY (EdtInteractionConditions) REFERENCES OrganismInteractionConditions (ConditionID) ON UPDATE CASCADE, FOREIGN KEY (SourceID,ObservationDisplayOrder) REFERENCES OrganismInteractionObservation (SourceID,DisplayOrder) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (EdtInteractionType) REFERENCES OrganismInteractionType (InteractionTypeID) ON UPDATE CASCADE, FOREIGN KEY (EdtOrganism2Part) REFERENCES OrganismPart (OrganismPartID) ON UPDATE CASCADE, FOREIGN KEY (EdtOrganismPart) REFERENCES OrganismPart (OrganismPartID) ON UPDATE CASCADE, FOREIGN KEY (EdtOrganismStage) REFERENCES OrganismStage (OrganismStageID) ON UPDATE CASCADE, FOREIGN KEY (EdtOrganism2Stage) REFERENCES OrganismStage (OrganismStageID) ON UPDATE CASCADE, FOREIGN KEY (EdtOrganismQuality) REFERENCES USys_SpecialIndexingQuality (QualityCategoryID) ON UPDATE CASCADE, FOREIGN KEY (EdtOrganism2Quality) REFERENCES USys_SpecialIndexingQuality (QualityCategoryID) ON UPDATE CASCADE, FOREIGN KEY (EdtAreaQuality) REFERENCES USys_SpecialIndexingQuality (QualityCategoryID) ON UPDATE CASCADE ALTER TABLE OrganismInteractionObservation ADD FOREIGN KEY (SourceID) REFERENCES IndexingSource (SourceID) ON UPDATE CASCADE, FOREIGN KEY (OriInteractionConditions) REFERENCES OrganismInteractionConditions (ConditionID) ON UPDATE CASCADE, FOREIGN KEY (OriInteractionType) REFERENCES OrganismInteractionType (InteractionTypeID) ON UPDATE CASCADE ALTER TABLE OrganismInteractionReference ADD FOREIGN KEY (SourceID,ObservationDisplayOrder) REFERENCES OrganismInteractionObservation (SourceID,DisplayOrder) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE OrganismInteractionType ADD FOREIGN KEY (ParentType) REFERENCES OrganismInteractionType (InteractionTypeID) ON UPDATE CASCADE ALTER TABLE OrganismPart ADD FOREIGN KEY (ParentPartID) REFERENCES OrganismPart (OrganismPartID) ON UPDATE CASCADE ALTER TABLE OrganismResource ADD FOREIGN KEY (SourceID) REFERENCES IndexingSource (SourceID) ON UPDATE CASCADE, FOREIGN KEY (ResourceCategory) REFERENCES USys_SpecialIndexingObjects (CategoryID) ON UPDATE CASCADE /*** Remove this comment line to enable creation of column description for MS SQL Server 2000 *** exec sp_addextendedproperty N'MS_Description',N'A number that uniquely identifies a source for indexing projects, e.g. indexing organism interactions or images (primary key).',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'SourceID' exec sp_addextendedproperty N'MS_Description',N'Required classification of the information source (reference, label, etc.) for special indexing records (e.g. organism interaction observations).',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'SourceCategory' exec sp_addextendedproperty N'MS_Description',N'Optional: Data quality of this source. The values must come from the associated pick list.',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'QualityCategory' exec sp_addextendedproperty N'MS_Description',N'Additional notes referring to the estimation of data quality for this source.',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'QualityNotes' exec sp_addextendedproperty N'MS_Description',N'If source is a publication: the reference ID of that work. Refers to the ID code of the main ReferenceTitle table in the reference module (= foreign key).',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'RefID' exec sp_addextendedproperty N'MS_Description',N'If source is a publication: a short human readable description of the reference, obtained through the RefID from the reference subsystem (calculated field).',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'RefDescriptionCache' exec sp_addextendedproperty N'MS_Description',N'If source is a specimen: Standard abbreviation of the collection from which the specimen was obtained (e.g. ''B'' for Berlin herbarium). The full name is used if no acronym is available.',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'CollectionAbbreviation' exec sp_addextendedproperty N'MS_Description',N'If source is a specimen: Used only when a specimen record is available in a compatible collection database subsystem; refers to CollectionSpecimenID in that system (foreign key).',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'CollectionSpecimenID' exec sp_addextendedproperty N'MS_Description',N'If source is a specimen: Optionally used for accession number or storage location name (which may be different from current scientific name!), esp. if CollectionSpecimenID cannot be used because no compatible collection database subsystem is available.',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'CollectionSpecimenDescription' exec sp_addextendedproperty N'MS_Description',N'The point coordinate system used in the attribute ''OriAreaCoordinates'' of the entity ''OrganismInteractionObservation''.',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'AreaCoordinateSystem' exec sp_addextendedproperty N'MS_Description',N'The grid cell coordinate system used in the attribute ''OriAreaGridCoord'' of the entity ''OrganismInteractionObservation''.',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'AreaGridCoordSystem' exec sp_addextendedproperty N'MS_Description',N'If organism interactions (incl. geogr. distribution) are indexed: the default interaction type used for new observations recorded from this source.',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'DefaultInteractionType' exec sp_addextendedproperty N'MS_Description',N'If organism interactions (incl. geogr. distribution) are indexed: the default interaction conditions used for new observations recorded from this source.',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'DefaultInteractionConditions' exec sp_addextendedproperty N'MS_Description',N'If resources (esp. images printed in a book) are indexed: the default resource category used for new observations recorded from this source.',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'DefaultResourceCategory' exec sp_addextendedproperty N'MS_Description',N'Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'LogCreated_User' exec sp_addextendedproperty N'MS_Description',N'Date and time when record was first entered (= typed or imported) into this system.',N'user',N'dbo',N'table',N'IndexingSource',N'column',N'LogCreated_Date' exec sp_addextendedproperty N'MS_Description',N'Source ID, links annotation with ''IndexingSource'' (= foreign key).',N'user',N'dbo',N'table',N'IndexingSourceAnnotation',N'column',N'SourceID' exec sp_addextendedproperty N'MS_Description',N'The date when the annotation was entered into the system.',N'user',N'dbo',N'table',N'IndexingSourceAnnotation',N'column',N'AnnotationDate' exec sp_addextendedproperty N'MS_Description',N'Type of annotation, esp. ''data capture notes'', ''data import notes'', ''editing notes'', ''copyright agreements'', etc.',N'user',N'dbo',N'table',N'IndexingSourceAnnotation',N'column',N'AnnotationType' exec sp_addextendedproperty N'MS_Description',N'Person responsible for the source annotation.',N'user',N'dbo',N'table',N'IndexingSourceAnnotation',N'column',N'Responsible' exec sp_addextendedproperty N'MS_Description',N'The text of the annotation. Internal information, no web access!',N'user',N'dbo',N'table',N'IndexingSourceAnnotation',N'column',N'Annotation' exec sp_addextendedproperty N'MS_Description',N'Unique ID number of this interaction condition (primary key).',N'user',N'dbo',N'table',N'OrganismInteractionConditions',N'column',N'ConditionID' exec sp_addextendedproperty N'MS_Description',N'Short code for the interaction condition, displayed to user.',N'user',N'dbo',N'table',N'OrganismInteractionConditions',N'column',N'ConditionAbbreviation' exec sp_addextendedproperty N'MS_Description',N'Description of interaction condition.',N'user',N'dbo',N'table',N'OrganismInteractionConditions',N'column',N'ConditionDescription' exec sp_addextendedproperty N'MS_Description',N'Internal development notes about an interaction condition.',N'user',N'dbo',N'table',N'OrganismInteractionConditions',N'column',N'ConditionNotes' exec sp_addextendedproperty N'MS_Description',N'The order in which the entries are displayed.',N'user',N'dbo',N'table',N'OrganismInteractionConditions',N'column',N'DisplayOrder' exec sp_addextendedproperty N'MS_Description',N'The entries are displayed only if marked here.',N'user',N'dbo',N'table',N'OrganismInteractionConditions',N'column',N'DisplayEnable' exec sp_addextendedproperty N'MS_Description',N'Source ID, links observations with a reference (literature reference, specimen label, etc. ) in ''IndexingSource'' (= foreign key).',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'SourceID' exec sp_addextendedproperty N'MS_Description',N'Refers to DisplayOrder of ''OrganismInteractionObservation'', thus identifying a single observation record (= foreign key).',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'ObservationDisplayOrder' exec sp_addextendedproperty N'MS_Description',N'Date and time when the last editing was performed.',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtDate' exec sp_addextendedproperty N'MS_Description',N'Organism interaction type (e.g. parasitism, mutualism, etc.). Refers to categories defined in ''OrganismInteractionType'' (= foreign key).',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtInteractionType' exec sp_addextendedproperty N'MS_Description',N'Conditions under which the interaction occurred (e.g. ''natural'', ''artificial'', ''experimental''). Refers to conditions defined in ''OrganismInteractionConditions'' (= foreign key).',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtInteractionConditions' exec sp_addextendedproperty N'MS_Description',N'OriOrganism interpreted as standard name. Enter the name as closely as possible, enter valid name of a synonym only if synonymization is not already defined in the tax. thesaurus!',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtOrganism' exec sp_addextendedproperty N'MS_Description',N'Estimation of identification quality of 1st organism, either due to doubt by original author (e.g. a "cf. name" given) or due to problems in interpretation. Note that there is a separate category for type material!',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtOrganismQuality' exec sp_addextendedproperty N'MS_Description',N'Life- or spore stages of 1st organism in standard (constrained) terminology.',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtOrganismStage' exec sp_addextendedproperty N'MS_Description',N'Part/organ of 1st organism in standard (constrained) terminology (example: pycnidia on twigs...).',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtOrganismPart' exec sp_addextendedproperty N'MS_Description',N'Notes/remarks regarding the evaluation/interpretation of 1st organism, its stages, parts and identification quality.',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtOrganismNotes' exec sp_addextendedproperty N'MS_Description',N'OriOrganism2 interpreted. Enter the name as closely as possible, enter valid name of a synonym only of synonymization is not already defined in the tax. thesaurus!',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtOrganism2' exec sp_addextendedproperty N'MS_Description',N'Estimation of identification quality of EdtOrganism2, either due to doubt by original author (e.g. a "cf. name" given) or due to problems in interpretation. Note that there is a separate category for type material!',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtOrganism2Quality' exec sp_addextendedproperty N'MS_Description',N'Affected life stages of 2nd organism (e.g. host plant) in standard (constrained) terminology. Examples for plants: seedling, young plant, grown plant, etc.',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtOrganism2Stage' exec sp_addextendedproperty N'MS_Description',N'Part/organ of 2nd organism in standard (constrained) terminology (example: root, stem, leaf, flower, etc.).',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtOrganism2Part' exec sp_addextendedproperty N'MS_Description',N'Notes/remarks regarding the evaluation/interpretation of OriOrganism2, its stages, parts and identification quality.',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtOrganism2Notes' exec sp_addextendedproperty N'MS_Description',N'OriArea interpreted as standard geographic area (current English area name as verified in a gazetteer of geographic names).',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtArea' exec sp_addextendedproperty N'MS_Description',N'Estimation of quality of area interpretation, either due to doubt by original author or due to problems in interpretation.',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtAreaQuality' exec sp_addextendedproperty N'MS_Description',N'Notes/remarks regarding the evaluation/interpretation of ''OriArea'' to ''EdtArea''.',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtAreaNote' exec sp_addextendedproperty N'MS_Description',N'Use this field to document a problem with the application during data entry, or make notes to yourself.',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'Problem' exec sp_addextendedproperty N'MS_Description',N'Person responsible for the editing of an organism interaction observation (e.g. interpreting host and parasite name or identification quality, the geographic area, etc.).',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'EdtResponsible' exec sp_addextendedproperty N'MS_Description',N'Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'LogCreated_User' exec sp_addextendedproperty N'MS_Description',N'Date and time when record was first entered (= typed or imported) into this system.',N'user',N'dbo',N'table',N'OrganismInteractionInterpretation',N'column',N'LogCreated_Date' exec sp_addextendedproperty N'MS_Description',N'Source ID, links observations with a reference (literature reference, specimen label, etc. ) in ''IndexingSource'' (= foreign key).',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'SourceID' exec sp_addextendedproperty N'MS_Description',N'Defines ordering of observations. A simple sequence with step 100 is automatically created for new records; records can be moved or inserted between existing records by changing this number.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'DisplayOrder' exec sp_addextendedproperty N'MS_Description',N'Information where observation can be found in source. In the case of page numbers (incl. roman numbers) simply enter the number, else precede with ''Tab.'', ''Fig.'', etc.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'SourceDetail' exec sp_addextendedproperty N'MS_Description',N'(Calculated field, set to the numeric integer part of SourceDetailText, esp. page numbers. Only positive integer numbers can be stored here.).',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'SourceDetailNumCache' exec sp_addextendedproperty N'MS_Description',N'Organism interaction type (e.g. parasitism, mutualism, etc.). Refers to categories defined in ''OrganismInteractionType'' (= foreign key).',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriInteractionType' exec sp_addextendedproperty N'MS_Description',N'Conditions under which the interaction occurred (e.g. ''natural'', ''artificial'', ''experimental''). Refers to conditions defined in ''OrganismInteractionConditions'' (= foreign key).',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriInteractionConditions' exec sp_addextendedproperty N'MS_Description',N'Additional notes on interaction type (e.g. ''only on dead twigs'') and interaction conditions (e.g. ''from bot. garden'') present in the original source.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriInteractionNote' exec sp_addextendedproperty N'MS_Description',N'Name of the primary organism (e.g. a parasite), exactly as present in the original source, without corrections. If a common name is given in addition to a scientific name, it should be included in brackets: ''Acer saccharum [sugar maple]''.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriOrganism' exec sp_addextendedproperty N'MS_Description',N'Life stage(s) or spore stages (multiple stages separated with semicolon): anamorph/teleomorph, presence of spore stages like beta conidia; in rusts: aecia/uredinia/telia etc. Data entered exactly as in the original source, not translated to English.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriOrganismStages' exec sp_addextendedproperty N'MS_Description',N'Part(s) of primary organism. Examples for parasitic fungi: ''pycnidia'', ''apothecia'', etc. Data entered exactly as in the original source, not translated to English.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriOrganismParts' exec sp_addextendedproperty N'MS_Description',N'Synonyms given in the original publication. Include indications of doubt like ''?'', use ''='' and ''='' (use ''3='' if ''='' is unavailable). Use '';'' between names. Knowledge of these synonyms may help in understanding the taxon concepts of the original author(s).',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriOrganismCitedSynonyms' exec sp_addextendedproperty N'MS_Description',N'The higher taxa given in the original source for the primary organism (optional, entered only if considered relevant).',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriOrganismHigherTaxa' exec sp_addextendedproperty N'MS_Description',N'Name of the associated organism (e.g. a host/substrate), exactly as present in source, including common/vernacular names in ''()''. If only a common name is given in the original source, the scientific name should not be added from other sources!',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriOrganism2' exec sp_addextendedproperty N'MS_Description',N'Life stage(s) of associated organism affected by the interaction. Examples for plants: ''seed'', ''seedling'', ''young plant'', etc. Data entered exactly as in the original source, not translated to English.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriOrganism2Stages' exec sp_addextendedproperty N'MS_Description',N'Part(s) of associated organism affected by interaction. Examples for plants: ''root'', ''stem'', ''leaf'', ''flower'', etc. Data entered exactly as in the original source, not translated to English.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriOrganism2Parts' exec sp_addextendedproperty N'MS_Description',N'Synonyms given in the original publication. Include indications of doubt like ''?'', use ''='' and ''='' (use ''3='' if ''='' is unavailable). Use '';'' between names. Knowledge of these synonyms may help in understanding the taxon concepts of the original author(s).',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriOrganism2CitedSynonyms' exec sp_addextendedproperty N'MS_Description',N'The higher taxa given in the original source for the associated organism (optional, entered only if considered relevant).',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriOrganism2HigherTaxa' exec sp_addextendedproperty N'MS_Description',N'Geographical area as written in the original source (in the original form and language, not translated to standard terminology, compare EdtArea).',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriArea' exec sp_addextendedproperty N'MS_Description',N'Details of the geographical area/location; Normally everything below the county or city should be considered a detail. Example: ''2 km S of mill pond''.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriAreaDetail' exec sp_addextendedproperty N'MS_Description',N'Geographical area coordinates (excluding grid data) for an observation, exactly as given in the source. The coordinate system should normally be specified a single time in AreaCoordinateSystem of IndexingSource.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriAreaPointCoordinates' exec sp_addextendedproperty N'MS_Description',N'Geographical area grid cell coordinates for an observation, exactly as given in the source. The grid system should normally be specified a single time in AreaGridCoordSystem of IndexingSource.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriAreaGridCoordinates' exec sp_addextendedproperty N'MS_Description',N'Additional information or annotations as they appear in the original source.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriNotes' exec sp_addextendedproperty N'MS_Description',N'Optionally: symptoms given by original author for a specific observation. Symptoms may depend on the host, and even on the geographical origin!',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriSymptoms' exec sp_addextendedproperty N'MS_Description',N'Optionally: information whether morphological descriptions for OriOrganism are present; these may e.g. be important for the interpretation of the taxonomic concept.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriDescriptionPresent' exec sp_addextendedproperty N'MS_Description',N'Optionally: collector(s) of the original material (also: exsiccatum information), if cited in the source reference.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriCollectors' exec sp_addextendedproperty N'MS_Description',N'Optionally: a string specifying a collection date, range, or date parts. Examples: ''5-7.1940'', ''6-9'' (i.e. only the months are known). Use the sequence day-month-year (with century, i.e. not ''30.12.98'').',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'OriCollectionDate' exec sp_addextendedproperty N'MS_Description',N'Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'LogCreated_User' exec sp_addextendedproperty N'MS_Description',N'Date and time when record was first entered (= typed or imported) into this system.',N'user',N'dbo',N'table',N'OrganismInteractionObservation',N'column',N'LogCreated_Date' exec sp_addextendedproperty N'MS_Description',N'Source ID, links observations with a reference (literature reference, specimen label, etc. ) in ''IndexingSource'' (= foreign key).',N'user',N'dbo',N'table',N'OrganismInteractionReference',N'column',N'SourceID' exec sp_addextendedproperty N'MS_Description',N'Refers to ''DisplayOrder'' of ''OrganismInteractionObservation'' (= foreign key).',N'user',N'dbo',N'table',N'OrganismInteractionReference',N'column',N'ObservationDisplayOrder' exec sp_addextendedproperty N'MS_Description',N'The text of a literature or specimen reference cited for an interaction observation, exactly as given in the source. Examples: ''Miller (1920a)'', ''[471]'', or ''H.WB. 4225'' (for a specimen).',N'user',N'dbo',N'table',N'OrganismInteractionReference',N'column',N'OriCitedReference' exec sp_addextendedproperty N'MS_Description',N'The reference ID (RefID) of those references that can be identified in the linked references module (= foreign key).',N'user',N'dbo',N'table',N'OrganismInteractionReference',N'column',N'CitedRefID' exec sp_addextendedproperty N'MS_Description',N'A short human readable description of the reference, obtained through the RefID from the reference subsystem (calculated field).',N'user',N'dbo',N'table',N'OrganismInteractionReference',N'column',N'CitedRefDescriptionCache' exec sp_addextendedproperty N'MS_Description',N'Detail of cited reference (esp. a page number) on which the referenced information can be found. Do not confuse with the page number of the work evaluated itself (= citing reference), comp. SourceDetail.',N'user',N'dbo',N'table',N'OrganismInteractionReference',N'column',N'CitedRefDetail' exec sp_addextendedproperty N'MS_Description',N'Notes and comments, esp. regarding problems or doubt in the association between the original work and the.',N'user',N'dbo',N'table',N'OrganismInteractionReference',N'column',N'TranscriptionNotes' exec sp_addextendedproperty N'MS_Description',N'Person responsible for the transcription of OriCitedReference to CitedReferenceID.',N'user',N'dbo',N'table',N'OrganismInteractionReference',N'column',N'TranscriptionResponsible' exec sp_addextendedproperty N'MS_Description',N'Name of user who first entered (typed or imported) the transcription (not the entry of ''OriCitedReference''). This is the operator (or typist) name, which may be different from the person responsible.',N'user',N'dbo',N'table',N'OrganismInteractionReference',N'column',N'TranscriptionOperator' exec sp_addextendedproperty N'MS_Description',N'Date and time when transcription occurred.',N'user',N'dbo',N'table',N'OrganismInteractionReference',N'column',N'TranscriptionDate' exec sp_addextendedproperty N'MS_Description',N'Unique ID number of this interaction type (primary key).',N'user',N'dbo',N'table',N'OrganismInteractionType',N'column',N'InteractionTypeID' exec sp_addextendedproperty N'MS_Description',N'Short code for the interaction type, displayed to user.',N'user',N'dbo',N'table',N'OrganismInteractionType',N'column',N'InteractionAbbreviation' exec sp_addextendedproperty N'MS_Description',N'Description of interaction type (e.g. parasitism, mutualism, etc.).',N'user',N'dbo',N'table',N'OrganismInteractionType',N'column',N'InteractionDescription' exec sp_addextendedproperty N'MS_Description',N'Label displayed in user interface for primary organism. The default label is used when left empty.',N'user',N'dbo',N'table',N'OrganismInteractionType',N'column',N'Org1CustomLabel' exec sp_addextendedproperty N'MS_Description',N'Label displayed in user interface for associated organism (Organism2). The default label is used when left empty.',N'user',N'dbo',N'table',N'OrganismInteractionType',N'column',N'Org2CustomLabel' exec sp_addextendedproperty N'MS_Description',N'The organism group, as used in parts definitions. Empty if all groups apply.',N'user',N'dbo',N'table',N'OrganismInteractionType',N'column',N'Org1Group' exec sp_addextendedproperty N'MS_Description',N'The organism group for 2nd organism, as used in parts definitions. Empty if all groups apply.',N'user',N'dbo',N'table',N'OrganismInteractionType',N'column',N'Org2Group' exec sp_addextendedproperty N'MS_Description',N'Internal development notes about an interaction type.',N'user',N'dbo',N'table',N'OrganismInteractionType',N'column',N'InteractionNotes' exec sp_addextendedproperty N'MS_Description',N'Defines a more widely defined interaction type that include the current type.',N'user',N'dbo',N'table',N'OrganismInteractionType',N'column',N'ParentType' exec sp_addextendedproperty N'MS_Description',N'The order in which the entries are displayed.',N'user',N'dbo',N'table',N'OrganismInteractionType',N'column',N'DisplayOrder' exec sp_addextendedproperty N'MS_Description',N'The entries are displayed only if marked here.',N'user',N'dbo',N'table',N'OrganismInteractionType',N'column',N'DisplayEnable' exec sp_addextendedproperty N'MS_Description',N'A number that uniquely identifies an organism part (primary key).',N'user',N'dbo',N'table',N'OrganismPart',N'column',N'OrganismPartID' exec sp_addextendedproperty N'MS_Description',N'The type of organism to which a set of part descriptions is applicable (plant, fungus, etc.).',N'user',N'dbo',N'table',N'OrganismPart',N'column',N'OrganismGroup' exec sp_addextendedproperty N'MS_Description',N'Defines a part (or ''organ'') of an organism of OrganismGroup in a standard (constrained) terminology. Abbreviated text displayed to user.',N'user',N'dbo',N'table',N'OrganismPart',N'column',N'OrganismPart' exec sp_addextendedproperty N'MS_Description',N'Supplementary explanation of the entry.',N'user',N'dbo',N'table',N'OrganismPart',N'column',N'Description' exec sp_addextendedproperty N'MS_Description',N'Supplementary explanation of the entry (German).',N'user',N'dbo',N'table',N'OrganismPart',N'column',N'DescriptionDe' exec sp_addextendedproperty N'MS_Description',N'Internal development notes.',N'user',N'dbo',N'table',N'OrganismPart',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'Defines a parent organism part that includes the current part.',N'user',N'dbo',N'table',N'OrganismPart',N'column',N'ParentPartID' exec sp_addextendedproperty N'MS_Description',N'The order in which the entries are displayed.',N'user',N'dbo',N'table',N'OrganismPart',N'column',N'DisplayOrder' exec sp_addextendedproperty N'MS_Description',N'The entries are displayed only if marked here.',N'user',N'dbo',N'table',N'OrganismPart',N'column',N'DisplayEnable' exec sp_addextendedproperty N'MS_Description',N'A number that uniquely identifies an organism part (primary key).',N'user',N'dbo',N'table',N'OrganismPartCombination',N'column',N'OrganismPartID' exec sp_addextendedproperty N'MS_Description',N'The type of organism to which a set of part descriptions is applicable (plant, fungus, etc.).',N'user',N'dbo',N'table',N'OrganismPartCombination',N'column',N'OrganismGroup' exec sp_addextendedproperty N'MS_Description',N'Defines a part (or ''organ'') of an organism of OrganismGroup in a standard (constrained) terminology. Abbreviated text displayed to user.',N'user',N'dbo',N'table',N'OrganismPartCombination',N'column',N'OrganismPart' exec sp_addextendedproperty N'MS_Description',N'Supplementary explanation of the entry.',N'user',N'dbo',N'table',N'OrganismPartCombination',N'column',N'Description' exec sp_addextendedproperty N'MS_Description',N'Internal development notes.',N'user',N'dbo',N'table',N'OrganismPartCombination',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'Defines a parent organism part that includes the current part.',N'user',N'dbo',N'table',N'OrganismPartCombination',N'column',N'ParentPartID' exec sp_addextendedproperty N'MS_Description',N'The order in which the entries are displayed.',N'user',N'dbo',N'table',N'OrganismPartCombination',N'column',N'DisplayOrder' exec sp_addextendedproperty N'MS_Description',N'The entries are displayed only if marked here.',N'user',N'dbo',N'table',N'OrganismPartCombination',N'column',N'DisplayEnable' exec sp_addextendedproperty N'MS_Description',N'A number that uniquely identifies an organism part (primary key).',N'user',N'dbo',N'table',N'OrganismPartElement',N'column',N'OrganismPartID' exec sp_addextendedproperty N'MS_Description',N'The type of organism to which a set of part descriptions is applicable (plant, fungus, etc.).',N'user',N'dbo',N'table',N'OrganismPartElement',N'column',N'OrganismGroup' exec sp_addextendedproperty N'MS_Description',N'Defines a part (or ''organ'') of an organism of OrganismGroup in a standard (constrained) terminology. Abbreviated text displayed to user.',N'user',N'dbo',N'table',N'OrganismPartElement',N'column',N'OrganismPart' exec sp_addextendedproperty N'MS_Description',N'Supplementary explanation of the entry.',N'user',N'dbo',N'table',N'OrganismPartElement',N'column',N'Description' exec sp_addextendedproperty N'MS_Description',N'Internal development notes.',N'user',N'dbo',N'table',N'OrganismPartElement',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'Defines a parent organism part that includes the current part.',N'user',N'dbo',N'table',N'OrganismPartElement',N'column',N'ParentPartID' exec sp_addextendedproperty N'MS_Description',N'The order in which the entries are displayed.',N'user',N'dbo',N'table',N'OrganismPartElement',N'column',N'DisplayOrder' exec sp_addextendedproperty N'MS_Description',N'The entries are displayed only if marked here.',N'user',N'dbo',N'table',N'OrganismPartElement',N'column',N'DisplayEnable' exec sp_addextendedproperty N'MS_Description',N'Source ID, links resource with a reference (literature reference, specimen label, etc. ) in ''IndexingSource'' (= foreign key).',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'SourceID' exec sp_addextendedproperty N'MS_Description',N'Defines ordering of resources (e.g. images). A simple sequence with step 100 is automatically created for new records; records can be moved or inserted between existing records by changing this number.',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'DisplayOrder' exec sp_addextendedproperty N'MS_Description',N'Information where resources (e.g. images) can be found in source. In the case of page numbers (incl. roman numbers) simply enter the number, else precede with ''Tab.'', ''Fig.'', etc.',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'SourceDetail' exec sp_addextendedproperty N'MS_Description',N'(Calculated field, set to the numeric integer part of SourceDetailText, esp. page numbers. Only positive integer numbers can be stored here.).',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'SourceDetailNumCache' exec sp_addextendedproperty N'MS_Description',N'Resource category (e.g. drawing, photograph, b/w or color).',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'ResourceCategory' exec sp_addextendedproperty N'MS_Description',N'Number of figure etc. as used in the source. Example: ''Fig. 23''.',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'ResourceNumber' exec sp_addextendedproperty N'MS_Description',N'Name of the organism described by the resource (e.g. illustrated), exactly as in source, without corrections. If a common name is given in addition to a scientific name, it should be included in brackets: ''Acer saccharum [sugar maple]''.',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'OriOrganism' exec sp_addextendedproperty N'MS_Description',N'OriOrganism interpreted as standard name. Enter the name as closely as possible, enter valid name of a synonym only if synonymization is not already defined in the tax. thesaurus!',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'EdtOrganism' exec sp_addextendedproperty N'MS_Description',N'Notes/remarks regarding the evaluation/interpretation of organism, its parts and identification quality.',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'EdtOrganismNotes' exec sp_addextendedproperty N'MS_Description',N'Organism parts. Example for parasitic fungi: ''pycnidia;apothecia'', etc. Entered as '';'' separated list using English terminology.',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'OriOrganismParts' exec sp_addextendedproperty N'MS_Description',N'Synonyms given in the original publication. Include indications of doubt like ''?'', use ''='' and ''='' (use ''3='' if ''='' is unavailable). Use '';'' between names. Knowledge of these synonyms may help in understanding the taxon concepts of the original author(s).',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'OriOrganismCitedSynonyms' exec sp_addextendedproperty N'MS_Description',N'Additional information or annotations as they appear in the original source.',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'OriNotes' exec sp_addextendedproperty N'MS_Description',N'Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'LogCreated_User' exec sp_addextendedproperty N'MS_Description',N'Date and time when record was first entered (= typed or imported) into this system.',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'LogCreated_Date' exec sp_addextendedproperty N'MS_Description',N'The file and pathname (or URL) in cases were the resouce has already been digitized (e.g. scanned image) AND copyright is available (document copyright issues under source!).',N'user',N'dbo',N'table',N'OrganismResource',N'column',N'Filename' exec sp_addextendedproperty N'MS_Description',N'A number that uniquely identifies an organism life stage (primary key).',N'user',N'dbo',N'table',N'OrganismStage',N'column',N'OrganismStageID' exec sp_addextendedproperty N'MS_Description',N'The type of organism to which a set of life stage categories is applicable (plant, fungus, etc.).',N'user',N'dbo',N'table',N'OrganismStage',N'column',N'OrganismGroup' exec sp_addextendedproperty N'MS_Description',N'Life stage to which the organism interaction applies (e.g. developmental stage like seedling, young, adult plant) of an OrganismGroup in a standard (constrained) terminology.',N'user',N'dbo',N'table',N'OrganismStage',N'column',N'OrganismStage' exec sp_addextendedproperty N'MS_Description',N'Supplementary explanation of the entry.',N'user',N'dbo',N'table',N'OrganismStage',N'column',N'Description' exec sp_addextendedproperty N'MS_Description',N'Supplementary explanation of the entry (German).',N'user',N'dbo',N'table',N'OrganismStage',N'column',N'DescriptionDe' exec sp_addextendedproperty N'MS_Description',N'Internal development notes.',N'user',N'dbo',N'table',N'OrganismStage',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'The order in which the entries are displayed.',N'user',N'dbo',N'table',N'OrganismStage',N'column',N'DisplayOrder' exec sp_addextendedproperty N'MS_Description',N'The entries are displayed only if marked here.',N'user',N'dbo',N'table',N'OrganismStage',N'column',N'DisplayEnable' exec sp_addextendedproperty N'MS_Description',N'(rust standard stage transformation prepared by M. Scholler).',N'user',N'dbo',N'table',N'OrganismStage',N'column',N'StandardStage' exec sp_addextendedproperty N'MS_Description',N'rust stage combination.',N'user',N'dbo',N'table',N'SchollerRustStages',N'column',N'Stage' exec sp_addextendedproperty N'MS_Description',N'Transformation (mainly after Scholler, 1996: 17).',N'user',N'dbo',N'table',N'SchollerRustStages',N'column',N'Transformation' exec sp_addextendedproperty N'MS_Description',N'Description German.',N'user',N'dbo',N'table',N'SchollerRustStages',N'column',N'DescriptionDe' exec sp_addextendedproperty N'MS_Description',N'Description English.',N'user',N'dbo',N'table',N'SchollerRustStages',N'column',N'Description' GO *** Remove this comment line to enable creation of column description for MS SQL Server 2000 ***/