Table cxgn.sgn_bt.go

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

go_id

bigserial

√

nextval('go_go_id_seq'::regclass)

go_accession

varchar

√

null

interpro_go.go_accession

interpro_go_go_accession_fkey

description

text

2147483647

√

null

cxgn_production_visible

bool

√

false

description_fulltext

tsvector

2147483647

√

null

Table contained 2,838 rows at Thu Jun 21 23:03 EDT 2007

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
go_id	Primary key	Asc	go_pkey
go_accession	Performance	Asc	go_accession_idx
go_accession	Must be unique	Asc	go_go_accession_key	This unique column is also nullable
description_fulltext	Performance	Asc	sgn_go_description_fulltext_index