Menu
▾
▴
[Gmod-schema-cmts] SF.net SVN: gmod:[25193] schema/trunk/chado/modules
|
From: <sco...@us...> - 2011-09-20 19:04:52
|
Revision: 25193
http://gmod.svn.sourceforge.net/gmod/?rev=25193&view=rev
Author: scottcain
Date: 2011-09-20 19:04:39 +0000 (Tue, 20 Sep 2011)
Log Message:
-----------
adding some left out doc
Added Paths:
-----------
schema/trunk/chado/modules/cell_line/cell_line.html
schema/trunk/chado/modules/stock/stock.html
Added: schema/trunk/chado/modules/cell_line/cell_line.html
===================================================================
--- schema/trunk/chado/modules/cell_line/cell_line.html (rev 0)
+++ schema/trunk/chado/modules/cell_line/cell_line.html 2011-09-20 19:04:39 UTC (rev 25193)
@@ -0,0 +1,1832 @@
+<!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" lang="en-US" xml:lang="en-US">
+<head>
+<title>Description of Schema</title>
+<meta name="generator" content="SQL::Translator::Producer::HTML" />
+<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
+</head>
+<body>
+
+
+<h1 class="SchemaDescription">
+ Description of Schema
+</h1>
+
+<hr />
+
+<!--
+ Table listing (11 tables)
+ -->
+
+<a name="top" />
+
+<table class="LinkTable" width="100%">
+
+<tr>
+ <td class="LinkTableCell"><h2 class="LinkTableTitle">
+ Tables
+</h2></td>
+</tr>
+
+<!--
+ Start link to table 'cell_line'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="cell_line-link" href="#cell_line">cell_line</a></td>
+</tr>
+
+<!--
+ End link to table 'cell_line'
+ -->
+
+<!--
+ Start link to table 'cell_line_relationship'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="cell_line_relationship-link" href="#cell_line_relationship">cell_line_relationship</a></td>
+</tr>
+
+<!--
+ End link to table 'cell_line_relationship'
+ -->
+
+<!--
+ Start link to table 'cell_line_synonym'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="cell_line_synonym-link" href="#cell_line_synonym">cell_line_synonym</a></td>
+</tr>
+
+<!--
+ End link to table 'cell_line_synonym'
+ -->
+
+<!--
+ Start link to table 'cell_line_cvterm'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="cell_line_cvterm-link" href="#cell_line_cvterm">cell_line_cvterm</a></td>
+</tr>
+
+<!--
+ End link to table 'cell_line_cvterm'
+ -->
+
+<!--
+ Start link to table 'cell_line_dbxref'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="cell_line_dbxref-link" href="#cell_line_dbxref">cell_line_dbxref</a></td>
+</tr>
+
+<!--
+ End link to table 'cell_line_dbxref'
+ -->
+
+<!--
+ Start link to table 'cell_lineprop'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="cell_lineprop-link" href="#cell_lineprop">cell_lineprop</a></td>
+</tr>
+
+<!--
+ End link to table 'cell_lineprop'
+ -->
+
+<!--
+ Start link to table 'cell_lineprop_pub'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="cell_lineprop_pub-link" href="#cell_lineprop_pub">cell_lineprop_pub</a></td>
+</tr>
+
+<!--
+ End link to table 'cell_lineprop_pub'
+ -->
+
+<!--
+ Start link to table 'cell_line_feature'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="cell_line_feature-link" href="#cell_line_feature">cell_line_feature</a></td>
+</tr>
+
+<!--
+ End link to table 'cell_line_feature'
+ -->
+
+<!--
+ Start link to table 'cell_line_cvtermprop'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="cell_line_cvtermprop-link" href="#cell_line_cvtermprop">cell_line_cvtermprop</a></td>
+</tr>
+
+<!--
+ End link to table 'cell_line_cvtermprop'
+ -->
+
+<!--
+ Start link to table 'cell_line_pub'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="cell_line_pub-link" href="#cell_line_pub">cell_line_pub</a></td>
+</tr>
+
+<!--
+ End link to table 'cell_line_pub'
+ -->
+
+<!--
+ Start link to table 'cell_line_library'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="cell_line_library-link" href="#cell_line_library">cell_line_library</a></td>
+</tr>
+
+<!--
+ End link to table 'cell_line_library'
+ -->
+
+</table>
+
+<!--
+ Starting table 'cell_line'
+ -->
+
+<a name="cell_line" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ cell_line
+</h3></td>
+ <a name="cell_line"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ========================================== <br />
+ Chado cell line module <br />
+ ============ <br />
+ DEPENDENCIES <br />
+ ============ <br />
+ :import feature from sequence <br />
+ :import synonym from sequence <br />
+ :import library from library <br />
+ :import cvterm from cv <br />
+ :import dbxref from general <br />
+ :import pub from pub <br />
+ :import organism from organism <br />
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ <br />
+ ================================================ <br />
+ TABLE: cell_line <br />
+ ================================================
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line-cell_line_id">cell_line_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line-name">name</a></td>
+ <td class="FieldCellType">varchar</td>
+ <td class="FieldCellSize">255</td>
+ <td class="FieldCellDefault">NULL</td>
+ <td class="FieldCellOther"></td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line-uniquename">uniquename</a></td>
+ <td class="FieldCellType">varchar</td>
+ <td class="FieldCellSize">255</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line-organism_id">organism_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#organism-organism_id">organism.organism_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line-timeaccessioned">timeaccessioned</a></td>
+ <td class="FieldCellType">timestamp</td>
+ <td class="FieldCellSize">0</td>
+ <td class="FieldCellDefault">current_timestamp</td>
+ <td class="FieldCellOther">NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line-timelastmodified">timelastmodified</a></td>
+ <td class="FieldCellType">timestamp</td>
+ <td class="FieldCellSize">0</td>
+ <td class="FieldCellDefault">current_timestamp</td>
+ <td class="FieldCellOther">NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>uniquename</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>organism_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>organism_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>timeaccessioned</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>timelastmodified</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>uniquename, organism_id</td>
+</tr>
+
+</table>
+
+<hr />
+
+<!--
+ Starting table 'cell_line_relationship'
+ -->
+
+<a name="cell_line_relationship" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ cell_line_relationship
+</h3></td>
+ <a name="cell_line_relationship"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ================================================ <br />
+ TABLE: cell_line_relationship <br />
+ ================================================
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_relationship-cell_line_relationship_id">cell_line_relationship_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_relationship-subject_id">subject_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_relationship-object_id">object_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_relationship-type_id">type_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_relationship_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>subject_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>subject_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>object_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>object_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>type_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>type_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>subject_id, object_id, type_id</td>
+</tr>
+
+</table>
+
+<hr />
+
+<!--
+ Starting table 'cell_line_synonym'
+ -->
+
+<a name="cell_line_synonym" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ cell_line_synonym
+</h3></td>
+ <a name="cell_line_synonym"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ================================================ <br />
+ TABLE: cell_line_synonym <br />
+ ================================================
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_synonym-cell_line_synonym_id">cell_line_synonym_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_synonym-cell_line_id">cell_line_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_synonym-synonym_id">synonym_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#synonym-synonym_id">synonym.synonym_id</a></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_synonym-pub_id">pub_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_synonym-is_current">is_current</a></td>
+ <td class="FieldCellType">boolean</td>
+ <td class="FieldCellSize">0</td>
+ <td class="FieldCellDefault">false</td>
+ <td class="FieldCellOther">NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_synonym-is_internal">is_internal</a></td>
+ <td class="FieldCellType">boolean</td>
+ <td class="FieldCellSize">0</td>
+ <td class="FieldCellDefault">false</td>
+ <td class="FieldCellOther">NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_synonym_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>synonym_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>synonym_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>is_current</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>is_internal</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>synonym_id, cell_line_id, pub_id</td>
+</tr>
+
+</table>
+
+<hr />
+
+<!--
+ Starting table 'cell_line_cvterm'
+ -->
+
+<a name="cell_line_cvterm" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ cell_line_cvterm
+</h3></td>
+ <a name="cell_line_cvterm"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ================================================ <br />
+ TABLE: cell_line_cvterm <br />
+ ================================================
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_cvterm-cell_line_cvterm_id">cell_line_cvterm_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_cvterm-cell_line_id">cell_line_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_cvterm-cvterm_id">cvterm_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_cvterm-pub_id">pub_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_cvterm-rank">rank</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault">0</td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_cvterm_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cvterm_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>cvterm_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>rank</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>cell_line_id, cvterm_id, pub_id, rank</td>
+</tr>
+
+</table>
+
+<hr />
+
+<!--
+ Starting table 'cell_line_dbxref'
+ -->
+
+<a name="cell_line_dbxref" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ cell_line_dbxref
+</h3></td>
+ <a name="cell_line_dbxref"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ================================================ <br />
+ TABLE: cell_line_dbxref <br />
+ ================================================
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_dbxref-cell_line_dbxref_id">cell_line_dbxref_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_dbxref-cell_line_id">cell_line_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_dbxref-dbxref_id">dbxref_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_dbxref-is_current">is_current</a></td>
+ <td class="FieldCellType">boolean</td>
+ <td class="FieldCellSize">0</td>
+ <td class="FieldCellDefault">true</td>
+ <td class="FieldCellOther">NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_dbxref_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>dbxref_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>dbxref_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>is_current</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>cell_line_id, dbxref_id</td>
+</tr>
+
+</table>
+
+<hr />
+
+<!--
+ Starting table 'cell_lineprop'
+ -->
+
+<a name="cell_lineprop" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ cell_lineprop
+</h3></td>
+ <a name="cell_lineprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ================================================ <br />
+ TABLE: cell_lineprop <br />
+ ================================================
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_lineprop-cell_lineprop_id">cell_lineprop_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_lineprop-cell_line_id">cell_line_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_lineprop-type_id">type_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_lineprop-value">value</a></td>
+ <td class="FieldCellType">text</td>
+ <td class="FieldCellSize">64000</td>
+ <td class="FieldCellDefault">NULL</td>
+ <td class="FieldCellOther"></td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_lineprop-rank">rank</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault">0</td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_lineprop_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>type_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>type_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>rank</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>cell_line_id, type_id, rank</td>
+</tr>
+
+</table>
+
+<hr />
+
+<!--
+ Starting table 'cell_lineprop_pub'
+ -->
+
+<a name="cell_lineprop_pub" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ cell_lineprop_pub
+</h3></td>
+ <a name="cell_lineprop_pub"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ================================================ <br />
+ TABLE: cell_lineprop_pub <br />
+ ================================================
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_lineprop_pub-cell_lineprop_pub_id">cell_lineprop_pub_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_lineprop_pub-cell_lineprop_id">cell_lineprop_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cell_lineprop-cell_lineprop_id">cell_lineprop.cell_lineprop_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_lineprop_pub-pub_id">pub_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_lineprop_pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_lineprop_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>cell_lineprop_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>cell_lineprop_id, pub_id</td>
+</tr>
+
+</table>
+
+<hr />
+
+<!--
+ Starting table 'cell_line_feature'
+ -->
+
+<a name="cell_line_feature" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ cell_line_feature
+</h3></td>
+ <a name="cell_line_feature"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ================================================ <br />
+ TABLE: cell_line_feature <br />
+ ================================================
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_feature-cell_line_feature_id">cell_line_feature_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_feature-cell_line_id">cell_line_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_feature-feature_id">feature_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#feature-feature_id">feature.feature_id</a></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_feature-pub_id">pub_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_feature_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>feature_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>feature_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>cell_line_id, feature_id, pub_id</td>
+</tr>
+
+</table>
+
+<hr />
+
+<!--
+ Starting table 'cell_line_cvtermprop'
+ -->
+
+<a name="cell_line_cvtermprop" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ cell_line_cvtermprop
+</h3></td>
+ <a name="cell_line_cvtermprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ================================================ <br />
+ TABLE: cell_line_cvtermprop <br />
+ ================================================
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_cvtermprop-cell_line_cvtermprop_id">cell_line_cvtermprop_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_cvtermprop-cell_line_cvterm_id">cell_line_cvterm_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cell_line_cvterm-cell_line_cvterm_id">cell_line_cvterm.cell_line_cvterm_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_cvtermprop-type_id">type_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_cvtermprop-value">value</a></td>
+ <td class="FieldCellType">text</td>
+ <td class="FieldCellSize">64000</td>
+ <td class="FieldCellDefault">NULL</td>
+ <td class="FieldCellOther"></td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_cvtermprop-rank">rank</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault">0</td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_cvtermprop_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_cvterm_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>cell_line_cvterm_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>type_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>type_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>rank</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>cell_line_cvterm_id, type_id, rank</td>
+</tr>
+
+</table>
+
+<hr />
+
+<!--
+ Starting table 'cell_line_pub'
+ -->
+
+<a name="cell_line_pub" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ cell_line_pub
+</h3></td>
+ <a name="cell_line_pub"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ================================================ <br />
+ TABLE: cell_line_pub <br />
+ ================================================
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_pub-cell_line_pub_id">cell_line_pub_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_pub-cell_line_id">cell_line_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_pub-pub_id">pub_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>cell_line_id, pub_id</td>
+</tr>
+
+</table>
+
+<hr />
+
+<!--
+ Starting table 'cell_line_library'
+ -->
+
+<a name="cell_line_library" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ cell_line_library
+</h3></td>
+ <a name="cell_line_library"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ================================================ <br />
+ TABLE: cell_line_library <br />
+ ================================================
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_library-cell_line_library_id">cell_line_library_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_library-cell_line_id">cell_line_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="cell_line_library-library_id">library_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#library-library_id">library.library_id</a></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="cell_line_library-pub_id">pub_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_library_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>cell_line_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>library_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>library_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>cell_line_id, library_id, pub_id</td>
+</tr>
+
+</table>
+
+<hr />
+
+Created by <a href="http://sqlfairy.sourceforge.net">
+SQL::Translator 0.11003</a>
+
+</body>
+</html>
Added: schema/trunk/chado/modules/stock/stock.html
===================================================================
--- schema/trunk/chado/modules/stock/stock.html (rev 0)
+++ schema/trunk/chado/modules/stock/stock.html 2011-09-20 19:04:39 UTC (rev 25193)
@@ -0,0 +1,2895 @@
+<!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" lang="en-US" xml:lang="en-US">
+<head>
+<title>Description of Schema</title>
+<meta name="generator" content="SQL::Translator::Producer::HTML" />
+<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
+</head>
+<body>
+
+
+<h1 class="SchemaDescription">
+ Description of Schema
+</h1>
+
+<hr />
+
+<!--
+ Table listing (15 tables)
+ -->
+
+<a name="top" />
+
+<table class="LinkTable" width="100%">
+
+<tr>
+ <td class="LinkTableCell"><h2 class="LinkTableTitle">
+ Tables
+</h2></td>
+</tr>
+
+<!--
+ Start link to table 'stock'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stock-link" href="#stock">stock</a></td>
+</tr>
+
+<!--
+ End link to table 'stock'
+ -->
+
+<!--
+ Start link to table 'stock_pub'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stock_pub-link" href="#stock_pub">stock_pub</a></td>
+</tr>
+
+<!--
+ End link to table 'stock_pub'
+ -->
+
+<!--
+ Start link to table 'stockprop'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stockprop-link" href="#stockprop">stockprop</a></td>
+</tr>
+
+<!--
+ End link to table 'stockprop'
+ -->
+
+<!--
+ Start link to table 'stockprop_pub'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stockprop_pub-link" href="#stockprop_pub">stockprop_pub</a></td>
+</tr>
+
+<!--
+ End link to table 'stockprop_pub'
+ -->
+
+<!--
+ Start link to table 'stock_relationship'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stock_relationship-link" href="#stock_relationship">stock_relationship</a></td>
+</tr>
+
+<!--
+ End link to table 'stock_relationship'
+ -->
+
+<!--
+ Start link to table 'stock_relationship_cvterm'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stock_relationship_cvterm-link" href="#stock_relationship_cvterm">stock_relationship_cvterm</a></td>
+</tr>
+
+<!--
+ End link to table 'stock_relationship_cvterm'
+ -->
+
+<!--
+ Start link to table 'stock_relationship_pub'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stock_relationship_pub-link" href="#stock_relationship_pub">stock_relationship_pub</a></td>
+</tr>
+
+<!--
+ End link to table 'stock_relationship_pub'
+ -->
+
+<!--
+ Start link to table 'stock_dbxref'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stock_dbxref-link" href="#stock_dbxref">stock_dbxref</a></td>
+</tr>
+
+<!--
+ End link to table 'stock_dbxref'
+ -->
+
+<!--
+ Start link to table 'stock_cvterm'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stock_cvterm-link" href="#stock_cvterm">stock_cvterm</a></td>
+</tr>
+
+<!--
+ End link to table 'stock_cvterm'
+ -->
+
+<!--
+ Start link to table 'stock_cvtermprop'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stock_cvtermprop-link" href="#stock_cvtermprop">stock_cvtermprop</a></td>
+</tr>
+
+<!--
+ End link to table 'stock_cvtermprop'
+ -->
+
+<!--
+ Start link to table 'stock_genotype'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stock_genotype-link" href="#stock_genotype">stock_genotype</a></td>
+</tr>
+
+<!--
+ End link to table 'stock_genotype'
+ -->
+
+<!--
+ Start link to table 'stockcollection'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stockcollection-link" href="#stockcollection">stockcollection</a></td>
+</tr>
+
+<!--
+ End link to table 'stockcollection'
+ -->
+
+<!--
+ Start link to table 'stockcollectionprop'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stockcollectionprop-link" href="#stockcollectionprop">stockcollectionprop</a></td>
+</tr>
+
+<!--
+ End link to table 'stockcollectionprop'
+ -->
+
+<!--
+ Start link to table 'stockcollection_stock'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stockcollection_stock-link" href="#stockcollection_stock">stockcollection_stock</a></td>
+</tr>
+
+<!--
+ End link to table 'stockcollection_stock'
+ -->
+
+<!--
+ Start link to table 'stock_dbxrefprop'
+ -->
+
+<tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="stock_dbxrefprop-link" href="#stock_dbxrefprop">stock_dbxrefprop</a></td>
+</tr>
+
+<!--
+ End link to table 'stock_dbxrefprop'
+ -->
+
+</table>
+
+<!--
+ Starting table 'stock'
+ -->
+
+<a name="stock" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ stock
+</h3></td>
+ <a name="stock"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ $Id: stock.sql,v 1.7 2007-03-23 15:18:03 scottcain Exp $ <br />
+ ========================================== <br />
+ Chado stock module <br />
+ DEPENDENCIES <br />
+ ============ <br />
+ :import cvterm from cv <br />
+ :import pub from pub <br />
+ :import dbxref from general <br />
+ :import organism from organism <br />
+ :import genotype from genetic <br />
+ :import contact from contact <br />
+ ================================================ <br />
+ TABLE: stock <br />
+ ================================================ <br />
+ Any stock can be globally identified by the
+ combination of organism, uniquename and stock type. A stock is the physical entities, either living or preserved, held by collections. Stocks belong to a collection; they have IDs, type, organism, description and may have a genotype.
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="stock-stock_id">stock_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="stock-dbxref_id">dbxref_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">The dbxref_id is an optional primary stable identifier for this stock. Secondary indentifiers and external dbxrefs go in table: stock_dbxref. </td>
+ <td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="stock-organism_id">organism_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, The organism_id is the organism to which the stock belongs. This column should only be left blank if the organism cannot be determined. </td>
+ <td class="FieldCellFK"><a href="#organism-organism_id">organism.organism_id</a></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="stock-name">name</a></td>
+ <td class="FieldCellType">varchar</td>
+ <td class="FieldCellSize">255</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">The name is a human-readable local name for a stock. </td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="stock-uniquename">uniquename</a></td>
+ <td class="FieldCellType">text</td>
+ <td class="FieldCellSize">64000</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="stock-description">description</a></td>
+ <td class="FieldCellType">text</td>
+ <td class="FieldCellSize">64000</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">The description is the genetic description provided in the stock list. </td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="stock-type_id">type_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL, The type_id foreign key links to a controlled vocabulary of stock types. The would include living stock, genomic DNA, preserved specimen. Secondary cvterms for stocks would go in stock_cvterm. </td>
+ <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="stock-is_obsolete">is_obsolete</a></td>
+ <td class="FieldCellType">boolean</td>
+ <td class="FieldCellSize">0</td>
+ <td class="FieldCellDefault">false</td>
+ <td class="FieldCellOther">NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+</table>
+
+<h3>
+ Indices
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Name
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>stock_name_ind1</td>
+ <td>name</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>stock_idx1</td>
+ <td>dbxref_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>stock_idx2</td>
+ <td>organism_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>stock_idx3</td>
+ <td>type_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>stock_idx4</td>
+ <td>uniquename</td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>stock_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>dbxref_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>organism_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>uniquename</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>type_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>type_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>is_obsolete</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>organism_id, uniquename, type_id</td>
+</tr>
+
+</table>
+
+<hr />
+
+<!--
+ Starting table 'stock_pub'
+ -->
+
+<a name="stock_pub" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ stock_pub
+</h3></td>
+ <a name="stock_pub"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ================================================ <br />
+ TABLE: stock_pub <br />
+ ================================================ <br />
+ Provenance. Linking table between stocks and, for example, a stocklist computer file.
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="stock_pub-stock_pub_id">stock_pub_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="stock_pub-stock_id">stock_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#stock-stock_id">stock.stock_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="stock_pub-pub_id">pub_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
+</tr>
+
+</table>
+
+<h3>
+ Indices
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Name
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>stock_pub_idx1</td>
+ <td>stock_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>stock_pub_idx2</td>
+ <td>pub_id</td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>stock_pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>stock_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>stock_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>stock_id, pub_id</td>
+</tr>
+
+</table>
+
+<hr />
+
+<!--
+ Starting table 'stockprop'
+ -->
+
+<a name="stockprop" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ stockprop
+</h3></td>
+ <a name="stockprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ================================================ <br />
+ TABLE: stockprop <br />
+ ================================================ <br />
+ A stock can have any number of
+ slot-value property tags attached to it. This is an alternative to
+ hardcoding a list of columns in the relational schema, and is
+ completely extensible. There is a unique constraint, stockprop_c1, for
+ the combination of stock_id, rank, and type_id. Multivalued property-value pairs must be differentiated by rank.
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="stockprop-stockprop_id">stockprop_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="stockprop-stock_id">stock_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#stock-stock_id">stock.stock_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="stockprop-type_id">type_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="stockprop-value">value</a></td>
+ <td class="FieldCellType">text</td>
+ <td class="FieldCellSize">64000</td>
+ <td class="FieldCellDefault">NULL</td>
+ <td class="FieldCellOther"></td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="stockprop-rank">rank</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault">0</td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+</table>
+
+<h3>
+ Indices
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Name
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>stockprop_idx1</td>
+ <td>stock_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>stockprop_idx2</td>
+ <td>type_id</td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>stockprop_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>stock_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>stock_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>type_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>type_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>rank</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>stock_id, type_id, rank</td>
+</tr>
+
+</table>
+
+<hr />
+
+<!--
+ Starting table 'stockprop_pub'
+ -->
+
+<a name="stockprop_pub" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ stockprop_pub
+</h3></td>
+ <a name="stockprop_pub"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ================================================ <br />
+ TABLE: stockprop_pub <br />
+ ================================================ <br />
+ Provenance. Any stockprop assignment can optionally be supported by a publication.
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="stockprop_pub-stockprop_pub_id">stockprop_pub_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">11</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
+ <td class="FieldCellFK"></td>
+</tr>
+
+<tr class="tr-even">
+ <td class="FieldCellName"><a name="stockprop_pub-stockprop_id">stockprop_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#stockprop-stockprop_id">stockprop.stockprop_id</a></td>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldCellName"><a name="stockprop_pub-pub_id">pub_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL</td>
+ <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
+</tr>
+
+</table>
+
+<h3>
+ Indices
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Name
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>stockprop_pub_idx1</td>
+ <td>stockprop_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>stockprop_pub_idx2</td>
+ <td>pub_id</td>
+</tr>
+
+</table>
+
+<h3>
+ Constraints
+</h3>
+
+<table border="1">
+
+<tr class="IndexRow">
+ <th>
+ Type
+ </th>
+ <th>
+ Fields
+ </th>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>stockprop_pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>stockprop_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>stockprop_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>pub_id</td>
+</tr>
+
+<tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>stockprop_id, pub_id</td>
+</tr>
+
+</table>
+
+<hr />
+
+<!--
+ Starting table 'stock_relationship'
+ -->
+
+<a name="stock_relationship" />
+
+<table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ stock_relationship
+</h3></td>
+ <a name="stock_relationship"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+</table>
+
+<b>
+ Comments:
+</b>
+
+<br />
+
+<em>
+ <br />
+ ================================================ <br />
+ TABLE: stock_relationship <br />
+ ================================================
+</em>
+
+<table border="1">
+
+<tr>
+ <th class="FieldHeader">
+ Field Name
+ </th>
+ <th class="FieldHeader">
+ Data Type
+ </th>
+ <th class="FieldHeader">
+ Size
+ </th>
+ <th class="FieldHeader">
+ Default Value
+ </th>
+ <th class="FieldHeader">
+ Other
+ </th>
+ <th class="FieldHeader">
+ Foreign Key
+ </th>
+</tr>
+
+<tr class="tr-odd">
+ <td class="FieldC...
[truncated message content] |