Documentation created on 5. May 2001; last update: 2005-03-30, email address revised 2010-08-05.
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: ReferenceType, ReferenceAuthor, ReferenceAvailability, ReferenceKeyword, ReferenceProjectMarker, ReferenceManagerUserDefined, ReferenceChanges, ReferenceUserNote, ReferencePeriodicalSyn, ReferenceAbstract, ReferencePeriodical, ReferenceTitle, ReferenceUserMarker, ReferenceWordIdx1, ReferenceWordIdx2.
(You can click on the entities to go to the attribute tables.)
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 (10) | 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 (U) |
| Description | Text (255) | 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 (255) | Internal notes regarding the use of a ReferenceTitle type. | - | - |
| Index name: | Attributes & index properties | |||
| RefType: | RefType (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates cascade | ReferenceType.RefType « ReferenceTitle.RefType | |||
Literature reference subsystem: Reference authors, book editors, or series editors.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| Author | Text (255) | Author: last name first, a comma, the first initial with period and blank, and the middle initial. Optionally add a comma and a suffix = Jr./Sr./III./MD etc. (Star,N. B.,Jr.) [RefMan 04: A1/AU, 14: A2/ED, 24: A3; do not use '*' in this field!]. |
R | I (UM) |
| AuthorAddress | Text (255) | 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]. |
- | - |
| AuthorType | Byte | Three different author categories are supported: 1 = primary author, 2 = secondary author/editor, 3 = series editor. [RefMan implicit]. Default value: 1; Validation rule: >0 And <4, validation message: Use only values from the associated pick list. |
R | - |
| RefID | Text (20) | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I |
| 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()-36800)) |
R | I (UM) |
| Index name: | Attributes & index properties | |||
| {3B29AA30-C0CA-11D4-BDB2-8A...: | RefID (Duplicates OK) | |||
| Author: | Author; AuthorType; RefID (Unique values) | |||
| PrimaryKey: | AuthorSequence; RefID (Primary key; Unique values) | |||
| Relation type: | Fields 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.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text (20) | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I |
| FilingCode | Text (255) | Availability or location of publication. Filing code of reprint or book in private filing system, or official catalogue code, signature, call number, or shelf code in a library. [RefMan 27: AV interpreted as comma-separated list]. |
- | I |
| ReprintStatus | Byte | If responsible person has private filing system, 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 rule: >-1 And <5, 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 | Text (50) | The person responsible for the signature information, and to which the reprint status/request date refers. [RefMan: not supported]. |
R | I (UM) |
| LogCreated_User | Text (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible. | R | - |
| LogCreated_Date | 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 | |||
| {3B29AA31-C0CA-11D4-BDB2-8A...: | RefID (Duplicates OK) | |||
| FilingCode: | FilingCode (Duplicates OK) | |||
| Responsible: | Responsible; RefID (Primary key; Unique values) | |||
| Table validation rule: | [RequestDate] Is Null Or ([ReprintStatus]=1 Or [ReprintStatus]=2) | |||
| Table validation text: | You can enter a Request date only if the Reprint Status is set to 'On request'. | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceAvailability.RefID | |||
Literature reference subsystem: Keywords (may include 'subject heading'-keywords and organism names).
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text (20) | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I |
| Keyword | Text (255) | 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]. |
R | I (UM) |
| Responsible | Text (50) | The person responsible for the assignment of this keyword to a reference. [RefMan: not supported]. |
R | - |
| Index name: | Attributes & index properties | |||
| {3B29AA33-C0CA-11D4-BDB2-8A...: | RefID (Duplicates OK) | |||
| PrimaryKey: | Keyword; RefID (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceKeyword.RefID | |||
Literature reference subsystem: Project specific markers, to declare that references are used or checked by a specific project.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text (20) | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I |
| Project | Text (25) | Project specific marker, e.g. to mark up a reference for a specific project or for a publication. | R | I (UM) |
| Responsible | Text (50) | The person responsible for the assignment of this project marker to a reference. [RefMan: not supported]. |
R | - |
| Index name: | Attributes & index properties | |||
| {3B29AA34-C0CA-11D4-BDB2-8A...: | RefID (Duplicates OK) | |||
| PrimaryKey: | Project; RefID (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceProjectMarker.RefID | |||
Literature reference subsystem: User defined fields originating form imported Reference Manager RIS files.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text (20) | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I |
| Responsible | Text (50) | The person responsible for the user defined fields (usually who imported the RIS file). | R | I (UM) |
| 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 | |||
| {3B29AA3A-C0CA-11D4-BDB2-8A...: | RefID (Duplicates OK) | |||
| Responsible: | Responsible; RefID (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « USys_ReferenceManagerUserDefined.RefID | |||
Literature reference subsystem: All changes of references are logged here (user, date, fields affected).
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text (20) | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I/I |
| Changes | Memo | * Attributes and/or data affected by changes. [RefMan: not applicable. Internal mgmt.attribute]. |
R | - |
| LogUpdated_User | Text (50) | * Name of user who last updated the record. This is the operator (or typist) name, which may be different from the person responsible. [RefMan: not applicable. Internal mgmt.attribute]. |
R | - |
| LogUpdated_Date | Date/Time | * Date and time of last update of the record. [RefMan: not applicable. Internal mgmt.attribute]. |
R | I (UM) |
| Index name: | Attributes & index properties | |||
| {3B29AA32-C0CA-11D4-BDB2-8A...: | RefID (Duplicates OK) | |||
| PrimaryKey: | LogUpdated_Date; RefID (Primary key; Unique values) | |||
| RefID: | RefID (Duplicates OK) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceChanges.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 (20) | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I/I (UM) |
| Responsible | Text (50) | * The person responsible for the Notes. [RefMan: not supported]. |
R | - |
| Notes | Memo | Internal notes regarding the reference title. Notes will normally be visible only under the same Responsible login name. [RefMan 06: N1, AB]. |
R | - |
| LogCreated_User | Text (50) | * Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible. [RefMan: not applicable. Internal mgmt.attribute]. |
R | - |
| LogCreated_Date | 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 | |||
| {3B29AA37-C0CA-11D4-BDB2-8A...: | RefID (Duplicates OK) | |||
| PrimaryKey: | RefID; Responsible (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceUserNote.RefID | |||
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 (255) | Alternative, synonymous names for the main record. Automatically translated into StdAbbrev if a thesaurus pick list is used in forms. [RefMan 11: J1, J2]. |
R | I (U) |
| Abbreviation | Text (255) | Standardized abbreviation of periodical or journal, as defined in RefPeriodical entity (= foreign key). | R | I/I |
| Source | Text (50) | 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 | - |
| Index name: | Attributes & index properties | |||
| Abbreviation: | Abbreviation (Duplicates OK) | |||
| ReferencePeriodicalReferenc...: | Abbreviation (Duplicates OK) | |||
| Synonym: | Synonym (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | ReferencePeriodical.Abbreviation « ReferencePeriodicalSyn.Abbreviation | |||
Literature reference subsystem: Public Abstracts.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefID | Text (20) | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I/I (UM) |
| Responsible | Text (50) | * 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 | - |
| Language | Text (20) | * Language of the abstract, as ISO 2 letter codes. [RefMan : not supported!]. Default value: "?" |
R | - |
| Abstract | Memo | An abstract containing a short summary of the content of the article or book [RefMan 25: N2]. |
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 | - |
| LogCreated_User | Text (50) | * Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible. [RefMan: not applicable. Internal mgmt.attribute]. |
R | - |
| LogCreated_Date | 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 | |||
| {3B29AA2F-C0CA-11D4-BDB2-8A...: | RefID (Duplicates OK) | |||
| PrimaryKey: | RefID; Responsible; Language (Primary key; Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceAbstract.RefID | |||
Literature reference subsystem: Journal/periodical titles.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| Abbreviation | Text (255) | Standardized abbreviation of periodical or journal. Use periods after the abbreviations [RefMan 11: JA, JO]. |
R | I (U) |
| FullName | Text (255) | Full, non-abbreviated name of periodical or journal [RefMan 11: JF, JO]. |
- | - |
| Notes | Memo | Notes, remarks, or comments regarding the journal/periodical as a whole, incl. "continued as (new title)" or notes about local availability. | - | - |
| LogCreated_User | Text (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible. | R | - |
| LogCreated_Date | Date/Time | Date and time when record was first entered (typed or imported) into this system. Default value: Now() |
R | - |
| s_GUID | GUID | (system attribute used in database replication). Default value: GenGUID() |
- | I (U) |
| s_Generation | Long | (system attribute used in database replication). | - | I |
| s_Lineage | OLE Object | (system attribute used in database replication). | - | - |
| Index name: | Attributes & index properties | |||
| Abbreviation: | Abbreviation (Primary key; Unique values) | |||
| s_Generation: | s_Generation (Duplicates OK) | |||
| s_GUID: | s_GUID (Unique values) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | ReferencePeriodical.Abbreviation « ReferencePeriodicalSyn.Abbreviation | |||
| Simple relation (no integrity) | ReferencePeriodical.Abbreviation « ReferenceTitle.Periodical | |||
Literature reference subsystem: Main entity; compatible with Reference Manager™ v.9.
| Name | Type | Description / Default value & validation | Rqrd./Index | |
|---|---|---|---|---|
| RefType | Text (10) | 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/I |
| RefID | Text (20) | 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 (U) |
| RefDescription | Text (120) | * 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]. |
- | - |
| 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: Is Null Or (>0 And <=Year(Now())), 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 Or (>0 And <13), 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 Or (>0 And <32), validation message: Only values between 1 and 31 are valid for a day! |
- | - |
| DateSuppl | Text (255) | 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]. |
- | I |
| DateSecondary | Text (255) | A secondary date, esp. the true publ. date where relevant for nomenclatural priority (usage in Reference Manager seems to be undefined...) [RefMan 28: Y2]. |
- | - |
| 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]. |
- | - |
| SeriesTitle | Text (255) | 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]. |
- | I |
| Periodical | Text (255) | Journal/periodical in which the article appeared. Linked to the Abbreviation attribute of ReferencePeriodical. [RefMan 11: JF, JO, JA]. |
- | I |
| Volume | Text (255) | The volume (for periodicals or journals, excluding the issue number), report number, etc. [RefMan 12: VL pro parte, comp. Edition!]. |
- | I |
| Issue | Text (255) | The issue, if any. Useful to enter a special designation for a supplement, for example '45 (Suppl.)'. [RefMan 15: IS]. |
- | - |
| Pages | Text (255) | 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]. |
- | - |
| Publisher | Text (255) | The name of the publisher (publishing company or institution, including universities or scientific societies). [RefMan 17: PB]. |
- | I |
| PublPlace | Text (255) | The location where the item being referenced was published, such as a city and state. [RefMan 16: CY, CP]. |
- | I |
| Edition | Integer | Number of the edition of a book. Use only positive integer numbers. [RefMan 12: VL pro parte, compare Volume!]. Validation rule: >0 Or Is Null, validation message: The edition must be a simple number like '1', '2', etc. |
- | - |
| ISSN_ISBN | Text (15) | The 'International Standard Serial Number' or 'International Standard Book Number'. [RefMan 26: SN]. |
- | - |
| Miscellaneous1 | Text (255) | Various reference type dependent information; e.g. the total number of volumes for books [RefMan 29: M1]. |
- | - |
| Miscellaneous2 | Text (255) | Various reference type dependent information [RefMan 30: M2]. |
- | - |
| Miscellaneous3 | Text (255) | Various reference type dependent information [RefMan 31: M3]. |
- | - |
| URL | Memo | URL address (http: www...) or local file (C:\graphic.gif; \\Oudemans\Data\x.doc) [RefMan 33: UR]. |
- | - |
| SourceRefID | Text (20) | * 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! | - | I/I |
| Language | Text (20) | * Language of the article/book, as ISO 2 letter codes. [RefMan: not supported!]. Default value: "?" |
R | - |
| DuplicateCheck | Text (255) | * 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 (20) | * 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 entry when working with the application. Typically the entries here should later be deleted after help has been obtained. Do not enter scientific of bibliographic problems here; use Notes for such permanent problems! | - | - |
| Problem_User | Text (50) | * Name of operator who entered the problem text. | - | - |
| Problem_Date | Date/Time | * Date and time when problem was recorded. | - | - |
| RefCitationFrom | Text (255) | * Only known as citation in the publication given here (as ID code or author/year description); i.e. the reference has only been seen as citation in the ref. list of another work, never as orig. publication. Empty if transcribed from original publication! | - | I (N) |
| RefImportedFrom | Text (50) | * If imported from a reference database (esp. a commercial one): The name of the database system or provider; otherwise empty. This information is used to prevent copyright violations. [RefMan: not supported!; Internal management attribute]. |
- | - |
| RefImportedID | Text (50) | * If imported from a reference database (esp. a commercial one): The ID to later re-identify the record in that database; otherwise empty. [RefMan: not supported!; Internal management attribute]. |
- | - |
| CheckPlausible_User | Text (50) | * Name of user 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]. |
- | - |
| CheckPlausible_Date | 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]. |
- | - |
| CheckOriginal_User | Text (50) | * Name of user responsible for comparison of ReferenceTitle record with original publication [RefMan: not applicable. Internal mgmt.attribute]. |
- | - |
| CheckOriginal_Date | 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]. |
- | - |
| LogCreated_User | Text (50) | * Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible. [RefMan: not applicable. Internal mgmt.attribute]. |
R | - |
| LogCreated_Date | 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 | - |
| s_GUID | GUID | * Globally Unique ReferenceTitle Identifier, system assigned number to identify this record (system attribute used in database replication). Default value: GenGUID() |
- | I (U) |
| s_Generation | Long | (system attribute used in database replication). | - | I |
| s_Lineage | OLE Object | (system attribute used in database replication). | - | - |
| Index name: | Attributes & index properties | |||
| {3B29AA35-C0CA-11D4-BDB2-8A...: | SourceRefID (Duplicates OK) | |||
| {3B29AA3B-C0CA-11D4-BDB2-8A...: | RefType (Duplicates OK) | |||
| DateSuppl: | DateSuppl (Duplicates OK) | |||
| DateYear: | DateYear (Duplicates OK) | |||
| DuplicateCheck: | DuplicateCheck (Unique values) | |||
| Periodical: | Periodical (Duplicates OK) | |||
| Publisher: | Publisher (Duplicates OK) | |||
| PublPlace: | PublPlace (Duplicates OK) | |||
| RefCitationFrom: | RefCitationFrom (Duplicates OK; Ignore Nulls) | |||
| RefDescription: | RefDescription (Duplicates OK) | |||
| RefID: | RefID (Primary key; Unique values) | |||
| RefType: | RefType (Duplicates OK) | |||
| s_Generation: | s_Generation (Duplicates OK) | |||
| s_GUID: | s_GUID (Unique values) | |||
| SeriesTitle: | SeriesTitle (Duplicates OK) | |||
| SourceRefID: | SourceRefID (Duplicates OK) | |||
| Volume: | Volume (Duplicates OK) | |||
| Relation type: | Fields 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 « ReferenceProjectMarker.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 « ReferenceWordIdx1.RefID | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceWordIdx2.RefID | |||
| Updates & deletions cascade | ReferenceTitle.RefID « USys_ReferenceManagerUserDefined.RefID | |||
| Updates cascade | ReferenceType.RefType « ReferenceTitle.RefType | |||
| Simple relation (no integrity) | ReferencePeriodical.Abbreviation « ReferenceTitle.Periodical | |||
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 (20) | Refers to the ID code of the main ReferenceTitle table (= foreign key). | R | I |
| Marker | Text (255) | * 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. | R | I (UM) |
| Responsible | Text (50) | * 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 |
| Index name: | Attributes & index properties | |||
| {3B29AA36-C0CA-11D4-BDB2-8A...: | RefID (Duplicates OK) | |||
| PrimaryKey: | Marker; RefID; Responsible (Primary key; Unique values) | |||
| Responsible: | Responsible (Duplicates OK) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceUserMarker.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 (50) | Words > 50 character are truncated! | - | I (UM) |
| RefID | Text (20) | - | I/I | |
| Index name: | Attributes & index properties | |||
| {3B29AA38-C0CA-11D4-BDB2-8A...: | RefID (Duplicates OK) | |||
| PrimaryKey: | Word; RefID (Primary key; Unique values) | |||
| RefID: | RefID (Duplicates OK) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | 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 (50) | Words > 50 character are truncated! | - | I (UM) |
| RefID | Text (20) | - | I/I | |
| Index name: | Attributes & index properties | |||
| {3B29AA39-C0CA-11D4-BDB2-8A...: | RefID (Duplicates OK) | |||
| PrimaryKey: | Word; RefID (Primary key; Unique values) | |||
| RefID: | RefID (Duplicates OK) | |||
| Relation type: | Fields involved | |||
| Updates & deletions cascade | ReferenceTitle.RefID « ReferenceWordIdx2.RefID | |||
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 name@gmail.com, please replace name with g.m.hagedorn!
Documentation created on 5. May 2001; last update: 2005-03-30, email address revised 2010-08-05.