Table cxgn.public.feature_synonym

Linking table between feature and synonym

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

feature_synonym_id

serial

√

nextval('feature_synonym_feature_synonym_id_seq'::regclass)

synonym_id

int4

synonym.synonym_id

feature_synonym_synonym_id_fkey

feature_id

int4

feature.feature_id

feature_synonym_feature_id_fkey

pub_id

int4

pub.pub_id

feature_synonym_pub_id_fkey

the pub_id link is for relating the usage of a given synonym to the publication in which it was used

is_current

bool

true

the is_current boolean indicates whether the linked synonym is the current -official- symbol for the linked feature

is_internal

bool

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 & deliberately (eg in a paper), it my also be listed in reports as a synonym. If the synonym was not used deliberately (eg, 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

Table contained 346,683 rows at Wed May 20 01:40 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name
feature_synonym_id	Primary key	Asc	feature_synonym_pkey
synonym_id + feature_id + pub_id	Must be unique	Asc/Asc/Asc	feature_synonym_c1
synonym_id	Performance	Asc	feature_synonym_idx1
feature_id	Performance	Asc	feature_synonym_idx2
pub_id	Performance	Asc	feature_synonym_idx3