Google Git
Sign in
apache / openoffice-org / 40da1b721d60efa1c9da79b7f3a087c20f0da5bf / . / content / bibliographic / BiblioDB / objects / names.html
blob: b6983f36e74c96ed8eef2b482e28d461d3332958 [file] [log] [blame]
<?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 : names</td></tr>
</table>
<p>In order to track in particular changed names, we have a separate table</p>
<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>&nbsp;</td>
</tr>
<tr>
<td>
givenname
</td>
<td>
Varchar-50
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
familyname
</td>
<td>
Varchar-50
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
articular
</td>
<td>
Varchar-50
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
prefix
</td>
<td>
Varchar-50
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
suffix
</td>
<td>
Varchar-50
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
preffered
</td>
<td>
Bool
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
language
</td>
<td>
Varchar-5
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
valid
</td>
<td>
date
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>
<i>
contributers_id
</i>
</td>
<td>
<a href="contributors.html">
contributors(id)
</a>
</td>
<td>&nbsp;</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>&nbsp;</td>
<td align="center"><img alt="set.gif" src="../images/set.gif" /></td>
</tr>
<tr>
<td>
givenname
</td>
<td>varchar(50)</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>&nbsp;</td>
<td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td>
</tr>
<tr>
<td>
familyname
</td>
<td>varchar(50)</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>&nbsp;</td>
<td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td>
</tr>
<tr>
<td>
articular
</td>
<td>varchar(50)</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>&nbsp;</td>
<td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td>
</tr>
<tr>
<td>
prefix
</td>
<td>varchar(50)</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>&nbsp;</td>
<td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td>
</tr>
<tr>
<td>
suffix
</td>
<td>varchar(50)</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>&nbsp;</td>
<td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td>
</tr>
<tr>
<td>
preffered
</td>
<td>char(1)</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>1</td>
<td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td>
</tr>
<tr>
<td>
language
</td>
<td>varchar(5)</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>&nbsp;</td>
<td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td>
</tr>
<tr>
<td>
valid
</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>&nbsp;</td>
<td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td>
</tr>
<tr>
<td>
<i>
contributers_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="unset.gif" src="../images/unset.gif" /></td>
<td align="center"><img alt="unset.gif" src="../images/unset.gif" /></td>
<td>&nbsp;</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>contributers_id</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>