Difference between revisions of "Template:ChadoTable feature cvterm pub"

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|Sequence|feature_cvterm_pub|Secondary pubs for an
+
<protect><noinclude>{{ChadoTableTemplateHeader}}</noinclude>
 +
{{ChadoTableDesc|Sequence|feature_cvterm_pub|Secondary pubs for an
 
association. Each feature_cvterm association is supported by a single
 
association. Each feature_cvterm association is supported by a single
 
primary publication. Additional secondary pubs can be added using this
 
primary publication. Additional secondary pubs can be added using this
Line 5: Line 6:
 
any IDs after the pipe symbol in the publications column.}}
 
any IDs after the pipe symbol in the publications column.}}
 
{{ChadoColumnsHeader|Sequence|feature_cvterm_pub}}
 
{{ChadoColumnsHeader|Sequence|feature_cvterm_pub}}
{{ChadoColumnDesc||feature_cvterm_pub_id|serial|''PRIMARY KEY''
+
{{ChadoColumnDesc||feature_cvterm_pub_id|serial|''PRIMARY KEY''<br />
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|Sequence|feature_cvterm}}|feature_cvterm_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|Sequence|feature_cvterm}}|feature_cvterm_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
{{ChadoColumnDesc|{{ChadoModuleTableLink|Publication|pub}}|pub_id|integer|''UNIQUE#1''
+
{{ChadoColumnDesc|{{ChadoModuleTableLink|Publication|pub}}|pub_id|integer|''UNIQUE#1''<br />
 
+
''NOT NULL''<br />
''NOT NULL''
+
 
+
 
}}
 
}}
 
{{ChadoColumnsFooter}}
 
{{ChadoColumnsFooter}}
  
 
{{ChadoTablesReferencingHeader|feature_cvterm_pub}}
 
{{ChadoTablesReferencingHeader|feature_cvterm_pub}}
 
+
* None.</protect>
* None.
+
</protect>
+

Latest revision as of 19:20, 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: feature_cvterm_pub
Module: Sequence

Secondary pubs for an association. Each feature_cvterm association is supported by a single primary publication. Additional secondary pubs can be added using this linking table (in a GO gene association file, these corresponding to any IDs after the pipe symbol in the publications column.

feature_cvterm_pub columns
FK Name Type Description
feature_cvterm_pub_id serial PRIMARY KEY
feature_cvterm feature_cvterm_id integer UNIQUE#1

NOT NULL

pub pub_id integer UNIQUE#1

NOT NULL


Tables referencing feature_cvterm_pub via foreign key constraints:

  • None.