Difference between revisions of "Template:ChadoTable stock dbxrefprop"

From GMOD
Jump to: navigation, search
(Table definition, first upload on 2010/11/22.)
 
(Table definition for Chado on 2010/11/24)
 
Line 1: Line 1:
<noinclude>{{ChadoTableTemplateHeader}}</noinclude><protect>{{ChadoTableDesc|Stock|stock_dbxrefprop|A stock_dbxref can have any number of
+
<protect><noinclude>{{ChadoTableTemplateHeader}}</noinclude>
 +
{{ChadoTableDesc|Stock|stock_dbxrefprop|A stock_dbxref can have any number of
 
slot-value property tags attached to it. This is useful for storing properties related to dbxref annotations of stocks, such as evidence codes, and references, and metadata, such as create/modify dates. This is an alternative to
 
slot-value property tags attached to it. This is useful for storing properties related to dbxref annotations of stocks, such as evidence codes, and references, and metadata, such as create/modify dates. This is an alternative to
 
hardcoding a list of columns in the relational schema, and is
 
hardcoding a list of columns in the relational schema, and is
Line 5: Line 6:
 
the combination of stock_dbxref_id, rank, and type_id. Multivalued property-value pairs must be differentiated by rank.}}
 
the combination of stock_dbxref_id, rank, and type_id. Multivalued property-value pairs must be differentiated by rank.}}
 
{{ChadoColumnsHeader|Stock|stock_dbxrefprop}}
 
{{ChadoColumnsHeader|Stock|stock_dbxrefprop}}
{{ChadoColumnDesc||stock_dbxrefprop_id|serial|''PRIMARY KEY''
+
{{ChadoColumnDesc||stock_dbxrefprop_id|serial|''PRIMARY KEY''<br />
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|Stock|stock_dbxref}}|stock_dbxref_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|Stock|stock_dbxref}}|stock_dbxref_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|CV|cvterm}}|type_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|CV|cvterm}}|type_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
 
{{ChadoColumnDesc||value|text|}}
 
{{ChadoColumnDesc||value|text|}}
{{ChadoColumnDesc||rank|integer|''UNIQUE#1''
+
{{ChadoColumnDesc||rank|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
 
{{ChadoColumnsFooter}}
 
{{ChadoColumnsFooter}}
  
 
{{ChadoTablesReferencingHeader|stock_dbxrefprop}}
 
{{ChadoTablesReferencingHeader|stock_dbxrefprop}}
 
+
* None.</protect>
* None.
+
</protect>
+

Latest revision as of 19:23, 24 November 2010

This template is a Chado Table Template. It defines a single table from the Chado schema, and every Chado table has a template like this one. This template is automatically included in two places:

  1. The module page for the module the table is a part of. This is where updates and comments should be posted.
  2. The Chado Tables page, which lists all tables.

You can include this template anywhere you want to show the table description.


Table: stock_dbxrefprop
Module: Stock

A stock_dbxref can have any number of slot-value property tags attached to it. This is useful for storing properties related to dbxref annotations of stocks, such as evidence codes, and references, and metadata, such as create/modify dates. This is an alternative to hardcoding a list of columns in the relational schema, and is completely extensible. There is a unique constraint, stock_dbxrefprop_c1, for the combination of stock_dbxref_id, rank, and type_id. Multivalued property-value pairs must be differentiated by rank.

stock_dbxrefprop columns
FK Name Type Description
stock_dbxrefprop_id serial PRIMARY KEY
stock_dbxref stock_dbxref_id integer UNIQUE#1

NOT NULL

cvterm type_id integer UNIQUE#1

NOT NULL

value text
rank integer UNIQUE#1

NOT NULL


Tables referencing stock_dbxrefprop via foreign key constraints:

  • None.