Template:ChadoTable nd experiment phenotype

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: nd_experiment_phenotype
Module: Natural Diversity

Linking table: experiments to the phenotypes they produce. There is a one-to-one relationship between an experiment and a phenotype since each phenotype record should point to one experiment. Add a new experiment_id for each phenotype record.

nd_experiment_phenotype columns
FK Name Type Description
nd_experiment_phenotype_id serial PRIMARY KEY
nd_experiment nd_experiment_id integer UNIQUE


phenotype phenotype_id integer NOT NULL

Tables referencing nd_experiment_phenotype via foreign key constraints:

  • None.