/* SQL DDL: Create an implementation of the model using the SQL Data Definition Language */
/*  Note: Comments such as this may not be supported by your system and may have to be removed */
/*  You may want to change some field types to improve the implementation on your DBMS. */
/*  Data type 'National Character' etc. indicates Unicode text. */
/*  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 */ 
/*   named '...SQL.Postgres.txt' instead of '...SQL.txt' is now created in addition to the current file. */
/*   The current file aims at SQL-Server dialects (but uses 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 */
/*  Note: CREATE INDEX statements (other than primary, foreign, or unique key constraints) are missing at the moment; to be added later */
/*  Generated on 30/Mar/2005 by Diversity Information Model Documenter 2.61 (G. Hagedorn) */



/*=== Table: DD_CHAR ===*/
/* Character table. */
  /*   CID: Character ID number. Also currently defines the order of characters. This ID may change over time, please compare the separate CharID. */
  /*   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. to output "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 starts if group ID changes or whenever Null. */
  /*   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: Calculated field: Number of states other than special states U,V,- present in this character, default is 2. Calculated automatically, do not edit! */
  /*   CharID: Immutable unique number identifying a character (candidate key). Not exported to DELTA! Semantics are similar to CID, which, however, is exported to DELTA and requires renumbering after character deletions. */
CREATE TABLE DD_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 BIT 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 BIT 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 BIT NULL,
    FormatString NATIONAL CHARACTER VARYING(255) NULL,
    ParagraphLink INTEGER NULL DEFAULT 1,
    SentenceLink INTEGER NULL,
    CommaLink INTEGER NULL,
    UseComma2 BIT NULL,
    OmitFinalComma BIT NOT NULL DEFAULT 0,
    OmitValues NATIONAL CHARACTER VARYING(1) NULL,
    Emphasize BIT NULL DEFAULT 0,
    OmitPeriod BIT NULL DEFAULT 0,
    NumStates SMALLINT NOT NULL DEFAULT 2,
    CharID INTEGER IDENTITY   NOT NULL UNIQUE
);




/*=== Table: DD_CHAR_Translation ===*/
/* Character table, translations into multiple languages. */
  /*   CharID: Character ID (unchanging version). */
  /*   Language: Language of the translation. */
  /*   CharName: Short label for character; in the current Language. */
  /*   CharWording: Natural language descript.: Wording to be used instead of CharName; in the current Language. */
  /*   CharWording2: Natural language descript.: Wording to be used AFTER states or values + unit, e.g. 'wide' for 'leaves 3-5 mm wide'; in the current Language. */
  /*   Unit: For numeric characters: an optional measurement unit like 'mm'. Only true units here, text like 'wide' belongs to CharWording2! */
  /*   UnitIsPrefix: True if unit is to be placed in front of value, e.g. to output "pH 7.2". */
  /*   Notes: Character Notes (for DELTA data this could be an extensive definition of the character). */
  /*   FormatString: Default formatting for all states (compare StateFormatString). Esp. for numeric values (number of decimal places etc.). Standard Basic formatting string like "#.0". */
CREATE TABLE DD_CHAR_Translation (
    CharID INTEGER NOT NULL,
    Language NATIONAL CHARACTER VARYING(2) NOT NULL,
    CharName NATIONAL CHARACTER VARYING(255) NOT NULL,
    CharWording NATIONAL CHARACTER VARYING(255) NULL,
    CharWording2 NATIONAL CHARACTER VARYING(255) NULL,
    Unit NATIONAL CHARACTER VARYING(50) NULL,
    UnitIsPrefix BIT NULL,
    Notes NATIONAL TEXT NULL,
    FormatString NATIONAL CHARACTER VARYING(255) NULL,
  PRIMARY KEY (CharID,Language)
);




/*=== Table: DD_CHAR_Heading ===*/
/* 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 if headings for natural language descriptions are defined through the HeadingLink mechanism . */
  /*   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 query returning a set of character IDs. (HeadingName of predefined AutoGroups may be changed!). */
  /*   ParentHeadingID: A hierarchy of headings can be defined in DeltaAccess by adding the higher hierarchy here. However, this is not supported by DELTA and can not be exported. */
  /*   HeadingID: Immutable unique number identifying a heading (candidate key). */
