blob: 716d05e0c819cff10caaee11320ae7d641f8b8ae [file] [log] [blame]
<!-- $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(&#39;kaspa_seq&#39;::text)
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>lastname</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>firstname</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>pseudonym</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>born</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>died</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>country</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>memo</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>created</td>
<td>timestamp with time zone</td>
<td><i>
DEFAULT &quot;timestamp&quot;(&#39;now&#39;::text)
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>modified</td>
<td>timestamp with time zone</td>
<td><i>
DEFAULT &quot;timestamp&quot;(&#39;now&#39;::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 &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>created</td>
<td>timestamp with time zone</td>
<td><i>
DEFAULT &quot;timestamp&quot;(&#39;now&#39;::text)
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>modified</td>
<td>timestamp with time zone</td>
<td><i>
DEFAULT &quot;timestamp&quot;(&#39;now&#39;::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(&#39;kaspa_seq&#39;::text)
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>title</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</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 &quot;timestamp&quot;(&#39;now&#39;::text)
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>modified</td>
<td>timestamp with time zone</td>
<td><i>
DEFAULT &quot;timestamp&quot;(&#39;now&#39;::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(&#39;kaspa_seq&#39;::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 &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>pages</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>memo</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>key</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>language</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>bibtex</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</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 &quot;timestamp&quot;(&#39;now&#39;::text)
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>modified</td>
<td>timestamp with time zone</td>
<td><i>
DEFAULT &quot;timestamp&quot;(&#39;now&#39;::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 &quot;timestamp&quot;(&#39;now&#39;::text)
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>modified</td>
<td>timestamp with time zone</td>
<td><i>
DEFAULT &quot;timestamp&quot;(&#39;now&#39;::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(&#39;kaspa_seq&#39;::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 &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>astext</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>filename</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>type</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>created</td>
<td>timestamp with time zone</td>
<td><i>
DEFAULT &quot;timestamp&quot;(&#39;now&#39;::text)
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>modified</td>
<td>timestamp with time zone</td>
<td><i>
DEFAULT &quot;timestamp&quot;(&#39;now&#39;::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(&#39;kaspa_seq&#39;::text)
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>title</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>subtitle</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</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 &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>howpublished</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>organization</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</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 &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>pages</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>translator</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>volume</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>number</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>month</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>series</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>type</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>key</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>orgtitle</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</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 &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>isbn_issn</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>hidingplace</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>bibtex</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</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 &quot;timestamp&quot;(&#39;now&#39;::text)
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>modified</td>
<td>timestamp with time zone</td>
<td><i>
DEFAULT &quot;timestamp&quot;(&#39;now&#39;::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 &quot;timestamp&quot;(&#39;now&#39;::text)
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>modified</td>
<td>timestamp with time zone</td>
<td><i>
DEFAULT &quot;timestamp&quot;(&#39;now&#39;::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(&#39;kaspa_seq&#39;::text)
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>name</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>city</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>serie</td>
<td>text</td>
<td><i>
DEFAULT &#39;&#39;
</i>
</td>
</tr>
<tr class="tr0">
<td>
</td>
<td>created</td>
<td>timestamp with time zone</td>
<td><i>
DEFAULT &quot;timestamp&quot;(&#39;now&#39;::text)
</i>
</td>
</tr>
<tr class="tr1">
<td>
</td>
<td>modified</td>
<td>timestamp with time zone</td>
<td><i>
DEFAULT &quot;timestamp&quot;(&#39;now&#39;::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>