Table cxgn.public.phenotype

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_id

serial

√

nextval('phenotype_phenotype_id_seq'::regclass)

phenotype_cvterm.phenotype_id

phenotype_cvterm_phenotype_id_fkey

uniquename

text

2147483647

observable_id

int4

√

null

cvterm.cvterm_id

phenotype_observable_id_fkey

attr_id

int4

√

null

cvterm.cvterm_id

phenotype_attr_id_fkey

value

varchar

2147483647

√

null

cvalue_id

int4

√

null

cvterm.cvterm_id

phenotype_cvalue_id_fkey

assay_id

int4

√

null

cvterm.cvterm_id

phenotype_assay_id_fkey

individual_id

int4

sp_person_id

int4

√

null

Table contained 13,242 rows at Wed May 20 01:40 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name
phenotype_id	Primary key	Asc	phenotype_pkey
uniquename	Must be unique	Asc	phenotype_c1
cvalue_id	Performance	Asc	phenotype_idx1
observable_id	Performance	Asc	phenotype_idx2
attr_id	Performance	Asc	phenotype_idx3