/* SQL DDL: Create an implementation of the model using SQL data definition language */ /* Note: You may want to change some field types to improve the implementation on your DBMS */ /* Note: Comments such as this may not be supported by your system and may have to be removed */ /* Note: Tested on MS SQL Server 2000 and !TODO! PostgreSQL !TODO! */ /* Note: MS SQL Server 2000: remove comments at end of file to enable creation of column descriptions */ /* Note: CREATE INDEX, CONSTRAINT (other than primary or unique key) and Foreign key constraints are missing at the moment, to be added later */ /* Generated on 16.Feb.2001 15:32 by Diversity Workbench: Diversity Information Model Documenter, Vers. 1.4 (G. Hagedorn) */ /*=== Table: DELTA_CS ===*/ /* Descriptor project: Character states for each character. */ /* SID: State ID. */ /* CID: Character ID. */ /* CS: Character state code. Usually pos. integer number or special codes for variable/unknown and for statistics (mean etc.). */ /* CharStateName: Name or description of character state. */ /* StateWording: Wording to be used instead of CharStateName for natural language descriptions output. */ /* Notes: Internal character state notes. */ /* StateFormatString: State specific formatting, overriding FormatString defined in the character definition. Standard Basic formatting string like "#.0". */ /* Implicit: Mark this state as a default which is automatically set. */ /* UseEdit: Use this state during entering or updating of item descriptions. */ /* UseIdentify: Use this state during interactive identification. */ /* UseDescr: Use this state for natural language item descriptions. */ /* UsePhylo: Use this state for phylogenetic analysis. */ /* UseOther: Use this to define a character state set for user-defined purposes. */ /* MinValue: Numeric characters only: The lowest value of X in an item description to be mapped to this state (inclusive). */ /* MaxValue: Numeric characters only: The highest value of X in an item description to be mapped to this state (inclusive). */ /* StateWording1: 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. */ /* StateWording2: 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! */ /* StateWording3: 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'. */ /* StateWordingSuppressSingle: 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. */ CREATE TABLE DELTA_CS ( SID INTEGER IDENTITY NOT NULL PRIMARY KEY, CID SMALLINT NOT NULL UNIQUE, CS NATIONAL CHARACTER VARYING(16) NOT NULL UNIQUE, CharStateName NATIONAL CHARACTER VARYING(255) NOT NULL, StateWording NATIONAL CHARACTER VARYING(255) NULL, Notes NATIONAL TEXT NULL, StateFormatString NATIONAL CHARACTER VARYING(255) NULL, Implicit BOOLEAN NOT NULL DEFAULT 0, UseEdit BOOLEAN NULL DEFAULT -1, UseIdentify BOOLEAN NULL DEFAULT 0, UseDescr BOOLEAN NULL DEFAULT 0, UsePhylo BOOLEAN NULL DEFAULT 0, UseOther BOOLEAN NULL DEFAULT 0, MinValue FLOAT NOT NULL DEFAULT -1E+308, MaxValue FLOAT NOT NULL DEFAULT 1E+308, StateWording1 NATIONAL CHARACTER VARYING(255) NULL, StateWording2 NATIONAL CHARACTER VARYING(255) NULL, StateWording3 NATIONAL CHARACTER VARYING(255) NULL, StateWordingSuppressSingle BOOLEAN NULL ) /*=== Table: DELTA_ITEM ===*/ /* Descriptor project: Item or taxon table. */ /* IID: Item ID. */ /* ItemName: Name or description of item (incl. taxon authors if necessary), link to taxonomic subsystem. */ /* ItemWording: Natural language descript.: Wording to be used instead of ItemName. */ /* Notes: Item notes. */ /* Abundance: Abundance, relative importance (or weight) of item, 1-10, default is 5. */ /* CollUnit: Unit code in specimen collection, link into collection subsystem. NOT DEFINED IN DELTA! */ /* LitRef: Literature reference (user-readable text form). NOT DEFINED IN DELTA! */ /* LitKey: Literature reference (numeric link into literature reference subsystem). NOT DEFINED IN DELTA! */ /* LitRefDetail: Reference detail, like page(s) of interest, specific figures, etc. */ CREATE TABLE DELTA_ITEM ( IID INTEGER NOT NULL PRIMARY KEY, ItemName NATIONAL CHARACTER VARYING(255) NOT NULL, ItemWording NATIONAL CHARACTER VARYING(255) NULL, Notes NATIONAL TEXT NULL, Abundance FLOAT(7) NOT NULL DEFAULT 5, CollUnit NATIONAL CHARACTER VARYING(255) NULL, LitRef NATIONAL CHARACTER VARYING(255) NULL, LitKey INTEGER NULL, LitRefDetail NATIONAL CHARACTER VARYING(255) NULL ) /*=== Table: DescriptorProject ===*/ /* Overview over all descriptor projects available in the current application. */ /* PID: Descriptor project ID. */ /* ProjectName: The name of the project used by the application, also the prefix of all project tables. */ /* ParentPID: Only for linked subprojects: The project containing the main tables. */ /* ProjectTitle: A short title for the project (up to 50 characters). */ /* ProjectTitleURL: A URL that may optionally be placed behind the Title to hyperlink to another site on the world-wide-web. */ /* ProjectTitleAligment: Default horizontal alignment of title text: 0 = left; 1 = centered; 2 = right; 3 = justified (block). */ /* ProjectDescription: A short descriptive text, explaining the scope of the descriptor project (used in reports). */ /* ProjectVersion: A version number or code for the descriptor definition and item data of the project. */ /* ProjectAuthors: A string containing one or several authors responsible for the data in the descriptor project. */ /* ProjectEditors: A string containing one or several editors responsible for the data in the descriptor project. */ /* ProjectCopyright: A string containing a copyright statement, including the year (do include the copyright symbol, (c) or ©, if you want to use it). */ /* ProjectHistory: History of the project, including data source information, copyright agreements, acknowledgements, occasional collaborators, and disclaimers. */ /* ProjectHistoryNotes: Internal notes and additions to the history. In contrast to ProjectHistory this information is not used in reports. */ /* ProjectImportNotes: Messages issued during the import of the project (import source, import warnings, import skipped information). */ /* ProjectNotes: Internal notes regarding the entire project. */ /* ProjectLogo: A logo or icon, usually a small gif file that can be displayed side-by-side with the project title. */ /* ProjectLogoURL: A URL that may optionally be placed behind the Logo to hyperlink to another site on the world-wide-web. */ /* ProjectLogoAligment: 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. */ /* ProjectStylesheetURL: URL of a CSS (cascading style sheet) file to create a consistent format for html reports. */ /* ProjectDisclamer: Text placed at the bottom of reports, containing a disclaimer or other information. */ /* ProjectDisclamerURL: A URL that may optionally be placed behind the Disclaimer to hyperlink to another site on the world-wide-web. */ /* ProjectDisclamerAligment: Default horizontal alignment of disclaimer text: 0 = left; 1 = centered; 2 = right; 3 = justified (block). */ /* ProjectLastBackup: Date and file name of last backup to an mdb backup file. */ /* ProjectLastRestore: Date and file name of last restore from an mdb backup file. */ /* ProjectLastExport: Date and file name of last export, e. g., to a DELTA file. */ /* ProjectLastSchemaUpdate: 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. */ /* ProjectLastItemUpdate: 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. */ /* StorageModelVersion: 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). */ /* ProjectTextFormatting: Formatting encoding of data in the project (0=Plain/BasicHTML, 1= Full HTML), list of coding for item, heading, char. etc. */ CREATE TABLE DescriptorProject ( PID INTEGER IDENTITY NOT NULL PRIMARY KEY, ProjectName NATIONAL CHARACTER VARYING(20) NULL UNIQUE, ParentPID INTEGER NULL, ProjectTitle NATIONAL CHARACTER VARYING(50) NOT NULL UNIQUE, ProjectTitleURL NATIONAL CHARACTER VARYING(255) NULL, ProjectTitleAligment TINYINT NULL DEFAULT 0, ProjectDescription NATIONAL CHARACTER VARYING(255) NULL, ProjectVersion NATIONAL CHARACTER VARYING(255) NULL, ProjectAuthors NATIONAL CHARACTER VARYING(255) NULL, ProjectEditors NATIONAL CHARACTER VARYING(255) NULL, ProjectCopyright NATIONAL CHARACTER VARYING(255) NULL, ProjectHistory NATIONAL TEXT NULL, ProjectHistoryNotes NATIONAL TEXT NULL, ProjectImportNotes NATIONAL TEXT NULL, ProjectNotes NATIONAL TEXT NULL, ProjectLogo NATIONAL CHARACTER VARYING(255) NULL, ProjectLogoURL NATIONAL CHARACTER VARYING(255) NULL, ProjectLogoAligment TINYINT NULL DEFAULT 0, ProjectStylesheetURL NATIONAL CHARACTER VARYING(255) NULL, ProjectDisclamer NATIONAL CHARACTER VARYING(255) NULL, ProjectDisclamerURL NATIONAL CHARACTER VARYING(255) NULL, ProjectDisclamerAligment TINYINT NULL DEFAULT 0, ProjectLastBackup NATIONAL CHARACTER VARYING(255) NULL, ProjectLastRestore NATIONAL CHARACTER VARYING(255) NULL, ProjectLastExport NATIONAL CHARACTER VARYING(255) NULL, ProjectLastSchemaUpdate DATETIME NULL, ProjectLastItemUpdate DATETIME NULL, StorageModelVersion NATIONAL CHARACTER VARYING(10) NULL, ProjectTextFormatting NATIONAL CHARACTER VARYING(255) NULL ) /*=== Table: DescriptorProject_ParameterSet ===*/ /* Parameter set (Character definition, Natural language, HTML form reports, etc.) for descriptor projects. */ /* PID: Descriptor project ID. */ /* ObjectName: The reporting or other object to which the parameter set applies, e.g. the Character definition report. */ /* SetName: A user defined name distinguishing multiple parameter sets for the same object. */ /* LastUpdate: The date at which the parameter set was last edited. */ /* Notes: Internal notes regarding the parameter set. */ /* Parameters: The coded parameter set (machine readable). */ /* OverrideHeaderFile: Precalculated. */ /* InsertHeaderFile: Precalculated. */ CREATE TABLE DescriptorProject_ParameterSet ( PID INTEGER NOT NULL, ObjectName NATIONAL CHARACTER VARYING(40) NOT NULL, SetName NATIONAL CHARACTER VARYING(50) NOT NULL DEFAULT 'Default', LastUpdate DATETIME NULL, Notes NATIONAL TEXT NULL, Parameters NATIONAL TEXT NULL, OverrideHeaderFile NATIONAL TEXT NULL, OverrideFooterFile NATIONAL TEXT NULL, CalculatedHeaderText NATIONAL TEXT NULL, CalculatedFooterText NATIONAL TEXT NULL, InsertHeaderFile NATIONAL TEXT NULL, InsertFooterFile NATIONAL TEXT NULL, UseHeaderOverride NATIONAL CHARACTER VARYING(255) NULL, PRIMARY KEY (PID,ObjectName,SetName) ) /*=== Table: DELTA_CHAR ===*/ /* Descriptor project: Character table. */ /* CID: Character ID number. */ /* CharName: Short name of character. */ /* Unit: For numeric characters: an optional measurement unit like 'mm'. Only true units here, text like 'wide' belongs to CharWording2! */ /* Notes: Character notes. */ /* Type: Type of character: Text, Ordered/unordered multistate, Integer/Real numeric. */ /* Mandatory: Is the scoring of this character mandatory (required) in each item? */ /* MultiStateType: Are multiple states allowed and how are they interpreted? */ /* Reliability: Reliability (or weight) of character for identification, 1-10, default is 5. */ /* Availability: Availability (or accessibility) of character for identification, 1-10, default is 5. This is an extension to the Delta standard. */ /* Fuzziness: For identification: Unless a range is explicitly present, used to form a range around the mean (RN/IN) or state (OM). */ /* FuzzinessIsPercent: Interpret 'Fuzziness' as 'percent' rather than 'absolute value' (e.g. Fuzziness=10 -> range=mean +/- 10%, instead of +/- 10 absolute). */ /* KeyStates: For use in a key: combine multistate char, into new combinations or define ranges for numeric char. */ /* CharHeading: A heading defined in the headings definition, inserted in char. def. output in front of the current character. */ /* HeadingLink: A heading defined in the headings definition, inserted in natural language descriptions in front of descriptions using this character. */ /* CharWording: Natural language descript.: Wording to be used instead of CharName. */ /* CharWording2: Natural language descript.: Wording to be used AFTER states or values + unit, e.g. 'wide' for 'leaves 3-5 mm wide'. */ /* UnitIsPrefix: True if unit is to be placed in front of value, e.g. "pH 7.2". */ /* FormatString: Default formatting for all states (compare StateFormatString). Esp. for numeric values (number of decimal places etc.). Standard Basic formatting string like "#.0". */ /* ParagraphLink: Nat.language descript.: Define char. linked into a single paragraph. A new paragraph starts if group ID changes. */ /* SentenceLink: Nat.language descript.: Define char. linked into a single sentence. A new sentence starts if group ID changes or whenever 'Null'. */ /* CommaLink: Nat.language descript.: Define characters linked into a comma-enumeration ('sub-sentence'). A new group starts if group ID changes or whenever 'Null'. */ /* SpecialLink: Nat.language descript.: Define characters that are linked by special means (as defined in SpecialElement). */ /* 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]. */ /* UseComma2: Nat.language descript.: Use alternative comma separator between states of this character (e.g. for Chinese). */ /* OmitFinalComma: Nat.language descript.: The final comma between character states is omitted ('1,2 and 3' instead of '1,2, and 3'). */ /* OmitValues: Natural language descript.: Omit lower ('-') or upper ('+') part of numeric character ranges. */ /* Emphasize: Nat.language descript.: Emphasize (italic or bold print) this character in all items. */ /* OmitPeriod: Nat.language descript.: Omit the end delimiter (usually the period for a sentence, DELTA: 'OMIT PERIOD FOR CHAR'). */ /* NumStates: Number of states for this character, default is 2. Calculated automatically, do not edit! */ CREATE TABLE DELTA_CHAR ( CID SMALLINT NOT NULL PRIMARY KEY, CharName NATIONAL CHARACTER VARYING(255) NOT NULL UNIQUE, Unit NATIONAL CHARACTER VARYING(255) NULL, Notes NATIONAL TEXT NULL, Type NATIONAL CHARACTER VARYING(2) NOT NULL DEFAULT 'UM', Mandatory BOOLEAN NOT NULL DEFAULT 0, MultiStateType TINYINT NOT NULL DEFAULT 1, Reliability FLOAT(7) NOT NULL DEFAULT 5, Availability FLOAT(7) NOT NULL DEFAULT 5, Fuzziness FLOAT(7) NOT NULL DEFAULT 0, FuzzinessIsPercent BOOLEAN NOT NULL DEFAULT 0, KeyStates NATIONAL CHARACTER VARYING(255) NULL, CharHeading SMALLINT NULL, HeadingLink SMALLINT NULL, CharWording NATIONAL CHARACTER VARYING(255) NULL, CharWording2 NATIONAL CHARACTER VARYING(255) NULL, UnitIsPrefix BOOLEAN NULL, FormatString NATIONAL CHARACTER VARYING(255) NULL, ParagraphLink INTEGER NULL DEFAULT 1, SentenceLink INTEGER NULL, CommaLink INTEGER NULL, SpecialLink INTEGER NULL, SpecialElement INTEGER NULL, UseComma2 BOOLEAN NULL, OmitFinalComma BOOLEAN NOT NULL DEFAULT 0, OmitValues NATIONAL CHARACTER VARYING(1) NULL, Emphasize BOOLEAN NULL DEFAULT 0, OmitPeriod BOOLEAN NULL DEFAULT 0, NumStates SMALLINT NOT NULL DEFAULT 2 ) /*=== Table: DELTA_CHAR_Heading ===*/ /* Descriptor project: Character heading/Identification/HeadingLink table. */ /* HID: Character heading ID; determines sequence of headings when used in identification; change number to change that sequence! */ /* HeadingName: Heading name, used for CharHeadings and Named character groups (identification). */ /* HeadingWording: Optional wording; preferred over HeadingName as HeadingLink in natural language output. */ /* Notes: Internal notes (not exported to Delta format). */ /* AutoGroup: 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!). */ CREATE TABLE DELTA_CHAR_Heading ( HID SMALLINT NOT NULL PRIMARY KEY, HeadingName NATIONAL CHARACTER VARYING(255) NOT NULL UNIQUE, HeadingWording NATIONAL CHARACTER VARYING(255) NULL, Notes NATIONAL TEXT NULL, AutoGroup NATIONAL CHARACTER VARYING(255) NULL ) /*=== Table: DELTA_CHAR_Heading_Link ===*/ /* Descriptor project: Character groups for Identification, Linking. */ /* HID: Character heading ID to be linked. */ /* CID: Character ID to which the identification heading is applicable. */ CREATE TABLE DELTA_CHAR_Heading_Link ( HID SMALLINT NOT NULL, CID SMALLINT NOT NULL, PRIMARY KEY (HID,CID) ) /*=== Table: DELTA_DEP ===*/ /* Descriptor project: Dependent (= inapplicable) characters for each character state. */ /* CID: Controlling character ID. */ /* CS: Controlling character state. */ /* InapplicableCID: CID of dependent character, i.e. inapplicable for any item where current CID/CS combination is used. */ CREATE TABLE DELTA_DEP ( CID SMALLINT NOT NULL, CS NATIONAL CHARACTER VARYING(16) NOT NULL, InapplicableCID SMALLINT NOT NULL, PRIMARY KEY (CID,CS,InapplicableCID) ) /*=== Table: DELTA_DESCR ===*/ /* Descriptor project: Data/descriptions for each item. */ /* IID: Item ID. */ /* CID: Character ID. */ /* Modifier: Modifier wording for categorical or numerical data, e.g. "mostly", "usually", "rarely". */ /* CS: Character state code. Usually pos. integer number or special codes for variable/unknown and for statistics (mean etc.). */ /* X: Numeric value, defined by CS. */ /* TXT: Text data. */ /* Notes: Notes and additional information, included in natural language item descriptions. */ /* SEQ: Sequence of character states for the item. */ CREATE TABLE DELTA_DESCR ( IID INTEGER NOT NULL, CID SMALLINT NOT NULL, Modifier NATIONAL CHARACTER VARYING(255) NULL, CS NATIONAL CHARACTER VARYING(16) NOT NULL, X FLOAT NULL, TXT NATIONAL TEXT NULL, Notes NATIONAL TEXT NULL, SEQ INTEGER NULL, PRIMARY KEY (CID,CS,IID) ) /*=== Table: DELTA_Glossary ===*/ /* Preliminary, for testing purposes only. */ /* GID: Glossary ID. */ /* Entry: Glossary entry (basic xhtml formatting allowed). */ /* Definition: Glossary entry definition (basic xhtml formatting allowed). */ /* Notes: Internal notes. */ /* Keywords: Additional keywords (semicolon separated list). */ CREATE TABLE DELTA_Glossary ( GID INTEGER IDENTITY NOT NULL PRIMARY KEY, Entry NATIONAL CHARACTER VARYING(255) NOT NULL UNIQUE, Definition NATIONAL TEXT NOT NULL, Notes NATIONAL TEXT NULL, Keywords NATIONAL CHARACTER VARYING(255) NULL ) /*=== Table: DELTA_MOD ===*/ /* Descriptor project: Modifer wordings for categorical or numerical data. */ /* Usage: Type of characters for which the modifier is applicable, e.g. GENERAL. COLORS, FREQuency of occurrence. */ /* Modifier: Modifier wording for categorical or numerical data, e.g. "mostly", "usually", "rarely". */ /* Reliability: Influence of modifier on data coded through categorical/numerical char. states. More (>5) or less reliable (<5); 5 is default. */ /* Postfix: Checked = output after the character state wording, unchecked = in front of it. */ /* UseBlank: Checked = blank is added between the modifier wording and the item data text, else modifier added compress. */ /* Operator: >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. */ /* Notes: Internal notes. */ /* LowerFreq: The lower border of the frequency range, for freq. modifiers only. */ /* UpperFreq: The upper border of the frequency range, for freq. modifiers only. */ CREATE TABLE DELTA_MOD ( Usage NATIONAL CHARACTER VARYING(255) NOT NULL, Modifier NATIONAL CHARACTER VARYING(255) NOT NULL PRIMARY KEY, Reliability TINYINT NOT NULL DEFAULT 5, Postfix BOOLEAN NOT NULL, UseBlank BOOLEAN NOT NULL DEFAULT -1, Operator TINYINT NOT NULL DEFAULT 0, Notes NATIONAL CHARACTER VARYING(255) NULL, LowerFreq FLOAT(7) NULL, UpperFreq FLOAT(7) NULL ) /*=== Table: DELTA_MOD_Link ===*/ /* Descriptor project: Links between characters and modifiers. */ /* CID: Character ID to which the modifier is applicable. */ /* Modifier: Modifier wording for categorical or numerical data, e.g. "mostly", "usually", "rarely". */ CREATE TABLE DELTA_MOD_Link ( CID SMALLINT NOT NULL, Modifier NATIONAL CHARACTER VARYING(255) NOT NULL, PRIMARY KEY (Modifier,CID) ) /*=== Table: DELTA_PROPERTY ===*/ /* Descriptor project: General header information about the project. */ /* PropertyName: The name of the project property (do not change!). */ /* TextValue: Text information. Use Shift F2 to zoom into larger window! */ /* DateTimeValue: Date or time information, e.g. of last update. */ /* NumericValue: Numerical information, stored as real number. */ CREATE TABLE DELTA_PROPERTY ( PropertyName NATIONAL CHARACTER VARYING(255) NOT NULL PRIMARY KEY, TextValue NATIONAL TEXT NULL, DateTimeValue DATETIME NULL, NumericValue FLOAT NULL ) /*=== Table: DELTA_ReportElement ===*/ /* Descriptor project: ReportElements for natural language description formulas, tables, etc. */ /* ReportElement: ID of report element (1-10 are reserved!). */ /* Language: Language to which the ReportElement is applicable. */ /* Description: Text that describes the use of the report element (shown in user interface). */ /* ParagraphBefore: Start a new paragraph before the ReportElement. */ /* TextBefore: Text inserted before the ReportElement (unformatted text). */ /* TextBetween: Enumeration separator between multiple subelements (e.g. characters); used only if ComplexWording is empty! */ /* TextAfter: Text inserted after the ReportElement (unformatted text). */ /* ParagraphAfter: Start a new paragraph after the ReportElement. */ /* ComplexWording: Wording for multiple characters, char. are inserted at |1, |2, etc.; |U = Unit, |C new table column, |R new table row. */ /* ComplexWordingFormat: 0 = RTF; 1 = HTML; 2= unformatted, will be reformatted with character format. */ /* UseWordingIfIncomplete: Yes: char. missing in an item are replaced by ''; No: AlternativeElement is tried, if none fitting found: EnumSeparator is used. */ /* AlternativeElement: Another ReportElement that is used if not all elements in ComplexWording are present, see 'UseWordingIfIncomplete'. */ /* CapitalizeStart: Capitalize first letter at start of this group. */ /* CapitalizeWithin: Capitalize first letter of each element (each char. in enumeration or table cell). */ /* WordgTruncation: Wording truncation (e.g. char. wording). 0=disable, 1=enable, restart, 2=enable, continue. */ /* RepElementNotes: Internal development notes. */ CREATE TABLE DELTA_ReportElement ( ReportElement INTEGER NOT NULL, Language NATIONAL CHARACTER VARYING(2) NOT NULL, Description NATIONAL CHARACTER VARYING(255) NULL, ParagraphBefore BOOLEAN NULL, TextBefore NATIONAL CHARACTER VARYING(255) NULL, TextBetween NATIONAL CHARACTER VARYING(255) NULL, TextAfter NATIONAL CHARACTER VARYING(255) NULL, ParagraphAfter BOOLEAN NULL, ComplexWording NATIONAL CHARACTER VARYING(255) NULL, ComplexWordingFormat TINYINT NULL DEFAULT 2, UseWordingIfIncomplete BOOLEAN NULL, AlternativeElement INTEGER NULL, CapitalizeStart BOOLEAN NULL DEFAULT 0, CapitalizeWithin BOOLEAN NULL DEFAULT 0, WordgTruncation TINYINT NOT NULL DEFAULT 0, RepElementNotes NATIONAL TEXT NULL, PRIMARY KEY (ReportElement,Language) ) /*=== Table: DELTA_RSC ===*/ /* Descriptor project: External resources stored as files or URL, e.g. illustrations for characters/items. */ /* IID: ID of associated item (optional). */ /* CID: ID of associated character (optional). */ /* CS: ID of associated character state (set to U or TE for text characters if resource belongs to char. in general). */ /* Resource: Filename of illustration (photo/drawing/graph) or other media resources. See _HEADING properties MediaDefaultPath/MediaDefaultURL to set global paths. */ /* Caption: Caption for the resource, e.g. a text to display while showing an illustration or a video. */ /* Notes: Internal notes (perhaps also formatting commands for INTKEY). */ /* ItemDefault: This image is a default image for the whole item, regardless of character association. */ /* CharDefault: This image is a default image for the whole character, regardless of character state association. */ /* RID: Media resource ID (necessary, because either IID or CID may be missing). */ /* ItemDescription: Include the resource, esp. images in the natural language description of items. */ /* CharDefinition: Include the resource, esp. images in character definition report. */ CREATE TABLE DELTA_RSC ( IID INTEGER NULL, CID SMALLINT NULL, CS NATIONAL CHARACTER VARYING(16) NULL DEFAULT 'U', Resource NATIONAL CHARACTER VARYING(255) NULL, Caption NATIONAL TEXT NULL, Notes NATIONAL TEXT NULL, ItemDefault BOOLEAN NOT NULL DEFAULT 0, CharDefault BOOLEAN NOT NULL DEFAULT 0, RID INTEGER IDENTITY NOT NULL PRIMARY KEY, ItemDescription BOOLEAN NULL DEFAULT 0, CharDefinition BOOLEAN NULL DEFAULT 0 ) ALTER TABLE DescriptorProject ADD FOREIGN KEY (PID) REFERENCES DescriptorProject_ParameterSet (PID) ON DELETE CASCADE /*** Remove this comment to enable creation of column description for MS SQL Server 2000 exec sp_addextendedproperty N'MS_Description',N'State ID.',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'SID' exec sp_addextendedproperty N'MS_Description',N'Character ID.',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'CID' exec sp_addextendedproperty N'MS_Description',N'Character state code. Usually pos. integer number or special codes for variable/unknown and for statistics (mean etc.).',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'CS' exec sp_addextendedproperty N'MS_Description',N'Name or description of character state.',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'CharStateName' exec sp_addextendedproperty N'MS_Description',N'Wording to be used instead of CharStateName for natural language descriptions output.',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'StateWording' exec sp_addextendedproperty N'MS_Description',N'Internal character state notes.',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'State specific formatting, overriding FormatString defined in the character definition. Standard Basic formatting string like "#.0".',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'StateFormatString' exec sp_addextendedproperty N'MS_Description',N'Mark this state as a default which is automatically set.',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'Implicit' exec sp_addextendedproperty N'MS_Description',N'Use this state during entering or updating of item descriptions.',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'UseEdit' exec sp_addextendedproperty N'MS_Description',N'Use this state during interactive identification.',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'UseIdentify' exec sp_addextendedproperty N'MS_Description',N'Use this state for natural language item descriptions.',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'UseDescr' exec sp_addextendedproperty N'MS_Description',N'Use this state for phylogenetic analysis.',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'UsePhylo' exec sp_addextendedproperty N'MS_Description',N'Use this to define a character state set for user-defined purposes.',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'UseOther' exec sp_addextendedproperty N'MS_Description',N'Numeric characters only: The lowest value of X in an item description to be mapped to this state (inclusive).',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'MinValue' exec sp_addextendedproperty N'MS_Description',N'Numeric characters only: The highest value of X in an item description to be mapped to this state (inclusive).',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'MaxValue' exec sp_addextendedproperty N'MS_Description',N'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.',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'StateWording1' exec sp_addextendedproperty N'MS_Description',N'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!',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'StateWording2' exec sp_addextendedproperty N'MS_Description',N'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''.',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'StateWording3' exec sp_addextendedproperty N'MS_Description',N'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.',N'user',N'dbo',N'table',N'DELTA_CS',N'column',N'StateWordingSuppressSingle' exec sp_addextendedproperty N'MS_Description',N'Item ID.',N'user',N'dbo',N'table',N'DELTA_ITEM',N'column',N'IID' exec sp_addextendedproperty N'MS_Description',N'Name or description of item (incl. taxon authors if necessary), link to taxonomic subsystem.',N'user',N'dbo',N'table',N'DELTA_ITEM',N'column',N'ItemName' exec sp_addextendedproperty N'MS_Description',N'Natural language descript.: Wording to be used instead of ItemName.',N'user',N'dbo',N'table',N'DELTA_ITEM',N'column',N'ItemWording' exec sp_addextendedproperty N'MS_Description',N'Item notes.',N'user',N'dbo',N'table',N'DELTA_ITEM',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'Abundance, relative importance (or weight) of item, 1-10, default is 5.',N'user',N'dbo',N'table',N'DELTA_ITEM',N'column',N'Abundance' exec sp_addextendedproperty N'MS_Description',N'Unit code in specimen collection, link into collection subsystem. NOT DEFINED IN DELTA!',N'user',N'dbo',N'table',N'DELTA_ITEM',N'column',N'CollUnit' exec sp_addextendedproperty N'MS_Description',N'Literature reference (user-readable text form). NOT DEFINED IN DELTA!',N'user',N'dbo',N'table',N'DELTA_ITEM',N'column',N'LitRef' exec sp_addextendedproperty N'MS_Description',N'Literature reference (numeric link into literature reference subsystem). NOT DEFINED IN DELTA!',N'user',N'dbo',N'table',N'DELTA_ITEM',N'column',N'LitKey' exec sp_addextendedproperty N'MS_Description',N'Reference detail, like page(s) of interest, specific figures, etc.',N'user',N'dbo',N'table',N'DELTA_ITEM',N'column',N'LitRefDetail' exec sp_addextendedproperty N'MS_Description',N'Descriptor project ID.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'PID' exec sp_addextendedproperty N'MS_Description',N'The name of the project used by the application, also the prefix of all project tables.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectName' exec sp_addextendedproperty N'MS_Description',N'Only for linked subprojects: The project containing the main tables.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ParentPID' exec sp_addextendedproperty N'MS_Description',N'A short title for the project (up to 50 characters).',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectTitle' exec sp_addextendedproperty N'MS_Description',N'A URL that may optionally be placed behind the Title to hyperlink to another site on the world-wide-web.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectTitleURL' exec sp_addextendedproperty N'MS_Description',N'Default horizontal alignment of title text: 0 = left; 1 = centered; 2 = right; 3 = justified (block).',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectTitleAligment' exec sp_addextendedproperty N'MS_Description',N'A short descriptive text, explaining the scope of the descriptor project (used in reports).',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectDescription' exec sp_addextendedproperty N'MS_Description',N'A version number or code for the descriptor definition and item data of the project.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectVersion' exec sp_addextendedproperty N'MS_Description',N'A string containing one or several authors responsible for the data in the descriptor project.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectAuthors' exec sp_addextendedproperty N'MS_Description',N'A string containing one or several editors responsible for the data in the descriptor project.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectEditors' exec sp_addextendedproperty N'MS_Description',N'A string containing a copyright statement, including the year (do include the copyright symbol, (c) or ©, if you want to use it).',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectCopyright' exec sp_addextendedproperty N'MS_Description',N'History of the project, including data source information, copyright agreements, acknowledgements, occasional collaborators, and disclaimers.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectHistory' exec sp_addextendedproperty N'MS_Description',N'Internal notes and additions to the history. In contrast to ProjectHistory this information is not used in reports.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectHistoryNotes' exec sp_addextendedproperty N'MS_Description',N'Messages issued during the import of the project (import source, import warnings, import skipped information).',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectImportNotes' exec sp_addextendedproperty N'MS_Description',N'Internal notes regarding the entire project.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectNotes' exec sp_addextendedproperty N'MS_Description',N'A logo or icon, usually a small gif file that can be displayed side-by-side with the project title.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectLogo' exec sp_addextendedproperty N'MS_Description',N'A URL that may optionally be placed behind the Logo to hyperlink to another site on the world-wide-web.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectLogoURL' exec sp_addextendedproperty N'MS_Description',N'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.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectLogoAligment' exec sp_addextendedproperty N'MS_Description',N'URL of a CSS (cascading style sheet) file to create a consistent format for html reports.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectStylesheetURL' exec sp_addextendedproperty N'MS_Description',N'Text placed at the bottom of reports, containing a disclaimer or other information.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectDisclamer' exec sp_addextendedproperty N'MS_Description',N'A URL that may optionally be placed behind the Disclaimer to hyperlink to another site on the world-wide-web.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectDisclamerURL' exec sp_addextendedproperty N'MS_Description',N'Default horizontal alignment of disclaimer text: 0 = left; 1 = centered; 2 = right; 3 = justified (block).',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectDisclamerAligment' exec sp_addextendedproperty N'MS_Description',N'Date and file name of last backup to an mdb backup file.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectLastBackup' exec sp_addextendedproperty N'MS_Description',N'Date and file name of last restore from an mdb backup file.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectLastRestore' exec sp_addextendedproperty N'MS_Description',N'Date and file name of last export, e. g., to a DELTA file.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectLastExport' exec sp_addextendedproperty N'MS_Description',N'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.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectLastSchemaUpdate' exec sp_addextendedproperty N'MS_Description',N'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.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectLastItemUpdate' exec sp_addextendedproperty N'MS_Description',N'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).',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'StorageModelVersion' exec sp_addextendedproperty N'MS_Description',N'Formatting encoding of data in the project (0=Plain/BasicHTML, 1= Full HTML), list of coding for item, heading, char. etc.',N'user',N'dbo',N'table',N'DescriptorProject',N'column',N'ProjectTextFormatting' exec sp_addextendedproperty N'MS_Description',N'Descriptor project ID.',N'user',N'dbo',N'table',N'DescriptorProject_ParameterSet',N'column',N'PID' exec sp_addextendedproperty N'MS_Description',N'The reporting or other object to which the parameter set applies, e.g. the Character definition report.',N'user',N'dbo',N'table',N'DescriptorProject_ParameterSet',N'column',N'ObjectName' exec sp_addextendedproperty N'MS_Description',N'A user defined name distinguishing multiple parameter sets for the same object.',N'user',N'dbo',N'table',N'DescriptorProject_ParameterSet',N'column',N'SetName' exec sp_addextendedproperty N'MS_Description',N'The date at which the parameter set was last edited.',N'user',N'dbo',N'table',N'DescriptorProject_ParameterSet',N'column',N'LastUpdate' exec sp_addextendedproperty N'MS_Description',N'Internal notes regarding the parameter set.',N'user',N'dbo',N'table',N'DescriptorProject_ParameterSet',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'The coded parameter set (machine readable).',N'user',N'dbo',N'table',N'DescriptorProject_ParameterSet',N'column',N'Parameters' exec sp_addextendedproperty N'MS_Description',N'Precalculated.',N'user',N'dbo',N'table',N'DescriptorProject_ParameterSet',N'column',N'OverrideHeaderFile' exec sp_addextendedproperty N'MS_Description',N'Precalculated.',N'user',N'dbo',N'table',N'DescriptorProject_ParameterSet',N'column',N'InsertHeaderFile' exec sp_addextendedproperty N'MS_Description',N'Character ID number.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'CID' exec sp_addextendedproperty N'MS_Description',N'Short name of character.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'CharName' exec sp_addextendedproperty N'MS_Description',N'For numeric characters: an optional measurement unit like ''mm''. Only true units here, text like ''wide'' belongs to CharWording2!',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'Unit' exec sp_addextendedproperty N'MS_Description',N'Character notes.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'Type of character: Text, Ordered/unordered multistate, Integer/Real numeric.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'Type' exec sp_addextendedproperty N'MS_Description',N'Is the scoring of this character mandatory (required) in each item?',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'Mandatory' exec sp_addextendedproperty N'MS_Description',N'Are multiple states allowed and how are they interpreted?',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'MultiStateType' exec sp_addextendedproperty N'MS_Description',N'Reliability (or weight) of character for identification, 1-10, default is 5.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'Reliability' exec sp_addextendedproperty N'MS_Description',N'Availability (or accessibility) of character for identification, 1-10, default is 5. This is an extension to the Delta standard.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'Availability' exec sp_addextendedproperty N'MS_Description',N'For identification: Unless a range is explicitly present, used to form a range around the mean (RN/IN) or state (OM).',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'Fuzziness' exec sp_addextendedproperty N'MS_Description',N'Interpret ''Fuzziness'' as ''percent'' rather than ''absolute value'' (e.g. Fuzziness=10 -> range=mean +/- 10%, instead of +/- 10 absolute).',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'FuzzinessIsPercent' exec sp_addextendedproperty N'MS_Description',N'For use in a key: combine multistate char, into new combinations or define ranges for numeric char.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'KeyStates' exec sp_addextendedproperty N'MS_Description',N'A heading defined in the headings definition, inserted in char. def. output in front of the current character.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'CharHeading' exec sp_addextendedproperty N'MS_Description',N'A heading defined in the headings definition, inserted in natural language descriptions in front of descriptions using this character.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'HeadingLink' exec sp_addextendedproperty N'MS_Description',N'Natural language descript.: Wording to be used instead of CharName.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'CharWording' exec sp_addextendedproperty N'MS_Description',N'Natural language descript.: Wording to be used AFTER states or values + unit, e.g. ''wide'' for ''leaves 3-5 mm wide''.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'CharWording2' exec sp_addextendedproperty N'MS_Description',N'True if unit is to be placed in front of value, e.g. "pH 7.2".',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'UnitIsPrefix' exec sp_addextendedproperty N'MS_Description',N'Default formatting for all states (compare StateFormatString). Esp. for numeric values (number of decimal places etc.). Standard Basic formatting string like "#.0".',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'FormatString' exec sp_addextendedproperty N'MS_Description',N'Nat.language descript.: Define char. linked into a single paragraph. A new paragraph starts if group ID changes.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'ParagraphLink' exec sp_addextendedproperty N'MS_Description',N'Nat.language descript.: Define char. linked into a single sentence. A new sentence starts if group ID changes or whenever ''Null''.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'SentenceLink' exec sp_addextendedproperty N'MS_Description',N'Nat.language descript.: Define characters linked into a comma-enumeration (''sub-sentence''). A new group starts if group ID changes or whenever ''Null''.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'CommaLink' exec sp_addextendedproperty N'MS_Description',N'Nat.language descript.: Define characters that are linked by special means (as defined in SpecialElement).',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'SpecialLink' exec sp_addextendedproperty N'MS_Description',N'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].',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'SpecialElement' exec sp_addextendedproperty N'MS_Description',N'Nat.language descript.: Use alternative comma separator between states of this character (e.g. for Chinese).',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'UseComma2' exec sp_addextendedproperty N'MS_Description',N'Nat.language descript.: The final comma between character states is omitted (''1,2 and 3'' instead of ''1,2, and 3'').',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'OmitFinalComma' exec sp_addextendedproperty N'MS_Description',N'Natural language descript.: Omit lower (''-'') or upper (''+'') part of numeric character ranges.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'OmitValues' exec sp_addextendedproperty N'MS_Description',N'Nat.language descript.: Emphasize (italic or bold print) this character in all items.',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'Emphasize' exec sp_addextendedproperty N'MS_Description',N'Nat.language descript.: Omit the end delimiter (usually the period for a sentence, DELTA: ''OMIT PERIOD FOR CHAR'').',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'OmitPeriod' exec sp_addextendedproperty N'MS_Description',N'Number of states for this character, default is 2. Calculated automatically, do not edit!',N'user',N'dbo',N'table',N'DELTA_CHAR',N'column',N'NumStates' exec sp_addextendedproperty N'MS_Description',N'Character heading ID; determines sequence of headings when used in identification; change number to change that sequence!',N'user',N'dbo',N'table',N'DELTA_CHAR_Heading',N'column',N'HID' exec sp_addextendedproperty N'MS_Description',N'Heading name, used for CharHeadings and Named character groups (identification).',N'user',N'dbo',N'table',N'DELTA_CHAR_Heading',N'column',N'HeadingName' exec sp_addextendedproperty N'MS_Description',N'Optional wording; preferred over HeadingName as HeadingLink in natural language output.',N'user',N'dbo',N'table',N'DELTA_CHAR_Heading',N'column',N'HeadingWording' exec sp_addextendedproperty N'MS_Description',N'Internal notes (not exported to Delta format).',N'user',N'dbo',N'table',N'DELTA_CHAR_Heading',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'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!).',N'user',N'dbo',N'table',N'DELTA_CHAR_Heading',N'column',N'AutoGroup' exec sp_addextendedproperty N'MS_Description',N'Character heading ID to be linked.',N'user',N'dbo',N'table',N'DELTA_CHAR_Heading_Link',N'column',N'HID' exec sp_addextendedproperty N'MS_Description',N'Character ID to which the identification heading is applicable.',N'user',N'dbo',N'table',N'DELTA_CHAR_Heading_Link',N'column',N'CID' exec sp_addextendedproperty N'MS_Description',N'Controlling character ID.',N'user',N'dbo',N'table',N'DELTA_DEP',N'column',N'CID' exec sp_addextendedproperty N'MS_Description',N'Controlling character state.',N'user',N'dbo',N'table',N'DELTA_DEP',N'column',N'CS' exec sp_addextendedproperty N'MS_Description',N'CID of dependent character, i.e. inapplicable for any item where current CID/CS combination is used.',N'user',N'dbo',N'table',N'DELTA_DEP',N'column',N'InapplicableCID' exec sp_addextendedproperty N'MS_Description',N'Item ID.',N'user',N'dbo',N'table',N'DELTA_DESCR',N'column',N'IID' exec sp_addextendedproperty N'MS_Description',N'Character ID.',N'user',N'dbo',N'table',N'DELTA_DESCR',N'column',N'CID' exec sp_addextendedproperty N'MS_Description',N'Modifier wording for categorical or numerical data, e.g. "mostly", "usually", "rarely".',N'user',N'dbo',N'table',N'DELTA_DESCR',N'column',N'Modifier' exec sp_addextendedproperty N'MS_Description',N'Character state code. Usually pos. integer number or special codes for variable/unknown and for statistics (mean etc.).',N'user',N'dbo',N'table',N'DELTA_DESCR',N'column',N'CS' exec sp_addextendedproperty N'MS_Description',N'Numeric value, defined by CS.',N'user',N'dbo',N'table',N'DELTA_DESCR',N'column',N'X' exec sp_addextendedproperty N'MS_Description',N'Text data.',N'user',N'dbo',N'table',N'DELTA_DESCR',N'column',N'TXT' exec sp_addextendedproperty N'MS_Description',N'Notes and additional information, included in natural language item descriptions.',N'user',N'dbo',N'table',N'DELTA_DESCR',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'Sequence of character states for the item.',N'user',N'dbo',N'table',N'DELTA_DESCR',N'column',N'SEQ' exec sp_addextendedproperty N'MS_Description',N'Glossary ID.',N'user',N'dbo',N'table',N'DELTA_Glossary',N'column',N'GID' exec sp_addextendedproperty N'MS_Description',N'Glossary entry (basic xhtml formatting allowed).',N'user',N'dbo',N'table',N'DELTA_Glossary',N'column',N'Entry' exec sp_addextendedproperty N'MS_Description',N'Glossary entry definition (basic xhtml formatting allowed).',N'user',N'dbo',N'table',N'DELTA_Glossary',N'column',N'Definition' exec sp_addextendedproperty N'MS_Description',N'Internal notes.',N'user',N'dbo',N'table',N'DELTA_Glossary',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'Additional keywords (semicolon separated list).',N'user',N'dbo',N'table',N'DELTA_Glossary',N'column',N'Keywords' exec sp_addextendedproperty N'MS_Description',N'Type of characters for which the modifier is applicable, e.g. GENERAL. COLORS, FREQuency of occurrence.',N'user',N'dbo',N'table',N'DELTA_MOD',N'column',N'Usage' exec sp_addextendedproperty N'MS_Description',N'Modifier wording for categorical or numerical data, e.g. "mostly", "usually", "rarely".',N'user',N'dbo',N'table',N'DELTA_MOD',N'column',N'Modifier' exec sp_addextendedproperty N'MS_Description',N'Influence of modifier on data coded through categorical/numerical char. states. More (>5) or less reliable (<5); 5 is default.',N'user',N'dbo',N'table',N'DELTA_MOD',N'column',N'Reliability' exec sp_addextendedproperty N'MS_Description',N'Checked = output after the character state wording, unchecked = in front of it.',N'user',N'dbo',N'table',N'DELTA_MOD',N'column',N'Postfix' exec sp_addextendedproperty N'MS_Description',N'Checked = blank is added between the modifier wording and the item data text, else modifier added compress.',N'user',N'dbo',N'table',N'DELTA_MOD',N'column',N'UseBlank' exec sp_addextendedproperty N'MS_Description',N'>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.',N'user',N'dbo',N'table',N'DELTA_MOD',N'column',N'Operator' exec sp_addextendedproperty N'MS_Description',N'Internal notes.',N'user',N'dbo',N'table',N'DELTA_MOD',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'The lower border of the frequency range, for freq. modifiers only.',N'user',N'dbo',N'table',N'DELTA_MOD',N'column',N'LowerFreq' exec sp_addextendedproperty N'MS_Description',N'The upper border of the frequency range, for freq. modifiers only.',N'user',N'dbo',N'table',N'DELTA_MOD',N'column',N'UpperFreq' exec sp_addextendedproperty N'MS_Description',N'Character ID to which the modifier is applicable.',N'user',N'dbo',N'table',N'DELTA_MOD_Link',N'column',N'CID' exec sp_addextendedproperty N'MS_Description',N'Modifier wording for categorical or numerical data, e.g. "mostly", "usually", "rarely".',N'user',N'dbo',N'table',N'DELTA_MOD_Link',N'column',N'Modifier' exec sp_addextendedproperty N'MS_Description',N'The name of the project property (do not change!).',N'user',N'dbo',N'table',N'DELTA_PROPERTY',N'column',N'PropertyName' exec sp_addextendedproperty N'MS_Description',N'Text information. Use Shift F2 to zoom into larger window!',N'user',N'dbo',N'table',N'DELTA_PROPERTY',N'column',N'TextValue' exec sp_addextendedproperty N'MS_Description',N'Date or time information, e.g. of last update.',N'user',N'dbo',N'table',N'DELTA_PROPERTY',N'column',N'DateTimeValue' exec sp_addextendedproperty N'MS_Description',N'Numerical information, stored as real number.',N'user',N'dbo',N'table',N'DELTA_PROPERTY',N'column',N'NumericValue' exec sp_addextendedproperty N'MS_Description',N'ID of report element (1-10 are reserved!).',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'ReportElement' exec sp_addextendedproperty N'MS_Description',N'Language to which the ReportElement is applicable.',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'Language' exec sp_addextendedproperty N'MS_Description',N'Text that describes the use of the report element (shown in user interface).',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'Description' exec sp_addextendedproperty N'MS_Description',N'Start a new paragraph before the ReportElement.',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'ParagraphBefore' exec sp_addextendedproperty N'MS_Description',N'Text inserted before the ReportElement (unformatted text).',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'TextBefore' exec sp_addextendedproperty N'MS_Description',N'Enumeration separator between multiple subelements (e.g. characters); used only if ComplexWording is empty!',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'TextBetween' exec sp_addextendedproperty N'MS_Description',N'Text inserted after the ReportElement (unformatted text).',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'TextAfter' exec sp_addextendedproperty N'MS_Description',N'Start a new paragraph after the ReportElement.',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'ParagraphAfter' exec sp_addextendedproperty N'MS_Description',N'Wording for multiple characters, char. are inserted at |1, |2, etc.; |U = Unit, |C new table column, |R new table row.',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'ComplexWording' exec sp_addextendedproperty N'MS_Description',N'0 = RTF; 1 = HTML; 2= unformatted, will be reformatted with character format.',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'ComplexWordingFormat' exec sp_addextendedproperty N'MS_Description',N'Yes: char. missing in an item are replaced by ''''; No: AlternativeElement is tried, if none fitting found: EnumSeparator is used.',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'UseWordingIfIncomplete' exec sp_addextendedproperty N'MS_Description',N'Another ReportElement that is used if not all elements in ComplexWording are present, see ''UseWordingIfIncomplete''.',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'AlternativeElement' exec sp_addextendedproperty N'MS_Description',N'Capitalize first letter at start of this group.',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'CapitalizeStart' exec sp_addextendedproperty N'MS_Description',N'Capitalize first letter of each element (each char. in enumeration or table cell).',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'CapitalizeWithin' exec sp_addextendedproperty N'MS_Description',N'Wording truncation (e.g. char. wording). 0=disable, 1=enable, restart, 2=enable, continue.',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'WordgTruncation' exec sp_addextendedproperty N'MS_Description',N'Internal development notes.',N'user',N'dbo',N'table',N'DELTA_ReportElement',N'column',N'RepElementNotes' exec sp_addextendedproperty N'MS_Description',N'ID of associated item (optional).',N'user',N'dbo',N'table',N'DELTA_RSC',N'column',N'IID' exec sp_addextendedproperty N'MS_Description',N'ID of associated character (optional).',N'user',N'dbo',N'table',N'DELTA_RSC',N'column',N'CID' exec sp_addextendedproperty N'MS_Description',N'ID of associated character state (set to U or TE for text characters if resource belongs to char. in general).',N'user',N'dbo',N'table',N'DELTA_RSC',N'column',N'CS' exec sp_addextendedproperty N'MS_Description',N'Filename of illustration (photo/drawing/graph) or other media resources. See _HEADING properties MediaDefaultPath/MediaDefaultURL to set global paths.',N'user',N'dbo',N'table',N'DELTA_RSC',N'column',N'Resource' exec sp_addextendedproperty N'MS_Description',N'Caption for the resource, e.g. a text to display while showing an illustration or a video.',N'user',N'dbo',N'table',N'DELTA_RSC',N'column',N'Caption' exec sp_addextendedproperty N'MS_Description',N'Internal notes (perhaps also formatting commands for INTKEY).',N'user',N'dbo',N'table',N'DELTA_RSC',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'This image is a default image for the whole item, regardless of character association.',N'user',N'dbo',N'table',N'DELTA_RSC',N'column',N'ItemDefault' exec sp_addextendedproperty N'MS_Description',N'This image is a default image for the whole character, regardless of character state association.',N'user',N'dbo',N'table',N'DELTA_RSC',N'column',N'CharDefault' exec sp_addextendedproperty N'MS_Description',N'Media resource ID (necessary, because either IID or CID may be missing).',N'user',N'dbo',N'table',N'DELTA_RSC',N'column',N'RID' exec sp_addextendedproperty N'MS_Description',N'Include the resource, esp. images in the natural language description of items.',N'user',N'dbo',N'table',N'DELTA_RSC',N'column',N'ItemDescription' exec sp_addextendedproperty N'MS_Description',N'Include the resource, esp. images in character definition report.',N'user',N'dbo',N'table',N'DELTA_RSC',N'column',N'CharDefinition' GO /*** END column description for MS SQL Server 2000 ***/