CREATE TABLE DD_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,
    ParentHeadingID INTEGER NULL,
    HeadingID INTEGER IDENTITY   NOT NULL UNIQUE
);




/*=== Table: DD_CHAR_Heading_Translation ===*/
/* Character headings, translations into multiple languages. */
  /*   HeadingID: Character heading ID. */
  /*   Language: Language of the translation. */
  /*   HeadingName: Heading name, used for CharHeadings and Named character groups (identification). */
  /*   HeadingWording: Optional wording; preferred over HeadingName if headings for natural language descriptions are defined through the HeadingLink mechanism . */
  /*   Notes: Notes on translation. */
CREATE TABLE DD_CHAR_Heading_Translation (
    HeadingID INTEGER NOT NULL,
    Language NATIONAL CHARACTER VARYING(2) NOT NULL,
    HeadingName NATIONAL CHARACTER VARYING(255) NOT NULL UNIQUE,
    HeadingWording NATIONAL CHARACTER VARYING(255) NULL,
    Notes NATIONAL TEXT NULL,
  PRIMARY KEY (HeadingID,Language)
);




/*=== Table: DD_CHAR_Heading_Link ===*/
/* Character groups for Identification, Linking. */
  /*   HID: Character heading ID to be linked. */
  /*   CID: Character ID to which the identification heading is applicable. */
CREATE TABLE DD_CHAR_Heading_Link (
    HID SMALLINT NOT NULL,
    CID SMALLINT NOT NULL,
  PRIMARY KEY (HID,CID)
);




/*=== Table: DD_CS ===*/
/* Character states for each character. */
  /*   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. */
  /*   Notes: Character state notes. */
  /*   StateWording: Wording to be used instead of CharStateName for natural language descriptions output. */
  /*   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: (Not yet implemented!) Use this state during entering or updating of item descriptions. */
  /*   UseIdentify: (Not yet implemented!) Use this state during interactive identification. */
  /*   UseDescr: (Not yet implemented!) Use this state for natural language item descriptions. */
  /*   UsePhylo: (Not yet implemented!) Use this state for phylogenetic analysis. */
  /*   UseOther: (Not yet implemented!) Use this to define a character state set for user-defined purposes. */
  /*   MinValue: Numeric characters only: The lowest value of X in item description to be mapped to this state (inclusive). */
  /*   MaxValue: Numeric characters only: The highest value of X in item description to be mapped to this state (inclusive). */
  /*   StateID: Immutable unique number identifying a character state independently of the character. Not exported to DELTA! Preferred key for any external references to states not protected by cascaded referential updates. (Candidate key). */
CREATE TABLE DD_CS (
    CID SMALLINT NOT NULL,
    CS NATIONAL CHARACTER VARYING(16) NOT NULL,
    CharStateName NATIONAL CHARACTER VARYING(255) NOT NULL UNIQUE,
    Notes NATIONAL TEXT NULL,
    StateWording NATIONAL CHARACTER VARYING(255) NULL,
    StateFormatString NATIONAL CHARACTER VARYING(255) NULL,
    Implicit BIT NOT NULL DEFAULT 0,
    UseEdit BIT NULL DEFAULT 1,
    UseIdentify BIT NULL DEFAULT 0,
    UseDescr BIT NULL DEFAULT 0,
    UsePhylo BIT NULL DEFAULT 0,
    UseOther BIT NULL DEFAULT 0,
    MinValue FLOAT NOT NULL DEFAULT -1E+308,
    MaxValue FLOAT NOT NULL DEFAULT 1E+308,
    StateID INTEGER IDENTITY   NOT NULL UNIQUE,
  PRIMARY KEY (CID,CS)
);




/*=== Table: DD_CS_Translation ===*/
/* Character states, translations into multiple languages. */
  /*   StateID: State ID (foreign key). */
  /*   Language: Language of the translation. */
  /*   CharStateName: Name or description of character state. */
  /*   Notes: Notes on translation. */
  /*   StateWording: Wording to be used instead of CharStateName for natural language descriptions output. */
  /*   StateFormatString: State specific formatting, overriding FormatString defined in the character definition. Standard Basic formatting string like "#.0". */
