Difference between revisions of "Template:ChadoTable synonym"

From GMOD
Jump to: navigation, search
(Table definition for Chado on 2010/11/24)
(Table definition for Chado on 2010/11/24)
 
Line 15: Line 15:
  
 
{{ChadoTablesReferencingHeader|synonym}}
 
{{ChadoTablesReferencingHeader|synonym}}
* {{ChadoReferencingTable|Cell Line|cell_line_synonym}}
+
{{ChadoReferencingTable|Cell Line|cell_line_synonym}}
* {{ChadoReferencingTable|Sequence|feature_synonym}}
+
{{ChadoReferencingTable|Sequence|feature_synonym}}
* {{ChadoReferencingTable|Library|library_synonym}}
+
{{ChadoReferencingTable|Library|library_synonym}}
 
</protect>
 
</protect>

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

A synonym for a feature. One feature can have multiple synonyms, and the same synonym can apply to multiple features.

synonym columns
FK Name Type Description
synonym_id serial PRIMARY KEY
name character varying(255) UNIQUE#1

NOT NULL
The synonym itself. Should be human-readable machine-searchable ascii text.

cvterm type_id integer UNIQUE#1

NOT NULL
Types would be symbol and fullname for now.

synonym_sgml character varying(255) NOT NULL

The fully specified synonym, with any non-ascii characters encoded in SGML.

Tables referencing synonym via foreign key constraints: