Table cxgn.sgn.unigene_build

Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
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
unigene_build_id serial 10  √  nextval('unigene_build_unigene_build_id_seq'::regclass)
unigene.unigene_build_id unigene_unigene_build_id_fkey
unigene_build.latest_build_id unigene_build_latest_build_id_fkey
unigene_build.next_build_id unigene_build_next_build_id_fkey
unigene_build.superseding_build_id unigene_build_superseding_build_id_fkey
source_data_group_id int4 10  √  null
organism_group_id int4 10  √  null
groups.group_id unigene_build_organism_group_id_fkey
build_nr int4 10 0
build_date date 13  √  now()
method_id int4 10  √  null
status bpchar 1  √  null
comment text 2147483647  √  null
superseding_build_id int4 10  √  null
unigene_build.unigene_build_id unigene_build_superseding_build_id_fkey
next_build_id int4 10  √  null
unigene_build.unigene_build_id unigene_build_next_build_id_fkey
latest_build_id int4 10  √  null
unigene_build.unigene_build_id unigene_build_latest_build_id_fkey
blast_db_id int4 10  √  null
blast_db.blast_db_id unigene_build_blast_db_id_fkey

Table contained 30 rows at Wed May 20 01:50 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name
unigene_build_id Primary key Asc unigene_build_pkey
build_nr Performance Asc build_nr_idx
organism_group_id Performance Asc organism_group_id_idx2
source_data_group_id Performance Asc source_data_group_id_idx

Close relationships  within one two degrees of separation :