| <?xml version="1.0" encoding="UTF-8"?> |
| <!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> |
| <!-- generated by Druid on 2006-04-10 11:20:30 --> |
| <title>Documentation for database : BiblioDB</title> |
| <link rel="stylesheet" type="text/css" href="../main/stylesheet.css" title="style" /> |
| </head> |
| |
| <body> |
| |
| <table class="navBar"> |
| <tr> |
| <td><a href="../main/index.html">INDEX</a></td> |
| <td><a href="../main/revisions.html">REVISIONS</a></td> |
| <td width="30%" /> |
| <td><a href="#Overview">OVERVIEW</a></td> |
| <td><a href="#FieldSummary">FIELD SUMMARY</a></td> |
| </tr> |
| |
| <tr> |
| <td><a href="../main/datatypes.html">DATATYPES</a></td> |
| <td></td> |
| <td width="30%" /> |
| <td><a href="#SqlSummary">SQL SUMMARY</a></td> |
| <td><a href="#Triggers">TRIGGERS</a></td> |
| </tr> |
| </table> |
| <hr /> |
| |
| <a name="Overview"></a> |
| |
| <table width="100%" border="1" cellspacing="0" cellpadding="2"> |
| <tr class="title"><td>Table : reference_items</td></tr> |
| </table> |
| |
| <p>Reference Items are citable content, and include both parts (articles) and monographs (books)</p> |
| |
| |
| <p><b>See Also:</b></p> |
| <blockquote> |
| |
| <a href="reference_items.html">reference_items</a><br/> |
| <a href="locators.html">locators</a><br/> |
| <a href="identifiers.html">identifiers</a><br/> |
| |
| </blockquote> |
| |
| <p/> |
| |
| |
| <a name="FieldSummary" /> |
| |
| <table width="100%" border="1" cellspacing="0" cellpadding="2"> |
| <tr class="paragr"><td colspan="3">Field Summary</td></tr> |
| |
| <tr class="header"> |
| <th width="20%">Name</th> |
| <th width="20%">Type</th> |
| <th width="60%">Description</th> |
| </tr> |
| |
| <tr> |
| <td> <b> |
| |
| |
| id |
| |
| |
| </b> |
| </td> |
| |
| <td> |
| |
| Serial |
| |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| <i> |
| |
| reference_type_id |
| |
| </i> |
| |
| </td> |
| |
| <td> |
| <a href="reference_types.html"> |
| |
| reference_types(id) |
| |
| </a> |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| |
| title |
| |
| |
| </td> |
| |
| <td> |
| |
| Varchar-255 |
| |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| |
| year |
| |
| |
| </td> |
| |
| <td> |
| |
| date |
| |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| <i> |
| |
| locators_id |
| |
| </i> |
| |
| </td> |
| |
| <td> |
| <a href="locators.html"> |
| |
| locators(id) |
| |
| </a> |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| |
| description |
| |
| |
| </td> |
| |
| <td> |
| |
| text |
| |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| <i> |
| |
| collection_id |
| |
| </i> |
| |
| </td> |
| |
| <td> |
| <a href="collections.html"> |
| |
| collections(id) |
| |
| </a> |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| |
| container_id |
| |
| |
| </td> |
| |
| <td> |
| |
| smallint |
| |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| |
| abstract |
| |
| |
| </td> |
| |
| <td> |
| |
| text |
| |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| <i> |
| |
| event_id |
| |
| </i> |
| |
| </td> |
| |
| <td> |
| <a href="events.html"> |
| |
| events(id) |
| |
| </a> |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| <i> |
| |
| original_id |
| |
| </i> |
| |
| </td> |
| |
| <td> |
| <a href="reference_items.html"> |
| |
| reference_items(id) |
| |
| </a> |
| </td> |
| |
| <td> </td> |
| </tr> |
| </table> |
| |
| <p/> |
| |
| |
| |
| <a name="SqlSummary" /> |
| |
| <table width="100%" border="1" cellspacing="0" cellpadding="2"> |
| <tr class="paragr"><td colspan="8">Sql Summary</td></tr> |
| |
| <tr class="header"> |
| <th width="50%">Name</th> |
| <th width="50%">Type</th> |
| |
| <th width="40">PrKey</th> |
| <th width="40">Unq</th> |
| <th width="40">NotN</th> |
| <th width="40">MUnq</th> |
| <th width="40">Def</th> |
| <th width="40">Idx1</th> |
| </tr> |
| |
| <tr> |
| <td> <b> |
| |
| |
| id |
| |
| |
| </b> |
| </td> |
| <td>int</td> |
| |
| <td align="center"><img alt="set.gif" src="../images/set.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="set.gif" src="../images/set.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td> </td> |
| <td align="center"><img alt="set.gif" src="../images/set.gif" /></td> |
| </tr> |
| <tr> |
| <td> |
| <i> |
| |
| reference_type_id |
| |
| </i> |
| |
| </td> |
| <td>int</td> |
| |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="set.gif" src="../images/set.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td> </td> |
| <td align="center"><img alt="set.gif" src="../images/set.gif" /></td> |
| </tr> |
| <tr> |
| <td> |
| |
| title |
| |
| |
| </td> |
| <td>varchar(255)</td> |
| |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="set.gif" src="../images/set.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td> </td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| </tr> |
| <tr> |
| <td> |
| |
| year |
| |
| |
| </td> |
| <td>date</td> |
| |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td> </td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| </tr> |
| <tr> |
| <td> |
| <i> |
| |
| locators_id |
| |
| </i> |
| |
| </td> |
| <td>int</td> |
| |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td> </td> |
| <td align="center"><img alt="set.gif" src="../images/set.gif" /></td> |
| </tr> |
| <tr> |
| <td> |
| |
| description |
| |
| |
| </td> |
| <td>varchar(32,000)</td> |
| |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td> </td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| </tr> |
| <tr> |
| <td> |
| <i> |
| |
| collection_id |
| |
| </i> |
| |
| </td> |
| <td>int</td> |
| |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td> </td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| </tr> |
| <tr> |
| <td> |
| |
| container_id |
| |
| |
| </td> |
| <td>smallint</td> |
| |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td> </td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| </tr> |
| <tr> |
| <td> |
| |
| abstract |
| |
| |
| </td> |
| <td>varchar(32,000)</td> |
| |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td> </td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| </tr> |
| <tr> |
| <td> |
| <i> |
| |
| event_id |
| |
| </i> |
| |
| </td> |
| <td>int</td> |
| |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td> </td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| </tr> |
| <tr> |
| <td> |
| <i> |
| |
| original_id |
| |
| </i> |
| |
| </td> |
| <td>int</td> |
| |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| <td> </td> |
| <td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td> |
| </tr> |
| |
| </table> |
| |
| <p/> |
| |
| |
| |
| |
| <table width="100%" border="1" cellspacing="0" cellpadding="2"> |
| <tr class="paragr"><td colspan="4">Foreign Keys</td></tr> |
| <tr class="header"> |
| <th width="25%">Field</th> |
| <th width="25%">Import</th> |
| <th width="25%">On Update</th> |
| <th width="25%">On Delete</th> |
| </tr> |
| |
| <tr><td>reference_type_id</td><td>reference_types(id)</td><td>NO ACTION</td><td>NO ACTION</td></tr> <tr><td>locators_id</td><td>locators(id)</td><td>NO ACTION</td><td>NO ACTION</td></tr> <tr><td>collection_id</td><td>collections(id)</td><td>NO ACTION</td><td>NO ACTION</td></tr> <tr><td>event_id</td><td>events(id)</td><td>NO ACTION</td><td>NO ACTION</td></tr> <tr><td>original_id</td><td>reference_items(id)</td><td>NO ACTION</td><td>NO ACTION</td></tr> |
| |
| </table> |
| <p/> |
| |
| |
| <a name="Vars" /> |
| |
| |
| |
| |
| |
| |
| <a name="Triggers" /> |
| |
| |
| |
| |
| <a name="Rules" /> |
| |
| |
| |
| |
| <hr /> |
| <table class="navBar"> |
| <tr> |
| <td><a href="../main/index.html">INDEX</a></td> |
| <td><a href="../main/revisions.html">REVISIONS</a></td> |
| <td width="30%" /> |
| <td><a href="#Overview">OVERVIEW</a></td> |
| <td><a href="#FieldSummary">FIELD SUMMARY</a></td> |
| </tr> |
| |
| <tr> |
| <td><a href="../main/datatypes.html">DATATYPES</a></td> |
| <td></td> |
| <td width="30%" /> |
| <td><a href="#SqlSummary">SQL SUMMARY</a></td> |
| <td><a href="#Triggers">TRIGGERS</a></td> |
| </tr> |
| </table> |
| |
| </body> |
| |
| </html> |
