Menu
▾
▴
[Genex-cvs-commit] genex-www/genex-2 ChangeLog.html,NONE,1.1 Role.html,NONE,1.1 Scratch.html,NONE,1.1 TableDef.html,NONE,1.1
|
From: <jas...@us...> - 2003-09-22 14:45:18
|
Update of /cvsroot/genex/genex-www/genex-2
In directory sc8-pr-cvs1:/tmp/cvs-serv5269
Added Files:
ChangeLog.html Role.html Scratch.html TableDef.html
Log Message:
new
--- NEW FILE: ChangeLog.html ---
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>
GeneX-2.0 DB: ChangeLog Table
</title>
</head>
<body bgcolor="#FFD78F">
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="3">
GeneX-2.0 DB: ChangeLog Table
</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Table Type</th><th>Inherits</th><th>Comment</th>
</tr>
<tr bgcolor="#D8E4F7">
<th>DATA</th><td><a href="none.html">none</a></td><th></th>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="5">Column Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Name</th><th>Full Name</th><th>Data Type</th><th>Not NULL</th><th>Comment</th>
</tr>
<tr bgcolor="#D8E4F7">
<td>audit_fk</td><td>Audit</td><td>int</td><td>true</td><td>The audit entry when this data was last modified, it will be null if it is the creation event. We set the write_sql attribute to be false so that Postgres doesn't put a constraint on this column. It is automatically set by a trigger. </td>
</tr>
<tr bgcolor="#D8E4F7">
<td>cl_pk</td><td>Accession Number</td><td>serial</td><td>false</td><td></td>
</tr>
<tr bgcolor="#D8E4F7">
<td>description</td><td>Description</td><td>text</td><td>false</td><td></td>
</tr>
<tr bgcolor="#D8E4F7">
<td>version_date</td><td>Date of Version Creation</td><td>datetime</td><td>false</td><td></td>
</tr>
<tr bgcolor="#D8E4F7">
<td>version_number</td><td>DB Version</td><td>char128</td><td>false</td><td></td>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="1">Primary Key Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Name</th>
</tr>
<tr bgcolor="#D8E4F7">
<td>cl_pk</td>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="4">Foreign Key Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Name</th><th>Foreign Table</th><th>Primary Key in Foreign Table</th><th>Foreign Key Type</th>
</tr>
<tr bgcolor="#D8E4F7">
<td>audit_fk</td><td><a href="Audit.html">Audit</a></td><td>audit_pk</td><td>ONE_TO_ONE</td>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="1">Unique Column Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Names</th>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="2">Index Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Name</th><th>Column Name</th>
</tr>
</table>
<br>
</body>
</html>
--- NEW FILE: Role.html ---
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>
GeneX-2.0 DB: Role Table
</title>
</head>
<body bgcolor="#FFD78F">
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="3">
GeneX-2.0 DB: Role Table
</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Table Type</th><th>Inherits</th><th>Comment</th>
</tr>
<tr bgcolor="#D8E4F7">
<th>SUBSET</th><td><a href="none.html">none</a></td><th> Role is a generic association table that enables different DB entries to be assigned Roles. Roles enable applications to filter their actions. Roles can be assigned not only to users, but to DB tables, or data entries such as Contacts.</th>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="5">Column Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Name</th><th>Full Name</th><th>Data Type</th><th>Not NULL</th><th>Comment</th>
</tr>
<tr bgcolor="#D8E4F7">
<td>other_fk</td><td>Other Foreign Key</td><td>int</td><td>true</td><td>This fkey points to the DB entry to which this role is assigned. It is not listed as a fkey constraint, because it can point to any table in the DB.</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>role_name</td><td>Role Name</td><td>char128</td><td>true</td><td>A controlled vocabulary</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>table_name</td><td>Table Name</td><td>char32</td><td>true</td><td>The table to which the entry specified by other_fk belongs.</td>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="1">Primary Key Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Name</th>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="4">Foreign Key Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Name</th><th>Foreign Table</th><th>Primary Key in Foreign Table</th><th>Foreign Key Type</th>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="1">Unique Column Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Names</th>
</tr>
<tr bgcolor="#D8E4F7">
<td>other_fk role_name</td>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="2">Index Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Name</th><th>Column Name</th>
</tr>
</table>
<br>
</body>
</html>
--- NEW FILE: Scratch.html ---
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>
GeneX-2.0 DB: Scratch Table
</title>
</head>
<body bgcolor="#FFD78F">
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="3">
GeneX-2.0 DB: Scratch Table
</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Table Type</th><th>Inherits</th><th>Comment</th>
</tr>
<tr bgcolor="#D8E4F7">
<th>DATA</th><td><a href="none.html">none</a></td><th>The Scratch table defines the user scratch space used for storing intermediate analysis results before they are moved into the DerivedBioAssayData table</th>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="5">Column Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Name</th><th>Full Name</th><th>Data Type</th><th>Not NULL</th><th>Comment</th>
</tr>
<tr bgcolor="#D8E4F7">
<td>bool1</td><td>Bool 1</td><td>bool</td><td>false</td><td>The first variable boolean column</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>dba_fk</td><td>Derived BioAssay</td><td>int</td><td>true</td><td>The Derived BioAssay to which this data belongs</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>float1</td><td>Float 1</td><td>float</td><td>false</td><td>The first variable floating point column</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>float2</td><td>Float 2</td><td>float</td><td>false</td><td>The second variable floating point column</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>float3</td><td>Float 3</td><td>float</td><td>false</td><td>The third variable floating point column</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>float4</td><td>Float 4</td><td>float</td><td>false</td><td>The fourth variable floating point column</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>int1</td><td>Int 1</td><td>int</td><td>false</td><td>The first variable integer column</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>int2</td><td>Int 2</td><td>int</td><td>false</td><td>The second variable integer column</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>int3</td><td>Int 3</td><td>int</td><td>false</td><td>The third variable integer column</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>int4</td><td>Int 4</td><td>int</td><td>false</td><td>The fourth variable integer column</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>spot_identifier</td><td>Spot Identifier</td><td>char128</td><td>true</td><td>The identifier used to identify a spot from an array</td>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="1">Primary Key Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Name</th>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="4">Foreign Key Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Name</th><th>Foreign Table</th><th>Primary Key in Foreign Table</th><th>Foreign Key Type</th>
</tr>
<tr bgcolor="#D8E4F7">
<td>dba_fk</td><td><a href="DerivedBioAssay.html">DerivedBioAssay</a></td><td>dba_pk</td><td>ONE_TO_ONE</td>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="1">Unique Column Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Names</th>
</tr>
<tr bgcolor="#D8E4F7">
<td>spot_identifier dba_fk</td>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="2">Index Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Name</th><th>Column Name</th>
</tr>
</table>
<br>
</body>
</html>
--- NEW FILE: TableDef.html ---
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>
GeneX-2.0 DB: TableDef Table
</title>
</head>
<body bgcolor="#FFD78F">
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="3">
GeneX-2.0 DB: TableDef Table
</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Table Type</th><th>Inherits</th><th>Comment</th>
</tr>
<tr bgcolor="#D8E4F7">
<th>DATA</th><td><a href="none.html">none</a></td><th>The TableDef table defines information about individual tables in the DB, such as their abbreviated names and their API names.</th>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="5">Column Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Name</th><th>Full Name</th><th>Data Type</th><th>Not NULL</th><th>Comment</th>
</tr>
<tr bgcolor="#D8E4F7">
<td>api_name</td><td>API Name</td><td>char32</td><td>true</td><td>The name of the table in the programming language API, this usually contains mixed case, and will often remove underscores, etc.</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>audit_fk</td><td>Audit</td><td>int</td><td>true</td><td>The audit entry when this data was last modified, it will be null if it is the creation event. We set the write_sql attribute to be false so that Postgres doesn't put a constraint on this column. It is automatically set by a trigger. </td>
</tr>
<tr bgcolor="#D8E4F7">
<td>description</td><td>Description</td><td>text</td><td>false</td><td></td>
</tr>
<tr bgcolor="#D8E4F7">
<td>is_abstract</td><td>Is Abstract</td><td>bool</td><td>true</td><td>Whether this table is an abstract table that holds no real data, but instead provides an inheritance template.</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>lc_table_name</td><td>Lowercase Table Name</td><td>char32</td><td>true</td><td>The name of the table in all lowercase letters</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>table_name</td><td>Table Name</td><td>char32</td><td>true</td><td>The name of the table</td>
</tr>
<tr bgcolor="#D8E4F7">
<td>td_pk</td><td>Accession Number</td><td>serial</td><td>false</td><td></td>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="1">Primary Key Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Name</th>
</tr>
<tr bgcolor="#D8E4F7">
<td>td_pk</td>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="4">Foreign Key Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Name</th><th>Foreign Table</th><th>Primary Key in Foreign Table</th><th>Foreign Key Type</th>
</tr>
<tr bgcolor="#D8E4F7">
<td>audit_fk</td><td><a href="Audit.html">Audit</a></td><td>audit_pk</td><td>ONE_TO_ONE</td>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="1">Unique Column Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Column Names</th>
</tr>
</table>
<br>
<table border="2">
<tr bgcolor="#BFD8D8">
<th colspan="2">Index Information</th>
</tr>
<tr bgcolor="#BFD8D8">
<th>Name</th><th>Column Name</th>
</tr>
</table>
<br>
</body>
</html>
|
