Documentation created on 16. Feb. 2001 15:28; last update: 2005-03-30.
This document contains a complete list of all entities and attributes used in the information model of this application module. It is primarily intended as a technical reference. It can also be helpful, however, in understanding the scope and usage of certain attributes. When you have a question like 'where does this information fit in', reading the attribute description of related attributes may help you.
Besides the human readable documentation provided below, three more technical documents are provided:
Index of entities: DELTA_CS, DELTA_ITEM, DescriptorProject, DescriptorProject_ParameterSet, DELTA_CHAR, DELTA_CHAR_Heading, DELTA_CHAR_Heading_Link, DELTA_DEP, DELTA_DESCR, DELTA_Glossary, DELTA_MOD, DELTA_MOD_Link, DELTA_PROPERTY, DELTA_ReportElement, DELTA_RSC.
Descriptor project: Character states for each character.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| SID | Autonumber | State ID. | - | I (U) |
| CID | Integer | Character ID. | R | I (UM) |
| CS | Text (16) | Character state code. Usually pos. integer number or special codes for variable/unknown and for statistics (mean etc.). | R | I |
| CharStateName | Text (255) | Name or description of character state. | R | I |
| StateWording | Text (255) | Wording to be used instead of CharStateName for natural language descriptions output. | - | - |
| Notes | Memo | Internal character state notes. | - | - |
| StateFormatString | Text (255) | State specific formatting, overriding FormatString defined in the character definition. Standard Basic formatting string like "#.0". | - | - |
| Implicit | Boolean | Mark this state as a default which is automatically set. Default value: 0 |
R | - |
| UseEdit | Boolean | Use this state during entering or updating of item descriptions. Default value: -1 |
- | - |
| UseIdentify | Boolean | Use this state during interactive identification. Default value: 0 |
- | - |
| UseDescr | Boolean | Use this state for natural language item descriptions. Default value: 0 |
- | - |
| UsePhylo | Boolean | Use this state for phylogenetic analysis. Default value: 0 |
- | - |
| UseOther | Boolean | Use this to define a character state set for user-defined purposes. Default value: 0 |
- | - |
| MinValue | Double | Numeric characters only: The lowest value of X in an item description to be mapped to this state (inclusive). Default value: -1E+308 |
R | - |
| MaxValue | Double | Numeric characters only: The highest value of X in an item description to be mapped to this state (inclusive). Default value: 1E+308 |
R | - |
| StateWording1 | Text (255) | 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 | Text (255) | 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 | Text (255) | 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 | Boolean | 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. | - | - |
| Index name: | Attributes & index properties | |||
| CharStateName: | CharStateName (Duplicates OK) | |||
| CID: | CID; CS (Unique values) | |||
| CS: | CS (Duplicates OK) | |||
| SID: | SID (Primary key; Unique values) | |||
Descriptor project: Item or taxon table.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| IID | Long | Item ID. Validation rule: >0 |
R | I (U) |
| ItemName | Text (255) | Name or description of item (incl. taxon authors if necessary), link to taxonomic subsystem. | R | I |
| ItemWording | Text (255) | Natural language descript.: Wording to be used instead of ItemName. | - | - |
| Notes | Memo | Item notes. | - | - |
| Abundance | Single | Abundance, relative importance (or weight) of item, 1-10, default is 5. Default value: 5 |
R | I |
| CollUnit | Text (255) | Unit code in specimen collection, link into collection subsystem. NOT DEFINED IN DELTA! | - | I (N) |
| LitRef | Text (255) | Literature reference (user-readable text form). NOT DEFINED IN DELTA! | - | I (N) |
| LitKey | Long | Literature reference (numeric link into literature reference subsystem). NOT DEFINED IN DELTA! | - | I (N) |
| LitRefDetail | Text (255) | Reference detail, like page(s) of interest, specific figures, etc. | - | - |
| Index name: | Attributes & index properties | |||
| Abundance: | Abundance (Duplicates OK) | |||
| CollUnit: | CollUnit (Duplicates OK; Ignore Nulls) | |||
| IID: | IID (Primary key; Unique values) | |||
| ItemName: | ItemName (Duplicates OK) | |||
| LitKey: | LitKey (Duplicates OK; Ignore Nulls) | |||
| LitRef: | LitRef (Duplicates OK; Ignore Nulls) | |||
Overview over all descriptor projects available in the current application.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| PID | Autonumber | Descriptor project ID. | - | I (U) |
| ProjectName | Text (20) | The name of the project used by the application, also the prefix of all project tables. | - | I (U) |
| ParentPID | Long | Only for linked subprojects: The project containing the main tables. | - | I |
| ProjectTitle | Text (50) | A short title for the project (up to 50 characters). | R | I (U) |
| ProjectTitleURL | Text (255) | A URL that may optionally be placed behind the Title to hyperlink to another site on the world-wide-web. | - | - |
| ProjectTitleAligment | Byte | Default horizontal alignment of title text: 0 = left; 1 = centered; 2 = right; 3 = justified (block). Default value: 0 |
- | - |
| ProjectDescription | Text (255) | A short descriptive text, explaining the scope of the descriptor project (used in reports). | - | - |
| ProjectVersion | Text (255) | A version number or code for the descriptor definition and item data of the project. | - | - |
| ProjectAuthors | Text (255) | A string containing one or several authors responsible for the data in the descriptor project. | - | - |
| ProjectEditors | Text (255) | A string containing one or several editors responsible for the data in the descriptor project. | - | - |
| ProjectCopyright | Text (255) | A string containing a copyright statement, including the year (do include the copyright symbol, (c) or ©, if you want to use it). | - | - |
| ProjectHistory | Memo | History of the project, including data source information, copyright agreements, acknowledgements, occasional collaborators, and disclaimers. | - | - |
| ProjectHistoryNotes | Memo | Internal notes and additions to the history. In contrast to ProjectHistory this information is not used in reports. | - | - |
| ProjectImportNotes | Memo | Messages issued during the import of the project (import source, import warnings, import skipped information). | - | - |
| ProjectNotes | Memo | Internal notes regarding the entire project. | - | - |
| ProjectLogo | Text (255) | A logo or icon, usually a small gif file that can be displayed side-by-side with the project title. | - | - |
| ProjectLogoURL | Text (255) | A URL that may optionally be placed behind the Logo to hyperlink to another site on the world-wide-web. | - | - |
| ProjectLogoAligment | Byte | 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. Default value: 0 |
- | - |
| ProjectStylesheetURL | Text (255) | URL of a CSS (cascading style sheet) file to create a consistent format for html reports. | - | - |
| ProjectDisclamer | Text (255) | Text placed at the bottom of reports, containing a disclaimer or other information. | - | - |
| ProjectDisclamerURL | Text (255) | A URL that may optionally be placed behind the Disclaimer to hyperlink to another site on the world-wide-web. | - | - |
| ProjectDisclamerAligment | Byte | Default horizontal alignment of disclaimer text: 0 = left; 1 = centered; 2 = right; 3 = justified (block). Default value: 0 |
- | - |
| ProjectLastBackup | Text (255) | Date and file name of last backup to an mdb backup file. | - | - |
| ProjectLastRestore | Text (255) | Date and file name of last restore from an mdb backup file. | - | - |
| ProjectLastExport | Text (255) | Date and file name of last export, e. g., to a DELTA file. | - | - |
| ProjectLastSchemaUpdate | Date/Time | 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 | Date/Time | 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 | Text (10) | 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 | Text (255) | Formatting encoding of data in the project (0=Plain/BasicHTML, 1= Full HTML), list of coding for item, heading, char. etc. | - | - |
| Index name: | Attributes & index properties | |||
| ParentPID: | ParentPID (Duplicates OK) | |||
| PID: | PID (Primary key; Unique values) | |||
| ProjectName: | ProjectName (Unique values) | |||
| ProjectTitle: | ProjectTitle (Unique values) | |||
| Relation type: | Fields involved | |||
| Deletions cascade | DescriptorProject.PID « DescriptorProject_ParameterSet.PID | |||
Parameter set (Character definition, Natural language, HTML form reports, etc.) for descriptor projects.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| PID | Long | Descriptor project ID. | R | I/I/I (UM) |
| ObjectName | Text (40) | The reporting or other object to which the parameter set applies, e.g. the Character definition report. | R | I |
| SetName | Text (50) | A user defined name distinguishing multiple parameter sets for the same object. Default value: "Default" |
R | I |
| LastUpdate | Date/Time | The date at which the parameter set was last edited. | - | - |
| Notes | Memo | Internal notes regarding the parameter set. | - | - |
| Parameters | Memo | The coded parameter set (machine readable). | - | - |
| OverrideHeaderFile | Memo | Precalculated. | - | - |
| OverrideFooterFile | Memo | - | - | |
| CalculatedHeaderText | Memo | - | - | |
| CalculatedFooterText | Memo | - | - | |
| InsertHeaderFile | Memo | Precalculated. | - | - |
| InsertFooterFile | Memo | - | - | |
| UseHeaderOverride | Text (255) | - | - | |
| Index name: | Attributes & index properties | |||
| DescriptorProject_ParameterSetPID: | PID (Duplicates OK) | |||
| DescriptorProjectDescriptorProject_ParameterSet: | PID (Duplicates OK) | |||
| Name: | SetName (Duplicates OK) | |||
| Object: | ObjectName (Duplicates OK) | |||
| PID: | PID; ObjectName; SetName (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Deletions cascade | DescriptorProject.PID « DescriptorProject_ParameterSet.PID | |||
Descriptor project: Character table.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| CID | Integer | Character ID number. Validation rule: >0 |
R | I (U) |
| CharName | Text (255) | Short name of character. | R | I (U) |
| Unit | Text (255) | For numeric characters: an optional measurement unit like 'mm'. Only true units here, text like 'wide' belongs to CharWording2! | - | - |
| Notes | Memo | Character notes. | - | - |
| Type | Text (2) | Type of character: Text, Ordered/unordered multistate, Integer/Real numeric. Default value: "UM"; Validation rule: "UM" Or "OM" Or "IN" Or "RN" Or "TE" |
R | I |
| Mandatory | Boolean | Is the scoring of this character mandatory (required) in each item? Default value: 0 |
R | - |
| MultiStateType | Byte | Are multiple states allowed and how are they interpreted? Default value: 1; Validation rule: >-1 And <5 |
R | I |
| Reliability | Single | Reliability (or weight) of character for identification, 1-10, default is 5. Default value: 5; Validation rule: (>=0 And <=32) Or Is Null |
R | - |
| Availability | Single | Availability (or accessibility) of character for identification, 1-10, default is 5. This is an extension to the Delta standard. Default value: 5; Validation rule: (>=0 And <=32) Or Is Null |
R | - |
| Fuzziness | Single | For identification: Unless a range is explicitly present, used to form a range around the mean (RN/IN) or state (OM). Default value: 0; Validation rule: >=0 |
R | - |
| FuzzinessIsPercent | Boolean | Interpret 'Fuzziness' as 'percent' rather than 'absolute value' (e.g. Fuzziness=10 ® range=mean ± 10%, instead of ± 10 absolute). Default value: 0 |
R | - |
| KeyStates | Text (255) | For use in a key: combine multistate char, into new combinations or define ranges for numeric char. | - | I |
| CharHeading | Integer | A heading defined in the headings definition, inserted in char. def. output in front of the current character. | - | I (N) |
| HeadingLink | Integer | A heading defined in the headings definition, inserted in natural language descriptions in front of descriptions using this character. | - | I (N) |
| CharWording | Text (255) | Natural language descript.: Wording to be used instead of CharName. | - | - |
| CharWording2 | Text (255) | Natural language descript.: Wording to be used AFTER states or values + unit, e.g. 'wide' for 'leaves 3-5 mm wide'. | - | - |
| UnitIsPrefix | Boolean | True if unit is to be placed in front of value, e.g. "pH 7.2". | - | - |
| FormatString | Text (255) | Default formatting for all states (compare StateFormatString). Esp. for numeric values (number of decimal places etc.). Standard Basic formatting string like "#.0". | - | - |
| ParagraphLink | Long | Nat.language descript.: Define char. linked into a single paragraph. A new paragraph starts if group ID changes. Default value: 1; Validation rule: >0 Or Is Null |
- | - |
| SentenceLink | Long | Nat.language descript.: Define char. linked into a single sentence. A new sentence starts if group ID changes or whenever 'Null'. Validation rule: >0 Or Is Null |
- | - |
| CommaLink | Long | Nat.language descript.: Define characters linked into a comma-enumeration ('sub-sentence'). A new group starts if group ID changes or whenever 'Null'. Validation rule: >0 Or Is Null |
- | - |
| SpecialLink | Long | Nat.language descript.: Define characters that are linked by special means (as defined in SpecialElement). Validation rule: >0 Or Is Null |
- | - |
| SpecialElement | Long | 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]. Validation rule: >9 Or Is Null |
- | - |
| UseComma2 | Boolean | Nat.language descript.: Use alternative comma separator between states of this character (e.g. for Chinese). | - | - |
| OmitFinalComma | Boolean | Nat.language descript.: The final comma between character states is omitted ('1,2 and 3' instead of '1,2, and 3'). Default value: 0 |
R | - |
| OmitValues | Text (1) | Natural language descript.: Omit lower ('-') or upper ('+') part of numeric character ranges. Validation rule: Is Null Or '+' Or '-' |
- | - |
| Emphasize | Boolean | Nat.language descript.: Emphasize (italic or bold print) this character in all items. Default value: 0 |
- | - |
| OmitPeriod | Boolean | Nat.language descript.: Omit the end delimiter (usually the period for a sentence, DELTA: 'OMIT PERIOD FOR CHAR'). Default value: 0 |
- | - |
| NumStates | Integer | Number of states for this character, default is 2. Calculated automatically, do not edit! Default value: 2 |
R | I |
| Index name: | Attributes & index properties | |||
| CharHeading: | CharHeading (Duplicates OK; Ignore Nulls) | |||
| CharName: | CharName (Unique values) | |||
| CID: | CID (Primary key; Unique values) | |||
| HeadingLink: | HeadingLink (Duplicates OK; Ignore Nulls) | |||
| KeyStates: | KeyStates (Duplicates OK) | |||
| MultiStateType: | MultiStateType (Duplicates OK) | |||
| NumStates: | NumStates (Duplicates OK) | |||
| Type: | Type (Duplicates OK) | |||
Descriptor project: Character heading/Identification/HeadingLink table.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| HID | Integer | Character heading ID; determines sequence of headings when used in identification; change number to change that sequence! Validation rule: >0, validation message: You must use integer numbers greater than zero. |
R | I (U) |
| HeadingName | Text (255) | Heading name, used for CharHeadings and Named character groups (identification). | R | I (U) |
| HeadingWording | Text (255) | Optional wording; preferred over HeadingName as HeadingLink in natural language output. | - | - |
| Notes | Memo | Internal notes (not exported to Delta format). | - | - |
| AutoGroup | Text (255) | 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!). | - | - |
| Index name: | Attributes & index properties | |||
| HeadingName: | HeadingName (Unique values) | |||
| HID: | HID (Primary key; Unique values) | |||
Descriptor project: Character groups for Identification, Linking.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| HID | Integer | Character heading ID to be linked. Validation rule: >0, validation message: You must use integer numbers greater than zero. |
R | I (UM) |
| CID | Integer | Character ID to which the identification heading is applicable. | R | I |
| Index name: | Attributes & index properties | |||
| CID: | CID (Duplicates OK) | |||
| HID: | HID; CID (Primary key; Unique values) | |||
Descriptor project: Dependent (= inapplicable) characters for each character state.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| CID | Integer | Controlling character ID. | R | I (UM) |
| CS | Text (16) | Controlling character state. | R | - |
| InapplicableCID | Integer | CID of dependent character, i.e. inapplicable for any item where current CID/CS combination is used. | R | I |
| Index name: | Attributes & index properties | |||
| CID: | CID; CS; InapplicableCID (Primary key; Unique values) | |||
| InapplicableCID: | InapplicableCID (Duplicates OK) | |||
Descriptor project: Data/descriptions for each item.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| IID | Long | Item ID. | R | I |
| CID | Integer | Character ID. | R | I (UM) |
| Modifier | Text (255) | Modifier wording for categorical or numerical data, e.g. "mostly", "usually", "rarely". | - | - |
| CS | Text (16) | Character state code. Usually pos. integer number or special codes for variable/unknown and for statistics (mean etc.). | R | I |
| X | Double | Numeric value, defined by CS. | - | I (N) |
| TXT | Memo | Text data. | - | - |
| Notes | Memo | Notes and additional information, included in natural language item descriptions. | - | - |
| SEQ | Long | Sequence of character states for the item. | - | I |
| Index name: | Attributes & index properties | |||
| CID: | CID; CS; IID (Primary key; Unique values) | |||
| CS: | CS (Duplicates OK) | |||
| IID: | IID (Duplicates OK) | |||
| SEQ: | SEQ (Duplicates OK) | |||
| X: | X (Duplicates OK; Ignore Nulls) | |||
| Table validation rule: | (Not IsNull([TXT]) And IsNull([X]) And [CS]='TE') Or (IsNull([TXT]) And (IsNull([X]) Or Not IsNull([X]) And Not IsNumeric([CS]))) | |||
| Table validation text: | You may not enter data in both TXT and X, use only one of them! To enter TXT data, use CS='TE', to enter numeric data use the appropriate CS attributes. | |||
Preliminary, for testing purposes only.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| GID | Autonumber | Glossary ID. | - | I (U) |
| Entry | Text (255) | Glossary entry (basic xhtml formatting allowed). | R | I (U) |
| Definition | Memo | Glossary entry definition (basic xhtml formatting allowed). | R | - |
| Notes | Memo | Internal notes. | - | - |
| Keywords | Text (255) | Additional keywords (semicolon separated list). | - | - |
| Index name: | Attributes & index properties | |||
| Entry: | Entry (Unique values) | |||
| GID: | GID (Primary key; Unique values) | |||
Descriptor project: Modifer wordings for categorical or numerical data.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| Usage | Text (255) | Type of characters for which the modifier is applicable, e.g. GENERAL. COLORS, FREQuency of occurrence. | R | I |
| Modifier | Text (255) | Modifier wording for categorical or numerical data, e.g. "mostly", "usually", "rarely". | R | I (U) |
| Reliability | Byte | Influence of modifier on data coded through categorical/numerical char. states. More (>5) or less reliable (<5); 5 is default. Default value: 5; Validation rule: (>=0 And <=32) Or Is Null |
R | - |
| Postfix | Boolean | Checked = output after the character state wording, unchecked = in front of it. | R | - |
| UseBlank | Boolean | Checked = blank is added between the modifier wording and the item data text, else modifier added compress. Default value: -1 |
R | - |
| Operator | Byte | >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. Default value: 0; Validation rule: (>-1 And <4) Or 5 |
R | - |
| Notes | Text (255) | Internal notes. | - | - |
| LowerFreq | Single | The lower border of the frequency range, for freq. modifiers only. Validation rule: (>=0 And <=1) Or Is Null |
- | - |
| UpperFreq | Single | The upper border of the frequency range, for freq. modifiers only. Validation rule: (>=0 And <=1) Or Is Null |
- | - |
| Index name: | Attributes & index properties | |||
| Modifier: | Modifier (Primary key; Unique values) | |||
| Usage: | Usage (Duplicates OK) | |||
Descriptor project: Links between characters and modifiers.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| CID | Integer | Character ID to which the modifier is applicable. | R | I |
| Modifier | Text (255) | Modifier wording for categorical or numerical data, e.g. "mostly", "usually", "rarely". | R | I (UM) |
| Index name: | Attributes & index properties | |||
| CID: | CID (Duplicates OK) | |||
| Modifier: | Modifier; CID (Primary key; Unique values) | |||
Descriptor project: General header information about the project.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| PropertyName | Text (255) | The name of the project property (do not change!). | - | I (U) |
| TextValue | Memo | Text information. Use Shift F2 to zoom into larger window! | - | - |
| DateTimeValue | Date/Time | Date or time information, e.g. of last update. | - | - |
| NumericValue | Double | Numerical information, stored as real number. | - | I (N) |
| Index name: | Attributes & index properties | |||
| NumericValue: | NumericValue (Duplicates OK; Ignore Nulls) | |||
| PropertyName: | PropertyName (Primary key; Unique values) | |||
Descriptor project: ReportElements for natural language description formulas, tables, etc.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| ReportElement | Long | ID of report element (1-10 are reserved!). | - | I (UM) |
| Language | Text (2) | Language to which the ReportElement is applicable. | R | - |
| Description | Text (255) | Text that describes the use of the report element (shown in user interface). | - | - |
| ParagraphBefore | Boolean | Start a new paragraph before the ReportElement. | - | - |
| TextBefore | Text (255) | Text inserted before the ReportElement (unformatted text). | - | - |
| TextBetween | Text (255) | Enumeration separator between multiple subelements (e.g. characters); used only if ComplexWording is empty! | - | - |
| TextAfter | Text (255) | Text inserted after the ReportElement (unformatted text). | - | - |
| ParagraphAfter | Boolean | Start a new paragraph after the ReportElement. | - | - |
| ComplexWording | Text (255) | Wording for multiple characters, char. are inserted at |1, |2, etc.; |U = Unit, |C new table column, |R new table row. | - | - |
| ComplexWordingFormat | Byte | 0 = RTF; 1 = HTML; 2= unformatted, will be reformatted with character format. Default value: 2 |
- | - |
| UseWordingIfIncomplete | Boolean | Yes: char. missing in an item are replaced by ''; No: AlternativeElement is tried, if none fitting found: EnumSeparator is used. | - | - |
| AlternativeElement | Long | Another ReportElement that is used if not all elements in ComplexWording are present, see 'UseWordingIfIncomplete'. | - | - |
| CapitalizeStart | Boolean | Capitalize first letter at start of this group. Default value: 0 |
- | - |
| CapitalizeWithin | Boolean | Capitalize first letter of each element (each char. in enumeration or table cell). Default value: 0 |
- | - |
| WordgTruncation | Byte | Wording truncation (e.g. char. wording). 0=disable, 1=enable, restart, 2=enable, continue. Default value: 0; Validation rule: >-1 And <3 |
R | - |
| RepElementNotes | Memo | Internal development notes. | - | - |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | ReportElement; Language (Primary key; Unique values) | |||
Descriptor project: External resources stored as files or URL, e.g. illustrations for characters/items.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| IID | Long | ID of associated item (optional). | - | I (N) |
| CID | Integer | ID of associated character (optional). | - | I (N) |
| CS | Text (16) | ID of associated character state (set to U or TE for text characters if resource belongs to char. in general). Default value: "U" |
- | I (N) |
| Resource | Text (255) | Filename of illustration (photo/drawing/graph) or other media resources. See _HEADING properties MediaDefaultPath/MediaDefaultURL to set global paths. | - | I |
| Caption | Memo | Caption for the resource, e.g. a text to display while showing an illustration or a video. | - | - |
| Notes | Memo | Internal notes (perhaps also formatting commands for INTKEY). | - | - |
| ItemDefault | Boolean | This image is a default image for the whole item, regardless of character association. Default value: 0 |
R | - |
| CharDefault | Boolean | This image is a default image for the whole character, regardless of character state association. Default value: 0 |
R | - |
| RID | Autonumber | Media resource ID (necessary, because either IID or CID may be missing). | - | I (U) |
| ItemDescription | Boolean | Include the resource, esp. images in the natural language description of items. Default value: 0 |
- | - |
| CharDefinition | Boolean | Include the resource, esp. images in character definition report. Default value: 0 |
- | - |
| Index name: | Attributes & index properties | |||
| CID: | CID (Duplicates OK; Ignore Nulls) | |||
| CS: | CS (Duplicates OK; Ignore Nulls) | |||
| IID: | IID (Duplicates OK; Ignore Nulls) | |||
| Resource: | Resource (Duplicates OK) | |||
| RID: | RID (Primary key; Unique values) | |||
Footnotes: The following abbreviations have been used in the tables: R: It is required to enter data in this field. I: The field is indexed to enable faster searching. Different types of indices are denoted by additional letters in parentheses: U = unique index, N = Null values are ignored in the index, M = the index contains more than one attribute. In the first column the names of attributes that are part of the primary key are underlined.
Data types: 'Text (255)' indicates a text of varying length for which no specific design restrictions have been formulated. 255 characters should be read as a proposed technical maximum limit, that can be changed if required by the database management system. In contrast, 'Memo' is explicitly defined as text of unlimited length.
We are interested in your opinion. If you see any problems with the model that you would like to bring to our attention, please contact us by sending an email to g.hagedorn@bba.de!
Documentation created on 16. Feb. 2001 15:28; last update: 2005-03-30.