| <?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 : events</td></tr> |
| </table> |
| |
| |
| |
| |
| <p><b>See Also:</b></p> |
| <blockquote> |
| |
| <a href="reference_items.html">reference_items</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> |
| |
| event_type_id |
| |
| </i> |
| |
| </td> |
| |
| <td> |
| <a href="event_types.html"> |
| |
| event_types(id) |
| |
| </a> |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| |
| name |
| |
| |
| </td> |
| |
| <td> |
| |
| Varchar-255 |
| |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| <i> |
| |
| sponser |
| |
| </i> |
| |
| </td> |
| |
| <td> |
| <a href="contributors.html"> |
| |
| contributors(id) |
| |
| </a> |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| |
| begin_date |
| |
| |
| </td> |
| |
| <td> |
| |
| date |
| |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| |
| end_date |
| |
| |
| </td> |
| |
| <td> |
| |
| date |
| |
| </td> |
| |
| <td> </td> |
| </tr> |
| <tr> |
| <td> |
| |
| other_date |
| |
| |
| </td> |
| |
| <td> |
| |
| date |
| |
| </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> |
| <i> |
| |
| event_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> |
| |
| name |
| |
| |
| </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> |
| <i> |
| |
| sponser |
| |
| </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> |
| |
| begin_date |
| |
| |
| </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> |
| |
| end_date |
| |
| |
| </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> |
| |
| other_date |
| |
| |
| </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> |
| |
| </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>event_type_id</td><td>event_types(id)</td><td>NO ACTION</td><td>NO ACTION</td></tr> <tr><td>sponser</td><td>contributors(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> |