Table cxgn.public.phenotype_cvterm

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

phenotype_cvterm_id

serial

nextval('phenotype_cvterm_phenotype_cvterm_id_seq'::regclass)

phenotype_id

int4

phenotype.phenotype_id

phenotype_cvterm_phenotype_id_fkey

cvterm_id

int4

cvterm.cvterm_id

phenotype_cvterm_cvterm_id_fkey

rank

int4

Table contained -1 rows at Wed May 20 01:40 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name
phenotype_cvterm_id	Primary key	Asc	phenotype_cvterm_pkey
phenotype_id + cvterm_id + rank	Must be unique	Asc/Asc/Asc	phenotype_cvterm_c1
phenotype_id	Performance	Asc	phenotype_cvterm_idx1
cvterm_id	Performance	Asc	phenotype_cvterm_idx2