unigene_build

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
unigene_build_id serial 10 √ nextval('sgn.unigene_build_unigene_build_id_seq'::regclass)
unigene.unigene_build_id unigene_unigene_build_id_fkey R
unigene_build.latest_build_id unigene_build_latest_build_id_fkey R
unigene_build.next_build_id unigene_build_next_build_id_fkey R
unigene_build.superseding_build_id unigene_build_superseding_build_id_fkey R
source_data_group_id int4 10 √ null
groups.group_id Implied Constraint R
organism_group_id int4 10 √ null
groups.group_id unigene_build_organism_group_id_fkey R
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 R
next_build_id int4 10 √ null
unigene_build.unigene_build_id unigene_build_next_build_id_fkey R
latest_build_id int4 10 √ null
unigene_build.unigene_build_id unigene_build_latest_build_id_fkey R
blast_db_id int4 10 √ null
blast_db.blast_db_id unigene_build_blast_db_id_fkey R

Indexes

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

Check Constraints

Constraint Name Constraint
unigene_build_status_check (((status = 'C'::bpchar) OR (status = 'D'::bpchar) OR (status = 'P'::bpchar)))

Relationships

Close relationships within degrees of separation