/usr/share/doc/refdb/refdb-manual/ch16.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>Chapter 16. Reference database design</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="pt05.html" title="Part V. Programmer's manual" /><link rel="prev" href="pt05.html" title="Part V. Programmer's manual" /><link rel="next" href="ch16s02.html" title="The table t_refdb" /></head><body><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Chapter 16. Reference database design</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="pt05.html">Prev</a> </td><th width="60%" align="center">Part V. Programmer's manual</th><td width="20%" align="right"> <a accesskey="n" href="ch16s02.html">Next</a></td></tr></table><hr /></div><div class="chapter"><div class="titlepage"><div><div><h2 class="title"><a id="chapter-reference-database-design"></a>Chapter 16. Reference database design</h2></div></div></div><div class="toc"><p><strong>Table of Contents</strong></p><dl class="toc"><dt><span class="sect1"><a href="ch16.html#sect-table-t-meta">The table t_meta</a></span></dt><dt><span class="sect1"><a href="ch16s02.html">The table t_refdb</a></span></dt><dt><span class="sect1"><a href="ch16s03.html">The table t_author</a></span></dt><dt><span class="sect1"><a href="ch16s04.html">The table t_keyword</a></span></dt><dt><span class="sect1"><a href="ch16s05.html">The table t_periodical</a></span></dt><dt><span class="sect1"><a href="ch16s06.html">The table t_note</a></span></dt><dt><span class="sect1"><a href="ch16s07.html">The table t_user</a></span></dt><dt><span class="sect1"><a href="ch16s08.html">The table t_link</a></span></dt><dt><span class="sect1"><a href="ch16s09.html">The table t_xauthor</a></span></dt><dt><span class="sect1"><a href="ch16s10.html">The table t_xkeyword</a></span></dt><dt><span class="sect1"><a href="ch16s11.html">The table t_xuser</a></span></dt><dt><span class="sect1"><a href="ch16s12.html">The table t_xnote</a></span></dt><dt><span class="sect1"><a href="ch16s13.html">The table t_xlink</a></span></dt></dl></div><p>This section gives an overview over the design of the reference database with MySQL as the database server. The same design is used with the other database engines, although the details may differ somewhat. This will be mentioned where appropriate.</p><p>The requirements of the database necessitate some tables which hold the data proper and some tables which cross-reference these tables.</p><div class="sect1"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="sect-table-t-meta"></a>The table t_meta</h2></div></div></div><p>The t_meta table contains the following meta-information about the database:</p><div class="variablelist"><dl class="variablelist"><dt><span class="term">meta_app</span></dt><dd><p>This string contains the name of the application that created the database.</p></dd><dt><span class="term">meta_version</span></dt><dd><p>This string contains the version number of the application that created the database.</p></dd><dt><span class="term">meta_type</span></dt><dd><p>This string describes the type of the database. Currently only the type "risx" is supported.</p></dd><dt><span class="term">meta_create_date</span></dt><dd><p>This timestamp is set by refdbd when the database is created.</p></dd><dt><span class="term">meta_modify_date</span></dt><dd><p>This timestamp is updated by refdbd whenever the database is changed.</p></dd></dl></div></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="pt05.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="pt05.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="ch16s02.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Part V. Programmer's manual </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_refdb</td></tr></table></div></body></html>
|