/usr/share/doc/refdb/refdb-manual/ch16s06.html is in refdb-doc 1.0.2-3.
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_note</title><link rel="stylesheet" type="text/css" href="manual.css" /><meta name="generator" content="DocBook XSL Stylesheets V1.78.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="ch16s05.html" title="The table t_periodical" /><link rel="next" href="ch16s07.html" title="The table t_user" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">The table t_note</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch16s05.html">Prev</a> </td><th width="60%" align="center">Chapter 16. Reference database design</th><td width="20%" align="right"> <a accesskey="n" href="ch16s07.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-note"></a>The table t_note</h2></div></div></div><p>This table contains the extended notes.</p><div class="variablelist"><dl class="variablelist"><dt><span class="term">note_id</span></dt><dd><p>This unique identifier for entries in t_note is automatically generated by RefDB and is stored as a BIGINT value (INTEGER for SQLite).</p></dd><dt><span class="term">note_key</span></dt><dd><p>This is a user-supplied unique identifier for entries in t_note. If not supplied by the user, RefDB will create a unique identifier when the entry is added.</p></dd><dt><span class="term">note_title</span></dt><dd><p>This alphanumeric field (up to 255 characters) contains the title of the entry.</p></dd><dt><span class="term">note_content</span></dt><dd><p>This alphanumeric field of unlimited length contains the text of the note.</p></dd><dt><span class="term">note_content_type</span></dt><dd><p>This alphanumeric field (up to 255 characters) contains the type of the data in the note_content field.</p></dd><dt><span class="term">note_content_xmllang</span></dt><dd><p>This alphanumeric field (up to 255 characters) contains an identifier of the language of the data in the note_content field.</p></dd><dt><span class="term">note_user_id</span></dt><dd><p>This BIGINT (INTEGER for SQLite) variable points to the user_id in t_user which corresponds to the user who created the note.</p></dd><dt><span class="term">note_date</span></dt><dd><p>This DATETIME field stores the date the note was added, or any other user-supplied date.</p></dd><dt><span class="term">note_share</span></dt><dd><p>This short integer field stores whether the note may be shared with others (value != zero) or not (value = zero).</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="ch16s05.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="ch16s07.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">The table t_periodical </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_user</td></tr></table></div></body></html>
|