Table cxgn.public.cvtermsynonym

A cvterm actually represents a
distinct class or concept. A concept can be refered to by different
phrases or names. In addition to the primary name (cvterm.name) there
can be a number of alternative aliases or synonyms. For example, -T
cell- as a synonym for -T lymphocyte-

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

cvtermsynonym_id

serial

√

nextval('cvtermsynonym_cvtermsynonym_id_seq'::regclass)

cvterm_id

int4

cvterm.cvterm_id

cvtermsynonym_cvterm_id_fkey

synonym

varchar

1024

type_id

int4

√

null

cvterm.cvterm_id

cvtermsynonym_type_id_fkey

A synonym can be exact,
narrow or borader than

Table contained 33,552 rows at Wed May 20 01:40 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name
cvtermsynonym_id	Primary key	Asc	cvtermsynonym_pkey
cvterm_id + synonym	Must be unique	Asc/Asc	cvtermsynonym_c1
cvterm_id	Performance	Asc	cvtermsynonym_idx1