Table cxgn.sgn.unigene

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

unigene_id

serial

√

nextval('unigene_unigene_id_seq'::regclass)

blast_annotations.apply_id	apply_id_fkey
cds.unigene_id	cds_unigene_id_fkey
primer_unigene_match.unigene_id	primer_unigene_match_unigene_id_fkey
rflp_unigene_associations.unigene_id	unigene_id_fk
ssr_primer_unigene_matches.unigene_id	unigene_id_fk
unigene_member.unigene_id	unigene_member_unigene_id_fkey

unigene_build_id

int4

√

null

unigene_build.unigene_build_id

unigene_unigene_build_id_fkey

consensi_id

int4

√

null

unigene_consensi.consensi_id

unigene_unigene_consensi_id_fkey

cluster_no

int8

√

null

contig_no

int8

√

null

nr_members

int8

√

null

database_name

varchar

2147483647

'SGN'::character varying

sequence_name

int8

Table contained 575,206 rows at Wed May 20 01:50 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name
unigene_id	Primary key	Asc	unigene_pkey
cluster_no + contig_no	Performance	Asc/Asc	cluster_no_2_idx
cluster_no	Performance	Asc	cluster_no_idx
consensi_id	Performance	Asc	consensi_id_idx
unigene_build_id + cluster_no	Performance	Asc/Asc	unigene_build_id_idx
sequence_name	Performance	Asc	unigene_sequence_name