Template:ChadoTable phylonode organism

Revision as of 19:23, 24 November 2010 by Clements (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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: phylonode_organism
Module: Phylogeny

This linking table should only be used for nodes in taxonomy trees; it provides a mapping between the node and an organism. One node can have zero or one organisms, one organism can have zero or more nodes (although typically it should only have one in the standard NCBI taxonomy tree).

phylonode_organism columns
FK Name Type Description
phylonode_organism_id serial PRIMARY KEY
phylonode phylonode_id integer UNIQUE

One phylonode cannot refer to >1 organism.

organism organism_id integer NOT NULL

Tables referencing phylonode_organism via foreign key constraints:

  • None.