Table zfindb.informix.clone 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
clone_mrkr_zdb_id varchar 50
marker.mrkr_zdb_id clone_mrkr_zdb_id_foreign_key C
clone_comments lvarchar 2048  √  null
clone_vector_name varchar 80  √  null
vector.vector_name clone_vector_name_foreign_key R
clone_polymerase_name varchar 80  √  null
clone_insert_size int 10  √  null
clone_cloning_site varchar 80  √  null
clone_digest varchar 20  √  null
clone_probelib_zdb_id varchar 50
clone_sequence_type varchar 20 unspecified
sequence_type.seqtype_name clone_sequence_type_foreign_key R
clone_pcr_amplification lvarchar 2048  √  null
clone_rating int 10  √  null
clone_problem_type varchar 60  √  null
clone_problem_type.cpt_type clone_problem_type_foreign_key R

Table contained 48,658 rows at Tue Nov 10 13:18 PST 2015

Indexes:
Column(s) Type Sort Constraint Name
clone_comments + clone_pcr_amplification + clone_mrkr_zdb_id Must be unique Asc/Asc/Asc clone_primary_key_index
clone_comments + clone_pcr_amplification + clone_probelib_zdb_id Performance Asc/Asc/Asc clone_probelib_zdb_id_index
clone_comments + clone_pcr_amplification + clone_problem_type Performance Asc/Asc/Asc clone_problem_type_index
clone_comments + clone_pcr_amplification + clone_sequence_type Performance Asc/Asc/Asc clone_sequence_type_index
clone_comments + clone_pcr_amplification + clone_vector_name Performance Asc/Asc/Asc clone_vector_name_index

Close relationships  within of separation: