Template:ChadoTable feature dbxref

From GMOD
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: feature_dbxref
Module: Sequence

Links a feature to dbxrefs. This is for secondary identifiers; primary identifiers should use feature.dbxref_id.

feature_dbxref columns
FK Name Type Description
feature_dbxref_id serial PRIMARY KEY
feature feature_id integer UNIQUE#1

NOT NULL

dbxref dbxref_id integer UNIQUE#1

NOT NULL

is_current boolean NOT NULL

DEFAULT true
True if this secondary dbxref is the most up to date accession in the corresponding db. Retired accessions should set this field to false

Tables referencing feature_dbxref via foreign key constraints:

  • None.