Template:ChadoTable stock relationship

From GMOD
Revision as of 19:58, 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: stock_relationship
Module: Stock


stock_relationship columns
FK Name Type Description
stock_relationship_id serial PRIMARY KEY
stock subject_id integer UNIQUE#1

NOT NULL
stock_relationship.subject_id is the subject of the subj-predicate-obj sentence. This is typically the substock.

stock object_id integer UNIQUE#1

NOT NULL
stock_relationship.object_id is the object of the subj-predicate-obj sentence. This is typically the container stock.

cvterm type_id integer UNIQUE#1

NOT NULL
stock_relationship.type_id is relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed.

value text stock_relationship.value is for additional notes or comments.
rank integer UNIQUE#1

NOT NULL
stock_relationship.rank is the ordering of subject stocks with respect to the object stock may be important where rank is used to order these; starts from zero.

Tables referencing stock_relationship via foreign key constraints: