Table zfindb.informix.candidate 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
cnd_zdb_id varchar 50
run_candidate.runcan_cnd_zdb_id runcan_cnd_zdb_id_foreign_key_odc C
zdb_active_data.zactvd_zdb_id candidate_active_data_foreign_key_odc C
cnd_suggested_name varchar 255  √  null
cnd_is_problem boolean 1 f
cnd_mrkr_type varchar 10
marker_types.marker_type candidate_type_foreign_key R
cnd_run_count int 10 0
cnd_last_done_date datetime year to day 10  √  null
cnd_note lvarchar 1500  √  null

Table contained 43,625 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
cnd_is_problem + cnd_note + cnd_suggested_name Must be unique Asc/Asc/Asc candidate_cnd_suggested_name_idx
cnd_is_problem + cnd_note + cnd_zdb_id Must be unique Asc/Asc/Asc candidate_primary_key_index
cnd_is_problem + cnd_note + cnd_mrkr_type Performance Asc/Asc/Asc cnd_mrkr_type_foreign_key_index

Close relationships  within of separation: