Documentation created on 24. Sep. 2003; last update: 2005-03-30, email address revised 2010-08-05.
By G. Hagedorn, 2003
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 may help you.
Besides the human readable documentation provided below, three additional technical documents are provided:
See also the separate alphabetical index to attribute names.
Literature reference subsystem: Reference type definitions. Which reference attributes are enabled and how they should be labeled? Currently only the usage of a type is defined here; the attribute labels are defined directly in the vba code.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefType | Text | The ReferenceTitle type, as used by Reference Manager (tm) 9.0 in their default databases. Additional ref. types may be added if they occur in the import. | R | I (P) |
| Description | Text | A description, explaining the scope and use of the reference type to the user. | - | - |
| LabelSet | Integer | This number is used to retrieve the correct customization set in the forms. Do not change the numbering without updating the methods in the code! | R | - |
| ShowInPicklist | Boolean | Only reference types selected here are available in a pick list; other types may be entered if the user knows their type code. | R | - |
| Notes | Text | Internal notes regarding the use of a ReferenceTitle type. | - | - |
| Index name: | Attributes & index properties | |||
| RefType: | RefType (Primary key; Unique values) | |||
| Relation type: | Attributes involved | |||
| Updates cascade | ReferenceType.RefType « ReferenceTitle.RefType | |||
Literature reference subsystem: Main entity; compatible with Reference Manager™ v.9.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefType | Text | Type of literature reference, determines which fields are available for data entry. The value must come from the pick list provided. [RefMan 01: TY] Default value: "JOUR" |
R | I |
| RefID | Text | Unique reference ID code for the reference record. The only characters allowed are '0'-'9' and 'A'-'Z' [RefMan 02: ID] validation message: Please enter between 3 and 20 uppercase letters or digits. Punctuation, blank, or other characters are not allowed! |
R | I (P) |
| RefDescription | Text | * A short text identifying the reference, usually authors, year, title. Example: 'Smith, J. & Nao, S. (1999). New Taxa.' System generated, but users may update it. [RefMan: not applicable] |
- | I |
| Title | Memo | The main (primary) title. Use normal capitalization, omit a period ('.') at the end, and do not type a paragraph return (Enter) at the end of each line! [RefMan 03: TI, T1, CT, BT only for BOOK & UNPB] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| DateYear | Integer | Year of the publication date (primary date). Only numbers are allowed and the year must be entered with 4 digits ('1998', not '98'). [RefMan 05: Y1,PY pro parte] Validation rule: (Year(Now())+1) Or Is Null, validation message: The publication year must have 4 digits, and it may not be a date in future. |
- | I |
| DateMonth | Byte+ | Optional: The month of the publication date. [Note: in DateYear/Month/Day the information printed on the book or journal are entered, even if this is not the true date!] [RefMan 05: Y1,PY pro parte] Validation rule: Is Null, validation message: Only values between 1 and 12 are valid for a month! |
- | - |
| DateDay | Byte+ | Optional: The day of the publication date. [Note continued: if the true date is relevant, e.g. for the purpose of nomenclatural priority, it can be entered under DateSecondary.] [RefMan 05: Y1,PY pro parte] Validation rule: Is Null, validation message: Only values between 1 and 31 are valid for a day! |
- | - |
| DateSuppl | Text | Optional: A date supplement, like 'approx.', a season ('Summer'), a quarter ('1st Quarter'), or any other information regarding the publication date. [RefMan 05: Y1,PY pro parte] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| SourceTitle | Memo | The book (secondary) title in cases where the reference is an article or chapter from a book. Use normal capitalization. [RefMan 13: T2; BT for all types except BOOK & UNPB] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| SeriesTitle | Text | The series title. Use normal capitalization, omit a period ('.') at the end, and do not type a paragraph return (Enter) at the end of each line! [RefMan 23: T3] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | I (N) |
| Periodical | Text | Journal/periodical in which the article appeared. Linked to the Abbreviation attribute of ReferencePeriodical. [RefMan 11: JF, JO, JA] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | I |
| Volume | Text | The volume (for periodicals or journals, excluding the issue number), report number, etc. [RefMan 12: VL pro parte, comp. Edition!] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | I (N) |
| Issue | Text | The issue, if any. Useful also to enter a special designation for a supplement, for example for 'xxx 45 (Suppl.)' enter volume = 45 and issue = 'Suppl.'. Do not put '()' around the issue number. [RefMan 15: IS] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| Pages | Text | The page, table, or figure numbers for the reference, e.g. '23-41', '341 pp.', or '20, 22-24, 32' (for non-consecutive pages). [RefMan 09: SP + 10: EP] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| Publisher | Text | The name of the publisher (publishing company or institution, including universities or scientific societies). [RefMan 17: PB] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | I |
| PublPlace | Text | The location where the item being referenced was published, such as a city and state. [RefMan 16: CY, CP] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | I |
| Edition | Integer | Number of the edition of a book. Use only positive integer numbers. [RefMan 12: VL pro parte, compare Volume!] Validation rule: Is Null, validation message: The edition must be a simple number like '1', '2', etc. |
- | - |
| DateYear2 | Integer | Year of a secondary date, esp. the true publ. date where relevant for nomenclatural priority. Only numbers are allowed and the year must be entered with 4 digits ('1998', not '98'). [RefMan 28: Y2 pro parte] Validation rule: (Year(Now())+1) Or Is Null, validation message: The publication year must have 4 digits, and it may not be a date in future. |
- | I (N) |
| DateMonth2 | Byte+ | Optional: The month of a secondary date. [RefMan 28: Y2 pro parte] Validation rule: Is Null, validation message: Only values between 1 and 12 are valid for a month! |
- | - |
| DateDay2 | Byte+ | Optional: The day of a secondary date. [RefMan 28: Y2 pro parte] Validation rule: Is Null, validation message: Only values between 1 and 31 are valid for a day! |
- | - |
| DateSuppl2 | Text | Optional: A date supplement a secondary date, like 'approx.', a season ('Summer'), a quarter ('1st Quarter'), or any other information regarding the secondary date. [RefMan 28: Y2 pro parte] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| ISSN_ISBN | Text | The 'International Standard Serial Number' or 'International Standard Book Number'. Optional information; use is recommended only for publications that are otherwise difficult to order. [RefMan 26: SN] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| Miscellaneous1 | Text | Various reference type dependent information; e.g. the total number of volumes for books [RefMan 29: M1] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| Miscellaneous2 | Text | Various reference type dependent information [RefMan 30: M2] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| Miscellaneous3 | Text | Various reference type dependent information [RefMan 31: M3] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| URL | Memo | URL address (http: www...) or local file (C:\graphic.gif; \\servername\Data\x.doc) [RefMan 33: UR] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| SourceRefID | Text | * Independent publication (e.g. an edited book) in which a dependent publication was published. Refers to the ID code of a reference already entered in this system. Provided as an alternative to ref. manager's denormalized storage! | - | - |
| Language | Text | * Language of the article/book, as ISO 2 letter codes. [RefMan: not supported!] Default value: "?" |
R | - |
| DuplicateCheck | Text | * A system generated string (typically Au. 1-4/Yr./Jour./Vol./first page) that is assumed to be unique. Use 'DuplicateOverride' to override if two reference titles are falsely identified as duplicates. [RefMan: not applicable] |
- | I (U) |
| DuplicateOverride | Byte+ | * A number to manually override automatic duplicate check, enter a number 1-255 if the system claims that non-duplicate entries are duplicates. [RefMan: not applicable] Default value: 0 |
R | - |
| ReplaceWithRefID | Text | * Instead of direct deletes (currently not available for security reasons), users here select which reference should be the valid one, into which all related information (keywords, markers) is merged. References are later deleted after a review process. | - | - |
| Problem | Memo | * A problem that occurred during data editing within the application. Typically the entries here should later be deleted after help has been obtained. Do not enter scientific or bibliographic problems here; use Notes for such permanent problems! | - | - |
| ProblemUpdatedBy | Long | * Operator who entered the problem text. | - | - |
| ProblemUpdatedWhen | Date/Time | * Date and time when problem was recorded. | - | - |
| CitationText | Memo | * Full text of a citation that describes the current reference. Use if ref. is only known as a citation in the bibliography of another publication, or if imported from unstructure data source. Empty if reference is transcribed from original publication! Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| CitationFrom | Text | * Description of publication, Only known as citation from bibliography of another publication given here (as ID code or author/year description); Empty if transcribed from original publication! Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| ImportedFrom | Text | * If imported from a reference database (esp. a commercial one): The name of the database system or provider; otherwise empty. This information is important to prevent copyright violations! Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| ImportedID | Text | * If imported from a reference database (esp. a commercial one): The ID identifying the record in that database; otherwise empty. Requires ImportedFrom [RefMan: not supported!; Internal management attribute] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| PlausibilityCheckedBy | Long | * Person responsible for a first plausibility or consistency check. User and Date are automatically filled if 'Original check' performed directly. [RefMan: not applicable. Internal mgmt.attribute] |
- | - |
| PlausibilityCheckedWhen | Date/Time | * Date and time when plausibility/consistency was checked (i.e. data entry rules and spelling errors checked, no comparison with original publication) [RefMan: not applicable. Internal mgmt.attribute] |
- | - |
| OriginalComparedBy | Long | * Name of user responsible for comparison of ReferenceTitle record with original publication [RefMan: not applicable. Internal mgmt.attribute] |
- | - |
| OriginalComparedWhen | Date/Time | * Date and time when entry was compared with the original publication (important esp. when ReferenceTitle was entered from secondary ReferenceTitle list) [RefMan: not applicable. Internal mgmt.attribute] |
- | - |
| Responsible | Long | * Person responsible for entering this reference into the data collection. | R | - |
| [LogCreatedBy] | Long | * Operator who first entered (typed or imported) the data. The operator (or typist) may be different from the person responsible. [RefMan: not applicable. Internal mgmt.attribute] |
R | - |
| [LogCreatedWhen] | Date/Time | * Date and time when record was first entered (= typed or imported) into this system. Note: Updates are recorded in ReferenceChanges. [RefMan: not applicable. Internal mgmt.attribute] Default value: Now() |
R | - |
| Table validation rule: | ([CitationText] Is Null Or Not ([ImportedFrom] Is Null Or [CitationFrom] Is Null)) And ([ImportedID] Is Null Or Not [ImportedFrom] Is Null) | |||
| Index name: | Attributes & index properties | |||
| DateYear: | DateYear (Duplicates OK) | |||
| DateYear2: | DateYear2 (Duplicates OK; Ignore Nulls) | |||
| DuplicateCheck: | DuplicateCheck (Unique values) | |||
| Periodical: | Periodical (Duplicates OK) | |||
| Publisher: | Publisher (Duplicates OK) | |||
| PublPlace: | PublPlace (Duplicates OK) | |||
| RefDescription: | RefDescription (Duplicates OK) | |||
| RefID: | RefID (Primary key; Unique values) | |||
| RefType: | RefType (Duplicates OK) | |||
| SeriesTitle: | SeriesTitle (Duplicates OK; Ignore Nulls) | |||
| Volume: | Volume (Duplicates OK; Ignore Nulls) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceAbstract.RefID | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceAuthor.RefID | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceAvailability.RefID | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceChanges.RefID | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceKeyword.RefID | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceCollection.RefID | |||
| Updates cascade | ReferenceTitle.RefID « ReferenceTitle.SourceRefID | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceUserMarker.RefID | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceUserNote.RefID | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceUserDefined.RefID | |||
| Updates cascade | ReferenceType.RefType « ReferenceTitle.RefType | |||
| Simple relation (no integrity) | ReferencePeriodical.Abbreviation « ReferenceTitle.Periodical | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceAnonymousNote.RefID | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceTitle.ReplaceWithRefID | |||
| Simple relation (no integrity) | ReferenceTitle.RefID « ReferenceWordIdx1.RefID | |||
| Simple relation (no integrity) | ReferenceTitle.RefID « ReferenceWordIdx2.RefID | |||
Literature reference subsystem: Reference authors, book editors, or series editors.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| Author | Text | Author. Example: 'Miller, W. I., Jr.'. Format: Last name, a comma, the first initial with period and blank, an optional middle initial, and an optional comma plus suffix (Jr./Sr./III./MD etc.) [RefMan 04: A1/AU, 14: A2/ED, 24: A3; no '*' allowed!] Validation rule: Not (Like ' *' Or Like '* ' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*' Or Like '*[*]*' Or Like '* *' Or Like '*;*' Or Like '*&*' Or Like '*+*' Or 'et al.' Or '& al.' Or 'et alii' Or '& alii' Or 'and others' Or '& others'), validation message: You may not use a '*', a semicolon (';'), an ampersand ('&'), a plus ('+'), or double blanks in author or editor names. Do not start or end the entry with a blank! In the case of et al./& al./etc.: enter all authors, do not abbreviate author lists! |
R | I(M) |
| AuthorAddress | Text | The address of the author, if available. Entered only in cases where it is of special relevance to one of the users of the database (or if imported from a database). [RefMan 32: AD] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| RefID | Text | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I(PM) |
| AuthorType | Byte+ | Three different author categories are supported: 1 = primary author, 2 = secondary author/editor, 3 = series editor. [RefMan implicit] Default value: 1, validation message: Use only values from the associated pick list. |
R | I(PM)+ |
| AuthorSequence | Long | The sequence of authors of the article. (Default based on system date/time; counter attrib. wouldn't work with replication ® random sequence! Note: Au+RefID+Type is not necessarily unique. Two authors may have identical abbreviated names, e.g. spouses!). Default value: CLng(99999*(Now()-37200)) |
R | I(PM) |
| Index name: | Attributes & index properties | |||
| Author: | Author; AuthorType (Duplicates OK) | |||
| PrimaryKey: | RefID; AuthorType; AuthorSequence (Primary key; Unique values) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceAuthor.RefID | |||
Literature reference subsystem: Availability and location of reference items in private or official filing system; e.g., book signatures or reprint article availability. Each responsible user may enter multiple filing codes.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I(PM) |
| AvailabilityID | Autonum | Unique ID to identify the availability record. (Technical note: to improve reliability of database replication, the primary key is formed in combination with the RefID. Note that FilingCode may be Null.). Default value: GenUniqueID() |
R | I(PM) |
| FilingCode | Text | Information about availability or location of a copy of the referenced publication: Filing code of reprint or book in private filing system, institutional catalogue code, signature, official call number, or shelf code in a library. [RefMan 27: AV] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | I |
| ReprintStatus | Byte+ | Refers to filing system of responsible person. Reprint may be 'Not in file' (0), 'On request (card to author)' (1), 'On request (internal order/copy marker)' (2), 'On request (interlibrary loan)' (3), or 'In file' (4) [RefMan 08: RP pro parte] Default value: 0, validation message: Use only values from the associated pick list. |
R | - |
| RequestDate | Date/Time | Only if ReprintStatus = 'On request' (1/2): The date on which the reprint was requested. [RefMan 08: RP pro parte] Validation rule: Is Null Or <Now() |
- | - |
| Responsible | Long | The person responsible for the availability/filing code information, and to which the reprint status/request date refers. [RefMan: not supported] |
R | - |
| [LogCreatedBy] | Long | Operator who first entered (typed or imported) the data. The operator (or typist) may be different from the person responsible. [RefMan: not applicable. Internal mgmt.attribute] |
R | - |
| [LogCreatedWhen] | Date/Time | Date and time when record was first entered (= typed or imported) into this system. Note: Updates are recorded in ReferenceChanges. [RefMan: not applicable. Internal mgmt.attribute] Default value: Now() |
R | - |
| Table validation rule: | [RequestDate] Is Null Or ([ReprintStatus]=1 Or [ReprintStatus]=2 Or [ReprintStatus]=3) | |||
| Table validation text: | You can enter a Request date only if the Reprint Status is set to 'On request'. | |||
| Index name: | Attributes & index properties | |||
| FilingCode: | FilingCode (Duplicates OK) | |||
| PrimaryKey: | RefID; AvailabilityID (Primary key; Unique values) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceAvailability.RefID | |||
Literature reference subsystem: Declares that a reference belongs to a virtual reference database called a 'reference collection'. For example, all references from a collaborative project may form a reference collection.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I(PM) |
| ReferenceCollection | Text | Code to identify a reference as belonging to a specific reference collection (= a virtual reference database, e.g. for a collaborative project). Validation rule: Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*' Or Like '*[*]*' Or Like '*;*'), validation message: You may not use a '*' or a semicolon (';') in a keyword or marker phrase. Also, do not start or end with a blank and do not include double blanks or new line characters! |
R | I(PM) |
| Responsible | Long | The person responsible for assigning the reference to a reference collection. [RefMan: not supported] |
R | - |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | ReferenceCollection; RefID (Primary key; Unique values) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceCollection.RefID | |||
Literature reference subsystem: Keywords (may include 'subject heading'-keywords and organism names).
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I(PM) |
| Keyword | Text | A keyword, esp. subject headings or private markers. A keyword may consist of multiple words (phrases, e.g. 'red herring'), which can then only be searched as a whole. [RefMan 07: KW] Validation rule: Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*' Or Like '*[*]*' Or Like '*;*'), validation message: You may not use a '*' or a semicolon (';') in a keyword or marker phrase. Also, do not start or end with a blank and do not include double blanks or new line characters! |
R | I(PM) |
| Responsible | Long | The person responsible for the assignment of this keyword to a reference. [RefMan: not supported] |
R | - |
| KeywordType | Text | (temporarily introduced to preserve information when importing data that distinguish between (k)eyword, (g)eography, and organism (n)ames). | - | - |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | Keyword; RefID (Primary key; Unique values) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceKeyword.RefID | |||
Literature reference subsystem: Public Abstracts.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text | Refers to the ID code of the main ReferenceTitle table (= foreign key). Validation rule: Not Like '* *' |
R | I(PM) |
| Responsible | Long | * The person responsible for the abstract information. Abstracts are copyright protected! Leave empty if the abstract was not written by you, but copied from the publication itself or a bibliographic database. [RefMan: not supported] Validation rule: Not Is Null, validation message: Any abstract must be authored by a responsible person. Copying abstracts from commercial reference database or from the journal itself is in most cases a violation of copyright! |
R | I(PM) |
| Language | Text | * Language of the abstract, as ISO 2 letter codes. [RefMan : not supported!] Default value: "?"; Validation rule: Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
R | I(PM) |
| Abstract | Memo | An abstract containing a short summary of the content of the article or book [RefMan 25: N2] Validation rule: Not (Like ' *' Or Like '* '), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
R | - |
| Shareable | Boolean | * Do you want to share your abstract with other users, i.e. can it be published on the web? [RefMan : not supported!] Default value: 0 |
R | - |
| [LogCreatedBy] | Long | * Operator who first entered (typed or imported) the data. The operator (or typist) may be different from the person responsible. [RefMan: not applicable. Internal mgmt.attribute] |
R | - |
| [LogCreatedWhen] | Date/Time | * Date and time when record was first entered (= typed or imported) into this system. Note: Updates are recorded in ReferenceChanges. [RefMan: not applicable. Internal mgmt.attribute] Default value: Now() |
R | - |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | RefID; Responsible; Language (Primary key; Unique values) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceAbstract.RefID | |||
Literature reference subsystem: User specific markers, e.g. to mark up a reference for a publication.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I(PM) |
| Marker | Text | * User specific marker, e.g. to mark up a reference for a specific project or for a publication. These markers will normally be visible only under the same Responsible login name. Validation rule: Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*' Or Like '*[*]*' Or Like '*;*'), validation message: You may not use a '*' or a semicolon (';') in a keyword or marker phrase. Also, do not start or end with a blank and do not include double blanks or new line characters! |
R | I(PM) |
| Responsible | Long | * The person responsible for the assignment of this user marker to a reference. Normally each person sees only his or her own markers! | R | I/I(PM) |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | RefID; Marker; Responsible (Primary key; Unique values) | |||
| Responsible: | Responsible (Duplicates OK) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceUserMarker.RefID | |||
Literature reference subsystem: User specific notes. Each user will only see the notes entered under the same responsible user name.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I(PM) |
| Responsible | Long | * The person responsible for the Notes. [RefMan: not supported] |
R | I/I(PM) |
| Notes | Memo | Internal notes regarding the reference title. Notes will normally be visible only under the same Responsible login name. [RefMan 06: N1, AB] Validation rule: Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
R | - |
| [LogCreatedBy] | Long | * Operator who first entered (typed or imported) the data. The operator (or typist) may be different from the person responsible. [RefMan: not applicable. Internal mgmt.attribute] |
R | - |
| [LogCreatedWhen] | Date/Time | * Date and time when record was first entered (= typed or imported) into this system. Note: Updates are recorded in ReferenceChanges. [RefMan: not applicable. Internal mgmt.attribute] Default value: Now() |
R | - |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | RefID; Responsible (Primary key; Unique values) | |||
| Responsible: | Responsible (Duplicates OK) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceUserNote.RefID | |||
Literature reference subsystem: User-defined fields originating form imported Reference Manager RIS files. These user-defined fields are currently not well supported in Diversity References.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I(PM) |
| Responsible | Long | The person responsible for the user defined fields (usually who imported the RIS file). | R | I(PM) |
| UserDef1 | Memo | User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. [RefMan 18: U1] |
- | - |
| UserDef2 | Memo | User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. [RefMan 19: U2] |
- | - |
| UserDef3 | Memo | User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. [RefMan 20: U3] |
- | - |
| UserDef4 | Memo | User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. [RefMan 21: U4] |
- | - |
| UserDef5 | Memo | User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. [RefMan 22: U5] |
- | - |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | RefID; Responsible (Primary key; Unique values) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceUserDefined.RefID | |||
Literature reference subsystem: Implementation entity. The words of the primary Title and the Source title, excluding stop words ('the', 'and', etc.), are written to this index table to allow fast queries. Words > 50 char. are truncated.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| Word | Text | Words > 50 character are truncated! | R | I(PM) |
| RefID | Text | R | I/I(PM) | |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | Word; RefID (Primary key; Unique values) | |||
| RefID: | RefID (Duplicates OK) | |||
| Relation type: | Attributes involved | |||
| Simple relation (no integrity) | ReferenceTitle.RefID « ReferenceWordIdx1.RefID | |||
Literature reference subsystem: Implementation entity. The words of the Abstracts, excluding stop words ('the', 'and', etc.), are written to this index table to allow fast queries. Words > 50 char. are truncated.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| Word | Text | Words > 50 character are truncated! | R | I(PM) |
| RefID | Text | R | I/I(PM) | |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | Word; RefID (Primary key; Unique values) | |||
| RefID: | RefID (Duplicates OK) | |||
| Relation type: | Attributes involved | |||
| Simple relation (no integrity) | ReferenceTitle.RefID « ReferenceWordIdx2.RefID | |||
Literature reference subsystem: Anonymous notes added through the internet public interface.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I(PM) |
| Notes | Memo | Notes entered by an anonymous user over the internet. | R | - |
| InternetAccessCode | Text | A system generated code that can be used to enable the anonymous user to update the Note over the internet. | - | - |
| [LogCreatedBy] | Text | Name of person who entered the anyonmous notes (free text, not referring to the User management component like most other LogCreatedBy attributes!). | R | - |
| [LogCreatedWhen] | Date/Time | Date and time when record was entered into this system. Default value: Now() |
R | I(PM) |
| [LogUpdatedWhen] | Date/Time | Date and time when record was last updated. | - | - |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | RefID; LogCreatedWhen (Primary key; Unique values) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceAnonymousNote.RefID | |||
Literature reference subsystem: Changes of reference records are logged here (user, date, attributes affected).
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I/I(PM) |
| Changes | Memo | Optionally a record of the attributes and data that were affected by the update [RefMan: not applicable. Internal mgmt.attribute] |
R | - |
| [LogUpdatedBy] | Long | * User who last updated the reference identified by RefID. This is the operator (or typist) name, which may be different from the person responsible. [RefMan: not applicable. Internal mgmt.attribute] |
R | - |
| [LogUpdatedWhen] | Date/Time | * Date and time of last update of the reference. [RefMan: not applicable. Internal mgmt.attribute] |
R | I(PM) |
| Index name: | Attributes & index properties | |||
| PrimaryKey: | LogUpdatedWhen; RefID (Primary key; Unique values) | |||
| RefID: | RefID (Duplicates OK) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceChanges.RefID | |||
Literature reference subsystem: Journal/periodical titles.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| Abbreviation | Text | Standardized abbreviation of periodical or journal. Use periods after the abbreviations [RefMan 11: JA, JO] Validation rule: Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
R | I (P) |
| FullName | Text | Full, non-abbreviated name of periodical or journal [RefMan 11: JF, JO] Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| Notes | Memo | Notes, remarks, or comments regarding the journal/periodical as a whole, incl. "continued as (new title)" or notes about local availability. Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| ImportedFrom | Text | If imported from another database: The name of the database system or provider; otherwise empty. Validation rule: Is Null Or Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
- | - |
| Responsible | Long | The person responsible for entering the information. | R | - |
| [LogCreatedBy] | Long | Operator who first entered (typed or imported) the data. The operator (or typist) may be different from the person responsible. [RefMan: not applicable. Internal mgmt.attribute] |
R | - |
| [LogCreatedWhen] | Date/Time | Date and time when record was first entered (typed or imported) into this system. Default value: Now() |
R | - |
| Index name: | Attributes & index properties | |||
| Abbreviation: | Abbreviation (Primary key; Unique values) | |||
| Relation type: | Attributes involved | |||
| Updates & deletions cascade | ReferencePeriodical.Abbreviation « ReferencePeriodicalSyn.Abbreviation | |||
| Simple relation (no integrity) | ReferencePeriodical.Abbreviation « ReferenceTitle.Periodical | |||
Literature reference subsystem, Journal/periodical titles, thesaurus with synonyms ® valid name. Any entry in Periodical.Abbreviation and Periodical.FullName must also be added to the synonym table.
| Name | Type | Description / Default value & validation | Rqrd./Index | |||||
|---|---|---|---|---|---|---|---|---|
| Synonym | Text | Alternative, synonymous names for the main record. Automatically translated into StdAbbrev if a thesaurus pick list is used in forms. [RefMan 11: J1, J2] Validation rule: Not (Like ' *' Or Like '* ' Or Like '* *' Or Like '*' & Chr(10) & '*' Or Like '*' & Chr(13) & '*'), validation message: Do not start or end with a blank and do not include double blanks or new line characters! |
R | I (P) | ||||
| Abbreviation | Text | Standardized abbreviation of periodical or journal, as defined in RefPeriodical entity (= foreign key). | R | I | ||||
| Source | Text | Source of the synonym/thesaurus name: 'ABBR' for standard abbreviation, 'FULL' for standard full name, else name or abbrev. of user who added a non-standard synonym (like PNAS for Proc. Nat. Acad. Sci.). | R | - | ||||
| Examples values (any other values may be added): |
|
|||||||
| Index name: | Attributes & index properties | |||||||
| Abbreviation: | Abbreviation (Duplicates OK) | |||||||
| Synonym: | Synonym (Primary key; Unique values) | |||||||
| Relation type: | Attributes involved | |||||||
| Updates & deletions cascade | ReferencePeriodical.Abbreviation « ReferencePeriodicalSyn.Abbreviation | |||||||
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: P = attribute is part of the primary key (values in the index must be unique), U = values in the index must be unique, N = Null values are ignored in the index, M = the index contains more than one attribute, + = the attribute is involved in more than one multiple-field index. The names of attributes that are part of the primary key are underlined in the first column.
Attribute names of system fields and logging fields (record creation or updating) are enclosed in square brackets: [].
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. All text is Unicode text. Numeric types: BigInt = 8 byte integer, Long = 4 byte integer, Integer or Int = 2 byte integer, Byte = 1 byte integer. A + (e.g. Byte+) indicates that the integer is unsigned and only positive values are allowed.
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 name@gmail.com, please replace name with g.m.hagedorn!
Documentation created on 24. Sep. 2003; last update: 2005-03-30, email address revised 2010-08-05.