| <?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:31 --> |
| <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 : collection_types</td></tr> |
| </table> |
| |
| |
| |
| |
| <p><b>See Also:</b></p> |
| <blockquote> |
| |
| <a href="collections.html">collections</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> |
| |
| name |
| |
| |
| </td> |
| |
| <td> |
| |
| Varchar-50 |
| |
| </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="set.gif" src="../images/set.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> |
| |
| name |
| |
| |
| </td> |
| <td>varchar(50)</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> |
| |
| </table> |
| |
| <p/> |
| |
| |
| |
| |
| |
| |
| <a name="Vars" /> |
| |
| |
| |
| |
| <table width="100%" border="1" cellspacing="0" cellpadding="2"> |
| <tr class="paragr"><td>Sql Commands</td></tr> |
| <tr><td><pre class="sql">INSERT INTO collection_types VALUES (1, 'Collection'); |
| INSERT INTO collection_types VALUES (2, 'Periodical'); |
| INSERT INTO collection_types VALUES (3, 'Journal'); |
| INSERT INTO collection_types VALUES (4, 'Series'); |
| </pre></td></tr> |
| </table> |
| <p/> |
| |
| |
| <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> |