CREATE TABLE DD_CS_Translation (
    StateID INTEGER NOT NULL DEFAULT 0,
    Language NATIONAL CHARACTER VARYING(2) NOT NULL,
    CharStateName NATIONAL CHARACTER VARYING(255) NOT NULL,
    Notes NATIONAL TEXT NULL,
    StateWording NATIONAL CHARACTER VARYING(255) NULL,
    StateFormatString NATIONAL CHARACTER VARYING(255) NULL,
  PRIMARY KEY (StateID,Language)
);




/*=== Table: DD_MOD ===*/
/* Modifier 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. */
  /*   MisinterpretationMarker: If set to true, the state to which this modifier is added is marked as being present only by misinterpretation of structure (phyllocladium as leaf) or state (rough spore surface as smooth). */
  /*   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 DD_MOD (
    Usage NATIONAL CHARACTER VARYING(255) NOT NULL,
    Modifier NATIONAL CHARACTER VARYING(255) NOT NULL PRIMARY KEY,
    Reliability TINYINT NOT NULL DEFAULT 5,
    MisinterpretationMarker BIT NOT NULL DEFAULT 0,
    Postfix BIT NOT NULL,
    UseBlank BIT 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: DD_MOD_Translation ===*/
/* Modifier wordings, translations into multiple languages. */
  /*   Modifier: Modifier wording. Foreign key linking to _MOD. In current language! */
  /*   Language: Language of the translation. */
  /*   ModifierTranslation: Translation of modifier wording. */
CREATE TABLE DD_MOD_Translation (
    Modifier NATIONAL CHARACTER VARYING(255) NOT NULL,
    Language NATIONAL CHARACTER VARYING(2) NOT NULL,
    ModifierTranslation NATIONAL CHARACTER VARYING(255) NOT NULL,
  PRIMARY KEY (Modifier,Language)
);




/*=== Table: DD_MOD_Link ===*/
/* 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 DD_MOD_Link (
    CID SMALLINT NOT NULL,
    Modifier NATIONAL CHARACTER VARYING(255) NOT NULL,
  PRIMARY KEY (Modifier,CID)
);




/*=== Table: DD_DEP ===*/
/* 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 DD_DEP (
    CID SMALLINT NOT NULL,
    CS NATIONAL CHARACTER VARYING(16) NOT NULL,
    InapplicableCID SMALLINT NOT NULL,
  PRIMARY KEY (CID,CS,InapplicableCID)
);




/*=== Table: DD_ITEM ===*/
/* 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. */
  /*   ItemID: Immutable unique number identifying an item (candidate key). Not exported to DELTA! Semantics are similar to IID, which, however, is exported to DELTA and requires renumbering after deletions. */
CREATE TABLE DD_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,
    ItemID INTEGER IDENTITY   NOT NULL UNIQUE
);




/*=== Table: DD_DESCR ===*/
/* 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 DD_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: DD_RSC ===*/
/* External resources stored as files or URL, e.g. illustrations for characters/items. */
  /*   ItemID: ID of associated item (optional). This refers to ItemID, not IID! */
  /*   CharID: ID of associated character (optional). This refers to CharID, not CID! */
  /*   StateID: ID of associated character state (optional). This refers to StateID, not CS! */
  /*   Resource: Filename of illustration (photo/drawing/graph) or other media resources (see ResourceDefaultPath/DefaultURL in table _PROPERTY for setting global paths). */
  /*   Caption: Caption for the resource, e.g. a text to display while showing an illustration or a video. */
  /*   Role: Roles the resource is intended for: I = Icon, S = Selector (displayed directly, e. g. to select a state), D = Definition (usually displayed only as thumbnail image or link for further information). */
  /*   ItemUsage: Usage of resource in the context of items (including natural language descriptions). Usage is especially relevant if both Item and CharIDs are defined, but resource is relevant for entire item (e.g. habit). */
  /*   CharUsage: Usage of resource in the context of items (especially character definition in print or web form). Usage is especially relevant if also Item or StateIDs are defined, but resource is relevant for entire character as well. */
  /*   Notes: Internal notes (perhaps also formatting commands for INTKEY). */
  /*   DisplayOrder: A positive number that can be used to define the sequence in which multiple resources are displayed. */
  /*   ResourceID: Media resource ID (any of item, char, state IDs may be missing). */
