Table cxgn.sgn.ssr_primer_unigene_matches

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

ssr_primer_unigene_match_id

serial

√

nextval('ssr_primer_unigene_matches_ssr_primer_unigene_match_id_seq'::regclass)

ssr_id

int8

(0)::bigint

ssr.ssr_id

ssr_id_fk

unigene_id

int8

(0)::bigint

unigene.unigene_id

unigene_id_fk

primer_direction

int2

(0)::smallint

match_length

int8

(0)::bigint

primer_match_start

int8

(0)::bigint

primer_match_end

int8

(0)::bigint

unigene_match_start

int8

(0)::bigint

unigene_match_end

int8

(0)::bigint

e_value

varchar

''::character varying

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

Indexes:

Column(s)	Type	Sort	Constraint Name
ssr_primer_unigene_match_id	Primary key	Asc	ssr_primer_unigene_matches_pkey
ssr_id + unigene_id + primer_direction + match_length + e_value	Performance	Asc/Asc/Asc/Asc/Asc	ssr_id_idx