| <!DOCTYPE html> |
| <html> |
| <head> |
| <meta http-equiv="content-type" content=""> |
| <title>Summary File for Database : BiblioDB (Build 33)</title> |
| </head> |
| |
| <body> |
| <h1>Summary File for Database : BiblioDB (Build 33)</h1> |
| |
| <p></p> |
| |
| <p></p> |
| |
| <p><img alt="er-diagram" src="BiblioDB/images/er-views/Bibli0DB.png"></p> |
| |
| <p>Date of creation: 2006-04-10 11:20:24<br> |
| </p> |
| <hr> |
| |
| <h2>reference_items</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">reference_type_id</td> |
| <td>reference_types(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">title</td> |
| <td>Varchar-255</td> |
| <td>varchar(255)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">year</td> |
| <td>date</td> |
| <td>date</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">locators_id</td> |
| <td>locators(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">description</td> |
| <td>text</td> |
| <td>varchar(32,000)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">collection_id</td> |
| <td>collections(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">container_id</td> |
| <td>smallint</td> |
| <td>smallint</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">abstract</td> |
| <td>text</td> |
| <td>varchar(32,000)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">event_id</td> |
| <td>events(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">original_id</td> |
| <td>reference_items(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>collections</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">title</td> |
| <td>Varchar-255</td> |
| <td>varchar(255)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">short_title</td> |
| <td>Varchar-255</td> |
| <td>varchar(255)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">description</td> |
| <td>text</td> |
| <td>varchar(32,000)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">collection_type-Id</td> |
| <td>collection_types(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>contributors</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">sort_name</td> |
| <td>Varchar-255</td> |
| <td>varchar(255)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">display_name</td> |
| <td>Varchar-255</td> |
| <td>varchar(255)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">organisation</td> |
| <td>Bool</td> |
| <td>char(1)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">discription</td> |
| <td>text</td> |
| <td>varchar(32,000)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>names</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">givenname</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">familyname</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">articular</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">prefix</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">suffix</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">preffered</td> |
| <td>Bool</td> |
| <td>char(1)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">1</td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">language</td> |
| <td>Varchar-5</td> |
| <td>varchar(5)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">valid</td> |
| <td>date</td> |
| <td>date</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">contributers_id</td> |
| <td>contributors(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>events</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">event_type_id</td> |
| <td>event_types(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">name</td> |
| <td>Varchar-255</td> |
| <td>varchar(255)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">sponser</td> |
| <td>contributors(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">begin_date</td> |
| <td>date</td> |
| <td>date</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">end_date</td> |
| <td>date</td> |
| <td>date</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">other_date</td> |
| <td>date</td> |
| <td>date</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>tags</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">name</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>feeds</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">url</td> |
| <td>Varchar-255</td> |
| <td>varchar(255)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">title</td> |
| <td>Varchar-255</td> |
| <td>varchar(255)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">link</td> |
| <td>Varchar-255</td> |
| <td>varchar(255)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">data_feed</td> |
| <td>text</td> |
| <td>varchar(32,000)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">data_feed_type</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">http_headers</td> |
| <td>text</td> |
| <td>varchar(32,000)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">last_retrieved</td> |
| <td>date</td> |
| <td>date</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>roles</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">name</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>reference_types</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">name</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>collection_types</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">name</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>event_types</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">name</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>locators</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">value</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">locator_type_id</td> |
| <td>locator_type(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">reference_item_id</td> |
| <td>reference_items(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>locator_type</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">name</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>users</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">nick</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">password</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">modified</td> |
| <td>date</td> |
| <td>date</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">access</td> |
| <td>date</td> |
| <td>date</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>contributions</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">position</td> |
| <td>smallint</td> |
| <td>smallint</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">role_id</td> |
| <td>roles(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">contributor_id</td> |
| <td>contributors(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>identifiers</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">reference_item_id</td> |
| <td>reference_items(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">content</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">identifier_type_id</td> |
| <td>identifier_type(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>identifier_type</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">name</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>annotations</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">X</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">X</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">user_id</td> |
| <td>users(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">content</td> |
| <td>text</td> |
| <td>varchar(32,000)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| <hr> |
| |
| <h2>tagings</h2> |
| |
| <table border="1" cellpadding="2" cellspacing="0" width="100%"> |
| <tbody> |
| <tr bgcolor="#CCCCFF"> |
| <th>Field</th> |
| <th>Type</th> |
| <th>Sql type</th> |
| <th>PrKey</th> |
| <th>Unq</th> |
| <th>NotN</th> |
| <th>MUnq</th> |
| <th>Def</th> |
| <th>Idx1</th> |
| <th>DD Equiv</th> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">id</td> |
| <td>Serial</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">tagable_type</td> |
| <td>Varchar-50</td> |
| <td>varchar(50)</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| <tr> |
| <td bgcolor="#E0E0FF">tags_id</td> |
| <td>tags(id)</td> |
| <td>int</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center">-</td> |
| <td align="center"> </td> |
| <td align="center">-</td> |
| <td> </td> |
| </tr> |
| </tbody> |
| </table> |
| </body> |
| </html> |
