| <!-- $Header: /cvs/bibliographic/www/kaspaliste.html,v 1.1 2003/07/01 00:10:21 dnw Exp $ --> |
| |
| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" |
| "http://www.w3.org/TR/html4/strict.dtd"> |
| <html> |
| <head> |
| <title>Index for kaspaliste</title> |
| <style type="text/css"> |
| BODY { |
| color: #000000; |
| background-color: #FFFFFF; |
| font-family: Helvetica, sans-serif; |
| } |
| |
| P { |
| margin-top: 5px; |
| margin-bottom: 5px; |
| } |
| |
| P.w3ref { |
| font-size: 8pt; |
| font-style: italic; |
| text-align: right; |
| } |
| |
| P.detail { |
| font-size: 10pt; |
| } |
| |
| .error { |
| color: #FFFFFF; |
| background-color: #FF0000; |
| } |
| |
| H1, H2, H3, H4, H5, H6 { |
| } |
| |
| OL { |
| list-style-type: upper-alpha; |
| } |
| |
| UL.topic { |
| list-style-type: upper-alpha; |
| } |
| |
| LI.topic { |
| font-weight : bold; |
| } |
| |
| HR { |
| color: #00FF00; |
| background-color: #808080; |
| } |
| |
| TABLE { |
| border-width: medium; |
| padding: 3px; |
| background-color: #000000; |
| width: 90%; |
| } |
| |
| CAPTION { |
| text-transform: capitalize; |
| font-weight : bold; |
| font-size: 14pt; |
| } |
| |
| TH { |
| color: #FFFFFF; |
| background-color: #000000; |
| text-align: left; |
| } |
| |
| TR { |
| color: #000000; |
| background-color: #000000; |
| vertical-align: top; |
| } |
| |
| TR.tr0 { |
| background-color: #F0F0F0; |
| } |
| |
| TR.tr1 { |
| background-color: #D8D8D8; |
| } |
| |
| TD { |
| font-size: 12pt; |
| } |
| |
| TD.col0 { |
| font-weight : bold; |
| width: 20%; |
| } |
| |
| TD.col1 { |
| font-style: italic; |
| width: 15%; |
| } |
| |
| TD.col2 { |
| font-size: 12px; |
| } |
| </style> |
| <link rel="stylesheet" type="text/css" media="all" href="all.css"> |
| <link rel="stylesheet" type="text/css" media="screen" href="screen.css"> |
| <link rel="stylesheet" type="text/css" media="print" href="print.css"> |
| <meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> |
| </head> |
| <body> |
| |
| <!-- Primary Index --> |
| <p><br><br>Dumped on 2003-07-01</p> |
| <a name="index"><h1>Index of database - kaspaliste</h1><ul> |
| |
| <ul> |
| |
| <li><a name="schema_public">public</a></li><ul> |
| <li><a href="#table_publicauthor">author</a></li><li><a href="#table_publiclink">link</a></li><li><a href="#table_publicnote">note</a></li><li><a href="#table_publicpart">part</a></li><li><a href="#table_publicpart_author">part_author</a></li><li><a href="#table_publicpartdata">partdata</a></li><li><a href="#table_publicpublication">publication</a></li><li><a href="#table_publicpublication_author">publication_author</a></li><li><a href="#table_publicpublisher">publisher</a></li> |
| |
| </ul> |
| |
| </ul> |
| |
| <!-- Schema Creation --> |
| <!-- publicpublic --> |
| |
| <hr> |
| <h2>Table: |
| <a name="table_publicauthor">author</a> |
| </h2> |
| |
| |
| <table width="100%" cellspacing="0" cellpadding="3"> |
| <caption>author Structure</caption> |
| <tr> |
| <th>F-Key</th> |
| <th>Name</th> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>no</td> |
| <td>integer</td> |
| <td><i> |
| |
| DEFAULT nextval('kaspa_seq'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>lastname</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>firstname</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>pseudonym</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>born</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>died</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>country</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>memo</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>created</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>modified</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| </table> |
| |
| <!-- Constraint List --> |
| |
| |
| <!-- Foreign Key Discovery --> |
| |
| |
| <!-- View Definition --> |
| |
| |
| <!-- List off permissions --> |
| |
| |
| <p> |
| <a href="#index">Index</a> - |
| <a href="#schema_public">Schema public</a> |
| </p> |
| |
| <hr> |
| <h2>Table: |
| <a name="table_publiclink">link</a> |
| </h2> |
| |
| |
| <table width="100%" cellspacing="0" cellpadding="3"> |
| <caption>link Structure</caption> |
| <tr> |
| <th>F-Key</th> |
| <th>Name</th> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>obj_1</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>obj_2</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>tbl</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>created</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>modified</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| </table> |
| |
| <!-- Constraint List --> |
| |
| |
| <!-- Foreign Key Discovery --> |
| |
| |
| <!-- View Definition --> |
| |
| |
| <!-- List off permissions --> |
| |
| |
| <p> |
| <a href="#index">Index</a> - |
| <a href="#schema_public">Schema public</a> |
| </p> |
| |
| <hr> |
| <h2>Table: |
| <a name="table_publicnote">note</a> |
| </h2> |
| |
| |
| <table width="100%" cellspacing="0" cellpadding="3"> |
| <caption>note Structure</caption> |
| <tr> |
| <th>F-Key</th> |
| <th>Name</th> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>no</td> |
| <td>integer</td> |
| <td><i> |
| |
| DEFAULT nextval('kaspa_seq'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>title</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>memo</td> |
| <td>text</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>type</td> |
| <td>smallint</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>publication_no</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>created</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>modified</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>parent</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>sibling</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| </table> |
| |
| <!-- Constraint List --> |
| |
| |
| <!-- Foreign Key Discovery --> |
| |
| |
| <!-- View Definition --> |
| |
| |
| <!-- List off permissions --> |
| |
| |
| <p> |
| <a href="#index">Index</a> - |
| <a href="#schema_public">Schema public</a> |
| </p> |
| |
| <hr> |
| <h2>Table: |
| <a name="table_publicpart">part</a> |
| </h2> |
| |
| |
| <table width="100%" cellspacing="0" cellpadding="3"> |
| <caption>part Structure</caption> |
| <tr> |
| <th>F-Key</th> |
| <th>Name</th> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>no</td> |
| <td>integer</td> |
| <td><i> |
| |
| DEFAULT nextval('kaspa_seq'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>publication_no</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>partno</td> |
| <td>smallint</td> |
| <td><i> |
| |
| DEFAULT 1 |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>title</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>pages</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>memo</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>key</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>language</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>bibtex</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>intro_no</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>createbibtex</td> |
| <td>boolean</td> |
| <td><i> |
| |
| DEFAULT false |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>created</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>modified</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| </table> |
| |
| <!-- Constraint List --> |
| |
| |
| <!-- Foreign Key Discovery --> |
| |
| |
| <!-- View Definition --> |
| |
| |
| <!-- List off permissions --> |
| |
| |
| <p> |
| <a href="#index">Index</a> - |
| <a href="#schema_public">Schema public</a> |
| </p> |
| |
| <hr> |
| <h2>Table: |
| <a name="table_publicpart_author">part_author</a> |
| </h2> |
| |
| |
| <table width="100%" cellspacing="0" cellpadding="3"> |
| <caption>part_author Structure</caption> |
| <tr> |
| <th>F-Key</th> |
| <th>Name</th> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>part_no</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>author_no</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>created</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>modified</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>author_order</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| </table> |
| |
| <!-- Constraint List --> |
| |
| |
| <!-- Foreign Key Discovery --> |
| |
| |
| <!-- View Definition --> |
| |
| |
| <!-- List off permissions --> |
| |
| |
| <p> |
| <a href="#index">Index</a> - |
| <a href="#schema_public">Schema public</a> |
| </p> |
| |
| <hr> |
| <h2>Table: |
| <a name="table_publicpartdata">partdata</a> |
| </h2> |
| |
| |
| <table width="100%" cellspacing="0" cellpadding="3"> |
| <caption>partdata Structure</caption> |
| <tr> |
| <th>F-Key</th> |
| <th>Name</th> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>no</td> |
| <td>integer</td> |
| <td><i> |
| |
| DEFAULT nextval('kaspa_seq'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>part_no</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>file</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>astext</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>filename</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>type</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>created</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>modified</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| </table> |
| |
| <!-- Constraint List --> |
| |
| |
| <!-- Foreign Key Discovery --> |
| |
| |
| <!-- View Definition --> |
| |
| |
| <!-- List off permissions --> |
| |
| |
| <p> |
| <a href="#index">Index</a> - |
| <a href="#schema_public">Schema public</a> |
| </p> |
| |
| <hr> |
| <h2>Table: |
| <a name="table_publicpublication">publication</a> |
| </h2> |
| |
| |
| <table width="100%" cellspacing="0" cellpadding="3"> |
| <caption>publication Structure</caption> |
| <tr> |
| <th>F-Key</th> |
| <th>Name</th> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>no</td> |
| <td>integer</td> |
| <td><i> |
| |
| DEFAULT nextval('kaspa_seq'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>title</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>subtitle</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>edition</td> |
| <td>smallint</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>editor</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>howpublished</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>organization</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>publisher_no</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>year</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>pages</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>translator</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>volume</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>number</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>month</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>series</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>type</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>key</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>orgtitle</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>orgpublisher_no</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>orgyear</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>isbn_issn</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>hidingplace</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>bibtex</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>entrytype</td> |
| <td>smallint</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>memo</td> |
| <td>text</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>createbibtex</td> |
| <td>boolean</td> |
| <td><i> |
| |
| DEFAULT false |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>created</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>modified</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| </table> |
| |
| <!-- Constraint List --> |
| |
| |
| <!-- Foreign Key Discovery --> |
| |
| |
| <!-- View Definition --> |
| |
| |
| <!-- List off permissions --> |
| |
| |
| <p> |
| <a href="#index">Index</a> - |
| <a href="#schema_public">Schema public</a> |
| </p> |
| |
| <hr> |
| <h2>Table: |
| <a name="table_publicpublication_author">publication_author</a> |
| </h2> |
| |
| |
| <table width="100%" cellspacing="0" cellpadding="3"> |
| <caption>publication_author Structure</caption> |
| <tr> |
| <th>F-Key</th> |
| <th>Name</th> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>publication_no</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>author_no</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>created</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>modified</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>author_order</td> |
| <td>integer</td> |
| <td><i> |
| |
| |
| </i> |
| |
| </td> |
| </tr> |
| |
| </table> |
| |
| <!-- Constraint List --> |
| |
| |
| <!-- Foreign Key Discovery --> |
| |
| |
| <!-- View Definition --> |
| |
| |
| <!-- List off permissions --> |
| |
| |
| <p> |
| <a href="#index">Index</a> - |
| <a href="#schema_public">Schema public</a> |
| </p> |
| |
| <hr> |
| <h2>Table: |
| <a name="table_publicpublisher">publisher</a> |
| </h2> |
| |
| |
| <table width="100%" cellspacing="0" cellpadding="3"> |
| <caption>publisher Structure</caption> |
| <tr> |
| <th>F-Key</th> |
| <th>Name</th> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>no</td> |
| <td>integer</td> |
| <td><i> |
| |
| DEFAULT nextval('kaspa_seq'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>name</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>city</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>serie</td> |
| <td>text</td> |
| <td><i> |
| |
| DEFAULT '' |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr0"> |
| <td> |
| |
| </td> |
| <td>created</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| <tr class="tr1"> |
| <td> |
| |
| </td> |
| <td>modified</td> |
| <td>timestamp with time zone</td> |
| <td><i> |
| |
| DEFAULT "timestamp"('now'::text) |
| </i> |
| |
| </td> |
| </tr> |
| |
| </table> |
| |
| <!-- Constraint List --> |
| |
| |
| <!-- Foreign Key Discovery --> |
| |
| |
| <!-- View Definition --> |
| |
| |
| <!-- List off permissions --> |
| |
| |
| <p> |
| <a href="#index">Index</a> - |
| <a href="#schema_public">Schema public</a> |
| </p> |
| |
| |
| <!-- We've gone through the table structure, now lets take a look at user functions --> |
| |
| |
| |
| <p class="w3ref"> |
| <a href="http://validator.w3.org/check/referer">W3C HTML 4.01 Strict</a></p> |
| </body></html> |