Table cxgn.sgn.pcr_experiment

 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
pcr_experiment_id bigserial 19  √  nextval('pcr_experiment_pcr_experiment_id_seq'::regclass)
marker_experiment.pcr_experiment_id marker_experiment_pcr_experiment_id_fkey
pcr_exp_accession.pcr_experiment_id pcr_experiment_id_fk
marker_id int8 19  √  null
marker.marker_id marker_id_fk
mg_concentration float4 8,8  √  null
annealing_temp int8 19  √  null
primer_id_fwd int8 19  √  null
sequence.sequence_id primer_id_fwd_fk
primer_id_rev int8 19  √  null
sequence.sequence_id primer_id_rev_fk
subscript varchar 255  √  null
experiment_type_id int8 19  √  null
experiment_type.experiment_type_id experiment_type_id_fk
map_id int8 19  √  null
map.map_id map_id_fk
additional_enzymes varchar 1023  √  null
primer_type varchar 4  √  null
predicted bool 1  √  false
primer_id_pd int8 19  √  null
accession_id varchar 7  √  null

Table contained 8,990 rows at Wed May 20 01:50 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name
pcr_experiment_id Primary key Asc pcr_experiment_pkey
marker_id + experiment_type_id Performance Asc/Asc marker_id_idx6

Close relationships  within one two degrees of separation :