Table zfindb.informix.primer_set Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
zdb_id varchar 50
lab.zdb_id Implied Constraint R
marker_id varchar 50  √  null
marker.mrkr_zdb_id primer_set_marker_id_foreign_key_odc C
strain_id varchar 50  √  null
genotype.geno_zdb_id primerset_strain_id_foreign_key R
fwd_primer lvarchar 2048  √  null
rev_primer lvarchar 2048  √  null
band_size varchar 80  √  null
restr_enzyme varchar 80  √  null
anneal_temp smallfloat 7  √  null
comments lvarchar 2048  √  null
source varchar 50  √  null
the_id varchar 80  √  null

Table contained 7,460 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
comments + fwd_primer + rev_primer + marker_id Performance Asc/Asc/Asc/Asc primer_set_marker_id_index
comments + fwd_primer + rev_primer + zdb_id Must be unique Asc/Asc/Asc/Asc primer_set_primary_key_index
comments + fwd_primer + rev_primer + strain_id Performance Asc/Asc/Asc/Asc primerset_strain_id_index

Close relationships  within of separation: