/usr/share/doc/refdb/refdb-manual/ch16s11.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_xuser</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="ch16s10.html" title="The table t_xkeyword" /><link rel="next" href="ch16s12.html" title="The table t_xnote" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">The table t_xuser</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch16s10.html">Prev</a> </td><th width="60%" align="center">Chapter 16. Reference database design</th><td width="20%" align="right"> <a accesskey="n" href="ch16s12.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-xuser"></a>The table t_xuser</h2></div></div></div><p>This table cross-references the tables <a class="link" href="ch16s07.html" title="The table t_user">t_user</a> and <a class="link" href="ch16s02.html" title="The table t_refdb">t_refdb</a>.</p><div class="variablelist"><dl class="variablelist"><dt><span class="term">xuser_id</span></dt><dd><p>The unique ID of an t_xuser entry is stored as a BIGINT value (INTEGER for SQLite).</p></dd><dt><span class="term">user_id</span></dt><dd><p>This BIGINT value (INTEGER for SQLite) points to the ID of the user in the table <a class="link" href="ch16s07.html" title="The table t_user">t_user</a>.</p></dd><dt><span class="term">refdb_id</span></dt><dd><p>This is the ID of the reference in the <a class="link" href="ch16s02.html" title="The table t_refdb">t_refdb</a> table, stored as a BIGINT value (INTEGER for SQLite).</p></dd><dt><span class="term">xuser_reprint</span></dt><dd><p>This alphanumeric string must contain one of the following:</p><div class="itemizedlist"><ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>NOT IN FILE (this is the default if nothing is specified)</p></li><li class="listitem"><p>ON REQUEST</p></li><li class="listitem"><p>IN FILE</p></li></ul></div></dd><dt><span class="term">xuser_date</span></dt><dd><p>This DATE field holds the date when a reprint was requested. If xuser_reprint contains something else than <span class="quote">“<span class="quote">ON REQUEST</span>”</span>, this field is not relevant.</p></dd><dt><span class="term">xuser_avail</span></dt><dd><p>This alphanumeric field with a maximum of 255 characters contains the information where a physical copy of the article is stored. This may be a room number, a contact person, a binder or folder name or anything else that helps to track that copy down. This field is irrelevant if the reprint status is not <span class="quote">“<span class="quote">IN FILE</span>”</span>.</p></dd><dt><span class="term">xuser_notes</span></dt><dd><p>This alphanumeric field of variable length contains notes or comments added by the user.</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="ch16s10.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="ch16s12.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">The table t_xkeyword </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_xnote</td></tr></table></div></body></html>
|