Template:ChadoTable feature synonym

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_synonym
Module:	Sequence

Linking table between feature and synonym.

feature_synonym columns

FK	Name	Type	Description
	feature_synonym_id	serial	PRIMARY KEY
synonym	synonym_id	integer	UNIQUE#1 NOT NULL
feature	feature_id	integer	UNIQUE#1 NOT NULL
pub	pub_id	integer	UNIQUE#1 NOT NULL The pub_id link is for relating the usage of a given synonym to the publication in which it was used.
	is_current	boolean	NOT NULL DEFAULT false The is_current boolean indicates whether the linked synonym is the current -official- symbol for the linked feature.
	is_internal	boolean	NOT NULL DEFAULT false Typically a synonym exists so that somebody querying the db with an obsolete name can find the object theyre looking for (under its current name. If the synonym has been used publicly and deliberately (e.g. in a paper), it may also be listed in reports as a synonym. If the synonym was not used deliberately (e.g. there was a typo which went public), then the is_internal boolean may be set to -true- so that it is known that the synonym is -internal- and should be queryable but should not be listed in reports as a valid synonym.

Tables referencing feature_synonym via foreign key constraints:

• None.