Diversity References
The following objects are not included:
- Logging tables
- Enumeration tables
- System objects
- Objects marked as obsolete
- Previous versions of objects
TABLES
Table ReferenceAvailability
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.
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| RefID | int | Refers to the ID code of the main ReferenceTitle table (= foreign key) | NO | Refers to table ReferenceTitle |
| RecordID | int | Unique random ID (see trigger) 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 is optional and not suitable.)Default value: CONVERT([int],rand()*(2147483647.1),(0)) | NO | - |
| FilingCode | nvarchar (255) | 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]Default value: '' | NO | - |
| ReprintStatus | smallint | 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) | NO | Refers to table Ref_AvailabilityReprintStatus_Enum |
| RequestDate | datetime | Only if ReprintStatus = ‘On request’ (1/2): The date on which the reprint was requested. //[RefMan 08: RP pro parte] | YES | - |
| Responsible | int | The person responsible for the availability/filing code information, and to which the reprint status/request date refers. //[RefMan: not supported] | NO | - |
| LogInsertedBy | nvarchar (50) | ID of the creator of this data setDefault value: [dbo].UserID | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | ID of the person to update this data set lastDefault value: [dbo].UserID | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
Depending on:
- Ref_AvailabilityReprintStatus_Enum
- ReferenceTitle
trgInsReferenceAvailability
Table ReferenceDescriptor
Object names, event names, keywords, etc., providing indexing information for a resource.
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| RefID | int | ID of external resource to which the descriptor applies (foreign key) | NO | Refers to table ReferenceTitle |
| Language | varchar (5) | Language in which element content is expressed. Necessary even for numeric or date content (because expressed through string using language-specific conventions)Default value: ’en’ | NO | - |
| ElementID | int | ID of a descriptor element concept (foreign key)Default value: (0) | NO | Refers to table ReferenceDescriptorElement |
| Content | nvarchar (255) | A name, state, or value text for the descriptor element.Default value: '’ | NO | - |
| ContentURI | varchar (255) | The URI of a conceptual ontological resource considered equivalent with the content, especially URIs for taxon names or keywords from ontologies.Default value: '’ | NO | - |
| InstanceGrouping | smallint | Normally Null. If set, element relations are evaluated only within same-numbered instances. Example: 3 host-pathogen-pairs exist in one resource, each pair would get same instance number. Still, a place name set to instance=Null would apply to all.Default value: NULL | YES | - |
| ID | int | Internal system generated primary key. Note that multiple values for a descriptor concept may be added (e.g. keywords) | NO | - |
| LogInsertedBy | nvarchar (50) | ID of the creator of this data setDefault value: [dbo].UserID | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | ID of the person to update this data set lastDefault value: [dbo].UserID | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
Depending on:
- ReferenceDescriptorElement
- ReferenceTitle
Table ReferenceDescriptorElement
Examples of descriptor elements (= concepts for variables) are keyword, taxon name, pathogen name, host name, or host feature. Association with ResourceCollections is defined in ReferenceDescriptorAssociation, relations in Res.DescriptorElementRelation.
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ElementID | int | Numeric identifier (primary key). | NO | - |
| ElementAbbrev | nvarchar (25) | Short abbreviated name for descriptor element.Default value: '’ | NO | - |
| ElementLabel | nvarchar (80) | Concise English label of a descriptor element definition.Default value: '’ | NO | - |
| DisplayOrder | int | Order in which elements are displayed independently of a resource collection (for order within a collection see ReferenceDescriptorAssociation.DisplayOrder).Default value: (0) | NO | - |
| ElementDescription | nvarchar (1000) | A free-form text that may be displayed in user interfaces as explanatory text.Default value: '’ | NO | - |
| ElementURI | varchar (255) | The URI of a conceptual ontological resource considered equivalent with this descriptor element.Default value: '' | NO | - |
| InternalNotes | nvarchar (1000) | Internal notes and remarks. Although normally not published in public reports, this should not be used for truly confidential information.Default value: '' | NO | - |
| DisplayEnabled | bit | Whether this DescriptorElement is to be displayed in the user interface. | NO | - |
| LogInsertedBy | nvarchar (50) | ID of the creator of this data setDefault value: [dbo].UserID | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | ID of the person to update this data set lastDefault value: [dbo].UserID | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
Table ReferenceDescriptorElementRelation
General relations between descriptor elements (applicable to all values present in ReferenceDescriptor)
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| FromElement | int | Starting point of relation (foreign key, part of primary key) | NO | Refers to table ReferenceDescriptorElement |
| RoleLabel | nvarchar (25) | Abbreviated label for relation in forward directionDefault value: '' | NO | - |
| ToElement | int | End point of relation (foreign key, part of primary key) | NO | Refers to table ReferenceDescriptorElement |
| RoleDescription | nvarchar (1000) | A free-form text that may be displayed in user interfaces as explanatory text.Default value: '' | NO | - |
| RoleURI | varchar (255) | The URI of a conceptual ontological resource considered equivalent with the role of this relation.Default value: '' | NO | - |
| InternalNotes | nvarchar (1000) | Internal notes and remarks. Although normally not published in public reports, this should not be used for truly confidential information.Default value: '' | NO | - |
| LogInsertedBy | nvarchar (50) | ID of the creator of this data setDefault value: [dbo].UserID | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | ID of the person to update this data set lastDefault value: [dbo].UserID | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
Depending on:
- ReferenceDescriptorElement
Table ReferenceNote
Public reference abstracts/notes.
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| RefID | int | Refers to the ID code of the main ReferenceTitle table (= foreign key) | NO | Refers to table ReferenceTitle |
| Responsible | int | * The person responsible for the abstract information. Abstracts are copyright protected! Clearly state if the abstract was not written by you, but copied from the publication itself or a bibliographic database. //[RefMan: not supported]Default value: [dbo].wbCurrentUserID | NO | - |
| Language | varchar (20) | * Language of the abstract, as ISO 2 letter codes. //[RefMan : not supported!]Default value: ‘UNK’ | NO | - |
| Content | nvarchar (4000) | An abstract containing a short summary of the content of the article or book //[RefMan 25: N2] | NO | - |
| LogInsertedBy | nvarchar (50) | ID of the creator of this data setDefault value: [dbo].UserID | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | ID of the person to update this data set lastDefault value: [dbo].UserID | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
Depending on:
- ReferenceTitle
Table ReferencePeriodical
Periodical (journal/magazine, etc.) titles.
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| Abbreviation | nvarchar (255) | Standardized abbreviation of periodical or journal. Use periods after the abbreviations //[RefMan 11: JA, JO] | NO | - |
| FullName | nvarchar (255) | Full, non-abbreviated name of periodical or journal //[RefMan 11: JF, JO]Default value: '' | NO | - |
| Notes | nvarchar (4000) | Notes, remarks, or comments regarding the journal/periodical as a whole, incl. “continued as (new title)” or notes about local availabilityDefault value: '' | NO | - |
| ImportedFrom | nvarchar (255) | If imported from another database: The name of the database system or provider; otherwise empty.Default value: '' | NO | - |
| PeriodicalID | int | - | NO | - |
| LogInsertedBy | nvarchar (50) | ID of the creator of this data setDefault value: [dbo].UserID | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | ID of the person to update this data set lastDefault value: [dbo].UserID | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
trgInsReferencePeriodical
Table ReferencePeriodicalProject
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| Abbreviation | nvarchar (255) | Standardized abbreviation of periodical or journal, as defined in ReferencePeriodical entity (= foreign key). | NO | Refers to table ReferencePeriodical |
| ProjectID | int | ID of the project to which the periodical belongs (Projects are defined in DiversityProjects) | NO | Refers to table ProjectProxy |
| LogInsertedBy | nvarchar (50) | ID of the creator of this data setDefault value: [dbo].UserID | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | ID of the person to update this data set lastDefault value: [dbo].UserID | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
Depending on:
- ProjectProxy
- ReferencePeriodical
Table ReferencePeriodicalSynonym
Periodical (journal/magazine, etc.) titles: thesaurus with synonyms -> valid name. Any entry in Periodical.Abbreviation and Periodical.FullName must also be added to the synonym table.
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| Synonym | nvarchar (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] | NO | - |
| Abbreviation | nvarchar (255) | Standardized abbreviation of periodical or journal, as defined in ReferencePeriodical entity (= foreign key). | NO | Refers to table ReferencePeriodical |
| Source | nvarchar (255) | 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.) | NO | - |
| LogInsertedBy | nvarchar (50) | ID of the creator of this data setDefault value: [dbo].UserID | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | ID of the person to update this data set lastDefault value: [dbo].UserID | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
Depending on:
- ReferencePeriodical
Table ReferencePrivateDescriptor
Object names, event names, keywords, etc., providing indexing information for a resource.
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| RefID | int | ID of external resource to which the descriptor applies (foreign key) | NO | Refers to table ReferenceTitle |
| PrivateTo | int | (UNUSED : using table ProvateDescriptor instead!)Either the UserID of the user who created this descriptor for private usage or null for a public descriptor Default value: [dbo].wbCurrentUserID | NO | - |
| Language | varchar (5) | Language in which element content is expressed. Necessary even for numeric or date content (because expressed through string using language-specific conventions)Default value: ’en’ | NO | - |
| ElementID | int | ID of a descriptor element concept (foreign key)Default value: (0) | NO | Refers to table ReferenceDescriptorElement |
| Content | nvarchar (255) | A name, state, or value text for the descriptor element.Default value: '’ | NO | - |
| ContentURI | varchar (255) | The URI of a conceptual ontological resource considered equivalent with the content, especially URIs for taxon names or keywords from ontologies.Default value: '' | NO | - |
| InstanceGrouping | smallint | Normally Null. If set, element relations are evaluated only within same-numbered instances. Example: 3 host-pathogen-pairs exist in one resource, each pair would get same instance number. Still, a place name set to instance=Null would apply to all.Default value: NULL | YES | - |
| ID | int | Internal system generated primary key. Note that multiple values for a descriptor concept may be added (e.g. keywords) | NO | - |
| LogInsertedBy | nvarchar (50) | ID of the creator of this data setDefault value: [dbo].UserID | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | ID of the person to update this data set lastDefault value: [dbo].UserID | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
Depending on:
- ReferenceDescriptorElement
- ReferenceTitle
Table ReferencePrivateNote
User specific notes. Each user will only see the notes entered under the same responsible user name.
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| RefID | int | Refers to the ID code of the main ReferenceTitle table (= foreign key) | NO | Refers to table ReferenceTitle |
| PrivateTo | int | * The person responsible for the Notes. //[RefMan: not supported]Default value: [dbo].wbCurrentUserID | NO | - |
| Content | nvarchar (4000) | Internal notes regarding the reference title. Notes will normally be visible only under the same Responsible login name. //[RefMan 06: N1, AB] | NO | - |
| LogInsertedBy | nvarchar (50) | ID of the creator of this data setDefault value: [dbo].UserID | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | ID of the person to update this data set lastDefault value: [dbo].UserID | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
Depending on:
- ReferenceTitle
Table ReferenceProject
The projects within which the Reference were placed
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| RefID | int | Refers to the ID of ReferenceTitle (= Foreign key and part of primary key) | NO | Refers to table ReferenceTitle |
| ProjectID | int | ID of the project to which the Reference belongs (Projects are defined in DiversityProjects) | NO | Refers to table ProjectProxy |
| LogInsertedBy | nvarchar (50) | ID of the creator of this data setDefault value: [dbo].UserID | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | ID of the person to update this data set lastDefault value: [dbo].UserID | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
Depending on:
- ProjectProxy
- ReferenceTitle
Table ReferenceRelator
Reference authors, book editors, or series editors.
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| RefID | int | Refers to the ID code of the main ReferenceTitle table (= foreign key) | NO | Refers to table ReferenceTitle |
| Role | nvarchar (3) | Relator codes from MARC; Reference manager supports only aut = primary author, 2 = secondary author/editor, 3 = series editor. //[RefMan implicit] | NO | Refers to table Ref_RelatorRole_Enum |
| Sequence | int | 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: CONVERT([int],(99999)*(CONVERT([float],getdate(),(0))-(37200)),(0)) | NO | - |
| Name | nvarchar (255) | Author, editor, etc. Example: ‘Miller, W. I., Jr.’. Format: Last name, comma, first initial with period and blank, optional middle initial, and optional comma plus suffix (Jr./Sr./III./MD etc.) //[RefMan 04: A1/AU, 14: A2/ED, 24: A3; no ‘*’ allowed!] | NO | - |
| AgentURI | varchar (255) | The URI of the Agent, e.g. as stored within the module DiversityAgents | YES | - |
| SortLabel | nvarchar (255) | Name of the agent without special characters formatted to facilitate sorting | YES | - |
| Address | nvarchar (1000) | 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]Default value: '’ | YES | - |
| LogInsertedBy | nvarchar (50) | ID of the creator of this data setDefault value: [dbo].UserID | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | ID of the person to update this data set lastDefault value: [dbo].UserID | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
Depending on:
- Ref_RelatorRole_Enum
- ReferenceTitle
trgInsReferenceRelator
Table ReferenceTitle
Main entity; compatible with Reference Manager™ v.9-11
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| RefType | nvarchar (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’ | NO | Refers to table Ref_Type_Enum |
| RefID | int | Unique reference ID code for the reference record. Currently supporting only integer numbers. Note that RefMan in principle supports 20 char., but uses only integers. //[RefMan 02: ID]Default value: CONVERT([int],rand()*(2147483647.1),(0)) | NO | - |
| RefDescription_Cache | nvarchar (255) | * A short system generated text identifying the reference, usually authors, year, title. Example: ‘Smith. & Nao 1999. New Taxa.’ //[RefMan: not applicable]Default value: '’ | NO | - |
| Title | nvarchar (MAX) | 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]Default value: '’ | NO | - |
| DateYear | smallint | 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] | YES | - |
| DateMonth | smallint | 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] | YES | - |
| DateDay | smallint | 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] | YES | - |
| DateSuppl | nvarchar (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]Default value: '’ | NO | - |
| SourceTitle | nvarchar (MAX) | 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]Default value: '’ | NO | - |
| SeriesTitle | nvarchar (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]Default value: '’ | NO | - |
| Periodical | nvarchar (255) | Journal/periodical in which the article appeared. Linked to the Abbreviation attribute of ReferencePeriodical. //[RefMan 11: JF, JO, JA]Default value: '’ | NO | - |
| Volume | nvarchar (255) | The volume (for periodicals or journals, excluding the issue number), report number, etc. //[RefMan 12: VL pro parte, comp. Edition!]Default value: '’ | NO | - |
| Issue | nvarchar (255) | 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]Default value: '’ | NO | - |
| Pages | nvarchar (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]Default value: '’ | NO | - |
| Publisher | nvarchar (255) | The name of the publisher (publishing company or institution, including universities or scientific societies). //[RefMan 17: PB]Default value: '’ | NO | - |
| PublPlace | nvarchar (255) | The location where the item being referenced was published, such as a city and state. //[RefMan 16: CY, CP]Default value: '’ | NO | - |
| Edition | smallint | Number of the edition of a book. Use only positive integer numbers. //[RefMan 12: VL pro parte, compare Volume!] | YES | - |
| DateYear2 | smallint | 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] | YES | - |
| DateMonth2 | smallint | Optional: The month of a secondary date. //[RefMan 28: Y2 pro parte] | YES | - |
| DateDay2 | smallint | Optional: The day of a secondary date. //[RefMan 28: Y2 pro parte] | YES | - |
| DateSuppl2 | nvarchar (255) | 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]Default value: '’ | NO | - |
| ISSN_ISBN | nvarchar (18) | 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]Default value: '’ | NO | - |
| Miscellaneous1 | nvarchar (255) | Various reference type dependent information; e.g. the total number of volumes for books //[RefMan 29: M1]Default value: '’ | NO | - |
| Miscellaneous2 | nvarchar (255) | Various reference type dependent information //[RefMan 30: M2]Default value: '’ | NO | - |
| Miscellaneous3 | nvarchar (255) | Various reference type dependent information //[RefMan 31: M3]Default value: '’ | NO | - |
| UserDef1 | nvarchar (MAX) | User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 18: U1]Default value: '’ | NO | - |
| UserDef2 | nvarchar (MAX) | User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 19: U2]Default value: '’ | NO | - |
| UserDef3 | nvarchar (MAX) | User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 20: U3]Default value: '’ | NO | - |
| UserDef4 | nvarchar (MAX) | User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 21: U4]Default value: '’ | NO | - |
| UserDef5 | nvarchar (MAX) | User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 22: U5]Default value: '' | NO | - |
| WebLinks | nvarchar (MAX) | One or several URLs; use the semicolon as separator (http://www…). A URL may point to a local file (C:\graphic.gif; \servername\Data\x.doc) //[RefMan 33: UR]Default value: '' | NO | - |
| LinkToPDF | nvarchar (MAX) | One or several URLs; use the semicolon as separator (http://www…). A URL may point to a local file (C:\graphic.gif; \servername\Data\x.doc) //[RefMan 34: L1]Default value: '' | NO | - |
| LinkToFullText | nvarchar (MAX) | One or several URLs; use the semicolon as separator (http://www…). A URL may point to a local file (C:\graphic.gif; \servername\Data\x.doc) //[RefMan 35: L2]Default value: '' | NO | - |
| RelatedLinks | nvarchar (MAX) | One or several URLs; use the semicolon as separator (http://www…). A URL may point to a local file (C:\graphic.gif; \servername\Data\x.doc) //[RefMan 36: L3]Default value: '' | NO | - |
| LinkToImages | nvarchar (MAX) | One or several URLs; use the semicolon as separator (http://www…). A URL may point to a local file (C:\graphic.gif; \servername\Data\x.doc) //[RefMan 37: L4]Default value: '' | NO | - |
| SourceRefID | int | * 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! | YES | - |
| Language | nvarchar (25) | * Language of the article/book, as ISO 2 letter codes. //[RefMan: not supported!]Default value: ‘UNK’ | NO | - |
| DuplicateCheck_Cache | nvarchar (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]Default value: '’ | YES | - |
| DuplicateOverride | bit | * 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) | NO | - |
| ReplaceWithRefID | int | * Old RefIDs are maintained to provide stable object links. Instead of direct deletes, users may select a reference to be the valid one, into which all related information (keywords, markers) is merged. | YES | - |
| Problem | nvarchar (4000) | * 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!Default value: '' | NO | - |
| ProblemUpdatedBy | int | * Operator who entered the problem text | YES | - |
| ProblemUpdatedWhen | datetime | * Date and time when problem was recorded | YES | - |
| CitationText | nvarchar (1000) | * 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!Default value: '' | NO | - |
| CitationFrom | nvarchar (255) | * 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!Default value: '' | NO | - |
| ImportedFrom | nvarchar (80) | * 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!Default value: '' | NO | - |
| ImportedID | nvarchar (50) | * 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]Default value: '' | NO | - |
| PlausibilityCheckedBy | int | * 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] | YES | - |
| PlausibilityCheckedWhen | datetime | * 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] | YES | - |
| OriginalComparedBy | int | * Name of user responsible for comparison of ReferenceTitle record with original publication //[RefMan: not applicable. Internal mgmt.attribute] | YES | - |
| OriginalComparedWhen | datetime | * 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] | YES | - |
| DateFrom_Cache | datetime | Calculated field, based on DateYear, DateMonth, DateDay, where missing information is replaced with earliest possible value (e.g. “1999” results in 1.1.1999) | YES | - |
| DateTo_Cache | datetime | Calculated field, based on DateYear, DateMonth, DateDay, where missing information is replaced with latest possible value (e.g. “1999” results in 31.12.1999) | YES | - |
| Date2From_Cache | datetime | Calculated field, based on Date2Year, Date2Month, Date2Day, where missing information is replaced with earliest possible value (e.g. “1999” results in 1.1.1999) | YES | - |
| Date2To_Cache | datetime | Calculated field, based on Date2Year, Date2Month, Date2Day, where missing information is replaced with latest possible value (e.g. “1999” results in 31.12.1999) | YES | - |
| Responsible | int | * Person responsible for entering this reference into the data collectionDefault value: (-1) | NO | - |
| SysRecordVersion | int | (Under trigger control; number automatically increased with every record update, enabling manual version tracking)Default value: (0) | YES | - |
| ParentRefID | int | Refers to the RefID of the superior reference | YES | - |
| LogInsertedBy | nvarchar (50) | ID of the creator of this data setDefault value: [dbo].UserID | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | ID of the person to update this data set lastDefault value: [dbo].UserID | YES | - |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated.Default value: getdate() | YES | - |
Depending on:
- Ref_Type_Enum