Template:ChadoTable stock dbxref

From GMOD

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_dbxref
Module:	Stock

stock_dbxref links a stock to dbxrefs. This is for secondary identifiers; primary identifiers should use stock.dbxref_id.

stock_dbxref columns

FK	Name	Type	Description
	stock_dbxref_id	serial	PRIMARY KEY
stock	stock_id	integer	UNIQUE#1 NOT NULL
dbxref	dbxref_id	integer	UNIQUE#1 NOT NULL
	is_current	boolean	NOT NULL DEFAULT true The is_current boolean indicates whether the linked dbxref is the current -official- dbxref for the linked stock.

Tables referencing stock_dbxref via foreign key constraints:

• stock_dbxrefprop