/* SQL DDL: Create an implementation of the model using the SQL Data Definition Language */ /* Note: You may want to change some field types to improve the implementation on your DBMS */ /* Comments such as this may not be supported by your system and may have to be removed */ /* Note: Tested with MS SQL Server 2000 and PostgreSQL. The following changes must be made: */ /* MS SQL Server 2000: replace the data type BOOLEAN with BIT */ /* MS SQL Server 2000: replace the SQL92 constant 'current_timestamp' with 'GETDATE()' (= date and time) */ /* MS SQL Server 2000: remove comments around the block of 'exec' statements at end of file to enable creation of column descriptions */ /* PostgreSQL: National Character etc. indicates Unicode text. For Postgres you should create the entire database as Unicode and the 'National' must be removed from the SQL code */ /* PostgreSQL: replace the data type CHARACTER VARYING with VARCHAR */ /* PostgreSQL: replace the data type DATETIME with TIMESTAMP */ /* PostgreSQL: replace the SQL92 constant 'current_timestamp' with 'timestamp('now')' (= date and time) */ /* Note: CREATE INDEX (other than primary, foreign, or unique key constraints) are missing at the moment; to be added later */ /* Generated on 5.Mai.2001 23:59 by Diversity Workbench: Diversity Information Model Documenter, Vers. 1.6 (G. Hagedorn) */ /*=== Table: ReferenceType ===*/ /* 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. */ /* RefType: 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. */ /* Description: A description, explaining the scope and use of the reference type to the user. */ /* LabelSet: 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! */ /* ShowInPicklist: Only reference types selected here are available in a pick list; other types may be entered if the user knows their type code. */ /* Notes: Internal notes regarding the use of a ReferenceTitle type. */ CREATE TABLE ReferenceType ( RefType NATIONAL CHARACTER VARYING(10) NOT NULL PRIMARY KEY, Description NATIONAL CHARACTER VARYING(255) NULL, LabelSet SMALLINT NOT NULL, ShowInPicklist BOOLEAN NOT NULL, Notes NATIONAL CHARACTER VARYING(255) NULL ) /*=== Table: ReferenceAuthor ===*/ /* Literature reference subsystem: Reference authors, book editors, or series editors. */ /* Author: 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!]. */ /* AuthorAddress: 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: Three different author categories are supported: 1 = primary author, 2 = secondary author/editor, 3 = series editor. //[RefMan implicit]. */ /* RefID: Refers to the ID code of the main ReferenceTitle table (= foreign key). */ /* AuthorSequence: 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!). */ CREATE TABLE ReferenceAuthor ( Author NATIONAL CHARACTER VARYING(255) NOT NULL UNIQUE, AuthorAddress NATIONAL CHARACTER VARYING(255) NULL, AuthorType TINYINT NOT NULL UNIQUE DEFAULT 1, RefID NATIONAL CHARACTER VARYING(20) NOT NULL, AuthorSequence INTEGER NOT NULL DEFAULT CLng(99999*(Now()-36800)), PRIMARY KEY (AuthorSequence,RefID) ) /*=== Table: ReferenceAvailability ===*/ /* Literature reference subsystem: Availability and location of reference items in private or official filing system; e.g., book signatures or reprint article availability. */ /* RefID: Refers to the ID code of the main ReferenceTitle table (= foreign key). */ /* FilingCode: 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]. */ /* ReprintStatus: 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]. */ /* RequestDate: Only if ReprintStatus = 'On request' (1/2): The date on which the reprint was requested. //[RefMan 08: RP pro parte]. */ /* Responsible: The person responsible for the signature information, and to which the reprint status/request date refers. //[RefMan: not supported]. */ /* LogCreated_User: 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. */ /* LogCreated_Date: 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]. */ CREATE TABLE ReferenceAvailability ( RefID NATIONAL CHARACTER VARYING(20) NOT NULL, FilingCode NATIONAL CHARACTER VARYING(255) NULL, ReprintStatus TINYINT NOT NULL DEFAULT 0, RequestDate DATETIME NULL, Responsible NATIONAL CHARACTER VARYING(50) NOT NULL, LogCreated_User NATIONAL CHARACTER VARYING(50) NOT NULL, LogCreated_Date DATETIME NOT NULL DEFAULT current_timestamp, PRIMARY KEY (Responsible,RefID) ) /*=== Table: ReferenceKeyword ===*/ /* Literature reference subsystem: Keywords (may include 'subject heading'-keywords and organism names). */ /* RefID: Refers to the ID code of the main ReferenceTitle table (= foreign key). */ /* Keyword: 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]. */ /* Responsible: The person responsible for the assignment of this keyword to a reference. //[RefMan: not supported]. */ CREATE TABLE ReferenceKeyword ( RefID NATIONAL CHARACTER VARYING(20) NOT NULL, Keyword NATIONAL CHARACTER VARYING(255) NOT NULL, Responsible NATIONAL CHARACTER VARYING(50) NOT NULL, PRIMARY KEY (Keyword,RefID) ) /*=== Table: ReferenceProjectMarker ===*/ /* Literature reference subsystem: Project specific markers, to declare that references are used or checked by a specific project. */ /* RefID: Refers to the ID code of the main ReferenceTitle table (= foreign key). */ /* Project: Project specific marker, e.g. to mark up a reference for a specific project or for a publication. */ /* Responsible: The person responsible for the assignment of this project marker to a reference. //[RefMan: not supported]. */ CREATE TABLE ReferenceProjectMarker ( RefID NATIONAL CHARACTER VARYING(20) NOT NULL, Project NATIONAL CHARACTER VARYING(25) NOT NULL, Responsible NATIONAL CHARACTER VARYING(50) NOT NULL, PRIMARY KEY (Project,RefID) ) /*=== Table: ReferenceManagerUserDefined ===*/ /* Literature reference subsystem: User defined fields originating form imported Reference Manager RIS files. */ /* RefID: Refers to the ID code of the main ReferenceTitle table (= foreign key). */ /* Responsible: The person responsible for the user defined fields (usually who imported the RIS file). */ /* UserDef1: User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 18: U1]. */ /* UserDef2: User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 19: U2]. */ /* UserDef3: User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 20: U3]. */ /* UserDef4: User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 21: U4]. */ /* UserDef5: User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 22: U5]. */ CREATE TABLE ReferenceManagerUserDefined ( RefID NATIONAL CHARACTER VARYING(20) NOT NULL, Responsible NATIONAL CHARACTER VARYING(50) NOT NULL, UserDef1 NATIONAL TEXT NULL, UserDef2 NATIONAL TEXT NULL, UserDef3 NATIONAL TEXT NULL, UserDef4 NATIONAL TEXT NULL, UserDef5 NATIONAL TEXT NULL, PRIMARY KEY (Responsible,RefID) ) /*=== Table: ReferenceChanges ===*/ /* Literature reference subsystem: All changes of references are logged here (user, date, fields affected). */ /* RefID: Refers to the ID code of the main ReferenceTitle table (= foreign key). */ /* Changes: * Attributes and/or data affected by changes. //[RefMan: not applicable. Internal mgmt.attribute]. */ /* LogUpdated_User: * 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]. */ /* LogUpdated_Date: * Date and time of last update of the record. //[RefMan: not applicable. Internal mgmt.attribute]. */ CREATE TABLE ReferenceChanges ( RefID NATIONAL CHARACTER VARYING(20) NOT NULL, Changes NATIONAL TEXT NOT NULL, LogUpdated_User NATIONAL CHARACTER VARYING(50) NOT NULL, LogUpdated_Date DATETIME NOT NULL, PRIMARY KEY (LogUpdated_Date,RefID) ) /*=== Table: ReferenceUserNote ===*/ /* Literature reference subsystem: User specific notes. Each user will only see the notes entered under the same responsible user name. */ /* RefID: Refers to the ID code of the main ReferenceTitle table (= foreign key). */ /* Responsible: * The person responsible for the Notes. //[RefMan: not supported]. */ /* Notes: Internal notes regarding the reference title. Notes will normally be visible only under the same Responsible login name. //[RefMan 06: N1, AB]. */ /* LogCreated_User: * 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]. */ /* LogCreated_Date: * 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]. */ CREATE TABLE ReferenceUserNote ( RefID NATIONAL CHARACTER VARYING(20) NOT NULL, Responsible NATIONAL CHARACTER VARYING(50) NOT NULL, Notes NATIONAL TEXT NOT NULL, LogCreated_User NATIONAL CHARACTER VARYING(50) NOT NULL, LogCreated_Date DATETIME NOT NULL DEFAULT current_timestamp, PRIMARY KEY (RefID,Responsible) ) /*=== Table: ReferencePeriodicalSyn ===*/ /* 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. */ /* Synonym: Alternative, synonymous names for the main record. Automatically translated into StdAbbrev if a thesaurus pick list is used in forms. //[RefMan 11: J1, J2]. */ /* Abbreviation: Standardized abbreviation of periodical or journal, as defined in RefPeriodical entity (= foreign key). */ /* Source: 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.). */ CREATE TABLE ReferencePeriodicalSyn ( Synonym NATIONAL CHARACTER VARYING(255) NOT NULL PRIMARY KEY, Abbreviation NATIONAL CHARACTER VARYING(255) NOT NULL, Source NATIONAL CHARACTER VARYING(50) NOT NULL ) /*=== Table: ReferenceAbstract ===*/ /* Literature reference subsystem: Public Abstracts. */ /* RefID: Refers to the ID code of the main ReferenceTitle table (= foreign key). */ /* Responsible: * 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]. */ /* Language: * Language of the abstract, as ISO 2 letter codes. //[RefMan : not supported!]. */ /* Abstract: An abstract containing a short summary of the content of the article or book //[RefMan 25: N2]. */ /* Shareable: * Do you want to share your abstract with other users, i.e. can it be published on the web? //[RefMan : not supported!]. */ /* LogCreated_User: * 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]. */ /* LogCreated_Date: * 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]. */ CREATE TABLE ReferenceAbstract ( RefID NATIONAL CHARACTER VARYING(20) NOT NULL, Responsible NATIONAL CHARACTER VARYING(50) NOT NULL, Language NATIONAL CHARACTER VARYING(20) NOT NULL DEFAULT '?', Abstract NATIONAL TEXT NOT NULL, Shareable BOOLEAN NOT NULL DEFAULT 0, LogCreated_User NATIONAL CHARACTER VARYING(50) NOT NULL, LogCreated_Date DATETIME NOT NULL DEFAULT current_timestamp, PRIMARY KEY (RefID,Responsible,Language) ) /*=== Table: ReferencePeriodical ===*/ /* Literature reference subsystem: Journal/periodical titles. */ /* Abbreviation: Standardized abbreviation of periodical or journal. Use periods after the abbreviations //[RefMan 11: JA, JO]. */ /* FullName: Full, non-abbreviated name of periodical or journal //[RefMan 11: JF, JO]. */ /* Notes: Notes, remarks, or comments regarding the journal/periodical as a whole, incl. "continued as (new title)" or notes about local availability. */ /* LogCreated_User: 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. */ /* LogCreated_Date: Date and time when record was first entered (typed or imported) into this system. */ /* s_GUID: (system attribute used in database replication). */ /* s_Generation: (system attribute used in database replication). */ /* s_Lineage: (system attribute used in database replication). */ CREATE TABLE ReferencePeriodical ( Abbreviation NATIONAL CHARACTER VARYING(255) NOT NULL PRIMARY KEY, FullName NATIONAL CHARACTER VARYING(255) NULL, Notes NATIONAL TEXT NULL, LogCreated_User NATIONAL CHARACTER VARYING(50) NOT NULL, LogCreated_Date DATETIME NOT NULL DEFAULT current_timestamp, s_GUID UNIQUEIDENTIFIER NULL UNIQUE, s_Generation INTEGER NULL, s_Lineage IMAGE NULL ) /*=== Table: ReferenceTitle ===*/ /* Literature reference subsystem: Main entity; compatible with Reference Manager™ v.9. */ /* RefType: Type of literature reference, determines which fields are available for data entry. The value must come from the pick list provided. //[RefMan 01: TY]. */ /* RefID: Unique reference ID code for the reference record. The only characters allowed are '0'-'9' and 'A'-'Z' //[RefMan 02: ID]. */ /* RefDescription: * 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]. */ /* Title: 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: 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]. */ /* DateMonth: 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]. */ /* DateDay: 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]. */ /* DateSuppl: 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]. */ /* DateSecondary: 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: 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: 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]. */ /* Periodical: Journal/periodical in which the article appeared. Linked to the Abbreviation attribute of ReferencePeriodical. //[RefMan 11: JF, JO, JA]. */ /* Volume: The volume (for periodicals or journals, excluding the issue number), report number, etc. //[RefMan 12: VL pro parte, comp. Edition!]. */ /* Issue: The issue, if any. Useful to enter a special designation for a supplement, for example '45 (Suppl.)'. //[RefMan 15: IS]. */ /* Pages: 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: The name of the publisher (publishing company or institution, including universities or scientific societies). //[RefMan 17: PB]. */ /* PublPlace: The location where the item being referenced was published, such as a city and state. //[RefMan 16: CY, CP]. */ /* Edition: Number of the edition of a book. Use only positive integer numbers. //[RefMan 12: VL pro parte, compare Volume!]. */ /* ISSN_ISBN: The 'International Standard Serial Number' or 'International Standard Book Number'. //[RefMan 26: SN]. */ /* Miscellaneous1: Various reference type dependent information; e.g. the total number of volumes for books //[RefMan 29: M1]. */ /* Miscellaneous2: Various reference type dependent information //[RefMan 30: M2]. */ /* Miscellaneous3: Various reference type dependent information //[RefMan 31: M3]. */ /* URL: URL address (http://www...) or local file (C:\graphic.gif; \\Oudemans\Data\x.doc) //[RefMan 33: UR]. */ /* SourceRefID: * 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: * Language of the article/book, as ISO 2 letter codes. //[RefMan: not supported!]. */ /* DuplicateCheck: * 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]. */ /* DuplicateOverride: * 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]. */ /* ReplaceWithRefID: * 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: * 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: * Name of operator who entered the problem text. */ /* Problem_Date: * Date and time when problem was recorded. */ /* RefCitationFrom: * 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! */ /* RefImportedFrom: * 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: * 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: * 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 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: * Name of user responsible for comparison of ReferenceTitle record with original publication //[RefMan: not applicable. Internal mgmt.attribute]. */ /* CheckOriginal_Date: * 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: * 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]. */ /* LogCreated_Date: * 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]. */ /* s_GUID: * Globally Unique ReferenceTitle Identifier, system assigned number to identify this record (system attribute used in database replication). */ /* s_Generation: (system attribute used in database replication). */ /* s_Lineage: (system attribute used in database replication). */ CREATE TABLE ReferenceTitle ( RefType NATIONAL CHARACTER VARYING(10) NOT NULL DEFAULT 'JOUR', RefID NATIONAL CHARACTER VARYING(20) NOT NULL PRIMARY KEY, RefDescription NATIONAL CHARACTER VARYING(120) NULL, Title NATIONAL TEXT NULL, DateYear SMALLINT NULL, DateMonth TINYINT NULL, DateDay TINYINT NULL, DateSuppl NATIONAL CHARACTER VARYING(255) NULL, DateSecondary NATIONAL CHARACTER VARYING(255) NULL, SourceTitle NATIONAL TEXT NULL, SeriesTitle NATIONAL CHARACTER VARYING(255) NULL, Periodical NATIONAL CHARACTER VARYING(255) NULL, Volume NATIONAL CHARACTER VARYING(255) NULL, Issue NATIONAL CHARACTER VARYING(255) NULL, Pages NATIONAL CHARACTER VARYING(255) NULL, Publisher NATIONAL CHARACTER VARYING(255) NULL, PublPlace NATIONAL CHARACTER VARYING(255) NULL, Edition SMALLINT NULL, ISSN_ISBN NATIONAL CHARACTER VARYING(15) NULL, Miscellaneous1 NATIONAL CHARACTER VARYING(255) NULL, Miscellaneous2 NATIONAL CHARACTER VARYING(255) NULL, Miscellaneous3 NATIONAL CHARACTER VARYING(255) NULL, URL NATIONAL TEXT NULL, SourceRefID NATIONAL CHARACTER VARYING(20) NULL, Language NATIONAL CHARACTER VARYING(20) NOT NULL DEFAULT '?', DuplicateCheck NATIONAL CHARACTER VARYING(255) NULL UNIQUE, DuplicateOverride TINYINT NOT NULL DEFAULT 0, ReplaceWithRefID NATIONAL CHARACTER VARYING(20) NULL, Problem NATIONAL TEXT NULL, Problem_User NATIONAL CHARACTER VARYING(50) NULL, Problem_Date DATETIME NULL, RefCitationFrom NATIONAL CHARACTER VARYING(255) NULL, RefImportedFrom NATIONAL CHARACTER VARYING(50) NULL, RefImportedID NATIONAL CHARACTER VARYING(50) NULL, CheckPlausible_User NATIONAL CHARACTER VARYING(50) NULL, CheckPlausible_Date DATETIME NULL, CheckOriginal_User NATIONAL CHARACTER VARYING(50) NULL, CheckOriginal_Date DATETIME NULL, LogCreated_User NATIONAL CHARACTER VARYING(50) NOT NULL, LogCreated_Date DATETIME NOT NULL DEFAULT current_timestamp, s_GUID UNIQUEIDENTIFIER NULL UNIQUE, s_Generation INTEGER NULL, s_Lineage IMAGE NULL ) /*=== Table: ReferenceUserMarker ===*/ /* Literature reference subsystem: User specific markers, e.g. to mark up a reference for a publication. */ /* RefID: Refers to the ID code of the main ReferenceTitle table (= foreign key). */ /* Marker: * 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. */ /* Responsible: * The person responsible for the assignment of this user marker to a reference. Normally each person sees only his or her own markers! */ CREATE TABLE ReferenceUserMarker ( RefID NATIONAL CHARACTER VARYING(20) NOT NULL, Marker NATIONAL CHARACTER VARYING(255) NOT NULL, Responsible NATIONAL CHARACTER VARYING(50) NOT NULL, PRIMARY KEY (Marker,RefID,Responsible) ) /*=== Table: ReferenceWordIdx1 ===*/ /* 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. */ /* Word: Words > 50 character are truncated! */ CREATE TABLE ReferenceWordIdx1 ( Word NATIONAL CHARACTER VARYING(50) NOT NULL, RefID NATIONAL CHARACTER VARYING(20) NOT NULL, PRIMARY KEY (Word,RefID) ) /*=== Table: ReferenceWordIdx2 ===*/ /* 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. */ /* Word: Words > 50 character are truncated! */ CREATE TABLE ReferenceWordIdx2 ( Word NATIONAL CHARACTER VARYING(50) NOT NULL, RefID NATIONAL CHARACTER VARYING(20) NOT NULL, PRIMARY KEY (Word,RefID) ) ALTER TABLE ReferenceAuthor ADD FOREIGN KEY (RefID) REFERENCES ReferenceTitle (RefID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ReferenceAvailability ADD FOREIGN KEY (RefID) REFERENCES ReferenceTitle (RefID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ReferenceKeyword ADD FOREIGN KEY (RefID) REFERENCES ReferenceTitle (RefID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ReferenceProjectMarker ADD FOREIGN KEY (RefID) REFERENCES ReferenceTitle (RefID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ReferenceManagerUserDefined ADD FOREIGN KEY (RefID) REFERENCES ReferenceTitle (RefID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ReferenceChanges ADD FOREIGN KEY (RefID) REFERENCES ReferenceTitle (RefID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ReferenceUserNote ADD FOREIGN KEY (RefID) REFERENCES ReferenceTitle (RefID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ReferencePeriodicalSyn ADD FOREIGN KEY (Abbreviation) REFERENCES ReferencePeriodical (Abbreviation) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ReferenceAbstract ADD FOREIGN KEY (RefID) REFERENCES ReferenceTitle (RefID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ReferenceTitle ADD FOREIGN KEY (SourceRefID) REFERENCES ReferenceTitle (RefID) ON UPDATE CASCADE, FOREIGN KEY (RefType) REFERENCES ReferenceType (RefType) ON UPDATE CASCADE ALTER TABLE ReferenceUserMarker ADD FOREIGN KEY (RefID) REFERENCES ReferenceTitle (RefID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ReferenceWordIdx1 ADD FOREIGN KEY (RefID) REFERENCES ReferenceTitle (RefID) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE ReferenceWordIdx2 ADD FOREIGN KEY (RefID) REFERENCES ReferenceTitle (RefID) ON UPDATE CASCADE ON DELETE CASCADE /*** Remove this comment line to enable creation of column description for MS SQL Server 2000 *** exec sp_addextendedproperty N'MS_Description',N'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.',N'user',N'dbo',N'table',N'ReferenceType',N'column',N'RefType' exec sp_addextendedproperty N'MS_Description',N'A description, explaining the scope and use of the reference type to the user.',N'user',N'dbo',N'table',N'ReferenceType',N'column',N'Description' exec sp_addextendedproperty N'MS_Description',N'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!',N'user',N'dbo',N'table',N'ReferenceType',N'column',N'LabelSet' exec sp_addextendedproperty N'MS_Description',N'Only reference types selected here are available in a pick list; other types may be entered if the user knows their type code.',N'user',N'dbo',N'table',N'ReferenceType',N'column',N'ShowInPicklist' exec sp_addextendedproperty N'MS_Description',N'Internal notes regarding the use of a ReferenceTitle type.',N'user',N'dbo',N'table',N'ReferenceType',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'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!].',N'user',N'dbo',N'table',N'ReferenceAuthor',N'column',N'Author' exec sp_addextendedproperty N'MS_Description',N'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].',N'user',N'dbo',N'table',N'ReferenceAuthor',N'column',N'AuthorAddress' exec sp_addextendedproperty N'MS_Description',N'Three different author categories are supported: 1 = primary author, 2 = secondary author/editor, 3 = series editor. //[RefMan implicit].',N'user',N'dbo',N'table',N'ReferenceAuthor',N'column',N'AuthorType' exec sp_addextendedproperty N'MS_Description',N'Refers to the ID code of the main ReferenceTitle table (= foreign key).',N'user',N'dbo',N'table',N'ReferenceAuthor',N'column',N'RefID' exec sp_addextendedproperty N'MS_Description',N'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!).',N'user',N'dbo',N'table',N'ReferenceAuthor',N'column',N'AuthorSequence' exec sp_addextendedproperty N'MS_Description',N'Refers to the ID code of the main ReferenceTitle table (= foreign key).',N'user',N'dbo',N'table',N'ReferenceAvailability',N'column',N'RefID' exec sp_addextendedproperty N'MS_Description',N'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].',N'user',N'dbo',N'table',N'ReferenceAvailability',N'column',N'FilingCode' exec sp_addextendedproperty N'MS_Description',N'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].',N'user',N'dbo',N'table',N'ReferenceAvailability',N'column',N'ReprintStatus' exec sp_addextendedproperty N'MS_Description',N'Only if ReprintStatus = ''On request'' (1/2): The date on which the reprint was requested. //[RefMan 08: RP pro parte].',N'user',N'dbo',N'table',N'ReferenceAvailability',N'column',N'RequestDate' exec sp_addextendedproperty N'MS_Description',N'The person responsible for the signature information, and to which the reprint status/request date refers. //[RefMan: not supported].',N'user',N'dbo',N'table',N'ReferenceAvailability',N'column',N'Responsible' exec sp_addextendedproperty N'MS_Description',N'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.',N'user',N'dbo',N'table',N'ReferenceAvailability',N'column',N'LogCreated_User' exec sp_addextendedproperty N'MS_Description',N'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].',N'user',N'dbo',N'table',N'ReferenceAvailability',N'column',N'LogCreated_Date' exec sp_addextendedproperty N'MS_Description',N'Refers to the ID code of the main ReferenceTitle table (= foreign key).',N'user',N'dbo',N'table',N'ReferenceKeyword',N'column',N'RefID' exec sp_addextendedproperty N'MS_Description',N'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].',N'user',N'dbo',N'table',N'ReferenceKeyword',N'column',N'Keyword' exec sp_addextendedproperty N'MS_Description',N'The person responsible for the assignment of this keyword to a reference. //[RefMan: not supported].',N'user',N'dbo',N'table',N'ReferenceKeyword',N'column',N'Responsible' exec sp_addextendedproperty N'MS_Description',N'Refers to the ID code of the main ReferenceTitle table (= foreign key).',N'user',N'dbo',N'table',N'ReferenceProjectMarker',N'column',N'RefID' exec sp_addextendedproperty N'MS_Description',N'Project specific marker, e.g. to mark up a reference for a specific project or for a publication.',N'user',N'dbo',N'table',N'ReferenceProjectMarker',N'column',N'Project' exec sp_addextendedproperty N'MS_Description',N'The person responsible for the assignment of this project marker to a reference. //[RefMan: not supported].',N'user',N'dbo',N'table',N'ReferenceProjectMarker',N'column',N'Responsible' exec sp_addextendedproperty N'MS_Description',N'Refers to the ID code of the main ReferenceTitle table (= foreign key).',N'user',N'dbo',N'table',N'ReferenceManagerUserDefined',N'column',N'RefID' exec sp_addextendedproperty N'MS_Description',N'The person responsible for the user defined fields (usually who imported the RIS file).',N'user',N'dbo',N'table',N'ReferenceManagerUserDefined',N'column',N'Responsible' exec sp_addextendedproperty N'MS_Description',N'User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 18: U1].',N'user',N'dbo',N'table',N'ReferenceManagerUserDefined',N'column',N'UserDef1' exec sp_addextendedproperty N'MS_Description',N'User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 19: U2].',N'user',N'dbo',N'table',N'ReferenceManagerUserDefined',N'column',N'UserDef2' exec sp_addextendedproperty N'MS_Description',N'User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 20: U3].',N'user',N'dbo',N'table',N'ReferenceManagerUserDefined',N'column',N'UserDef3' exec sp_addextendedproperty N'MS_Description',N'User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 21: U4].',N'user',N'dbo',N'table',N'ReferenceManagerUserDefined',N'column',N'UserDef4' exec sp_addextendedproperty N'MS_Description',N'User defined fields as entered in Reference Manager, only provided for import/export compatibility and not supported beyond that. //[RefMan 22: U5].',N'user',N'dbo',N'table',N'ReferenceManagerUserDefined',N'column',N'UserDef5' exec sp_addextendedproperty N'MS_Description',N'Refers to the ID code of the main ReferenceTitle table (= foreign key).',N'user',N'dbo',N'table',N'ReferenceChanges',N'column',N'RefID' exec sp_addextendedproperty N'MS_Description',N'* Attributes and/or data affected by changes. //[RefMan: not applicable. Internal mgmt.attribute].',N'user',N'dbo',N'table',N'ReferenceChanges',N'column',N'Changes' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceChanges',N'column',N'LogUpdated_User' exec sp_addextendedproperty N'MS_Description',N'* Date and time of last update of the record. //[RefMan: not applicable. Internal mgmt.attribute].',N'user',N'dbo',N'table',N'ReferenceChanges',N'column',N'LogUpdated_Date' exec sp_addextendedproperty N'MS_Description',N'Refers to the ID code of the main ReferenceTitle table (= foreign key).',N'user',N'dbo',N'table',N'ReferenceUserNote',N'column',N'RefID' exec sp_addextendedproperty N'MS_Description',N'* The person responsible for the Notes. //[RefMan: not supported].',N'user',N'dbo',N'table',N'ReferenceUserNote',N'column',N'Responsible' exec sp_addextendedproperty N'MS_Description',N'Internal notes regarding the reference title. Notes will normally be visible only under the same Responsible login name. //[RefMan 06: N1, AB].',N'user',N'dbo',N'table',N'ReferenceUserNote',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceUserNote',N'column',N'LogCreated_User' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceUserNote',N'column',N'LogCreated_Date' exec sp_addextendedproperty N'MS_Description',N'Alternative, synonymous names for the main record. Automatically translated into StdAbbrev if a thesaurus pick list is used in forms. //[RefMan 11: J1, J2].',N'user',N'dbo',N'table',N'ReferencePeriodicalSyn',N'column',N'Synonym' exec sp_addextendedproperty N'MS_Description',N'Standardized abbreviation of periodical or journal, as defined in RefPeriodical entity (= foreign key).',N'user',N'dbo',N'table',N'ReferencePeriodicalSyn',N'column',N'Abbreviation' exec sp_addextendedproperty N'MS_Description',N'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.).',N'user',N'dbo',N'table',N'ReferencePeriodicalSyn',N'column',N'Source' exec sp_addextendedproperty N'MS_Description',N'Refers to the ID code of the main ReferenceTitle table (= foreign key).',N'user',N'dbo',N'table',N'ReferenceAbstract',N'column',N'RefID' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceAbstract',N'column',N'Responsible' exec sp_addextendedproperty N'MS_Description',N'* Language of the abstract, as ISO 2 letter codes. //[RefMan : not supported!].',N'user',N'dbo',N'table',N'ReferenceAbstract',N'column',N'Language' exec sp_addextendedproperty N'MS_Description',N'An abstract containing a short summary of the content of the article or book //[RefMan 25: N2].',N'user',N'dbo',N'table',N'ReferenceAbstract',N'column',N'Abstract' exec sp_addextendedproperty N'MS_Description',N'* Do you want to share your abstract with other users, i.e. can it be published on the web? //[RefMan : not supported!].',N'user',N'dbo',N'table',N'ReferenceAbstract',N'column',N'Shareable' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceAbstract',N'column',N'LogCreated_User' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceAbstract',N'column',N'LogCreated_Date' exec sp_addextendedproperty N'MS_Description',N'Standardized abbreviation of periodical or journal. Use periods after the abbreviations //[RefMan 11: JA, JO].',N'user',N'dbo',N'table',N'ReferencePeriodical',N'column',N'Abbreviation' exec sp_addextendedproperty N'MS_Description',N'Full, non-abbreviated name of periodical or journal //[RefMan 11: JF, JO].',N'user',N'dbo',N'table',N'ReferencePeriodical',N'column',N'FullName' exec sp_addextendedproperty N'MS_Description',N'Notes, remarks, or comments regarding the journal/periodical as a whole, incl. "continued as (new title)" or notes about local availability.',N'user',N'dbo',N'table',N'ReferencePeriodical',N'column',N'Notes' exec sp_addextendedproperty N'MS_Description',N'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.',N'user',N'dbo',N'table',N'ReferencePeriodical',N'column',N'LogCreated_User' exec sp_addextendedproperty N'MS_Description',N'Date and time when record was first entered (typed or imported) into this system.',N'user',N'dbo',N'table',N'ReferencePeriodical',N'column',N'LogCreated_Date' exec sp_addextendedproperty N'MS_Description',N'(system attribute used in database replication).',N'user',N'dbo',N'table',N'ReferencePeriodical',N'column',N's_GUID' exec sp_addextendedproperty N'MS_Description',N'(system attribute used in database replication).',N'user',N'dbo',N'table',N'ReferencePeriodical',N'column',N's_Generation' exec sp_addextendedproperty N'MS_Description',N'(system attribute used in database replication).',N'user',N'dbo',N'table',N'ReferencePeriodical',N'column',N's_Lineage' exec sp_addextendedproperty N'MS_Description',N'Type of literature reference, determines which fields are available for data entry. The value must come from the pick list provided. //[RefMan 01: TY].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'RefType' exec sp_addextendedproperty N'MS_Description',N'Unique reference ID code for the reference record. The only characters allowed are ''0''-''9'' and ''A''-''Z'' //[RefMan 02: ID].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'RefID' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'RefDescription' exec sp_addextendedproperty N'MS_Description',N'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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'Title' exec sp_addextendedproperty N'MS_Description',N'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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'DateYear' exec sp_addextendedproperty N'MS_Description',N'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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'DateMonth' exec sp_addextendedproperty N'MS_Description',N'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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'DateDay' exec sp_addextendedproperty N'MS_Description',N'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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'DateSuppl' exec sp_addextendedproperty N'MS_Description',N'A secondary date, esp. the true publ. date where relevant for nomenclatural priority (usage in Reference Manager seems to be undefined...) //[RefMan 28: Y2].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'DateSecondary' exec sp_addextendedproperty N'MS_Description',N'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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'SourceTitle' exec sp_addextendedproperty N'MS_Description',N'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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'SeriesTitle' exec sp_addextendedproperty N'MS_Description',N'Journal/periodical in which the article appeared. Linked to the Abbreviation attribute of ReferencePeriodical. //[RefMan 11: JF, JO, JA].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'Periodical' exec sp_addextendedproperty N'MS_Description',N'The volume (for periodicals or journals, excluding the issue number), report number, etc. //[RefMan 12: VL pro parte, comp. Edition!].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'Volume' exec sp_addextendedproperty N'MS_Description',N'The issue, if any. Useful to enter a special designation for a supplement, for example ''45 (Suppl.)''. //[RefMan 15: IS].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'Issue' exec sp_addextendedproperty N'MS_Description',N'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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'Pages' exec sp_addextendedproperty N'MS_Description',N'The name of the publisher (publishing company or institution, including universities or scientific societies). //[RefMan 17: PB].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'Publisher' exec sp_addextendedproperty N'MS_Description',N'The location where the item being referenced was published, such as a city and state. //[RefMan 16: CY, CP].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'PublPlace' exec sp_addextendedproperty N'MS_Description',N'Number of the edition of a book. Use only positive integer numbers. //[RefMan 12: VL pro parte, compare Volume!].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'Edition' exec sp_addextendedproperty N'MS_Description',N'The ''International Standard Serial Number'' or ''International Standard Book Number''. //[RefMan 26: SN].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'ISSN_ISBN' exec sp_addextendedproperty N'MS_Description',N'Various reference type dependent information; e.g. the total number of volumes for books //[RefMan 29: M1].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'Miscellaneous1' exec sp_addextendedproperty N'MS_Description',N'Various reference type dependent information //[RefMan 30: M2].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'Miscellaneous2' exec sp_addextendedproperty N'MS_Description',N'Various reference type dependent information //[RefMan 31: M3].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'Miscellaneous3' exec sp_addextendedproperty N'MS_Description',N'URL address (http://www...) or local file (C:\graphic.gif; \\Oudemans\Data\x.doc) //[RefMan 33: UR].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'URL' exec sp_addextendedproperty N'MS_Description',N'* 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!',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'SourceRefID' exec sp_addextendedproperty N'MS_Description',N'* Language of the article/book, as ISO 2 letter codes. //[RefMan: not supported!].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'Language' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'DuplicateCheck' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'DuplicateOverride' exec sp_addextendedproperty N'MS_Description',N'* 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.',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'ReplaceWithRefID' exec sp_addextendedproperty N'MS_Description',N'* 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!',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'Problem' exec sp_addextendedproperty N'MS_Description',N'* Name of operator who entered the problem text.',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'Problem_User' exec sp_addextendedproperty N'MS_Description',N'* Date and time when problem was recorded.',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'Problem_Date' exec sp_addextendedproperty N'MS_Description',N'* 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!',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'RefCitationFrom' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'RefImportedFrom' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'RefImportedID' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'CheckPlausible_User' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'CheckPlausible_Date' exec sp_addextendedproperty N'MS_Description',N'* Name of user responsible for comparison of ReferenceTitle record with original publication //[RefMan: not applicable. Internal mgmt.attribute].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'CheckOriginal_User' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'CheckOriginal_Date' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'LogCreated_User' exec sp_addextendedproperty N'MS_Description',N'* 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].',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N'LogCreated_Date' exec sp_addextendedproperty N'MS_Description',N'* Globally Unique ReferenceTitle Identifier, system assigned number to identify this record (system attribute used in database replication).',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N's_GUID' exec sp_addextendedproperty N'MS_Description',N'(system attribute used in database replication).',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N's_Generation' exec sp_addextendedproperty N'MS_Description',N'(system attribute used in database replication).',N'user',N'dbo',N'table',N'ReferenceTitle',N'column',N's_Lineage' exec sp_addextendedproperty N'MS_Description',N'Refers to the ID code of the main ReferenceTitle table (= foreign key).',N'user',N'dbo',N'table',N'ReferenceUserMarker',N'column',N'RefID' exec sp_addextendedproperty N'MS_Description',N'* 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.',N'user',N'dbo',N'table',N'ReferenceUserMarker',N'column',N'Marker' exec sp_addextendedproperty N'MS_Description',N'* The person responsible for the assignment of this user marker to a reference. Normally each person sees only his or her own markers!',N'user',N'dbo',N'table',N'ReferenceUserMarker',N'column',N'Responsible' exec sp_addextendedproperty N'MS_Description',N'Words > 50 character are truncated!',N'user',N'dbo',N'table',N'ReferenceWordIdx1',N'column',N'Word' exec sp_addextendedproperty N'MS_Description',N'Words > 50 character are truncated!',N'user',N'dbo',N'table',N'ReferenceWordIdx2',N'column',N'Word' GO *** Remove this comment line to enable creation of column description for MS SQL Server 2000 ***/