From GMOD
<!-- $Header: /cvsroot/autodoc/autodoc/html.tmpl,v 1.4 2006/05/16 19:01:27 rbt Exp $ -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>Index for <!-- TMPL_VAR ESCAPE="HTML" name="database" --></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<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><!-- TMPL_VAR ESCAPE="HTML" name="database_comment" --><br><br>Dumped on <!-- TMPL_VAR ESCAPE="HTML" name="dumped_on" --></p>
<h1><a name="index">Index of database - <!-- TMPL_VAR ESCAPE="HTML" name="database" --></a></h1>
<ul>
<!-- TMPL_LOOP name="schemas" -->
<li><a name="<!-- TMPL_VAR ESCAPE="HTML" name="schema_sgmlid" -->"><!-- TMPL_VAR ESCAPE="HTML" name="schema" --></a></li><ul>
<!-- TMPL_LOOP name="tables" --><li><a href="#<!-- TMPL_VAR ESCAPE="URL" name="table_sgmlid" -->"><!-- TMPL_VAR ESCAPE="HTML" name="table" --></a></li><!-- /TMPL_LOOP name="tables" -->
<!-- TMPL_LOOP name="functions" --><li><a href="#<!-- TMPL_VAR ESCAPE="URL" name="function_sgmlid" -->"><!-- TMPL_VAR ESCAPE="HTML" name="function" --></a></li><!-- /TMPL_LOOP name="functions" -->
</ul>
<!-- /TMPL_LOOP name="schemas" -->
</ul>
<!-- Schema Creation -->
<!-- TMPL_LOOP name="schemas" --><!-- <!-- TMPL_VAR ESCAPE="HTML" name="schema" --><!-- TMPL_VAR ESCAPE="HTML" name="schema" --> -->
<!-- TMPL_IF name="number_of_schemas" -->
<hr>
<h1>Schema <!-- TMPL_VAR ESCAPE="HTML" name="schema" --></h1>
<!-- TMPL_IF name="schema_comment" -->
<p><!-- TMPL_VAR name="schema_comment" --></p>
<!-- /TMPL_IF name="schema_comment" -->
<!-- /TMPL_IF name="number_of_schemas" -->
<!-- TMPL_LOOP name="tables" -->
<hr>
<h2><!-- TMPL_IF name="view_definition" -->View:<!-- TMPL_ELSE -->Table:<!-- /TMPL_IF -->
<!-- TMPL_IF name="number_of_schemas" -->
<a href="#<!-- TMPL_VAR ESCAPE="URL" name="schema_sgmlid" -->"><!-- TMPL_VAR ESCAPE="HTML" name="schema" --></a>.<!-- /TMPL_IF name="number_of_schemas" --><a name="<!-- TMPL_VAR ESCAPE="URL" name="table_sgmlid" -->"><!-- TMPL_VAR ESCAPE="HTML" name="table" --></a>
</h2>
<!-- TMPL_IF name="table_comment" -->
<p><!-- TMPL_VAR ESCAPE="HTML" name="table_comment" --></p>
<!-- /TMPL_IF name="table_comment" -->
<table border="1" cellspacing="0" cellpadding="3">
<caption><!-- TMPL_IF name="number_of_schemas" --><!-- TMPL_VAR ESCAPE="HTML" name="schema" -->.<!-- /TMPL_IF name="number_of_schemas" --><!-- TMPL_VAR ESCAPE="HTML" name="table" --> Structure</caption>
<tr>
<th>FK</th>
<th>Name</th>
<th>Type</th>
<th>Description</th>
</tr>
<!-- TMPL_LOOP name="columns" -->
<tr class="<!-- TMPL_IF name="__odd__" -->tr0<!-- tmpl_else name="__odd__" -->tr1<!-- /TMPL_IF name="__odd__" -->"><td><!-- TMPL_LOOP name="column_constraints" --><!-- TMPL_IF name="column_fk" --><a href="[#Table:_<!-- TMPL_VAR ESCAPE="URL" name="column_fk_table" -->|"><!-- TMPL_IF name="column_fk_keygroup" -->#<!-- TMPL_VAR name="column_fk_keygroup" --><!-- /TMPL_IF name="column_fk_keygroup" --><!-- TMPL_VAR name="column_fk_table" -->]</a><!-- /TMPL_IF name="column_fk" --><!-- /TMPL_LOOP name="column_constraints" --></td><td><!-- TMPL_VAR ESCAPE="HTML" name="column" --></td><td><!-- TMPL_VAR ESCAPE="HTML" name="column_type" --></td>
<td><i>
<!-- TMPL_LOOP name="column_constraints" -->
<!-- TMPL_IF name="column_primary_key" -->PRIMARY KEY
<!-- /TMPL_IF name="column_primary_key" -->
<!-- TMPL_IF name="column_unique" -->
UNIQUE<!-- TMPL_IF name="column_unique_keygroup" -->#<!-- TMPL_VAR name="column_unique_keygroup" --><!-- /TMPL_IF name="column_unique_keygroup" -->
<!-- /TMPL_IF name="column_unique" -->
<!-- /TMPL_LOOP name="column_constraints" -->
<!-- TMPL_IF name="column_constraint_notnull" -->NOT NULL<!-- /TMPL_IF name="column_constraint_notnull" -->
<!-- TMPL_IF name="column_default" -->DEFAULT <!-- TMPL_VAR ESCAPE="HTML" name="column_default" --><!-- /TMPL_IF name="column_default" -->
</i>
<!-- TMPL_IF name="column_comment" --><br><br><!-- TMPL_VAR ESCAPE="HTML" name="column_comment" --><!-- /TMPL_IF name="column_comment" -->
</td>
</tr>
<!-- /TMPL_LOOP name="columns" -->
</table>
<!-- Inherits -->
<!-- TMPL_IF name="inherits" -->
<p>Table <!-- TMPL_IF name="number_of_schemas" --><!-- TMPL_VAR ESCAPE="HTML" name="schema" -->.<!-- /TMPL_IF name="number_of_schemas" --><!-- TMPL_VAR ESCAPE="HTML" name="table" --> Inherits
<!-- TMPL_LOOP name="inherits" -->
<!-- TMPL_VAR name="index_name" --> <!-- TMPL_VAR name="index_definition" -->
<a href="#<!-- TMPL_VAR ESCAPE="URL" name="parent_sgmlid" -->"><!-- TMPL_IF name="number_of_schemas" --><!-- TMPL_VAR ESCAPE="HTML" name="parent_schema" -->.<!-- /TMPL_IF name="number_of_schemas" --><!-- TMPL_VAR ESCAPE="HTML" name="parent_table" --></a>,
<!-- /TMPL_LOOP name="inherits" -->
</p>
<!-- /TMPL_IF name="inherits" -->
<!-- TMPL_UNLESS name="view_definition" -->
<!-- TMPL_IF name="stats_enabled" -->
<p> </p>
<table width="100%" cellspacing="0" cellpadding="3">
<caption>Statistics</caption>
<tr>
<th>Total Space (disk usage)</th>
<th>Tuple Count</th>
<th>Active Space</th>
<th>Dead Space</th>
<th>Free Space</th>
</tr>
<tr class="tr0">
<td><!-- TMPL_VAR ESCAPE="HTML" name="stats_table_bytes" --></td>
<td><!-- TMPL_VAR ESCAPE="HTML" name="stats_tuple_count" --></td>
<td><!-- TMPL_VAR ESCAPE="HTML" name="stats_tuple_bytes" --></td>
<td><!-- TMPL_VAR ESCAPE="HTML" name="stats_dead_bytes" --></td>
<td><!-- TMPL_VAR ESCAPE="HTML" name="stats_free_bytes" --></td>
</tr>
</table>
<!-- /TMPL_IF name="stats_enabled" -->
<!-- /TMPL_UNLESS name="view_definition" -->
<!-- Constraint List -->
<!-- TMPL_IF name="constraints" -->
<p> </p>
<table width="100%" cellspacing="0" cellpadding="3">
<caption><!-- TMPL_IF name="number_of_schemas" --><!-- TMPL_VAR ESCAPE="HTML" name="schema" -->.<!-- /TMPL_IF name="number_of_schemas" --><!-- TMPL_VAR ESCAPE="HTML" name="table" --> Constraints</caption>
<tr>
<th>Name</th>
<th>Constraint</th>
</tr>
<!-- TMPL_LOOP name="constraints" -->
<tr class="<!-- TMPL_IF name="__odd__" -->tr0<!-- TMPL_ELSE name="__odd__" -->tr1<!-- /TMPL_IF name="__odd__" -->">
<td><!-- TMPL_VAR ESCAPE="HTML" name="constraint_name" --></td>
<td><!-- TMPL_VAR ESCAPE="HTML" name="constraint" --></td>
</tr>
<!-- /TMPL_LOOP name="constraints" -->
</table>
<!-- /TMPL_IF name="constraints" -->
<!-- Foreign Key Discovery -->
<!-- TMPL_IF name="fk_schemas" -->
<p>Tables referencing this one via Foreign Key Constraints:</p>
<!-- TMPL_LOOP name="fk_schemas" -->
<ul>
<li><a href="[#Table:_<!-- TMPL_VAR ESCAPE="URL" name="fk_table" -->|"><!-- TMPL_VAR name="fk_table" -->]</a></li>
</ul>
<!-- /TMPL_LOOP name="fk_schemas" -->
<!-- /TMPL_IF name="fk_schemas" -->
<!-- /TMPL_LOOP name="tables" -->
<!-- /TMPL_LOOP name="schemas" -->
<p class="w3ref">Generated by <a href="http://www.rbt.ca/autodoc/">PostgreSQL Autodoc</a></p>
<p class="w3ref"><a href="http://validator.w3.org/check/referer">W3C HTML 4.01 Strict</a></p>
</body></html>
