Update of /cvsroot/gmod/gmod-home/htdocs/schema/doc
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv566
Modified Files:
cv.html default_schema.html general.html sequence.html
Log Message:
updating schema docs for new schema
Index: cv.html
===================================================================
RCS file: /cvsroot/gmod/gmod-home/htdocs/schema/doc/cv.html,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** cv.html 18 Nov 2004 19:57:10 -0000 1.1
--- cv.html 23 Feb 2005 15:45:40 -0000 1.2
***************
*** 14,18 ****
<!--
! Table listing (7 tables)
-->
--- 14,18 ----
<!--
! Table listing (8 tables)
-->
***************
*** 100,103 ****
--- 100,115 ----
<!--
+ Start link to table 'cvtermprop'
+ -->
+
+ <tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="cvtermprop-link" href="#cvtermprop">cvtermprop</a></td>
+ </tr>
+
+ <!--
+ End link to table 'cvtermprop'
+ -->
+
+ <!--
Start link to table 'dbxrefprop'
-->
***************
*** 177,181 ****
<td class="FieldCellName"><a name="cv-name">name</a></td>
<td class="FieldCellType">varchar</td>
! <td class="FieldCellSize">1024</td>
<td class="FieldCellDefault"></td>
<td class="FieldCellOther">UNIQUE, NOT NULL</td>
--- 189,193 ----
<td class="FieldCellName"><a name="cv-name">name</a></td>
<td class="FieldCellType">varchar</td>
! <td class="FieldCellSize">255</td>
<td class="FieldCellDefault"></td>
<td class="FieldCellOther">UNIQUE, NOT NULL</td>
***************
*** 253,257 ****
================================================ <br />
TABLE: cvterm <br />
! ================================================
</em>
--- 265,272 ----
================================================ <br />
TABLE: cvterm <br />
! ================================================ <br />
! A term, class or concept within an ontology or controlled vocabulary.
! Also used for relationship types. A cvterm can also be thought of
! as a node in a graph
</em>
***************
*** 293,297 ****
<td class="FieldCellSize">10</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther">UNIQUE, NOT NULL</td>
<td class="FieldCellFK"><a href="#cv-cv_id">cv.cv_id</a></td>
</tr>
--- 308,312 ----
<td class="FieldCellSize">10</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther">UNIQUE, NOT NULL, The cv/ontology/namespace to which this cvterm belongs </td>
<td class="FieldCellFK"><a href="#cv-cv_id">cv.cv_id</a></td>
</tr>
***************
*** 302,306 ****
<td class="FieldCellSize">1024</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther">UNIQUE, NOT NULL</td>
<td class="FieldCellFK"></td>
</tr>
--- 317,321 ----
<td class="FieldCellSize">1024</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther">UNIQUE, NOT NULL, A concise human-readable name describing the meaning of the cvterm </td>
<td class="FieldCellFK"></td>
</tr>
***************
*** 311,315 ****
<td class="FieldCellSize">64000</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther"></td>
<td class="FieldCellFK"></td>
</tr>
--- 326,330 ----
<td class="FieldCellSize">64000</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther">A human-readable text definition </td>
<td class="FieldCellFK"></td>
</tr>
***************
*** 320,327 ****
<td class="FieldCellSize">10</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther"></td>
<td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
</tr>
</table>
--- 335,368 ----
<td class="FieldCellSize">10</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther">UNIQUE, NOT NULL, Primary dbxref - The unique global OBO identifier for this cvterm.
! Note that a cvterm may have multiple secondary dbxrefs - see also
! table: cvterm_dbxref </td>
<td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
</tr>
+ <tr>
+ <td class="FieldCellName"><a name="cvterm-is_obsolete">is_obsolete</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault">0</td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL, Boolean 0=false,1=true; see GO documentation for details of obsoletion.
+ note that two terms with different primary dbxrefs may exist if one
+ is obsolete </td>
+ <td class="FieldCellFK"></td>
+ </tr>
+
+ <tr>
+ <td class="FieldCellName"><a name="cvterm-is_relationshiptype">is_relationshiptype</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault">0</td>
+ <td class="FieldCellOther">NOT NULL, Boolean 0=false,1=true
+ Relationship types (also known as Typedefs in OBO format, or as
+ properties or slots) form a cv/ontology in themselves. We use this
+ flag to indicate whether this cvterm is an actual term/concept or
+ a relationship type </td>
+ <td class="FieldCellFK"></td>
+ </tr>
+
</table>
***************
*** 394,397 ****
--- 435,443 ----
<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>dbxref_id</td>
+ </tr>
+
+ <tr class="IndexCell">
<td>FOREIGN KEY</td>
<td>dbxref_id</td>
***************
*** 399,404 ****
<tr class="IndexCell">
<td>UNIQUE</td>
! <td>name, cv_id</td>
</tr>
--- 445,465 ----
<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>is_obsolete</td>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>is_relationshiptype</td>
+ </tr>
+
+ <tr class="IndexCell">
<td>UNIQUE</td>
! <td>name, cv_id, is_obsolete</td>
! </tr>
!
! <tr class="IndexCell">
! <td>UNIQUE</td>
! <td>dbxref_id</td>
</tr>
***************
*** 430,439 ****
<em>
<br />
! the primary dbxref for this term. Other dbxrefs may be cvterm_dbxref <br />
! The unique key on termname, cv_id ensures that all terms are <br />
! unique within a given cv <br />
================================================ <br />
TABLE: cvterm_relationship <br />
! ================================================
</em>
--- 491,508 ----
<em>
<br />
! the OBO identifier is globally unique <br />
! a name can mean different things in different contexts;
! for example "chromosome" in SO and GO. A name should be unique
! within an ontology/cv. A name may exist twice in a cv, in both
! obsolete and non-obsolete forms - these will be for different
! cvterms with different OBO identifiers; so GO documentation for
! more details on obsoletion <br />
================================================ <br />
TABLE: cvterm_relationship <br />
! ================================================ <br />
! A relationship linking two cvterms. A relationship can be thought of
! as an edge in a graph, or as a natural language statement about
! two cvterms. The statement is of the form SUBJECT PREDICATE OBJECT;
! for example "wing part_of body"
</em>
***************
*** 876,879 ****
--- 945,957 ----
</tr>
+ <tr>
+ <td class="FieldCellName"><a name="cvtermsynonym-type_id">type_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther"></td>
+ <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
+ </tr>
+
</table>
***************
*** 936,939 ****
--- 1014,1022 ----
<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>type_id</td>
+ </tr>
+
+ <tr class="IndexCell">
<td>UNIQUE</td>
<td>cvterm_id, synonym</td>
***************
*** 1022,1025 ****
--- 1105,1117 ----
</tr>
+ <tr>
+ <td class="FieldCellName"><a name="cvterm_dbxref-is_for_definition">is_for_definition</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault">0</td>
+ <td class="FieldCellOther">NOT NULL</td>
+ <td class="FieldCellFK"></td>
+ </tr>
+
</table>
***************
*** 1092,1095 ****
--- 1184,1192 ----
<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>is_for_definition</td>
+ </tr>
+
+ <tr class="IndexCell">
<td>UNIQUE</td>
<td>cvterm_id, dbxref_id</td>
***************
*** 1101,1104 ****
--- 1198,1385 ----
<!--
+ Starting table 'cvtermprop'
+ -->
+
+ <a name="cvtermprop" />
+
+ <table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ cvtermprop
+ </h3></td>
+ <a name="cvtermprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+ </table>
+
+ <b>
+ Comments:
+ </b>
+
+ <br />
+
+ <em>
+ <br />
+ ================================================ <br />
+ TABLE: 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>
+ <td class="FieldCellName"><a name="cvtermprop-cvtermprop_id">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>
+ <td class="FieldCellName"><a name="cvtermprop-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>
+ <td class="FieldCellName"><a name="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>
+ <td class="FieldCellName"><a name="cvtermprop-value">value</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>
+ <td class="FieldCellName"><a name="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>
+ Indices
+ </h3>
+
+ <table border="1">
+
+ <tr class="IndexRow">
+ <th>
+ Name
+ </th>
+ <th>
+ Fields
+ </th>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>cvtermprop_idx1</td>
+ <td>cvterm_id</td>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>cvtermprop_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>cvtermprop_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>type_id</td>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>type_id</td>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>value</td>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>rank</td>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>cvterm_id, type_id, value, rank</td>
+ </tr>
+
+ </table>
+
+ <hr />
+
+ <!--
Starting table 'dbxrefprop'
-->
***************
*** 1182,1187 ****
<td class="FieldCellType">text</td>
<td class="FieldCellSize">64000</td>
! <td class="FieldCellDefault">NULL</td>
! <td class="FieldCellOther"></td>
<td class="FieldCellFK"></td>
</tr>
--- 1463,1468 ----
<td class="FieldCellType">text</td>
<td class="FieldCellSize">64000</td>
! <td class="FieldCellDefault"></td>
! <td class="FieldCellOther">NOT NULL</td>
<td class="FieldCellFK"></td>
</tr>
***************
*** 1267,1270 ****
--- 1548,1556 ----
<tr class="IndexCell">
<td>NOT NULL</td>
+ <td>value</td>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>NOT NULL</td>
<td>rank</td>
</tr>
Index: default_schema.html
===================================================================
RCS file: /cvsroot/gmod/gmod-home/htdocs/schema/doc/default_schema.html,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** default_schema.html 19 Nov 2004 18:20:31 -0000 1.1
--- default_schema.html 23 Feb 2005 15:45:41 -0000 1.2
***************
*** 14,18 ****
<!--
! Table listing (90 tables)
-->
--- 14,18 ----
<!--
! Table listing (91 tables)
-->
***************
*** 160,163 ****
--- 160,175 ----
<!--
+ Start link to table 'cvtermprop'
+ -->
+
+ <tr class="LinkTableRow">
+ <td class="LinkTableCell"><a id="cvtermprop-link" href="#cvtermprop">cvtermprop</a></td>
+ </tr>
+
+ <!--
+ End link to table 'cvtermprop'
+ -->
+
+ <!--
Start link to table 'dbxrefprop'
-->
***************
*** 1474,1478 ****
<td class="FieldCellSize">10</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther">NOT NULL</td>
<td class="FieldCellFK"><a href="#contact-contact_id">contact.contact_id</a></td>
</tr>
--- 1486,1490 ----
<td class="FieldCellSize">10</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther"></td>
<td class="FieldCellFK"><a href="#contact-contact_id">contact.contact_id</a></td>
</tr>
***************
*** 1533,1541 ****
<tr class="IndexCell">
- <td>NOT NULL</td>
- <td>contact_id</td>
- </tr>
-
- <tr class="IndexCell">
<td>FOREIGN KEY</td>
<td>contact_id</td>
--- 1545,1548 ----
***************
*** 1915,1919 ****
<td class="FieldCellName"><a name="cv-name">name</a></td>
<td class="FieldCellType">varchar</td>
! <td class="FieldCellSize">1024</td>
<td class="FieldCellDefault"></td>
<td class="FieldCellOther">UNIQUE, NOT NULL</td>
--- 1922,1926 ----
<td class="FieldCellName"><a name="cv-name">name</a></td>
<td class="FieldCellType">varchar</td>
! <td class="FieldCellSize">255</td>
<td class="FieldCellDefault"></td>
<td class="FieldCellOther">UNIQUE, NOT NULL</td>
***************
*** 1991,1995 ****
================================================ <br />
TABLE: cvterm <br />
! ================================================
</em>
--- 1998,2005 ----
================================================ <br />
TABLE: cvterm <br />
! ================================================ <br />
! A term, class or concept within an ontology or controlled vocabulary.
! Also used for relationship types. A cvterm can also be thought of
! as a node in a graph
</em>
***************
*** 2031,2035 ****
<td class="FieldCellSize">10</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther">UNIQUE, NOT NULL</td>
<td class="FieldCellFK"><a href="#cv-cv_id">cv.cv_id</a></td>
</tr>
--- 2041,2045 ----
<td class="FieldCellSize">10</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther">UNIQUE, NOT NULL, The cv/ontology/namespace to which this cvterm belongs </td>
<td class="FieldCellFK"><a href="#cv-cv_id">cv.cv_id</a></td>
</tr>
***************
*** 2040,2044 ****
<td class="FieldCellSize">1024</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther">UNIQUE, NOT NULL</td>
<td class="FieldCellFK"></td>
</tr>
--- 2050,2054 ----
<td class="FieldCellSize">1024</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther">UNIQUE, NOT NULL, A concise human-readable name describing the meaning of the cvterm </td>
<td class="FieldCellFK"></td>
</tr>
***************
*** 2049,2053 ****
<td class="FieldCellSize">64000</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther"></td>
<td class="FieldCellFK"></td>
</tr>
--- 2059,2063 ----
<td class="FieldCellSize">64000</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther">A human-readable text definition </td>
<td class="FieldCellFK"></td>
</tr>
***************
*** 2058,2065 ****
<td class="FieldCellSize">10</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther"></td>
<td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
</tr>
</table>
--- 2068,2101 ----
<td class="FieldCellSize">10</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther">UNIQUE, NOT NULL, Primary dbxref - The unique global OBO identifier for this cvterm.
! Note that a cvterm may have multiple secondary dbxrefs - see also
! table: cvterm_dbxref </td>
<td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
</tr>
+ <tr>
+ <td class="FieldCellName"><a name="cvterm-is_obsolete">is_obsolete</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault">0</td>
+ <td class="FieldCellOther">UNIQUE, NOT NULL, Boolean 0=false,1=true; see GO documentation for details of obsoletion.
+ note that two terms with different primary dbxrefs may exist if one
+ is obsolete </td>
+ <td class="FieldCellFK"></td>
+ </tr>
+
+ <tr>
+ <td class="FieldCellName"><a name="cvterm-is_relationshiptype">is_relationshiptype</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault">0</td>
+ <td class="FieldCellOther">NOT NULL, Boolean 0=false,1=true
+ Relationship types (also known as Typedefs in OBO format, or as
+ properties or slots) form a cv/ontology in themselves. We use this
+ flag to indicate whether this cvterm is an actual term/concept or
+ a relationship type </td>
+ <td class="FieldCellFK"></td>
+ </tr>
+
</table>
***************
*** 2132,2135 ****
--- 2168,2176 ----
<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>dbxref_id</td>
+ </tr>
+
+ <tr class="IndexCell">
<td>FOREIGN KEY</td>
<td>dbxref_id</td>
***************
*** 2137,2142 ****
<tr class="IndexCell">
<td>UNIQUE</td>
! <td>name, cv_id</td>
</tr>
--- 2178,2198 ----
<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>is_obsolete</td>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>is_relationshiptype</td>
+ </tr>
+
+ <tr class="IndexCell">
<td>UNIQUE</td>
! <td>name, cv_id, is_obsolete</td>
! </tr>
!
! <tr class="IndexCell">
! <td>UNIQUE</td>
! <td>dbxref_id</td>
</tr>
***************
*** 2168,2177 ****
<em>
<br />
! the primary dbxref for this term. Other dbxrefs may be cvterm_dbxref <br />
! The unique key on termname, cv_id ensures that all terms are <br />
! unique within a given cv <br />
================================================ <br />
TABLE: cvterm_relationship <br />
! ================================================
</em>
--- 2224,2241 ----
<em>
<br />
! the OBO identifier is globally unique <br />
! a name can mean different things in different contexts;
! for example "chromosome" in SO and GO. A name should be unique
! within an ontology/cv. A name may exist twice in a cv, in both
! obsolete and non-obsolete forms - these will be for different
! cvterms with different OBO identifiers; so GO documentation for
! more details on obsoletion <br />
================================================ <br />
TABLE: cvterm_relationship <br />
! ================================================ <br />
! A relationship linking two cvterms. A relationship can be thought of
! as an edge in a graph, or as a natural language statement about
! two cvterms. The statement is of the form SUBJECT PREDICATE OBJECT;
! for example "wing part_of body"
</em>
***************
*** 2614,2617 ****
--- 2678,2690 ----
</tr>
+ <tr>
+ <td class="FieldCellName"><a name="cvtermsynonym-type_id">type_id</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault"></td>
+ <td class="FieldCellOther"></td>
+ <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
+ </tr>
+
</table>
***************
*** 2674,2677 ****
--- 2747,2755 ----
<tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>type_id</td>
+ </tr>
+
+ <tr class="IndexCell">
<td>UNIQUE</td>
<td>cvterm_id, synonym</td>
***************
*** 2760,2763 ****
--- 2838,2850 ----
</tr>
+ <tr>
+ <td class="FieldCellName"><a name="cvterm_dbxref-is_for_definition">is_for_definition</a></td>
+ <td class="FieldCellType">integer</td>
+ <td class="FieldCellSize">10</td>
+ <td class="FieldCellDefault">0</td>
+ <td class="FieldCellOther">NOT NULL</td>
+ <td class="FieldCellFK"></td>
+ </tr>
+
</table>
***************
*** 2830,2833 ****
--- 2917,2925 ----
<tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>is_for_definition</td>
+ </tr>
+
+ <tr class="IndexCell">
<td>UNIQUE</td>
<td>cvterm_id, dbxref_id</td>
***************
*** 2839,2842 ****
--- 2931,3118 ----
<!--
+ Starting table 'cvtermprop'
+ -->
+
+ <a name="cvtermprop" />
+
+ <table class="TableHeader" width="100%">
+ <tr class="TableHeaderRow">
+ <td class="TableHeaderCell"><h3>
+ cvtermprop
+ </h3></td>
+ <a name="cvtermprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
+ </tr>
+ </table>
+
+ <b>
+ Comments:
+ </b>
+
+ <br />
+
+ <em>
+ <br />
+ ================================================ <br />
+ TABLE: 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>
+ <td class="FieldCellName"><a name="cvtermprop-cvtermprop_id">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>
+ <td class="FieldCellName"><a name="cvtermprop-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>
+ <td class="FieldCellName"><a name="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>
+ <td class="FieldCellName"><a name="cvtermprop-value">value</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>
+ <td class="FieldCellName"><a name="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>
+ Indices
+ </h3>
+
+ <table border="1">
+
+ <tr class="IndexRow">
+ <th>
+ Name
+ </th>
+ <th>
+ Fields
+ </th>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>cvtermprop_idx1</td>
+ <td>cvterm_id</td>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>cvtermprop_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>cvtermprop_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>type_id</td>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>FOREIGN KEY</td>
+ <td>type_id</td>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>value</td>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>NOT NULL</td>
+ <td>rank</td>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>UNIQUE</td>
+ <td>cvterm_id, type_id, value, rank</td>
+ </tr>
+
+ </table>
+
+ <hr />
+
+ <!--
Starting table 'dbxrefprop'
-->
***************
*** 2920,2925 ****
<td class="FieldCellType">text</td>
<td class="FieldCellSize">64000</td>
! <td class="FieldCellDefault">NULL</td>
! <td class="FieldCellOther"></td>
<td class="FieldCellFK"></td>
</tr>
--- 3196,3201 ----
<td class="FieldCellType">text</td>
<td class="FieldCellSize">64000</td>
! <td class="FieldCellDefault"></td>
! <td class="FieldCellOther">NOT NULL</td>
<td class="FieldCellFK"></td>
</tr>
***************
*** 3005,3008 ****
--- 3281,3289 ----
<tr class="IndexCell">
<td>NOT NULL</td>
+ <td>value</td>
+ </tr>
+
+ <tr class="IndexCell">
+ <td>NOT NULL</td>
<td>rank</td>
</tr>
***************
*** 5201,5204 ****
--- 5482,5490 ----
</tr>
+ <tr class="IndexCell">
+ <td>CHECK</td>
+ <td></td>
+ </tr>
+
</table>
Index: sequence.html
===================================================================
RCS file: /cvsroot/gmod/gmod-home/htdocs/schema/doc/sequence.html,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** sequence.html 18 Nov 2004 19:57:10 -0000 1.1
--- sequence.html 23 Feb 2005 15:45:42 -0000 1.2
***************
*** 798,801 ****
--- 798,806 ----
</tr>
+ <tr class="IndexCell">
+ <td>CHECK</td>
+ <td></td>
+ </tr>
+
</table>
Index: general.html
===================================================================
RCS file: /cvsroot/gmod/gmod-home/htdocs/schema/doc/general.html,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** general.html 18 Nov 2004 19:57:10 -0000 1.1
--- general.html 23 Feb 2005 15:45:42 -0000 1.2
***************
*** 454,458 ****
<td class="FieldCellSize">10</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther">NOT NULL</td>
<td class="FieldCellFK"><a href="#contact-contact_id">contact.contact_id</a></td>
</tr>
--- 454,458 ----
<td class="FieldCellSize">10</td>
<td class="FieldCellDefault"></td>
! <td class="FieldCellOther"></td>
<td class="FieldCellFK"><a href="#contact-contact_id">contact.contact_id</a></td>
</tr>
***************
*** 513,521 ****
<tr class="IndexCell">
- <td>NOT NULL</td>
- <td>contact_id</td>
- </tr>
-
- <tr class="IndexCell">
<td>FOREIGN KEY</td>
<td>contact_id</td>
--- 513,516 ----
|