Table zfindb.informix.candidate Generated by
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 60  √  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 41,509 rows at Tue Nov 10 13:18 PST 2015

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: