/usr/share/doc/refdb/refdb-manual/ch16s02.html is in refdb-doc 1.0.2-3ubuntu1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 | <?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>The table t_refdb</title><link rel="stylesheet" type="text/css" href="manual.css" /><meta name="generator" content="DocBook XSL Stylesheets V1.79.1" /><link rel="home" href="index.html" title="RefDB handbook" /><link rel="up" href="ch16.html" title="Chapter 16. Reference database design" /><link rel="prev" href="ch16.html" title="Chapter 16. Reference database design" /><link rel="next" href="ch16s03.html" title="The table t_author" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">The table t_refdb</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch16.html">Prev</a> </td><th width="60%" align="center">Chapter 16. Reference database design</th><td width="20%" align="right"> <a accesskey="n" href="ch16s03.html">Next</a></td></tr></table><hr /></div><div class="sect1"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="t-refdb"></a>The table t_refdb</h2></div></div></div><p>This table is the main table of the database and holds all fields which are unique to one reference entry and not different between users.</p><p>This table contains the following columns:</p><div class="variablelist"><dl class="variablelist"><dt><span class="term">refdb_id</span></dt><dd><p>This unique identifier for entries in t_refdb is automatically generated by refdb and is stored as a BIGINT value (INTEGER for SQLite).</p></dd><dt><span class="term">refdb_citekey</span></dt><dd><p>This is a user-supplied unique identifier for entries in t_refdb. If not supplied by the user, RefDB will create a unique identifier when the entry is added.</p></dd><dt><span class="term">refdb_type</span></dt><dd><p>This indicates the type of the document. This six-character string must be one of the following:</p><div class="itemizedlist"><ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>ABST (abstract reference)</p></li><li class="listitem"><p>ADVS (audiovisual material)</p></li><li class="listitem"><p>ART (art work)</p></li><li class="listitem"><p>BILL (bill/resolution)</p></li><li class="listitem"><p>BOOK (whole book reference)</p></li><li class="listitem"><p>CASE (case)</p></li><li class="listitem"><p>CHAP (book chapter reference)</p></li><li class="listitem"><p>COMP (computer program)</p></li><li class="listitem"><p>CONF (conference proceeding)</p></li><li class="listitem"><p>CTLG (catalog)</p></li><li class="listitem"><p>DATA (data file)</p></li><li class="listitem"><p>ELEC (electronic citation)</p></li><li class="listitem"><p>GEN (generic)</p></li><li class="listitem"><p>ICOMM (internet communication)</p></li><li class="listitem"><p>INPR (in press reference)</p></li><li class="listitem"><p>JFULL (journal - full)</p></li><li class="listitem"><p>JOUR (journal reference)</p></li><li class="listitem"><p>MAP (map)</p></li><li class="listitem"><p>MGZN (magazine article)</p></li><li class="listitem"><p>MPCT (motion picture)</p></li><li class="listitem"><p>MUSIC (music score)</p></li><li class="listitem"><p>NEWS (newspaper)</p></li><li class="listitem"><p>PAMP (pamphlet)</p></li><li class="listitem"><p>PAT (patent)</p></li><li class="listitem"><p>PCOMM (personal communication)</p></li><li class="listitem"><p>RPRT (report)</p></li><li class="listitem"><p>SER (serial - book, monograph)</p></li><li class="listitem"><p>SLIDE (slide)</p></li><li class="listitem"><p>SOUND (sound recording)</p></li><li class="listitem"><p>STAT (statute)</p></li><li class="listitem"><p>THES (thesis/dissertation)</p></li><li class="listitem"><p>UNBILL (unenacted bill/resolution)</p></li><li class="listitem"><p>UNPB (unpublished work reference)</p></li><li class="listitem"><p>VIDEO (video recording)</p></li></ul></div></dd><dt><span class="term">refdb_pubyear</span></dt><dd><p>This numerical value (SMALLINT) indicates the publication year.</p></dd><dt><span class="term">refdb_secyear</span></dt><dd><p>This numerical value (SMALLINT) indicates the secondary year information.</p></dd><dt><span class="term">refdb_startpage</span></dt><dd><p>This alphanumeric string (up to 255 characters) contains the start page information.</p></dd><dt><span class="term">refdb_endpage</span></dt><dd><p>This alphanumeric string (up to 255 characters) contains the end page information.</p></dd><dt><span class="term">refdb_abstract</span></dt><dd><p>This variable-length string contains the abstract or table of contents of the entry.</p></dd><dt><span class="term">refdb_title</span></dt><dd><p>This alphanumeric field of variable length contains the title of the entry.</p></dd><dt><span class="term">refdb_volume</span></dt><dd><p>This alphanumeric field (up to 255 characters) contains the volume number or identifier of the periodical.</p></dd><dt><span class="term">refdb_issue</span></dt><dd><p>This alphanumeric field (up to 255 characters) contains the issue number or specifier.</p></dd><dt><span class="term">refdb_booktitle</span></dt><dd><p>This alphanumeric field of variable length contains the book title (book chapter or whole book reference).</p></dd><dt><span class="term">refdb_city</span></dt><dd><p>This alphanumeric field (up to 255 characters) contains the city where the periodical or book was published.</p></dd><dt><span class="term">refdb_publisher</span></dt><dd><p>This alphanumeric field (up to 255 characters) contains the name of the publisher.</p></dd><dt><span class="term">refdb_title_series</span></dt><dd><p>This alphanumerical field of variable length contains the title of a series of books or publications.</p></dd><dt><span class="term">refdb_address</span></dt><dd><p>This alphanumeric field of variable length holds the address of the corresponding author and other contact information.</p></dd><dt><span class="term">refdb_url</span></dt><dd><p>This alphanumeric field (up to 255 characters) holds a URL related to the entry, e.g. the homepage of an author or a link to an electronic reprint.</p></dd><dt><span class="term">refdb_issn</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the ISSN or ISBN number of the publication.</p></dd><dt><span class="term">refdb_pyother_info</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the additional information of a PY field after the publication year. The format is <span class="quote">“<span class="quote">/MM/DD/otherinfo</span>”</span>, with MM being the month and DD being the day of the publication. If either of these is missing, the corresponding slash <span class="quote">“<span class="quote">/</span>”</span> still has to be entered. The other information is free alphanumeric information.</p></dd><dt><span class="term">refdb_secother_info</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters provides the same additional information for the refdb_secyear field as the refdb_pyother_info field for refdb_pubyear.</p></dd><dt><span class="term">refdb_periodical_id</span></dt><dd><p>This BIGINT (INTEGER for SQLite) variable points to the periodical_id in t_periodical which corresponds to the periodical the given article appeared in.</p></dd><dt><span class="term">refdb_user1 through refdb_user5</span></dt><dd><p>These alphanumeric fields with a maximum of 255 characters provide space for user-defined information.</p></dd><dt><span class="term">refdb_typeofwork</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores tye type of work of some reference types.</p></dd><dt><span class="term">refdb_area</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the area information of MAP entries.</p></dd><dt><span class="term">refdb_ostype</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the type of the operating system of a computer program.</p></dd><dt><span class="term">refdb_degree</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the type of the degree of a THES reference..</p></dd><dt><span class="term">refdb_runningtime</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the running time of several multimedia reference types.</p></dd><dt><span class="term">refdb_classcodeintl</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the international class code of PAT references.</p></dd><dt><span class="term">refdb_classcodeus</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the US class code of PAT references.</p></dd><dt><span class="term">refdb_senderemail</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the email address of the sender of an ICOMM reference.</p></dd><dt><span class="term">refdb_recipientemail</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the email address of the recipient of an ICOMM reference.</p></dd><dt><span class="term">refdb_mediatype</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the type of the medium of a reference.</p></dd><dt><span class="term">refdb_numvolumes</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the total number of volumes of a monographic item which is part of a limited series.</p></dd><dt><span class="term">refdb_edition</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the edition of a monographic item.</p></dd><dt><span class="term">refdb_computer</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the type of computer of a COMP reference.</p></dd><dt><span class="term">refdb_conferencelocation</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the location of a conference of a CONF entry.</p></dd><dt><span class="term">refdb_registrynum</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the registry number of JFULL entries.</p></dd><dt><span class="term">refdb_classification</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the classification of multimedia entries.</p></dd><dt><span class="term">refdb_section</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the section of a NEWS entry.</p></dd><dt><span class="term">refdb_pamphletnum</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the number of the pamphlet of a PAMP entry.</p></dd><dt><span class="term">refdb_chapternum</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters stores the number of the chapter of a CHAP entry.</p></dd></dl></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="ch16.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="ch16.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="ch16s03.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Chapter 16. Reference database design </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> The table t_author</td></tr></table></div></body></html>
|