/* 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. Originally this file attempted to use */
/*   Standard SQL for both. However, a common denominator could not be found. A special PostgreSQL file */ 
/*   is now created as well as the current, aiming more at SQL-Server dialects (but using SQL92  */
/*   whereever possible). The following changes may have to be made: */
/*   Standard SQL 92: replace the data type BIT with SQL92 BOOLEAN */
/*   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 default values for boolean fields with 'true' and 'false' */
/*   PostgreSQL: The modeler can create special postgress SQL files as a separate file, it will be easiest to use those instead of the standard file. */
/*  Note: CREATE INDEX (other than primary, foreign, or unique key constraints) are missing at the moment; to be added later */
/*  Generated on 5.Mrz.2002 17:28 by Diversity Workbench: Diversity Information Model Documenter, Vers. 2.0 (G. Hagedorn) */



/*=== Table: TaxonomyActionOnName ===*/
/* Taxonomy: Secondary action, affecting the status of a taxon. Examples are neo-, lecto- or epitypifications and conservation/rejection. */
  /*   ActionID: Unique ID for this record. */
  /*   NomID: The taxon concerning this action. Refers to the NomID code of TaxonomyName (= foreign key). */
  /*   ActionType: Type of nomenclatural action: conservation, rejection, neo-, lecto- or epitypification, emendation. The sanctioning of a name should not be recorded here. */
  /*   InternalNote: Additional information regarding the typification or conservation/rejection. */
  /*   RefID: Reference ID of the reference containing the nomenclatural action defined in ActionType. Refers to the ID code of the main ReferenceTitle table in the reference module  (= foreign key). */
  /*   RefDescriptionCache: A short human readable description of the reference, obtained through the RefID from the reference subsystem (calculated field). */
  /*   RefPage: Relevant detail in a nomenclatural action reference; usually number of the page on which the action is described. */
  /*   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. */
  /*   TypificationSpecimenDescription: Only for typification actions: A user readable description of the specimen to which the typification refers (collection acronym + storage code / name under which specimen is stored). */
  /*   TypificationSpecimenID: Only for typification actions: If a specimen collection database subsystem is available, the relevant specimen unit identifier in that system is stored here (added in addition to a user readable TypificationSpecimenDescription). */
CREATE TABLE TaxonomyActionOnName (
    ActionID INTEGER IDENTITY   NOT NULL PRIMARY KEY,
    NomID INTEGER NOT NULL,
    ActionType NATIONAL CHARACTER VARYING(1) NOT NULL,
    InternalNote NATIONAL TEXT NULL,
    RefID NATIONAL CHARACTER VARYING(20) NOT NULL,
    RefDescriptionCache NATIONAL CHARACTER VARYING(255) NULL,
    RefPage NATIONAL CHARACTER VARYING(50) NULL,
    LogCreated_User NATIONAL CHARACTER VARYING(50) NOT NULL,
    LogCreated_Date DATETIME NOT NULL DEFAULT current_timestamp,
    TypificationSpecimenDescription NATIONAL CHARACTER VARYING(255) NULL,
    TypificationSpecimenID NATIONAL CHARACTER VARYING(255) NULL
);




/*=== Table: TaxonomyCitedSpecimen ===*/
/* Taxonomy: Specimen (esp. type specimens) that have been studied or shall be cited in a taxonomic monograph. */
  /*   CitedSpecimenID: Unique ID for a cited specimen (primary key). */
  /*   OpinionID: All cited specimens must refer to a taxonomic opinion that defines a NomID, project marker, and responsible scientist (foreign key). */
  /*   CollectionAcronym: Standard abbreviation of the collection from which the studied specimen was obtained (e.g. 'B' for Berlin herbarium). The full name is used if no acronym is available. */
  /*   CollectionSpecimenID: Used only when a specimen record is available in a compatible collection database subsystem; refers to CollectionSpecimenID in that system (foreign key). */
  /*   CollectionSpecimenDescription: Optionally used for accession number or storage location name (which may be different from current scientific name!), esp. if CollectionSpecimenID can not be used because no compatible collection database subsystem is available. */
  /*   TypeStatus: Type, holotype, syntype, paratype, isotype, lectotype, neotype, epitype, etc. */
  /*   ReportedNote: Annotation regarding the studied specimen that will be output after the taxon in a report. */
  /*   InternalNote: An internal note of the responsible person concerning the studied specimen. This information is NOT included in any report. */
  /*   Studied: False = the specimen is known to exist, but has not (perhaps not yet) been studied by the person named under Responsible. */
  /*   IncludeInReport: False = the information on the studied specimen is suppressed in reports, but is maintained in the database. */
CREATE TABLE TaxonomyCitedSpecimen (
    CitedSpecimenID INTEGER IDENTITY   NOT NULL PRIMARY KEY,
    OpinionID INTEGER NOT NULL,
    CollectionAcronym NATIONAL CHARACTER VARYING(50) NULL,
    CollectionSpecimenID NATIONAL CHARACTER VARYING(255) NULL,
    CollectionSpecimenDescription NATIONAL CHARACTER VARYING(255) NULL,
    TypeStatus NATIONAL CHARACTER VARYING(255) NULL,
    ReportedNote NATIONAL TEXT NULL,
    InternalNote NATIONAL TEXT NOT NULL,
    Studied BIT NOT NULL DEFAULT 0,
    IncludeInReport BIT NOT NULL DEFAULT 1
);




/*=== Table: TaxonomyConcept ===*/
/* Taxonomy: Concept of taxa. */
  /*   TaxonID: Unique ID code for a taxonomic concept (primary key). */
  /*   NomID: The ID of the name on which the concept is based. Each name has at least a default concept. Refers to the NomID code of TaxonomyName (= foreign key). */
  /*   ConceptQualifier: Empty for default and primary concept; else 's. lat.'/'s. str.' (usually used without a ConceptReference); the qualifier is not limited to the picklist shown! */
  /*   ConceptCitationPrefix: Empty for default and primary concept; else 'sec.', 'sensu', 'emend.'; if a prefix is set a concept citation has to be given. */
  /*   ConceptCitation: Empty for default concept, 'primary' if concept known to be identical with original publication of name, else author(s) of secondary concept (including the publication year, if possible). */
  /*   RefID: Reference ID of the concept publication. Refers to the ID code of the main ReferenceTitle table in the reference module  (= foreign key). */
  /*   RefNotes: Additional information regarding reference, esp. if doubtful or not yet present in reference subsystem. All other notes should be in the user specific TaxonomyOpinions. */
  /*   NameCache: Calculated: Full, standardized name for the new taxon, calculated from genus, species and infraspecific epithet and authors. The value is unique, since it includes the author for higher taxa (genera, families) as well as for species. */
  /*   NameCache_html: Calculated: Like NameCache, but italic and plain text is formatted using xhtml markup (<i>/</i>). */
  /*   NameCache_NoAuthors: Calculated: Like NameCache, but without any authors. Duplicates may occur here, and taxa with homonyms can be detected using this attribute. Where no homonyms are found, names from other data sources may be compared based on this field alone. */
  /*   NameCache_inverted: Calculated: Like NameCache, but for species or infraspecific taxa the lowest rank name is printed first ('species-epitheton, Genus' or 'variety (var.) species-epitheton, Genus'). */
  /*   NameCache_PlusYear: Calculated: Like NameCache, but with year of publication. Duplicates may occur here, and taxa with homonyms can be detected using this attribute. Where no homonyms are found, names from other data sources may be compared based on this field alone. */
CREATE TABLE TaxonomyConcept (
    TaxonID INTEGER IDENTITY   NOT NULL PRIMARY KEY,
    NomID INTEGER NOT NULL UNIQUE,
    ConceptQualifier NATIONAL CHARACTER VARYING(100) NULL,
    ConceptCitationPrefix NATIONAL CHARACTER VARYING(20) NULL UNIQUE,
    ConceptCitation NATIONAL CHARACTER VARYING(255) NULL UNIQUE,
    RefID NATIONAL CHARACTER VARYING(20) NULL,
    RefNotes NATIONAL CHARACTER VARYING(255) NULL,
    NameCache NATIONAL CHARACTER VARYING(255) NOT NULL UNIQUE,
    NameCache_html NATIONAL CHARACTER VARYING(255) NOT NULL UNIQUE,
    NameCache_NoAuthors NATIONAL CHARACTER VARYING(255) NOT NULL,
    NameCache_inverted NATIONAL CHARACTER VARYING(255) NOT NULL UNIQUE,
    NameCache_PlusYear NATIONAL CHARACTER VARYING(255) NOT NULL
);




/*=== Table: TaxonomyConceptChanges ===*/
/* Taxonomy: A technical log of changes of taxonomic or nomenclatural information maintained automatically by the database (user, date, entities & attributes affected). */
  /*   TaxonID: The ID of the taxonomic concept (TaxonID) that was changed by the user. Refers to the NomID code of TaxonomyName (= foreign key). */
  /*   Changes: Attributes and data affected by changes, details of changes. */
  /*   LogUpdated_User: Name of user who last updated the record. This is the operator (or typist) name, which may be different from the person responsible. */
  /*   LogUpdated_Date: Date and time of last update of the record. */
CREATE TABLE TaxonomyConceptChanges (
    TaxonID INTEGER NOT NULL,
    Changes NATIONAL TEXT NOT NULL,
    LogUpdated_User NATIONAL CHARACTER VARYING(50) NOT NULL,
    LogUpdated_Date DATETIME NOT NULL,
  PRIMARY KEY (LogUpdated_Date,TaxonID)
);




/*=== Table: TaxonomyHierarchy ===*/
/* Taxonomy: Hierarchy above the species. Each responsible user can create an independent taxonomic system. */
  /*   ProjectMarker: Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the user module. */
  /*   TaxonID: Unique ID code of the higher taxon. Refers to the TaxonID code of TaxonomyConcept (= foreign key). */
  /*   Parent_TaxonID: Next higher taxon (e.g. the family or subfamily if this taxon is a genus). */
  /*   ReportedNote: A note of the responsible person concerning this hierarchization that will be output in a report, e.g. 'fide Author 1999'. */
  /*   InternalNote: An internal note of the responsible person concerning this hierarchization. This information is NOT included in any report. */
  /*   RefID: If the classification is based on a publication: the reference ID of that work. */
  /*   RefDescriptionCache: If the classification is based on a publication: a short human readable description of the reference, obtained through the RefID from the reference subsystem (calculated field). */
  /*   RefPage: If the classification is based on a publication: relevant detail; usually page number where the opinion is published. */
  /*   Responsible: The person responsible for grouping this taxon into a higher taxon. */
  /*   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. */
  /*   HierarchyListCache: CALCULATED FIELD: List of higher taxa for faster access: "div.; class; ord.; fam.". */
CREATE TABLE TaxonomyHierarchy (
    ProjectMarker NATIONAL CHARACTER VARYING(25) NOT NULL,
    TaxonID INTEGER NOT NULL,
    Parent_TaxonID INTEGER NULL,
    ReportedNote NATIONAL CHARACTER VARYING(255) NULL,
    InternalNote NATIONAL TEXT NULL,
    RefID NATIONAL CHARACTER VARYING(20) NULL,
    RefDescriptionCache NATIONAL CHARACTER VARYING(255) NULL,
    RefPage NATIONAL CHARACTER VARYING(50) NULL,
    Responsible NATIONAL CHARACTER VARYING(50) NOT NULL,
    LogCreated_User NATIONAL CHARACTER VARYING(50) NULL,
    LogCreated_Date DATETIME NULL DEFAULT current_timestamp,
    HierarchyListCache NATIONAL CHARACTER VARYING(255) NULL,
  PRIMARY KEY (ProjectMarker,TaxonID)
);




/*=== Table: TaxonomyName ===*/
/* Taxonomy: Supertype entity, providing a nomenclatural ID for all names introduced as taxa (infraspecific, species, genus, family, etc.). Contains only objective information; all scientific opinion is placed in ...Opinion, ...Synonymy, & ...Hierarchy. */
  /*   NomID: Unique ID code for the nomenclatural name (primary key). */
  /*   CreationType: T: taxon based on new type; C: combination based on a previously publ. name ('comb. nov.'), N: new name ('nom.nov.') introduced to replace a homonym (may occur for genera!), V: validation of previously invalidly publ. taxon name ('ex'), or U: for unknown. */
  /*   TaxonomicRank: Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank). */
  /*   HigherTaxonName: If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc. */
  /*   SpeciesGenusID: If rank is species or below: NomID code of the Genus name. Refers to TaxonomyName (= foreign key) where TaxonomicRank = genus. */
  /*   SpeciesEpithet: If rank is species or below: Species epithet, for example 'alba' in 'Abies alba Miller' (currently accepted spelling). */
  /*   TaxonAuthors: For all taxonomic ranks: Author(s) of the taxon, abbreviated according to authors standard, including validating authors ('ex'), optionally including sanctioning authors or "in" authors, excluding basionym authors in '()' (see TaxonBasionymAuthors). */
  /*   TaxonBasionymAuthors: For all taxonomic ranks, only for 'comb. nov.' or 'nom. nov.': Author(s) of the basionym (will be displayed in in '()', do not enter the parentheses), abbreviated according to authors standard. */
  /*   BasionymNomID: Basionym: If CreationType is 'comb. nov.' or replacement ('nom. nov.'), of another name based on the same type material. Refers to ID code of corresponding TaxonomyName (= foreign key). */
  /*   ValidatedNomID: Validated name: If CreationType is validation ('ex') of another name based on the same type material. Refers to ID code of invalidly publ. TaxonomyName (= foreign key). */
  /*   InfraspecificEpithet: If rank is infraspecific: Infraspecific epithet (currently accepted spelling). Note: the rank is known from required attribute TaxonomicRank in TaxonomyName (= the supertype entity). */
  /*   TypeGenus_NomID: If rank is suprageneric: Type genus of taxon. Refers to the ID code of TaxonomyName (= foreign key). */
  /*   TypeSpecies_NomID: If rank is genus or infrageneric: Type species of genus or infrageneric taxon. Refers to the NomID code of TaxonomyName (= foreign key). */
  /*   TypeSpecimenDeposition: If rank is species or below: Information on deposition of type material in a collection, entered exactly as written in the protologue (original taxon description). */
  /*   TypeSpecimenLocation: If rank is species or below: Optional information on the geographic location of type material, entered exactly as written in the protologue (i.e. not as known from type specimen studied elsewhere!). */
  /*   TypeSpecimenSubstrate: If rank is species or below: Optional information on substrate (anorganic, or living/dead plant, animal, or fungus) of type material, entered exactly as written in the protologue (i.e. not as known from type specimen studied elsewhere!). */
  /*   TypeSpecimenCollectors: If rank is species or below: Optional information on collector(s) of type material  (separate multiple collectors with a ";"), entered exactly as written in the protologue (i.e. not as known from type specimen studied elsewhere!). */
  /*   TypeSpecimenInformation: If rank is species or below: Optional further information on type material, esp. collection date and number, entered exactly as written in the protologue (i.e. not as known from type specimen studied elsewhere!). */
  /*   GenusIsAsexual: If rank is genus: Checked (or true) -> this an anamorph genus, containing asexual forms only (relevant for fungi). The information can also be obtained from the taxonomic hierarchy; it is always added here to be available when the hierarchy is incomplete. */
  /*   ReportedCitation: Optional text of citation (without year); used only when default reference description is unsatisfactorily (esp. abbreviated tax. book titles, exsiccata references). If present, this information is used in preference over the RefDescriptionCache. */
  /*   RefID: Reference ID of the original nomenclatural citation/protologue. Refers to the ID code of the main ReferenceTitle table in the reference module  (= foreign key). */
  /*   RefDescriptionCache: A short human readable description of the reference, obtained through the RefID from the references subsystem (calculated field). */
  /*   RefPage: Page on which the nomenclatural citation/protologue of name starts in the reference. */
  /*   RefHasReprintPagination: If checked (or 'True'), the true page number is unknown and only a reprint page number (pagination starting w. 1...) is entered in RefPage. In tax. monographs this situation is often indicated by 'extr.' or 'extractum' after the page number. */
  /*   RefYear: Publication year of taxonomic name, will be automatically entered if a RefID is selected from the reference module. (Note: synonym output is sorted by this year). */
  /*   IsHybrid: If checked (or 'True'), the new taxon is a hybrid with or without a hybrid epithet. */
  /*   HybridNomID1: If IsHybrid is checked (or 'True'): Name of hybrid species 1. Refers to NomID code of publ. TaxonomyName (= foreign key). */
  /*   HybridNomID2: If IsHybrid is checked (or 'True'): Name of hybrid species 2. Refers to NomID code of publ. TaxonomyName (= foreign key). */
  /*   OriginalNameSpelling: Original spelling of taxonomic name in the protologue publication. Recorded only, if different from current taxon name. */
  /*   OriginalTaxonPlacement: Taxonomic placement (e.g. family or division) mentioned in the original description. This is NOT the current taxonomic placement! */
  /*   OriginalDiagnosisLatin: Optional: The full text of the Latin description/diagnosis in the protologue. */
  /*   OriginalDiagnosisOther: Optional: The full text of the original description/diagnosis in the protologue, if a diagnosis in another language than Latin was provided. To be entered into the database only if no copyright is violated. */
  /*   OriginalPublScan: Optional: a URL under which the scanned text/illustrations of the nomenclatural publication for the name can be found. */
  /*   IndexingReference: Optional: A secondary reference indexing this taxon, e.g. Saccardo, Index of Fungi, etc. Entered as text, not as reference ID! */
  /*   ImportedFrom: If imported from another database: The name of the database system or provider. Otherwise empty. */
  /*   ImportedID: If imported from another database: An ID value to later re-identify the record in that database may be stored here. */
  /*   IneditedResponsible: Empty for published names, filled w. the name of the responsible person for unpublished ('inedited') names entered in the database. These may not appear in any reports, until specifically requested for a report that will be used to publish the name. */
  /*   Problem: Problem with data entry (not with the taxon). */
  /*   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 TaxonomyName (
    NomID INTEGER IDENTITY   NOT NULL PRIMARY KEY,
    CreationType NATIONAL CHARACTER VARYING(1) NOT NULL DEFAULT 'U',
    TaxonomicRank TINYINT NOT NULL,
    HigherTaxonName NATIONAL CHARACTER VARYING(255) NULL UNIQUE,
    SpeciesGenusID INTEGER NULL,
    SpeciesEpithet NATIONAL CHARACTER VARYING(255) NULL,
    TaxonAuthors NATIONAL CHARACTER VARYING(255) NULL,
    TaxonBasionymAuthors NATIONAL CHARACTER VARYING(255) NULL,
    BasionymNomID INTEGER NULL,
    ValidatedNomID INTEGER NULL,
    InfraspecificEpithet NATIONAL CHARACTER VARYING(255) NULL,
    TypeGenus_NomID INTEGER NULL,
    TypeSpecies_NomID INTEGER NULL,
    TypeSpecimenDeposition NATIONAL CHARACTER VARYING(255) NULL,
    TypeSpecimenLocation NATIONAL TEXT NULL,
    TypeSpecimenSubstrate NATIONAL TEXT NULL,
    TypeSpecimenCollectors NATIONAL TEXT NULL,
    TypeSpecimenInformation NATIONAL TEXT NULL,
    GenusIsAsexual BIT NULL DEFAULT Null,
    ReportedCitation NATIONAL CHARACTER VARYING(255) NULL,
    RefID NATIONAL CHARACTER VARYING(20) NULL,
    RefDescriptionCache NATIONAL CHARACTER VARYING(255) NULL,
    RefPage NATIONAL CHARACTER VARYING(50) NULL,
    RefHasReprintPagination BIT NOT NULL DEFAULT 0,
    RefYear INTEGER NULL,
    IsHybrid BIT NULL,
    HybridNomID1 INTEGER NULL,
    HybridNomID2 INTEGER NULL,
    OriginalNameSpelling NATIONAL CHARACTER VARYING(255) NULL,
    OriginalTaxonPlacement NATIONAL CHARACTER VARYING(255) NULL,
    OriginalDiagnosisLatin NATIONAL TEXT NULL,
    OriginalDiagnosisOther NATIONAL TEXT NULL,
    OriginalPublScan NATIONAL CHARACTER VARYING(255) NULL,
    IndexingReference NATIONAL CHARACTER VARYING(255) NULL,
    ImportedFrom NATIONAL CHARACTER VARYING(50) NULL,
    ImportedID NATIONAL CHARACTER VARYING(255) NULL,
    IneditedResponsible NATIONAL CHARACTER VARYING(50) NULL,
    Problem NATIONAL CHARACTER VARYING(255) NULL,
    LogCreated_User NATIONAL CHARACTER VARYING(50) NULL,
    LogCreated_Date DATETIME NOT NULL DEFAULT current_timestamp
);




/*=== Table: TaxonomyNameChanges ===*/
/* Taxonomy: A technical log of changes of taxonomic or nomenclatural information maintained automatically by the database (user, date, entities & attributes affected). */
  /*   NomID: The ID of the taxonomic name that was changed by the user. Refers to the NomID code of TaxonomyName (= foreign key). */
  /*   Changes: Attributes and data affected by changes, details of changes. */
  /*   LogUpdated_User: Name of user who last updated the record. This is the operator (or typist) name, which may be different from the person responsible. */
  /*   LogUpdated_Date: Date and time of last update of the record. */
CREATE TABLE TaxonomyNameChanges (
    NomID INTEGER NOT NULL,
    Changes NATIONAL TEXT NOT NULL,
    LogUpdated_User NATIONAL CHARACTER VARYING(50) NOT NULL,
    LogUpdated_Date DATETIME NOT NULL,
  PRIMARY KEY (LogUpdated_Date,NomID)
);




/*=== Table: TaxonomyNameVariants ===*/
/* Taxonomy: Name variants of NomID's and TaxonID's (different concepts). */
  /*   NomID: Unique ID code for the nomenclatural name (= foreign key). */
  /*   TaxonID: Unique ID code for a taxonomic concept (= foreign key). */
  /*   TaxonNameVariant: Name variant: a complete name with or without authors that could be associated with a NomID as it has been used, e.g. if different orthographic opinions exist, original spelling ('Evonymus'  vs. 'Euonymus') or name variants used by concept authors. */
  /*   Source: Source for name variant: user name when entered directly, description of data import, 'Original Spelling', or 'NameBuilder' for names creates from TaxonomyName information (each change in NameCache is copied as a name variant). */
  /*   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 TaxonomyNameVariants (
    NomID INTEGER NOT NULL,
    TaxonID INTEGER NOT NULL,
    TaxonNameVariant NATIONAL CHARACTER VARYING(255) NOT NULL,
    Source NATIONAL CHARACTER VARYING(255) NULL,
    LogCreated_User NATIONAL CHARACTER VARYING(50) NULL,
    LogCreated_Date DATETIME NOT NULL DEFAULT current_timestamp,
  PRIMARY KEY (NomID,TaxonNameVariant,TaxonID)
);




/*=== Table: TaxonomyRank ===*/
/* Taxonomy: taxonomic ranks ranging from subforma to superregnum. */
  /*   RankID: The logical order of ranks (and display order), can be tested to find false hierarchizations or combinations Do not change the code, it is used in several restriction queries! */
  /*   RankCode: A unique user readable code for the taxonomic rank that is used in TaxonomyName. */
  /*   Description: Single line description of the rank. */
  /*   Output: Output elements for the rank, stored as a list of two elements (prefix string-semicolon-postfix string). */
  /*   Notes: Internal development notes regarding the taxonomic rank. */
  /*   DisplayOrder: The order in which the entries are displayed. */
  /*   DisplayEnable: The entries are displayed only if marked here. */
CREATE TABLE TaxonomyRank (
    RankID TINYINT NOT NULL PRIMARY KEY,
    RankCode NATIONAL CHARACTER VARYING(20) NOT NULL,
    Description NATIONAL CHARACTER VARYING(255) NULL,
    Output NATIONAL CHARACTER VARYING(255) NULL,
    Notes NATIONAL CHARACTER VARYING(255) NULL,
    DisplayOrder INTEGER NOT NULL UNIQUE,
    DisplayEnable BIT NOT NULL
);




/*=== Table: TaxonomyRevision ===*/
/* Taxonomy: Information defining a revision, opinion or comment relating to the status (valid, accepted, etc.) of a nomenclatural name. */
  /*   RevisionID: Unique ID code for the opinion (primary key). Note that the combination of NomID, ProjectMarker, and Responsible must also be unique and not null (candidate key). */
  /*   TaxonID: The taxon this opinion refers to. Refers to the NomID code of TaxonomyName (= foreign key). */
  /*   ProjectMarker: Each project can have a different opinion regarding synonmy. Refers to the common project definition in the user module. */
  /*   Responsible: The person responsible for this opinion/assessment on a taxon. */
  /*   WorkingStatus: Working status of taxonomic name in current project: I=Included, D=Doubtful, E=Excluded, etc. Synonyms of accepted taxa should have status I. The report may be grouped by these attributes. */
  /*   NomenclaturalStatus: ... categories for effective/valid/legitimate... esp. 'nom. illeg.', 'nom. inval.', 'nom. nudum', etc. */
  /*   ReportedNote: Taxonomic remarks that will be output after the taxon in a report. This includes an explanation, esp. the relevant articles in the code of nomenclature. */
  /*   InternalNote: An internal note of the responsible person concerning this name. This information is NOT included in any report. */
  /*   RefID: If the opinion is based on a publication: the reference ID of that work. */
  /*   RefDescriptionCache: If the opinion is based on a publication: a short human readable description of the reference, obtained through the RefID from the reference subsystem (calculated field). */
  /*   RefPage: If the opinion is based on a publication: relevant detail; usually page number where the opinion is published. */
  /*   UserMarker1: A temporary marker or keyword assigned by user for searching and sorting purposes while a group is reviewed. Any information can be entered here, but it will be visible only internally. */
  /*   UserMarker2: A temporary marker or keyword assigned by user for searching and sorting purposes while a group is reviewed. Any information can be entered here, but it will be visible only internally. */
  /*   Problem: Temporary problem with data entry (not with the taxon, cmp. ReportedNote/InternalNote for permanent notes on problems). */
  /*   CheckPlausible_User: Name of user responsible for a first plausibility or consistency check of the name and taxon concepts. User and Date are automatically filled if 'Original check' performed directly. */
  /*   CheckPlausible_Date: Date and time when plausibility/consistency was checked (i.e. data entry rules and spelling errors checked, no comparison with original publication). */
  /*   CheckOriginal_User: Name of user responsible for comparison of name and taxon concept records with original publication. */
  /*   CheckOriginal_Date: Date and time when entry was compared with the original publication. */
  /*   FinalCheck_User: Name of user responsible for final review of taxon name, the presence of a name here indicates that the record is ready for publication. */
  /*   FinalCheck_Date: Date and time when final check was performed. Note: it is possible to set FinalCheck without CheckOriginal, e.g. when another users has already checked the original publication. */
  /*   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 TaxonomyRevision (
    RevisionID INTEGER IDENTITY   NOT NULL PRIMARY KEY,
    TaxonID INTEGER NOT NULL UNIQUE,
    ProjectMarker NATIONAL CHARACTER VARYING(25) NOT NULL UNIQUE,
    Responsible NATIONAL CHARACTER VARYING(50) NOT NULL UNIQUE,
    WorkingStatus NATIONAL CHARACTER VARYING(1) NULL,
    NomenclaturalStatus NATIONAL CHARACTER VARYING(255) NULL,
    ReportedNote NATIONAL TEXT NULL,
    InternalNote NATIONAL TEXT NOT NULL,
    RefID NATIONAL CHARACTER VARYING(20) NULL,
    RefDescriptionCache NATIONAL CHARACTER VARYING(255) NULL,
    RefPage NATIONAL CHARACTER VARYING(50) NULL,
    UserMarker1 NATIONAL CHARACTER VARYING(50) NULL,
    UserMarker2 NATIONAL CHARACTER VARYING(50) NULL,
    Problem NATIONAL CHARACTER VARYING(255) NULL,
    CheckPlausible_User NATIONAL CHARACTER VARYING(50) NULL,
    CheckPlausible_Date DATETIME NULL,
    CheckOriginal_User NATIONAL CHARACTER VARYING(50) NULL,
    CheckOriginal_Date DATETIME NULL,
    FinalCheck_User NATIONAL CHARACTER VARYING(50) NULL,
    FinalCheck_Date DATETIME NULL,
    LogCreated_User NATIONAL CHARACTER VARYING(50) NOT NULL,
    LogCreated_Date DATETIME NOT NULL DEFAULT current_timestamp
);




/*=== Table: TaxonomySynonymy ===*/
/* Taxonomy: Synonymization of species. Each responsible user can create an independent system. */
  /*   ProjectMarker: Each project can have a different opinion regarding synonmy. Refers to the common project definition in the user module. */
  /*   TaxonID: Synonym name. Refers to the TaxonID code of TaxonomyConcept (= foreign key). */
  /*   Accepted_TaxonID: Accepted name within a project. Refers to the TaxonID code of TaxonomyConcept (= foreign key). */
  /*   ReportedNote: A note of the responsible person concerning this synonymization that will be output in a report, e.g. 'fide Author 1999'. */
  /*   InternalNote: An internal note of the responsible person concerning this synonymization. This information is NOT included in any report. */
  /*   RefID: If the synonymization is based on 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 the synonymization is based on a publication: a short human readable description of the reference, obtained through the RefID from the reference subsystem (calculated field). */
  /*   RefPage: If the synonymization is based on a publication: relevant detail; usually page number where the synonymization is published. */
  /*   Responsible: The person responsible for this synonymy opinion. */
  /*   ConSynCongruence: A = B: regarding taxa descriptions taxon A and B are absolutely congruent. If no information about a specific concept is available, neither Yes nor No can be checked. Questionable/No or Questionable/Yes/No ??? */
  /*   ConSynInclusion: A > B: regarding taxa descriptions taxon A is "larger" than taxon B (A includes B completely); (Note: hierarchy is special type of inclusion!). */
  /*   ConSynProParte: A < B: regarding description taxon A is "smaller" than taxon B (A is completely included in B); the description of A is just partly transferrable to taxon B. */
  /*   ConSynIntersection: A <> B: taxon A and B are partly congruent; their descriptions overlap. */
  /*   ConSynDisjunction: A ? B: there is no correspondence between taxon A and B; their description do not overlap. */
  /*   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 TaxonomySynonymy (
    ProjectMarker NATIONAL CHARACTER VARYING(25) NOT NULL,
    TaxonID INTEGER NOT NULL,
    Accepted_TaxonID INTEGER NOT NULL,
    ReportedNote NATIONAL CHARACTER VARYING(255) NULL,
    InternalNote NATIONAL TEXT NOT NULL,
    RefID NATIONAL CHARACTER VARYING(20) NULL,
    RefDescriptionCache NATIONAL CHARACTER VARYING(255) NULL,
    RefPage NATIONAL CHARACTER VARYING(50) NULL,
    Responsible NATIONAL CHARACTER VARYING(50) NOT NULL,
    ConSynCongruence BIT NULL,
    ConSynInclusion BIT NULL,
    ConSynProParte BIT NULL,
    ConSynIntersection BIT NULL,
    ConSynDisjunction BIT NULL,
    LogCreated_User NATIONAL CHARACTER VARYING(50) NOT NULL,
    LogCreated_Date DATETIME NOT NULL DEFAULT current_timestamp,
  PRIMARY KEY (ProjectMarker,TaxonID)
);




/*=== Table: WorkbenchDevelopmentNotes ===*/
/* General development notes (documentation of concepts, ideas, etc.). */
  /*   Title: The title of the development note. The title should be concise, but not a list of keywords. It may be output as a formatted title in a development documentation. */
  /*   Topic: An optional keyword phrase. Examples: data import, export, interface, name of an editing form, etc. Useful to sort notes! */
  /*   Note: The text of the development note. Basic xhtml character codes (<em></em>, <sub></sub>, etc.) are permitted. */
  /*   Responsible: Name of person(s) responsible for the note. */
  /*   LogCreatedWhen: Date and time when record was created. */
  /*   LogUpdatedWhen: Date and time of last update of the record. */
CREATE TABLE WorkbenchDevelopmentNotes (
    Title NATIONAL CHARACTER VARYING(255) NOT NULL,
    Topic NATIONAL CHARACTER VARYING(60) NULL,
    Note NATIONAL TEXT NOT NULL,
    Responsible NATIONAL CHARACTER VARYING(50) NOT NULL,
    LogCreatedWhen DATETIME NOT NULL PRIMARY KEY DEFAULT current_timestamp,
    LogUpdatedWhen DATETIME NULL
);




/*=== Table: WorkbenchDevelopmentTasks ===*/
/* A list of development tasks: bug fixes, necessary enhancements, and requests for additional features. */
  /*   ID: Unique number identifying the development task. */
  /*   Urgency: Definition of urgency of feature. */
  /*   Description: Description of bug, problem, or requested feature. */
  /*   Notes: Notes about steps already taken, or necessary prerequisites to solve problem. */
  /*   Responsible: Name of person(s) responsible for entering a bug, problem, or feature request. */
  /*   LogCreatedWhen: Date and time when record was first entered (= typed or imported) into this system. */
  /*   LogUpdatedWhen: Date and time of last update of the record. */
CREATE TABLE WorkbenchDevelopmentTasks (
    ID INTEGER IDENTITY   NULL UNIQUE,
    Urgency TINYINT NOT NULL DEFAULT 0,
    Description NATIONAL TEXT NULL,
    Notes NATIONAL TEXT NULL,
    Responsible NATIONAL CHARACTER VARYING(50) NOT NULL,
    LogCreatedWhen DATETIME NOT NULL DEFAULT current_timestamp,
    LogUpdatedWhen DATETIME NULL
);




/*=== Table: WorkbenchInterfaceDescription ===*/
/* This entity contains two records, describing the title, version number, and description of schema (= information model) and content (= data collection) of a database component (Workbench Framework 1.0). */
  /*   Type: Only two records possible: 'Content' (defined by the user) and 'Schema' (= information model, defined by developer, must be compatible with the application). */
  /*   MajorVersion: The major version number of the schema or content data collection. Example: '2' for version 2.1. */
  /*   MinorVersion: The minor version number of the schema or content data collection. Example: '1' for version 2.1. */
  /*   Revision: The revision version number of the schema or content data collection. Example: '5' for version 2.1.0005. Displayed only if > 0. */
  /*   VersionSuffix: An optional string to identify special versions. Examples: 'beta', 'rc' = release candidate, etc. */
  /*   Signature: A number that uniquely identifies a schema or content data collection (used by other components to identify object identifiers as belonging to this data collection; content signature values must be 1-524287, schema 1-4095). */
  /*   Title: A title for the schema or content data collection. Example: 'Mycological Literature collected by the Mycology.Net initiative'. */
  /*   Description: An optional description of the entire information schema or data collection (will be displayed in the 'About' dialog box). */
  /*   CopyrightStatement: A copyright statement concerning the data. */
  /*   PublicLicense: Type of public licence (none, GPL, LGPL, etc.). */
  /*   Authors: A list of author(s). */
  /*   AuthorsAddress: An address applying to the Authors and Copyright statements. */
  /*   AuthorsURL: A URL web address applying to the Authors or the database content. */
CREATE TABLE WorkbenchInterfaceDescription (
    Type NATIONAL CHARACTER VARYING(7) NOT NULL PRIMARY KEY DEFAULT 'Content',
    MajorVersion INTEGER NOT NULL DEFAULT 1,
    MinorVersion INTEGER NOT NULL DEFAULT 0,
    Revision INTEGER NOT NULL DEFAULT 0,
    VersionSuffix NATIONAL CHARACTER VARYING(20) NULL,
    Signature INTEGER NOT NULL DEFAULT CLng(Rnd()*524287),
    Title NATIONAL CHARACTER VARYING(255) NOT NULL,
    Description NATIONAL TEXT NULL,
    CopyrightStatement NATIONAL CHARACTER VARYING(255) NULL,
    PublicLicense NATIONAL CHARACTER VARYING(20) NULL DEFAULT 'GPL',
    Authors NATIONAL CHARACTER VARYING(255) NULL,
    AuthorsAddress NATIONAL CHARACTER VARYING(255) NULL,
    AuthorsURL NATIONAL CHARACTER VARYING(255) NULL
);


ALTER TABLE TaxonomyActionOnName ADD 
  FOREIGN KEY (NomID) REFERENCES TaxonomyName (NomID) ON DELETE CASCADE
ALTER TABLE TaxonomyCitedSpecimen ADD 
  FOREIGN KEY (OpinionID) REFERENCES TaxonomyRevision (RevisionID) ON UPDATE CASCADE ON DELETE CASCADE
ALTER TABLE TaxonomyConcept ADD 
  FOREIGN KEY (NomID) REFERENCES TaxonomyName (NomID)
ALTER TABLE TaxonomyConceptChanges ADD 
  FOREIGN KEY (TaxonID) REFERENCES TaxonomyConcept (TaxonID) ON UPDATE CASCADE ON DELETE CASCADE
ALTER TABLE TaxonomyHierarchy ADD 
  FOREIGN KEY (TaxonID) REFERENCES TaxonomyConcept (TaxonID) ON UPDATE CASCADE ON DELETE CASCADE,
  FOREIGN KEY (Parent_TaxonID) REFERENCES TaxonomyConcept (TaxonID) ON UPDATE CASCADE ON DELETE CASCADE
ALTER TABLE TaxonomyName ADD 
  FOREIGN KEY (SpeciesGenusID) REFERENCES TaxonomyName (NomID),
  FOREIGN KEY (BasionymNomID) REFERENCES TaxonomyName (NomID),
  FOREIGN KEY (TaxonomicRank) REFERENCES TaxonomyRank (RankID) ON UPDATE CASCADE,
  FOREIGN KEY (ValidatedNomID) REFERENCES TaxonomyName (NomID),
  FOREIGN KEY (TypeSpecies_NomID) REFERENCES TaxonomyName (NomID),
  FOREIGN KEY (TypeGenus_NomID) REFERENCES TaxonomyName (NomID),
  FOREIGN KEY (HybridNomID1) REFERENCES TaxonomyName (NomID),
  FOREIGN KEY (HybridNomID2) REFERENCES TaxonomyName (NomID)
ALTER TABLE TaxonomyNameChanges ADD 
  FOREIGN KEY (NomID) REFERENCES TaxonomyName (NomID)
ALTER TABLE TaxonomyNameVariants ADD 
  FOREIGN KEY (TaxonID) REFERENCES TaxonomyConcept (TaxonID) ON UPDATE CASCADE ON DELETE CASCADE,
  FOREIGN KEY (NomID) REFERENCES TaxonomyName (NomID) ON UPDATE CASCADE
ALTER TABLE TaxonomyRevision ADD 
  FOREIGN KEY (TaxonID) REFERENCES TaxonomyConcept (TaxonID)
ALTER TABLE TaxonomySynonymy ADD 
  FOREIGN KEY (TaxonID) REFERENCES TaxonomyConcept (TaxonID),
  FOREIGN KEY (Accepted_TaxonID) REFERENCES TaxonomyConcept (TaxonID)


/*** Remove this comment line to enable creation of column description for MS SQL Server 2000 ***
exec sp_addextendedproperty N'MS_Description',N'Unique ID for this record.',N'user',N'dbo',N'table',N'TaxonomyActionOnName',N'column',N'ActionID'
exec sp_addextendedproperty N'MS_Description',N'The taxon concerning this action. Refers to the NomID code of TaxonomyName (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyActionOnName',N'column',N'NomID'
exec sp_addextendedproperty N'MS_Description',N'Type of nomenclatural action: conservation, rejection, neo-, lecto- or epitypification, emendation. The sanctioning of a name should not be recorded here.',N'user',N'dbo',N'table',N'TaxonomyActionOnName',N'column',N'ActionType'
exec sp_addextendedproperty N'MS_Description',N'Additional information regarding the typification or conservation/rejection.',N'user',N'dbo',N'table',N'TaxonomyActionOnName',N'column',N'InternalNote'
exec sp_addextendedproperty N'MS_Description',N'Reference ID of the reference containing the nomenclatural action defined in ActionType. Refers to the ID code of the main ReferenceTitle table in the reference module  (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyActionOnName',N'column',N'RefID'
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'TaxonomyActionOnName',N'column',N'RefDescriptionCache'
exec sp_addextendedproperty N'MS_Description',N'Relevant detail in a nomenclatural action reference; usually number of the page on which the action is described.',N'user',N'dbo',N'table',N'TaxonomyActionOnName',N'column',N'RefPage'
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'TaxonomyActionOnName',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'TaxonomyActionOnName',N'column',N'LogCreated_Date'
exec sp_addextendedproperty N'MS_Description',N'Only for typification actions: A user readable description of the specimen to which the typification refers (collection acronym + storage code / name under which specimen is stored).',N'user',N'dbo',N'table',N'TaxonomyActionOnName',N'column',N'TypificationSpecimenDescription'
exec sp_addextendedproperty N'MS_Description',N'Only for typification actions: If a specimen collection database subsystem is available, the relevant specimen unit identifier in that system is stored here (added in addition to a user readable TypificationSpecimenDescription).',N'user',N'dbo',N'table',N'TaxonomyActionOnName',N'column',N'TypificationSpecimenID'
exec sp_addextendedproperty N'MS_Description',N'Unique ID for a cited specimen (primary key).',N'user',N'dbo',N'table',N'TaxonomyCitedSpecimen',N'column',N'CitedSpecimenID'
exec sp_addextendedproperty N'MS_Description',N'All cited specimens must refer to a taxonomic opinion that defines a NomID, project marker, and responsible scientist (foreign key).',N'user',N'dbo',N'table',N'TaxonomyCitedSpecimen',N'column',N'OpinionID'
exec sp_addextendedproperty N'MS_Description',N'Standard abbreviation of the collection from which the studied 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'TaxonomyCitedSpecimen',N'column',N'CollectionAcronym'
exec sp_addextendedproperty N'MS_Description',N'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'TaxonomyCitedSpecimen',N'column',N'CollectionSpecimenID'
exec sp_addextendedproperty N'MS_Description',N'Optionally used for accession number or storage location name (which may be different from current scientific name!), esp. if CollectionSpecimenID can not be used because no compatible collection database subsystem is available.',N'user',N'dbo',N'table',N'TaxonomyCitedSpecimen',N'column',N'CollectionSpecimenDescription'
exec sp_addextendedproperty N'MS_Description',N'Type, holotype, syntype, paratype, isotype, lectotype, neotype, epitype, etc.',N'user',N'dbo',N'table',N'TaxonomyCitedSpecimen',N'column',N'TypeStatus'
exec sp_addextendedproperty N'MS_Description',N'Annotation regarding the studied specimen that will be output after the taxon in a report.',N'user',N'dbo',N'table',N'TaxonomyCitedSpecimen',N'column',N'ReportedNote'
exec sp_addextendedproperty N'MS_Description',N'An internal note of the responsible person concerning the studied specimen. This information is NOT included in any report.',N'user',N'dbo',N'table',N'TaxonomyCitedSpecimen',N'column',N'InternalNote'
exec sp_addextendedproperty N'MS_Description',N'False = the specimen is known to exist, but has not (perhaps not yet) been studied by the person named under Responsible.',N'user',N'dbo',N'table',N'TaxonomyCitedSpecimen',N'column',N'Studied'
exec sp_addextendedproperty N'MS_Description',N'False = the information on the studied specimen is suppressed in reports, but is maintained in the database.',N'user',N'dbo',N'table',N'TaxonomyCitedSpecimen',N'column',N'IncludeInReport'
exec sp_addextendedproperty N'MS_Description',N'Unique ID code for a taxonomic concept (primary key).',N'user',N'dbo',N'table',N'TaxonomyConcept',N'column',N'TaxonID'
exec sp_addextendedproperty N'MS_Description',N'The ID of the name on which the concept is based. Each name has at least a default concept. Refers to the NomID code of TaxonomyName (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyConcept',N'column',N'NomID'
exec sp_addextendedproperty N'MS_Description',N'Empty for default and primary concept; else ''s. lat.''/''s. str.'' (usually used without a ConceptReference); the qualifier is not limited to the picklist shown!',N'user',N'dbo',N'table',N'TaxonomyConcept',N'column',N'ConceptQualifier'
exec sp_addextendedproperty N'MS_Description',N'Empty for default and primary concept; else ''sec.'', ''sensu'', ''emend.''; if a prefix is set a concept citation has to be given.',N'user',N'dbo',N'table',N'TaxonomyConcept',N'column',N'ConceptCitationPrefix'
exec sp_addextendedproperty N'MS_Description',N'Empty for default concept, ''primary'' if concept known to be identical with original publication of name, else author(s) of secondary concept (including the publication year, if possible).',N'user',N'dbo',N'table',N'TaxonomyConcept',N'column',N'ConceptCitation'
exec sp_addextendedproperty N'MS_Description',N'Reference ID of the concept publication. Refers to the ID code of the main ReferenceTitle table in the reference module  (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyConcept',N'column',N'RefID'
exec sp_addextendedproperty N'MS_Description',N'Additional information regarding reference, esp. if doubtful or not yet present in reference subsystem. All other notes should be in the user specific TaxonomyOpinions.',N'user',N'dbo',N'table',N'TaxonomyConcept',N'column',N'RefNotes'
exec sp_addextendedproperty N'MS_Description',N'Calculated: Full, standardized name for the new taxon, calculated from genus, species and infraspecific epithet and authors. The value is unique, since it includes the author for higher taxa (genera, families) as well as for species.',N'user',N'dbo',N'table',N'TaxonomyConcept',N'column',N'NameCache'
exec sp_addextendedproperty N'MS_Description',N'Calculated: Like NameCache, but italic and plain text is formatted using xhtml markup (<i>/</i>).',N'user',N'dbo',N'table',N'TaxonomyConcept',N'column',N'NameCache_html'
exec sp_addextendedproperty N'MS_Description',N'Calculated: Like NameCache, but without any authors. Duplicates may occur here, and taxa with homonyms can be detected using this attribute. Where no homonyms are found, names from other data sources may be compared based on this field alone.',N'user',N'dbo',N'table',N'TaxonomyConcept',N'column',N'NameCache_NoAuthors'
exec sp_addextendedproperty N'MS_Description',N'Calculated: Like NameCache, but for species or infraspecific taxa the lowest rank name is printed first (''species-epitheton, Genus'' or ''variety (var.) species-epitheton, Genus'').',N'user',N'dbo',N'table',N'TaxonomyConcept',N'column',N'NameCache_inverted'
exec sp_addextendedproperty N'MS_Description',N'Calculated: Like NameCache, but with year of publication. Duplicates may occur here, and taxa with homonyms can be detected using this attribute. Where no homonyms are found, names from other data sources may be compared based on this field alone.',N'user',N'dbo',N'table',N'TaxonomyConcept',N'column',N'NameCache_PlusYear'
exec sp_addextendedproperty N'MS_Description',N'The ID of the taxonomic concept (TaxonID) that was changed by the user. Refers to the NomID code of TaxonomyName (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyConceptChanges',N'column',N'TaxonID'
exec sp_addextendedproperty N'MS_Description',N'Attributes and data affected by changes, details of changes.',N'user',N'dbo',N'table',N'TaxonomyConceptChanges',N'column',N'Changes'
exec sp_addextendedproperty N'MS_Description',N'Name of user who last updated the record. This is the operator (or typist) name, which may be different from the person responsible.',N'user',N'dbo',N'table',N'TaxonomyConceptChanges',N'column',N'LogUpdated_User'
exec sp_addextendedproperty N'MS_Description',N'Date and time of last update of the record.',N'user',N'dbo',N'table',N'TaxonomyConceptChanges',N'column',N'LogUpdated_Date'
exec sp_addextendedproperty N'MS_Description',N'Each project can implement a different taxonomic hierarchy. Refers to the common project definition in the user module.',N'user',N'dbo',N'table',N'TaxonomyHierarchy',N'column',N'ProjectMarker'
exec sp_addextendedproperty N'MS_Description',N'Unique ID code of the higher taxon. Refers to the TaxonID code of TaxonomyConcept (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyHierarchy',N'column',N'TaxonID'
exec sp_addextendedproperty N'MS_Description',N'Next higher taxon (e.g. the family or subfamily if this taxon is a genus).',N'user',N'dbo',N'table',N'TaxonomyHierarchy',N'column',N'Parent_TaxonID'
exec sp_addextendedproperty N'MS_Description',N'A note of the responsible person concerning this hierarchization that will be output in a report, e.g. ''fide Author 1999''.',N'user',N'dbo',N'table',N'TaxonomyHierarchy',N'column',N'ReportedNote'
exec sp_addextendedproperty N'MS_Description',N'An internal note of the responsible person concerning this hierarchization. This information is NOT included in any report.',N'user',N'dbo',N'table',N'TaxonomyHierarchy',N'column',N'InternalNote'
exec sp_addextendedproperty N'MS_Description',N'If the classification is based on a publication: the reference ID of that work.',N'user',N'dbo',N'table',N'TaxonomyHierarchy',N'column',N'RefID'
exec sp_addextendedproperty N'MS_Description',N'If the classification is based on 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'TaxonomyHierarchy',N'column',N'RefDescriptionCache'
exec sp_addextendedproperty N'MS_Description',N'If the classification is based on a publication: relevant detail; usually page number where the opinion is published.',N'user',N'dbo',N'table',N'TaxonomyHierarchy',N'column',N'RefPage'
exec sp_addextendedproperty N'MS_Description',N'The person responsible for grouping this taxon into a higher taxon.',N'user',N'dbo',N'table',N'TaxonomyHierarchy',N'column',N'Responsible'
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'TaxonomyHierarchy',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'TaxonomyHierarchy',N'column',N'LogCreated_Date'
exec sp_addextendedproperty N'MS_Description',N'CALCULATED FIELD: List of higher taxa for faster access: "div.; class; ord.; fam.".',N'user',N'dbo',N'table',N'TaxonomyHierarchy',N'column',N'HierarchyListCache'
exec sp_addextendedproperty N'MS_Description',N'Unique ID code for the nomenclatural name (primary key).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'NomID'
exec sp_addextendedproperty N'MS_Description',N'T: taxon based on new type; C: combination based on a previously publ. name (''comb. nov.''), N: new name (''nom.nov.'') introduced to replace a homonym (may occur for genera!), V: validation of previously invalidly publ. taxon name (''ex''), or U: for unknown.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'CreationType'
exec sp_addextendedproperty N'MS_Description',N'Taxonomic rank of the taxon (var., subsp., species, genus, family, order, etc.). The rank must be selected from the associated list of ranks (= TaxonomyRank).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'TaxonomicRank'
exec sp_addextendedproperty N'MS_Description',N'If rank is above species: Name of taxon above species level (currently accepted spelling). Includes infrageneric taxon names, genera, families, etc.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'HigherTaxonName'
exec sp_addextendedproperty N'MS_Description',N'If rank is species or below: NomID code of the Genus name. Refers to TaxonomyName (= foreign key) where TaxonomicRank = genus.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'SpeciesGenusID'
exec sp_addextendedproperty N'MS_Description',N'If rank is species or below: Species epithet, for example ''alba'' in ''Abies alba Miller'' (currently accepted spelling).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'SpeciesEpithet'
exec sp_addextendedproperty N'MS_Description',N'For all taxonomic ranks: Author(s) of the taxon, abbreviated according to authors standard, including validating authors (''ex''), optionally including sanctioning authors or "in" authors, excluding basionym authors in ''()'' (see TaxonBasionymAuthors).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'TaxonAuthors'
exec sp_addextendedproperty N'MS_Description',N'For all taxonomic ranks, only for ''comb. nov.'' or ''nom. nov.'': Author(s) of the basionym (will be displayed in in ''()'', do not enter the parentheses), abbreviated according to authors standard.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'TaxonBasionymAuthors'
exec sp_addextendedproperty N'MS_Description',N'Basionym: If CreationType is ''comb. nov.'' or replacement (''nom. nov.''), of another name based on the same type material. Refers to ID code of corresponding TaxonomyName (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'BasionymNomID'
exec sp_addextendedproperty N'MS_Description',N'Validated name: If CreationType is validation (''ex'') of another name based on the same type material. Refers to ID code of invalidly publ. TaxonomyName (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'ValidatedNomID'
exec sp_addextendedproperty N'MS_Description',N'If rank is infraspecific: Infraspecific epithet (currently accepted spelling). Note: the rank is known from required attribute TaxonomicRank in TaxonomyName (= the supertype entity).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'InfraspecificEpithet'
exec sp_addextendedproperty N'MS_Description',N'If rank is suprageneric: Type genus of taxon. Refers to the ID code of TaxonomyName (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'TypeGenus_NomID'
exec sp_addextendedproperty N'MS_Description',N'If rank is genus or infrageneric: Type species of genus or infrageneric taxon. Refers to the NomID code of TaxonomyName (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'TypeSpecies_NomID'
exec sp_addextendedproperty N'MS_Description',N'If rank is species or below: Information on deposition of type material in a collection, entered exactly as written in the protologue (original taxon description).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'TypeSpecimenDeposition'
exec sp_addextendedproperty N'MS_Description',N'If rank is species or below: Optional information on the geographic location of type material, entered exactly as written in the protologue (i.e. not as known from type specimen studied elsewhere!).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'TypeSpecimenLocation'
exec sp_addextendedproperty N'MS_Description',N'If rank is species or below: Optional information on substrate (anorganic, or living/dead plant, animal, or fungus) of type material, entered exactly as written in the protologue (i.e. not as known from type specimen studied elsewhere!).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'TypeSpecimenSubstrate'
exec sp_addextendedproperty N'MS_Description',N'If rank is species or below: Optional information on collector(s) of type material  (separate multiple collectors with a ";"), entered exactly as written in the protologue (i.e. not as known from type specimen studied elsewhere!).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'TypeSpecimenCollectors'
exec sp_addextendedproperty N'MS_Description',N'If rank is species or below: Optional further information on type material, esp. collection date and number, entered exactly as written in the protologue (i.e. not as known from type specimen studied elsewhere!).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'TypeSpecimenInformation'
exec sp_addextendedproperty N'MS_Description',N'If rank is genus: Checked (or true) -> this an anamorph genus, containing asexual forms only (relevant for fungi). The information can also be obtained from the taxonomic hierarchy; it is always added here to be available when the hierarchy is incomplete.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'GenusIsAsexual'
exec sp_addextendedproperty N'MS_Description',N'Optional text of citation (without year); used only when default reference description is unsatisfactorily (esp. abbreviated tax. book titles, exsiccata references). If present, this information is used in preference over the RefDescriptionCache.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'ReportedCitation'
exec sp_addextendedproperty N'MS_Description',N'Reference ID of the original nomenclatural citation/protologue. Refers to the ID code of the main ReferenceTitle table in the reference module  (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'RefID'
exec sp_addextendedproperty N'MS_Description',N'A short human readable description of the reference, obtained through the RefID from the references subsystem (calculated field).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'RefDescriptionCache'
exec sp_addextendedproperty N'MS_Description',N'Page on which the nomenclatural citation/protologue of name starts in the reference.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'RefPage'
exec sp_addextendedproperty N'MS_Description',N'If checked (or ''True''), the true page number is unknown and only a reprint page number (pagination starting w. 1...) is entered in RefPage. In tax. monographs this situation is often indicated by ''extr.'' or ''extractum'' after the page number.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'RefHasReprintPagination'
exec sp_addextendedproperty N'MS_Description',N'Publication year of taxonomic name, will be automatically entered if a RefID is selected from the reference module. (Note: synonym output is sorted by this year).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'RefYear'
exec sp_addextendedproperty N'MS_Description',N'If checked (or ''True''), the new taxon is a hybrid with or without a hybrid epithet.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'IsHybrid'
exec sp_addextendedproperty N'MS_Description',N'If IsHybrid is checked (or ''True''): Name of hybrid species 1. Refers to NomID code of publ. TaxonomyName (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'HybridNomID1'
exec sp_addextendedproperty N'MS_Description',N'If IsHybrid is checked (or ''True''): Name of hybrid species 2. Refers to NomID code of publ. TaxonomyName (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'HybridNomID2'
exec sp_addextendedproperty N'MS_Description',N'Original spelling of taxonomic name in the protologue publication. Recorded only, if different from current taxon name.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'OriginalNameSpelling'
exec sp_addextendedproperty N'MS_Description',N'Taxonomic placement (e.g. family or division) mentioned in the original description. This is NOT the current taxonomic placement!',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'OriginalTaxonPlacement'
exec sp_addextendedproperty N'MS_Description',N'Optional: The full text of the Latin description/diagnosis in the protologue.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'OriginalDiagnosisLatin'
exec sp_addextendedproperty N'MS_Description',N'Optional: The full text of the original description/diagnosis in the protologue, if a diagnosis in another language than Latin was provided. To be entered into the database only if no copyright is violated.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'OriginalDiagnosisOther'
exec sp_addextendedproperty N'MS_Description',N'Optional: a URL under which the scanned text/illustrations of the nomenclatural publication for the name can be found.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'OriginalPublScan'
exec sp_addextendedproperty N'MS_Description',N'Optional: A secondary reference indexing this taxon, e.g. Saccardo, Index of Fungi, etc. Entered as text, not as reference ID!',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'IndexingReference'
exec sp_addextendedproperty N'MS_Description',N'If imported from another database: The name of the database system or provider. Otherwise empty.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'ImportedFrom'
exec sp_addextendedproperty N'MS_Description',N'If imported from another database: An ID value to later re-identify the record in that database may be stored here.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'ImportedID'
exec sp_addextendedproperty N'MS_Description',N'Empty for published names, filled w. the name of the responsible person for unpublished (''inedited'') names entered in the database. These may not appear in any reports, until specifically requested for a report that will be used to publish the name.',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'IneditedResponsible'
exec sp_addextendedproperty N'MS_Description',N'Problem with data entry (not with the taxon).',N'user',N'dbo',N'table',N'TaxonomyName',N'column',N'Problem'
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'TaxonomyName',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'TaxonomyName',N'column',N'LogCreated_Date'
exec sp_addextendedproperty N'MS_Description',N'The ID of the taxonomic name that was changed by the user. Refers to the NomID code of TaxonomyName (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyNameChanges',N'column',N'NomID'
exec sp_addextendedproperty N'MS_Description',N'Attributes and data affected by changes, details of changes.',N'user',N'dbo',N'table',N'TaxonomyNameChanges',N'column',N'Changes'
exec sp_addextendedproperty N'MS_Description',N'Name of user who last updated the record. This is the operator (or typist) name, which may be different from the person responsible.',N'user',N'dbo',N'table',N'TaxonomyNameChanges',N'column',N'LogUpdated_User'
exec sp_addextendedproperty N'MS_Description',N'Date and time of last update of the record.',N'user',N'dbo',N'table',N'TaxonomyNameChanges',N'column',N'LogUpdated_Date'
exec sp_addextendedproperty N'MS_Description',N'Unique ID code for the nomenclatural name (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyNameVariants',N'column',N'NomID'
exec sp_addextendedproperty N'MS_Description',N'Unique ID code for a taxonomic concept (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyNameVariants',N'column',N'TaxonID'
exec sp_addextendedproperty N'MS_Description',N'Name variant: a complete name with or without authors that could be associated with a NomID as it has been used, e.g. if different orthographic opinions exist, original spelling (''Evonymus''  vs. ''Euonymus'') or name variants used by concept authors.',N'user',N'dbo',N'table',N'TaxonomyNameVariants',N'column',N'TaxonNameVariant'
exec sp_addextendedproperty N'MS_Description',N'Source for name variant: user name when entered directly, description of data import, ''Original Spelling'', or ''NameBuilder'' for names creates from TaxonomyName information (each change in NameCache is copied as a name variant).',N'user',N'dbo',N'table',N'TaxonomyNameVariants',N'column',N'Source'
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'TaxonomyNameVariants',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'TaxonomyNameVariants',N'column',N'LogCreated_Date'
exec sp_addextendedproperty N'MS_Description',N'The logical order of ranks (and display order), can be tested to find false hierarchizations or combinations Do not change the code, it is used in several restriction queries!',N'user',N'dbo',N'table',N'TaxonomyRank',N'column',N'RankID'
exec sp_addextendedproperty N'MS_Description',N'A unique user readable code for the taxonomic rank that is used in TaxonomyName.',N'user',N'dbo',N'table',N'TaxonomyRank',N'column',N'RankCode'
exec sp_addextendedproperty N'MS_Description',N'Single line description of the rank.',N'user',N'dbo',N'table',N'TaxonomyRank',N'column',N'Description'
exec sp_addextendedproperty N'MS_Description',N'Output elements for the rank, stored as a list of two elements (prefix string-semicolon-postfix string).',N'user',N'dbo',N'table',N'TaxonomyRank',N'column',N'Output'
exec sp_addextendedproperty N'MS_Description',N'Internal development notes regarding the taxonomic rank.',N'user',N'dbo',N'table',N'TaxonomyRank',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'TaxonomyRank',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'TaxonomyRank',N'column',N'DisplayEnable'
exec sp_addextendedproperty N'MS_Description',N'Unique ID code for the opinion (primary key). Note that the combination of NomID, ProjectMarker, and Responsible must also be unique and not null (candidate key).',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'RevisionID'
exec sp_addextendedproperty N'MS_Description',N'The taxon this opinion refers to. Refers to the NomID code of TaxonomyName (= foreign key).',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'TaxonID'
exec sp_addextendedproperty N'MS_Description',N'Each project can have a different opinion regarding synonmy. Refers to the common project definition in the user module.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'ProjectMarker'
exec sp_addextendedproperty N'MS_Description',N'The person responsible for this opinion/assessment on a taxon.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'Responsible'
exec sp_addextendedproperty N'MS_Description',N'Working status of taxonomic name in current project: I=Included, D=Doubtful, E=Excluded, etc. Synonyms of accepted taxa should have status I. The report may be grouped by these attributes.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'WorkingStatus'
exec sp_addextendedproperty N'MS_Description',N'... categories for effective/valid/legitimate... esp. ''nom. illeg.'', ''nom. inval.'', ''nom. nudum'', etc.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'NomenclaturalStatus'
exec sp_addextendedproperty N'MS_Description',N'Taxonomic remarks that will be output after the taxon in a report. This includes an explanation, esp. the relevant articles in the code of nomenclature.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'ReportedNote'
exec sp_addextendedproperty N'MS_Description',N'An internal note of the responsible person concerning this name. This information is NOT included in any report.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'InternalNote'
exec sp_addextendedproperty N'MS_Description',N'If the opinion is based on a publication: the reference ID of that work.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'RefID'
exec sp_addextendedproperty N'MS_Description',N'If the opinion is based on 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'TaxonomyRevision',N'column',N'RefDescriptionCache'
exec sp_addextendedproperty N'MS_Description',N'If the opinion is based on a publication: relevant detail; usually page number where the opinion is published.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'RefPage'
exec sp_addextendedproperty N'MS_Description',N'A temporary marker or keyword assigned by user for searching and sorting purposes while a group is reviewed. Any information can be entered here, but it will be visible only internally.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'UserMarker1'
exec sp_addextendedproperty N'MS_Description',N'A temporary marker or keyword assigned by user for searching and sorting purposes while a group is reviewed. Any information can be entered here, but it will be visible only internally.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'UserMarker2'
exec sp_addextendedproperty N'MS_Description',N'Temporary problem with data entry (not with the taxon, cmp. ReportedNote/InternalNote for permanent notes on problems).',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'Problem'
exec sp_addextendedproperty N'MS_Description',N'Name of user responsible for a first plausibility or consistency check of the name and taxon concepts. User and Date are automatically filled if ''Original check'' performed directly.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'CheckPlausible_User'
exec sp_addextendedproperty N'MS_Description',N'Date and time when plausibility/consistency was checked (i.e. data entry rules and spelling errors checked, no comparison with original publication).',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'CheckPlausible_Date'
exec sp_addextendedproperty N'MS_Description',N'Name of user responsible for comparison of name and taxon concept records with original publication.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'CheckOriginal_User'
exec sp_addextendedproperty N'MS_Description',N'Date and time when entry was compared with the original publication.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'CheckOriginal_Date'
exec sp_addextendedproperty N'MS_Description',N'Name of user responsible for final review of taxon name, the presence of a name here indicates that the record is ready for publication.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'FinalCheck_User'
exec sp_addextendedproperty N'MS_Description',N'Date and time when final check was performed. Note: it is possible to set FinalCheck without CheckOriginal, e.g. when another users has already checked the original publication.',N'user',N'dbo',N'table',N'TaxonomyRevision',N'column',N'FinalCheck_Date'
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'TaxonomyRevision',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'TaxonomyRevision',N'column',N'LogCreated_Date'
exec sp_addextendedproperty N'MS_Description',N'Each project can have a different opinion regarding synonmy. Refers to the common project definition in the user module.',N'user',N'dbo',N'table',N'TaxonomySynonymy',N'column',N'ProjectMarker'
exec sp_addextendedproperty N'MS_Description',N'Synonym name. Refers to the TaxonID code of TaxonomyConcept (= foreign key).',N'user',N'dbo',N'table',N'TaxonomySynonymy',N'column',N'TaxonID'
exec sp_addextendedproperty N'MS_Description',N'Accepted name within a project. Refers to the TaxonID code of TaxonomyConcept (= foreign key).',N'user',N'dbo',N'table',N'TaxonomySynonymy',N'column',N'Accepted_TaxonID'
exec sp_addextendedproperty N'MS_Description',N'A note of the responsible person concerning this synonymization that will be output in a report, e.g. ''fide Author 1999''.',N'user',N'dbo',N'table',N'TaxonomySynonymy',N'column',N'ReportedNote'
exec sp_addextendedproperty N'MS_Description',N'An internal note of the responsible person concerning this synonymization. This information is NOT included in any report.',N'user',N'dbo',N'table',N'TaxonomySynonymy',N'column',N'InternalNote'
exec sp_addextendedproperty N'MS_Description',N'If the synonymization is based on 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'TaxonomySynonymy',N'column',N'RefID'
exec sp_addextendedproperty N'MS_Description',N'If the synonymization is based on 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'TaxonomySynonymy',N'column',N'RefDescriptionCache'
exec sp_addextendedproperty N'MS_Description',N'If the synonymization is based on a publication: relevant detail; usually page number where the synonymization is published.',N'user',N'dbo',N'table',N'TaxonomySynonymy',N'column',N'RefPage'
exec sp_addextendedproperty N'MS_Description',N'The person responsible for this synonymy opinion.',N'user',N'dbo',N'table',N'TaxonomySynonymy',N'column',N'Responsible'
exec sp_addextendedproperty N'MS_Description',N'A = B: regarding taxa descriptions taxon A and B are absolutely congruent. If no information about a specific concept is available, neither Yes nor No can be checked. Questionable/No or Questionable/Yes/No ???',N'user',N'dbo',N'table',N'TaxonomySynonymy',N'column',N'ConSynCongruence'
exec sp_addextendedproperty N'MS_Description',N'A > B: regarding taxa descriptions taxon A is "larger" than taxon B (A includes B completely); (Note: hierarchy is special type of inclusion!).',N'user',N'dbo',N'table',N'TaxonomySynonymy',N'column',N'ConSynInclusion'
exec sp_addextendedproperty N'MS_Description',N'A < B: regarding description taxon A is "smaller" than taxon B (A is completely included in B); the description of A is just partly transferrable to taxon B.',N'user',N'dbo',N'table',N'TaxonomySynonymy',N'column',N'ConSynProParte'
exec sp_addextendedproperty N'MS_Description',N'A <> B: taxon A and B are partly congruent; their descriptions overlap.',N'user',N'dbo',N'table',N'TaxonomySynonymy',N'column',N'ConSynIntersection'
exec sp_addextendedproperty N'MS_Description',N'A ? B: there is no correspondence between taxon A and B; their description do not overlap.',N'user',N'dbo',N'table',N'TaxonomySynonymy',N'column',N'ConSynDisjunction'
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'TaxonomySynonymy',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'TaxonomySynonymy',N'column',N'LogCreated_Date'
exec sp_addextendedproperty N'MS_Description',N'The title of the development note. The title should be concise, but not a list of keywords. It may be output as a formatted title in a development documentation.',N'user',N'dbo',N'table',N'WorkbenchDevelopmentNotes',N'column',N'Title'
exec sp_addextendedproperty N'MS_Description',N'An optional keyword phrase. Examples: data import, export, interface, name of an editing form, etc. Useful to sort notes!',N'user',N'dbo',N'table',N'WorkbenchDevelopmentNotes',N'column',N'Topic'
exec sp_addextendedproperty N'MS_Description',N'The text of the development note. Basic xhtml character codes (<em></em>, <sub></sub>, etc.) are permitted.',N'user',N'dbo',N'table',N'WorkbenchDevelopmentNotes',N'column',N'Note'
exec sp_addextendedproperty N'MS_Description',N'Name of person(s) responsible for the note.',N'user',N'dbo',N'table',N'WorkbenchDevelopmentNotes',N'column',N'Responsible'
exec sp_addextendedproperty N'MS_Description',N'Date and time when record was created.',N'user',N'dbo',N'table',N'WorkbenchDevelopmentNotes',N'column',N'LogCreatedWhen'
exec sp_addextendedproperty N'MS_Description',N'Date and time of last update of the record.',N'user',N'dbo',N'table',N'WorkbenchDevelopmentNotes',N'column',N'LogUpdatedWhen'
exec sp_addextendedproperty N'MS_Description',N'Unique number identifying the development task.',N'user',N'dbo',N'table',N'WorkbenchDevelopmentTasks',N'column',N'ID'
exec sp_addextendedproperty N'MS_Description',N'Definition of urgency of feature.',N'user',N'dbo',N'table',N'WorkbenchDevelopmentTasks',N'column',N'Urgency'
exec sp_addextendedproperty N'MS_Description',N'Description of bug, problem, or requested feature.',N'user',N'dbo',N'table',N'WorkbenchDevelopmentTasks',N'column',N'Description'
exec sp_addextendedproperty N'MS_Description',N'Notes about steps already taken, or necessary prerequisites to solve problem.',N'user',N'dbo',N'table',N'WorkbenchDevelopmentTasks',N'column',N'Notes'
exec sp_addextendedproperty N'MS_Description',N'Name of person(s) responsible for entering a bug, problem, or feature request.',N'user',N'dbo',N'table',N'WorkbenchDevelopmentTasks',N'column',N'Responsible'
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'WorkbenchDevelopmentTasks',N'column',N'LogCreatedWhen'
exec sp_addextendedproperty N'MS_Description',N'Date and time of last update of the record.',N'user',N'dbo',N'table',N'WorkbenchDevelopmentTasks',N'column',N'LogUpdatedWhen'
exec sp_addextendedproperty N'MS_Description',N'Only two records possible: ''Content'' (defined by the user) and ''Schema'' (= information model, defined by developer, must be compatible with the application).',N'user',N'dbo',N'table',N'WorkbenchInterfaceDescription',N'column',N'Type'
exec sp_addextendedproperty N'MS_Description',N'The major version number of the schema or content data collection. Example: ''2'' for version 2.1.',N'user',N'dbo',N'table',N'WorkbenchInterfaceDescription',N'column',N'MajorVersion'
exec sp_addextendedproperty N'MS_Description',N'The minor version number of the schema or content data collection. Example: ''1'' for version 2.1.',N'user',N'dbo',N'table',N'WorkbenchInterfaceDescription',N'column',N'MinorVersion'
exec sp_addextendedproperty N'MS_Description',N'The revision version number of the schema or content data collection. Example: ''5'' for version 2.1.0005. Displayed only if > 0.',N'user',N'dbo',N'table',N'WorkbenchInterfaceDescription',N'column',N'Revision'
exec sp_addextendedproperty N'MS_Description',N'An optional string to identify special versions. Examples: ''beta'', ''rc'' = release candidate, etc.',N'user',N'dbo',N'table',N'WorkbenchInterfaceDescription',N'column',N'VersionSuffix'
exec sp_addextendedproperty N'MS_Description',N'A number that uniquely identifies a schema or content data collection (used by other components to identify object identifiers as belonging to this data collection; content signature values must be 1-524287, schema 1-4095).',N'user',N'dbo',N'table',N'WorkbenchInterfaceDescription',N'column',N'Signature'
exec sp_addextendedproperty N'MS_Description',N'A title for the schema or content data collection. Example: ''Mycological Literature collected by the Mycology.Net initiative''.',N'user',N'dbo',N'table',N'WorkbenchInterfaceDescription',N'column',N'Title'
exec sp_addextendedproperty N'MS_Description',N'An optional description of the entire information schema or data collection (will be displayed in the ''About'' dialog box).',N'user',N'dbo',N'table',N'WorkbenchInterfaceDescription',N'column',N'Description'
exec sp_addextendedproperty N'MS_Description',N'A copyright statement concerning the data.',N'user',N'dbo',N'table',N'WorkbenchInterfaceDescription',N'column',N'CopyrightStatement'
exec sp_addextendedproperty N'MS_Description',N'Type of public licence (none, GPL, LGPL, etc.).',N'user',N'dbo',N'table',N'WorkbenchInterfaceDescription',N'column',N'PublicLicense'
exec sp_addextendedproperty N'MS_Description',N'A list of author(s).',N'user',N'dbo',N'table',N'WorkbenchInterfaceDescription',N'column',N'Authors'
exec sp_addextendedproperty N'MS_Description',N'An address applying to the Authors and Copyright statements.',N'user',N'dbo',N'table',N'WorkbenchInterfaceDescription',N'column',N'AuthorsAddress'
exec sp_addextendedproperty N'MS_Description',N'A URL web address applying to the Authors or the database content.',N'user',N'dbo',N'table',N'WorkbenchInterfaceDescription',N'column',N'AuthorsURL'
GO
*** Remove this comment line to enable creation of column description for MS SQL Server 2000 ***/