Table cxgn.sgn.pcr_product

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

pcr_product_id

bigserial

√

nextval('pcr_product_pcr_product_id_seq'::regclass)

pcr_exp_accession_id

int8

√

null

pcr_exp_accession.pcr_exp_accession_id

pcr_exp_accession_id_fk

enzyme_id

int8

√

null

enzymes.enzyme_id

enzyme_id_fk

multiple_flag

int8

√

null

band_size

int8

√

null

predicted

bool

√

false

Table contained 13,136 rows at Wed May 20 01:50 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
pcr_product_id	Primary key	Asc	pcr_product_pkey
pcr_exp_accession_id	Performance	Asc	pcr_exp_accession_id_idx
pcr_exp_accession_id + enzyme_id + multiple_flag + band_size + predicted	Must be unique	Asc/Asc/Asc/Asc/Asc	unique_acc_enz_mult_pred_size	These unique columns are also nullable