Diversity Workbench: Schema for DiversityDescriptions, version '1.8'.
Document last revised on 16.Feb.2001 15:32
Copyright 2001 G. Hagedorn. All rights reserved.
Suggestions how to correct or improve the schema are welcome! Descriptor project: Character states for each character. State ID. Character ID. Character state code. Usually pos. integer number or special codes for variable/unknown and for statistics (mean etc.). Name or description of character state. Wording to be used instead of CharStateName for natural language descriptions output. Internal character state notes. State specific formatting, overriding FormatString defined in the character definition. Standard Basic formatting string like "#.0". Mark this state as a default which is automatically set. Use this state during entering or updating of item descriptions. Use this state during interactive identification. Use this state for natural language item descriptions. Use this state for phylogenetic analysis. Use this to define a character state set for user-defined purposes. Numeric characters only: The lowest value of X in an item description to be mapped to this state (inclusive). Numeric characters only: The highest value of X in an item description to be mapped to this state (inclusive). First part of the wording used instead of CharStateName for natural language item descriptions output. Output once in front of all states where this wording occurs in a single item. Second part of the character state wording. This part is always output for each state. Note that any of the three parts of the state wording may be left empty! Second part of the character state wording. This part is output only once after all states where this wording is identical within the same item. Example: StateWording1 = 'not', 'weakly', 'strongly'; StateWording2 = 'hairy'; -> 'weakly or strongly hairy'. If true, the state wording is suppressed if it occurs singly in an item. It is assumed to be implicit. Example: 'absent' alone could be suppressed, but if if two states have been scored, 'absent or present' would be output. Descriptor project: Item or taxon table. Item ID. Name or description of item (incl. taxon authors if necessary), link to taxonomic subsystem. Natural language descript.: Wording to be used instead of ItemName. Item notes. Abundance, relative importance (or weight) of item, 1-10, default is 5. Unit code in specimen collection, link into collection subsystem. NOT DEFINED IN DELTA! Literature reference (user-readable text form). NOT DEFINED IN DELTA! Literature reference (numeric link into literature reference subsystem). NOT DEFINED IN DELTA! Reference detail, like page(s) of interest, specific figures, etc. Overview over all descriptor projects available in the current application. Descriptor project ID. The name of the project used by the application, also the prefix of all project tables. Only for linked subprojects: The project containing the main tables. A short title for the project (up to 50 characters). A URL that may optionally be placed behind the Title to hyperlink to another site on the world-wide-web. Default horizontal alignment of title text: 0 = left; 1 = centered; 2 = right; 3 = justified (block). A short descriptive text, explaining the scope of the descriptor project (used in reports). A version number or code for the descriptor definition and item data of the project. A string containing one or several authors responsible for the data in the descriptor project. A string containing one or several editors responsible for the data in the descriptor project. A string containing a copyright statement, including the year (do include the copyright symbol, (c) or ©, if you want to use it). History of the project, including data source information, copyright agreements, acknowledgements, occasional collaborators, and disclaimers. Internal notes and additions to the history. In contrast to ProjectHistory this information is not used in reports. Messages issued during the import of the project (import source, import warnings, import skipped information). Internal notes regarding the entire project. A logo or icon, usually a small gif file that can be displayed side-by-side with the project title. A URL that may optionally be placed behind the Logo to hyperlink to another site on the world-wide-web. Default alignment of project logo: 0 = on left side of title; 2 = on right side of title; 17 = centered above title; 33 = centered below title. URL of a CSS (cascading style sheet) file to create a consistent format for html reports. Text placed at the bottom of reports, containing a disclaimer or other information. A URL that may optionally be placed behind the Disclaimer to hyperlink to another site on the world-wide-web. Default horizontal alignment of disclaimer text: 0 = left; 1 = centered; 2 = right; 3 = justified (block). Date and file name of last backup to an mdb backup file. Date and file name of last restore from an mdb backup file. Date and file name of last export, e. g., to a DELTA file. The date at which the project schema (character, state, and modifier definitions) were last edited //MUST CURRENTLY BE UPDATED MANUALLY TO AVOID ADDING UPDATE CODE AT MANY MANY POINTS. The date at which the item definition and description were last edited //MUST CURRENTLY BE UPDATED MANUALLY TO AVOID ADDING UPDATE CODE AT MANY MANY POINTS. An internal string defining the version of the data model in which the project data are currently stored. This attribute is only relevant for restore operations (which can operate on active projects as well as on explicit backups). Formatting encoding of data in the project (0=Plain/BasicHTML, 1= Full HTML), list of coding for item, heading, char. etc. Parameter set (Character definition, Natural language, HTML form reports, etc.) for descriptor projects. Descriptor project ID. The reporting or other object to which the parameter set applies, e.g. the Character definition report. A user defined name distinguishing multiple parameter sets for the same object. The date at which the parameter set was last edited. Internal notes regarding the parameter set. The coded parameter set (machine readable). Precalculated. Precalculated. Descriptor project: Character table. Character ID number. Short name of character. For numeric characters: an optional measurement unit like 'mm'. Only true units here, text like 'wide' belongs to CharWording2! Character notes. Type of character: Text, Ordered/unordered multistate, Integer/Real numeric. Is the scoring of this character mandatory (required) in each item? Are multiple states allowed and how are they interpreted? Reliability (or weight) of character for identification, 1-10, default is 5. Availability (or accessibility) of character for identification, 1-10, default is 5. This is an extension to the Delta standard. For identification: Unless a range is explicitly present, used to form a range around the mean (RN/IN) or state (OM). Interpret 'Fuzziness' as 'percent' rather than 'absolute value' (e.g. Fuzziness=10 -> range=mean +/- 10%, instead of +/- 10 absolute). For use in a key: combine multistate char, into new combinations or define ranges for numeric char. A heading defined in the headings definition, inserted in char. def. output in front of the current character. A heading defined in the headings definition, inserted in natural language descriptions in front of descriptions using this character. Natural language descript.: Wording to be used instead of CharName. Natural language descript.: Wording to be used AFTER states or values + unit, e.g. 'wide' for 'leaves 3-5 mm wide'. True if unit is to be placed in front of value, e.g. "pH 7.2". Default formatting for all states (compare StateFormatString). Esp. for numeric values (number of decimal places etc.). Standard Basic formatting string like "#.0". Nat.language descript.: Define char. linked into a single paragraph. A new paragraph starts if group ID changes. Nat.language descript.: Define char. linked into a single sentence. A new sentence starts if group ID changes or whenever 'Null'. Nat.language descript.: Define characters linked into a comma-enumeration ('sub-sentence'). A new group starts if group ID changes or whenever 'Null'. Nat.language descript.: Define characters that are linked by special means (as defined in SpecialElement). Nat.language descript.: SpecialLink is rendered using this ReportElement (concatenation: char. separated only by blank, multi-char. formula/equation or table definition) [Denormalized n:m relation b/w Char.SpecialLink & ReportElement.ReportElement]. Nat.language descript.: Use alternative comma separator between states of this character (e.g. for Chinese). Nat.language descript.: The final comma between character states is omitted ('1,2 and 3' instead of '1,2, and 3'). Natural language descript.: Omit lower ('-') or upper ('+') part of numeric character ranges. Nat.language descript.: Emphasize (italic or bold print) this character in all items. Nat.language descript.: Omit the end delimiter (usually the period for a sentence, DELTA: 'OMIT PERIOD FOR CHAR'). Number of states for this character, default is 2. Calculated automatically, do not edit! Descriptor project: Character heading/Identification/HeadingLink table. Character heading ID; determines sequence of headings when used in identification; change number to change that sequence! Heading name, used for CharHeadings and Named character groups (identification). Optional wording; preferred over HeadingName as HeadingLink in natural language output. Internal notes (not exported to Delta format). Empty for user defined headings; else special code which is recognized during identification or a SQL queryreturning a set of character IDs. (HeadingName of predefined AutoGroups may be changed!). Descriptor project: Character groups for Identification, Linking. Character heading ID to be linked. Character ID to which the identification heading is applicable. Descriptor project: Dependent (= inapplicable) characters for each character state. Controlling character ID. Controlling character state. CID of dependent character, i.e. inapplicable for any item where current CID/CS combination is used. Descriptor project: Data/descriptions for each item. Item ID. Character ID. Modifier wording for categorical or numerical data, e.g. "mostly", "usually", "rarely". Character state code. Usually pos. integer number or special codes for variable/unknown and for statistics (mean etc.). Numeric value, defined by CS. Text data. Notes and additional information, included in natural language item descriptions. Sequence of character states for the item. Preliminary, for testing purposes only. Glossary ID. Glossary entry (basic xhtml formatting allowed). Glossary entry definition (basic xhtml formatting allowed). Internal notes. Additional keywords (semicolon separated list). Descriptor project: Modifer wordings for categorical or numerical data. Type of characters for which the modifier is applicable, e.g. GENERAL. COLORS, FREQuency of occurrence. Modifier wording for categorical or numerical data, e.g. "mostly", "usually", "rarely". Influence of modifier on data coded through categorical/numerical char. states. More (>5) or less reliable (<5); 5 is default. Checked = output after the character state wording, unchecked = in front of it. Checked = blank is added between the modifier wording and the item data text, else modifier added compress. >0 = Override operator, the normal operator between states is omitted when this modifier is encountered, e.g. to insert AND where normal operator would be OR. Internal notes. The lower border of the frequency range, for freq. modifiers only. The upper border of the frequency range, for freq. modifiers only. Descriptor project: Links between characters and modifiers. Character ID to which the modifier is applicable. Modifier wording for categorical or numerical data, e.g. "mostly", "usually", "rarely". Descriptor project: General header information about the project. The name of the project property (do not change!). Text information. Use Shift F2 to zoom into larger window! Date or time information, e.g. of last update. Numerical information, stored as real number. Descriptor project: ReportElements for natural language description formulas, tables, etc. ID of report element (1-10 are reserved!). Language to which the ReportElement is applicable. Text that describes the use of the report element (shown in user interface). Start a new paragraph before the ReportElement. Text inserted before the ReportElement (unformatted text). Enumeration separator between multiple subelements (e.g. characters); used only if ComplexWording is empty! Text inserted after the ReportElement (unformatted text). Start a new paragraph after the ReportElement. Wording for multiple characters, char. are inserted at |1, |2, etc.; |U = Unit, |C new table column, |R new table row. 0 = RTF; 1 = HTML; 2= unformatted, will be reformatted with character format. Yes: char. missing in an item are replaced by ''; No: AlternativeElement is tried, if none fitting found: EnumSeparator is used. Another ReportElement that is used if not all elements in ComplexWording are present, see 'UseWordingIfIncomplete'. Capitalize first letter at start of this group. Capitalize first letter of each element (each char. in enumeration or table cell). Wording truncation (e.g. char. wording). 0=disable, 1=enable, restart, 2=enable, continue. Internal development notes. Descriptor project: External resources stored as files or URL, e.g. illustrations for characters/items. ID of associated item (optional). ID of associated character (optional). ID of associated character state (set to U or TE for text characters if resource belongs to char. in general). Filename of illustration (photo/drawing/graph) or other media resources. See _HEADING properties MediaDefaultPath/MediaDefaultURL to set global paths. Caption for the resource, e.g. a text to display while showing an illustration or a video. Internal notes (perhaps also formatting commands for INTKEY). This image is a default image for the whole item, regardless of character association. This image is a default image for the whole character, regardless of character state association. Media resource ID (necessary, because either IID or CID may be missing). Include the resource, esp. images in the natural language description of items. Include the resource, esp. images in character definition report. (potential root element for the namespace of current database subsystem)