Table zfindb.public.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 text 2147483647
marker.mrkr_zdb_id clone_mrkr_zdb_id_foreign_key C
clone_comments text 2147483647  √  null
clone_vector_name text 2147483647  √  null
vector.vector_name clone_vector_name_foreign_key R
clone_polymerase_name text 2147483647  √  null
clone_insert_size int4 10  √  null
clone_cloning_site text 2147483647  √  null
clone_digest text 2147483647  √  null
clone_probelib_zdb_id text 2147483647
clone_sequence_type text 2147483647 'unspecified'::text
sequence_type.seqtype_name clone_sequence_type_foreign_key R
clone_pcr_amplification text 2147483647  √  null
clone_rating int4 10  √  null
clone_problem_type text 2147483647  √  null
clone_problem_type.cpt_type clone_problem_type_foreign_key R

Table contained 48,658 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name
clone_mrkr_zdb_id Primary key Asc clone_primary_key
clone_probelib_zdb_id Performance Asc clone_probelib_zdb_id_index
clone_problem_type Performance Asc clone_problem_type_index
clone_sequence_type Performance Asc clone_sequence_type_index
clone_vector_name Performance Asc clone_vector_name_index

Close relationships  within of separation: