Table cxgn.phenome.phenotype_term

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_term_id

serial

√

nextval('phenotype_term_phenotype_term_id_seq'::regclass)

term_ref

varchar

√

null

term_id

varchar

√

null

phenotype_id

int4

√

null

phenotype.phenotype_id

phenotype_term_phenotype_id_fkey

Table contained 0 rows at Fri Oct 10 01:30 EDT 2008

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
phenotype_term_id	Primary key	Asc	phenotype_term_pkey
term_id + phenotype_id	Must be unique	Asc/Asc	term_id_key	These unique columns are also nullable