<html>
<head>
<title>PLUM: Database Structure: Glyphnames table</title>
<link rel="stylesheet" type="text/css" href="../style.css">
</head>
<body>
<div class="section"><h1>Rack Database Structure: Glyphnames table</h1></div>

<div class="section">

<p>
  This table holds comments on the rest of the database. Comments can be associated with any object in the database, so tables don't need specific columns for comments.
</p>
<p>
  A comment is associated with a row in some table by giving the table name, the field it's associated with and the value. For a comment on a specific rack, the table would be "racks", the field "idx" and the value "27" if the rack has idx=27. For a constraint comment, the table would be "constraints", the field "name" and the value "HRFs Together".
</p>

<table class="database">

  <tr class="group"><td colspan=3><center>Fields</center></td></tr>

<tr>
  <td>idx</td>
  <td>integer</td>
  <td>Unique identifier. This is the only field guaranteed to be unique.</td>
</tr>

<tr>
  <td>tblname</td>
  <td>string</td>
  <td>The name of the table containing the row this is a comment for.</td>
</tr>

<tr>
  <td>indexfield</td>
  <td>string</td>
  <td>the field used to look up the row this is a comment for.</td>
</tr>

<tr>
  <td>value</td>
  <td>string</td>
  <td>the value the index field should have. Surrounding quotes aren't needed.</td>
</tr>

<tr>
  <td>author</td>
  <td>string</td>
  <td>the author of this comment</td>
</tr>

<tr>
  <td>comment</td>
  <td>string</td>
  <td>the text of the comment</td>
</tr>

</table>

</div>

<div class="section">
<img src="../img/nasa.jpg">
</div>
</body>
</html>