CREATE TABLE DD_RSC (
    ItemID INTEGER NULL,
    CharID INTEGER NULL,
    StateID INTEGER NULL,
    Resource NATIONAL CHARACTER VARYING(255) NOT NULL,
    Caption NATIONAL TEXT NULL,
    Language NATIONAL CHARACTER VARYING(2) NULL,
    Role NATIONAL CHARACTER VARYING(1) NOT NULL DEFAULT 'S',
    ItemUsage NATIONAL CHARACTER VARYING(1) NULL,
    CharUsage NATIONAL CHARACTER VARYING(1) NULL,
    Notes NATIONAL TEXT NULL,
    DisplayOrder INTEGER NOT NULL DEFAULT 0,
    ResourceID INTEGER IDENTITY   NOT NULL PRIMARY KEY
);




/*=== Table: DD_PROPERTY ===*/
/* 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. */
  /*   Language: Language of a property translation, e.g. for project title. */
CREATE TABLE DD_PROPERTY (
    PropertyName NATIONAL CHARACTER VARYING(255) NOT NULL PRIMARY KEY,
    TextValue NATIONAL TEXT NULL,
    DateTimeValue DATETIME NULL,
    NumericValue FLOAT NULL,
    Language NATIONAL CHARACTER VARYING(2) NOT NULL DEFAULT 'en'
);




/*=== Table: DD_CurrentLanguage ===*/
/* Definition of a single language as the current working language, determines which language is displayed in editing forms, reports, etc. The table supports only a single record! */
  /*   ID: ID (restricted to a single record, ID must always be 1!). */
  /*   Language: 2 character ISO language code. */
CREATE TABLE DD_CurrentLanguage (
    ID INTEGER NOT NULL PRIMARY KEY DEFAULT 1,
    Language NATIONAL CHARACTER VARYING(2) NOT NULL
);


ALTER TABLE DD_CHAR ADD 
  FOREIGN KEY (CharHeading) REFERENCES DD_CHAR_Heading (HID) ON UPDATE CASCADE,
  FOREIGN KEY (HeadingLink) REFERENCES DD_CHAR_Heading (HID) ON UPDATE CASCADE
ALTER TABLE DD_CHAR_Translation ADD 
  FOREIGN KEY (CharID) REFERENCES DD_CHAR (CharID) ON UPDATE CASCADE ON DELETE CASCADE
ALTER TABLE DD_CHAR_Heading ADD 
  FOREIGN KEY (ParentHeadingID) REFERENCES DD_CHAR_Heading (HeadingID) ON UPDATE CASCADE
ALTER TABLE DD_CHAR_Heading_Translation ADD 
  FOREIGN KEY (HeadingID) REFERENCES DD_CHAR_Heading (HeadingID) ON UPDATE CASCADE ON DELETE CASCADE
ALTER TABLE DD_CHAR_Heading_Link ADD 
  FOREIGN KEY (HID) REFERENCES DD_CHAR_Heading (HID) ON UPDATE CASCADE ON DELETE CASCADE,
  FOREIGN KEY (CID) REFERENCES DD_CHAR (CID) ON UPDATE CASCADE ON DELETE CASCADE
ALTER TABLE DD_CS ADD 
  FOREIGN KEY (CID) REFERENCES DD_CHAR (CID) ON UPDATE CASCADE ON DELETE CASCADE
ALTER TABLE DD_CS_Translation ADD 
  FOREIGN KEY (StateID) REFERENCES DD_CS (StateID) ON UPDATE CASCADE ON DELETE CASCADE
ALTER TABLE DD_MOD_Translation ADD 
  FOREIGN KEY (Modifier) REFERENCES DD_MOD (Modifier) ON UPDATE CASCADE ON DELETE CASCADE
ALTER TABLE DD_MOD_Link ADD 
  FOREIGN KEY (CID) REFERENCES DD_CHAR (CID) ON UPDATE CASCADE ON DELETE CASCADE,
  FOREIGN KEY (Modifier) REFERENCES DD_MOD (Modifier) ON UPDATE CASCADE ON DELETE CASCADE
ALTER TABLE DD_DEP ADD 
  FOREIGN KEY (InapplicableCID) REFERENCES DD_CHAR (CID) ON UPDATE CASCADE ON DELETE CASCADE,
  FOREIGN KEY (CID,CS) REFERENCES DD_CS (CID,CS) ON UPDATE CASCADE ON DELETE CASCADE
ALTER TABLE DD_DESCR ADD 
  FOREIGN KEY (CID,CS) REFERENCES DD_CS (CID,CS) ON UPDATE CASCADE ON DELETE CASCADE,
  FOREIGN KEY (IID) REFERENCES DD_ITEM (IID) ON UPDATE CASCADE ON DELETE CASCADE,
  FOREIGN KEY (Modifier) REFERENCES DD_MOD (Modifier) ON UPDATE CASCADE ON DELETE CASCADE
ALTER TABLE DD_RSC ADD 
  FOREIGN KEY (CharID) REFERENCES DD_CHAR (CharID) ON UPDATE CASCADE ON DELETE CASCADE,
  FOREIGN KEY (StateID) REFERENCES DD_CS (StateID) ON UPDATE CASCADE ON DELETE CASCADE,
  FOREIGN KEY (ItemID) REFERENCES DD_ITEM (ItemID) ON UPDATE CASCADE ON DELETE CASCADE


/*** Remove this comment line to enable creation of column description for MS SQL Server 2000 ***
exec sp_addextendedproperty N'MS_Description',N'Character ID number. Also currently defines the order of characters. This ID may change over time, please compare the separate CharID.',N'user',N'dbo',N'table',N'DD_CHAR',N'column',N'CID'
exec sp_addextendedproperty N'MS_Description',N'Short name of character.',N'user',N'dbo',N'table',N'DD_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'DD_CHAR',N'column',N'Unit'
exec sp_addextendedproperty N'MS_Description',N'Character notes.',N'user',N'dbo',N'table',N'DD_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'DD_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'DD_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'DD_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'DD_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'DD_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'DD_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'DD_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'DD_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'DD_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'DD_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'DD_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'DD_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. to output "pH 7.2".',N'user',N'dbo',N'table',N'DD_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'DD_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'DD_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'DD_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 starts if group ID changes or whenever Null.',N'user',N'dbo',N'table',N'DD_CHAR',N'column',N'CommaLink'
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'DD_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'DD_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'DD_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'DD_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'DD_CHAR',N'column',N'OmitPeriod'
exec sp_addextendedproperty N'MS_Description',N'Calculated field: Number of states other than special states U,V,- present in this character, default is 2. Calculated automatically, do not edit!',N'user',N'dbo',N'table',N'DD_CHAR',N'column',N'NumStates'
exec sp_addextendedproperty N'MS_Description',N'Immutable unique number identifying a character (candidate key). Not exported to DELTA! Semantics are similar to CID, which, however, is exported to DELTA and requires renumbering after character deletions.',N'user',N'dbo',N'table',N'DD_CHAR',N'column',N'CharID'
exec sp_addextendedproperty N'MS_Description',N'Character ID (unchanging version).',N'user',N'dbo',N'table',N'DD_CHAR_Translation',N'column',N'CharID'
exec sp_addextendedproperty N'MS_Description',N'Language of the translation.',N'user',N'dbo',N'table',N'DD_CHAR_Translation',N'column',N'Language'
exec sp_addextendedproperty N'MS_Description',N'Short label for character; in the current Language.',N'user',N'dbo',N'table',N'DD_CHAR_Translation',N'column',N'CharName'
exec sp_addextendedproperty N'MS_Description',N'Natural language descript.: Wording to be used instead of CharName; in the current Language.',N'user',N'dbo',N'table',N'DD_CHAR_Translation',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''; in the current Language.',N'user',N'dbo',N'table',N'DD_CHAR_Translation',N'column',N'CharWording2'
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'DD_CHAR_Translation',N'column',N'Unit'
exec sp_addextendedproperty N'MS_Description',N'True if unit is to be placed in front of value, e.g. to output "pH 7.2".',N'user',N'dbo',N'table',N'DD_CHAR_Translation',N'column',N'UnitIsPrefix'
exec sp_addextendedproperty N'MS_Description',N'Character Notes (for DELTA data this could be an extensive definition of the character).',N'user',N'dbo',N'table',N'DD_CHAR_Translation',N'column',N'Notes'
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'DD_CHAR_Translation',N'column',N'FormatString'
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'DD_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'DD_CHAR_Heading',N'column',N'HeadingName'
exec sp_addextendedproperty N'MS_Description',N'Optional wording; preferred over HeadingName if headings for natural language descriptions are defined through the HeadingLink mechanism .',N'user',N'dbo',N'table',N'DD_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'DD_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 query returning a set of character IDs. (HeadingName of predefined AutoGroups may be changed!).',N'user',N'dbo',N'table',N'DD_CHAR_Heading',N'column',N'AutoGroup'
exec sp_addextendedproperty N'MS_Description',N'A hierarchy of headings can be defined in DeltaAccess by adding the higher hierarchy here. However, this is not supported by DELTA and can not be exported.',N'user',N'dbo',N'table',N'DD_CHAR_Heading',N'column',N'ParentHeadingID'
exec sp_addextendedproperty N'MS_Description',N'Immutable unique number identifying a heading (candidate key).',N'user',N'dbo',N'table',N'DD_CHAR_Heading',N'column',N'HeadingID'
exec sp_addextendedproperty N'MS_Description',N'Character heading ID.',N'user',N'dbo',N'table',N'DD_CHAR_Heading_Translation',N'column',N'HeadingID'
exec sp_addextendedproperty N'MS_Description',N'Language of the translation.',N'user',N'dbo',N'table',N'DD_CHAR_Heading_Translation',N'column',N'Language'
exec sp_addextendedproperty N'MS_Description',N'Heading name, used for CharHeadings and Named character groups (identification).',N'user',N'dbo',N'table',N'DD_CHAR_Heading_Translation',N'column',N'HeadingName'
exec sp_addextendedproperty N'MS_Description',N'Optional wording; preferred over HeadingName if headings for natural language descriptions are defined through the HeadingLink mechanism .',N'user',N'dbo',N'table',N'DD_CHAR_Heading_Translation',N'column',N'HeadingWording'
exec sp_addextendedproperty N'MS_Description',N'Notes on translation.',N'user',N'dbo',N'table',N'DD_CHAR_Heading_Translation',N'column',N'Notes'
exec sp_addextendedproperty N'MS_Description',N'Character heading ID to be linked.',N'user',N'dbo',N'table',N'DD_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'DD_CHAR_Heading_Link',N'column',N'CID'
exec sp_addextendedproperty N'MS_Description',N'Character ID.',N'user',N'dbo',N'table',N'DD_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'DD_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'DD_CS',N'column',N'CharStateName'
exec sp_addextendedproperty N'MS_Description',N'Character state notes.',N'user',N'dbo',N'table',N'DD_CS',N'column',N'Notes'
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'DD_CS',N'column',N'StateWording'
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'DD_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'DD_CS',N'column',N'Implicit'
exec sp_addextendedproperty N'MS_Description',N'(Not yet implemented!) Use this state during entering or updating of item descriptions.',N'user',N'dbo',N'table',N'DD_CS',N'column',N'UseEdit'
exec sp_addextendedproperty N'MS_Description',N'(Not yet implemented!) Use this state during interactive identification.',N'user',N'dbo',N'table',N'DD_CS',N'column',N'UseIdentify'
exec sp_addextendedproperty N'MS_Description',N'(Not yet implemented!) Use this state for natural language item descriptions.',N'user',N'dbo',N'table',N'DD_CS',N'column',N'UseDescr'
exec sp_addextendedproperty N'MS_Description',N'(Not yet implemented!) Use this state for phylogenetic analysis.',N'user',N'dbo',N'table',N'DD_CS',N'column',N'UsePhylo'
exec sp_addextendedproperty N'MS_Description',N'(Not yet implemented!) Use this to define a character state set for user-defined purposes.',N'user',N'dbo',N'table',N'DD_CS',N'column',N'UseOther'
exec sp_addextendedproperty N'MS_Description',N'Numeric characters only: The lowest value of X in item description to be mapped to this state (inclusive).',N'user',N'dbo',N'table',N'DD_CS',N'column',N'MinValue'
exec sp_addextendedproperty N'MS_Description',N'Numeric characters only: The highest value of X in item description to be mapped to this state (inclusive).',N'user',N'dbo',N'table',N'DD_CS',N'column',N'MaxValue'
exec sp_addextendedproperty N'MS_Description',N'Immutable unique number identifying a character state independently of the character. Not exported to DELTA! Preferred key for any external references to states not protected by cascaded referential updates. (Candidate key).',N'user',N'dbo',N'table',N'DD_CS',N'column',N'StateID'
exec sp_addextendedproperty N'MS_Description',N'State ID (foreign key).',N'user',N'dbo',N'table',N'DD_CS_Translation',N'column',N'StateID'
exec sp_addextendedproperty N'MS_Description',N'Language of the translation.',N'user',N'dbo',N'table',N'DD_CS_Translation',N'column',N'Language'
exec sp_addextendedproperty N'MS_Description',N'Name or description of character state.',N'user',N'dbo',N'table',N'DD_CS_Translation',N'column',N'CharStateName'
exec sp_addextendedproperty N'MS_Description',N'Notes on translation.',N'user',N'dbo',N'table',N'DD_CS_Translation',N'column',N'Notes'
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'DD_CS_Translation',N'column',N'StateWording'
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'DD_CS_Translation',N'column',N'StateFormatString'
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'DD_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'DD_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'DD_MOD',N'column',N'Reliability'
exec sp_addextendedproperty N'MS_Description',N'If set to true, the state to which this modifier is added is marked as being present only by misinterpretation of structure (phyllocladium as leaf) or state (rough spore surface as smooth).',N'user',N'dbo',N'table',N'DD_MOD',N'column',N'MisinterpretationMarker'
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'DD_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'DD_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'DD_MOD',N'column',N'Operator'
exec sp_addextendedproperty N'MS_Description',N'Internal notes.',N'user',N'dbo',N'table',N'DD_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'DD_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'DD_MOD',N'column',N'UpperFreq'
exec sp_addextendedproperty N'MS_Description',N'Modifier wording. Foreign key linking to _MOD. In current language!',N'user',N'dbo',N'table',N'DD_MOD_Translation',N'column',N'Modifier'
exec sp_addextendedproperty N'MS_Description',N'Language of the translation.',N'user',N'dbo',N'table',N'DD_MOD_Translation',N'column',N'Language'
exec sp_addextendedproperty N'MS_Description',N'Translation of modifier wording.',N'user',N'dbo',N'table',N'DD_MOD_Translation',N'column',N'ModifierTranslation'
exec sp_addextendedproperty N'MS_Description',N'Character ID to which the modifier is applicable.',N'user',N'dbo',N'table',N'DD_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'DD_MOD_Link',N'column',N'Modifier'
exec sp_addextendedproperty N'MS_Description',N'Controlling character ID.',N'user',N'dbo',N'table',N'DD_DEP',N'column',N'CID'
exec sp_addextendedproperty N'MS_Description',N'Controlling character state.',N'user',N'dbo',N'table',N'DD_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'DD_DEP',N'column',N'InapplicableCID'
exec sp_addextendedproperty N'MS_Description',N'Item ID.',N'user',N'dbo',N'table',N'DD_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'DD_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'DD_ITEM',N'column',N'ItemWording'
exec sp_addextendedproperty N'MS_Description',N'Item notes.',N'user',N'dbo',N'table',N'DD_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'DD_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'DD_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'DD_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'DD_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'DD_ITEM',N'column',N'LitRefDetail'
exec sp_addextendedproperty N'MS_Description',N'Immutable unique number identifying an item (candidate key). Not exported to DELTA! Semantics are similar to IID, which, however, is exported to DELTA and requires renumbering after deletions.',N'user',N'dbo',N'table',N'DD_ITEM',N'column',N'ItemID'
exec sp_addextendedproperty N'MS_Description',N'Item ID.',N'user',N'dbo',N'table',N'DD_DESCR',N'column',N'IID'
exec sp_addextendedproperty N'MS_Description',N'Character ID.',N'user',N'dbo',N'table',N'DD_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'DD_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'DD_DESCR',N'column',N'CS'
exec sp_addextendedproperty N'MS_Description',N'Numeric value, defined by CS.',N'user',N'dbo',N'table',N'DD_DESCR',N'column',N'X'
exec sp_addextendedproperty N'MS_Description',N'Text data.',N'user',N'dbo',N'table',N'DD_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'DD_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'DD_DESCR',N'column',N'SEQ'
exec sp_addextendedproperty N'MS_Description',N'ID of associated item (optional). This refers to ItemID, not IID!',N'user',N'dbo',N'table',N'DD_RSC',N'column',N'ItemID'
exec sp_addextendedproperty N'MS_Description',N'ID of associated character (optional). This refers to CharID, not CID!',N'user',N'dbo',N'table',N'DD_RSC',N'column',N'CharID'
exec sp_addextendedproperty N'MS_Description',N'ID of associated character state (optional). This refers to StateID, not CS!',N'user',N'dbo',N'table',N'DD_RSC',N'column',N'StateID'
exec sp_addextendedproperty N'MS_Description',N'Filename of illustration (photo/drawing/graph) or other media resources (see ResourceDefaultPath/DefaultURL in table _PROPERTY for setting global paths).',N'user',N'dbo',N'table',N'DD_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'DD_RSC',N'column',N'Caption'
exec sp_addextendedproperty N'MS_Description',N'Roles the resource is intended for: I = Icon, S = Selector (displayed directly, e. g. to select a state), D = Definition (usually displayed only as thumbnail image or link for further information).',N'user',N'dbo',N'table',N'DD_RSC',N'column',N'Role'
exec sp_addextendedproperty N'MS_Description',N'Usage of resource in the context of items (including natural language descriptions). Usage is especially relevant if both Item and CharIDs are defined, but resource is relevant for entire item (e.g. habit).',N'user',N'dbo',N'table',N'DD_RSC',N'column',N'ItemUsage'
exec sp_addextendedproperty N'MS_Description',N'Usage of resource in the context of items (especially character definition in print or web form). Usage is especially relevant if also Item or StateIDs are defined, but resource is relevant for entire character as well.',N'user',N'dbo',N'table',N'DD_RSC',N'column',N'CharUsage'
exec sp_addextendedproperty N'MS_Description',N'Internal notes (perhaps also formatting commands for INTKEY).',N'user',N'dbo',N'table',N'DD_RSC',N'column',N'Notes'
exec sp_addextendedproperty N'MS_Description',N'A positive number that can be used to define the sequence in which multiple resources are displayed.',N'user',N'dbo',N'table',N'DD_RSC',N'column',N'DisplayOrder'
exec sp_addextendedproperty N'MS_Description',N'Media resource ID (any of item, char, state IDs may be missing).',N'user',N'dbo',N'table',N'DD_RSC',N'column',N'ResourceID'
exec sp_addextendedproperty N'MS_Description',N'Language of a property translation, e.g. for project title.',N'user',N'dbo',N'table',N'DD_PROPERTY',N'column',N'Language'
exec sp_addextendedproperty N'MS_Description',N'ID (restricted to a single record, ID must always be 1!).',N'user',N'dbo',N'table',N'DD_CurrentLanguage',N'column',N'ID'
exec sp_addextendedproperty N'MS_Description',N'2 character ISO language code.',N'user',N'dbo',N'table',N'DD_CurrentLanguage',N'column',N'Language'
exec sp_addextendedproperty N'MS_Description',N'The name of the project property (do not change!).',N'user',N'dbo',N'table',N'DD_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'DD_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'DD_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'DD_PROPERTY',N'column',N'NumericValue'
exec sp_addextendedproperty N'MS_Description',N'Language of a property translation, e.g. for project title.',N'user',N'dbo',N'table',N'DD_PROPERTY',N'column',N'Language'
exec sp_addextendedproperty N'MS_Description',N'ID (restricted to a single record, ID must always be 1!).',N'user',N'dbo',N'table',N'DD_CurrentLanguage',N'column',N'ID'
exec sp_addextendedproperty N'MS_Description',N'2 character ISO language code.',N'user',N'dbo',N'table',N'DD_CurrentLanguage',N'column',N'Language'
GO
*** Remove this comment line to enable creation of column description for MS SQL Server 2000 ***/