Table zfindb.public.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 text 2147483647
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 text 2147483647  √  null
cnd_is_problem bool 1 false
cnd_mrkr_type text 2147483647
cnd_run_count int4 10 0
cnd_last_done_date timestamp 29,6  √  null
cnd_note text 2147483647  √  null

Table contained 44,410 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name Anomalies
cnd_zdb_id Primary key Asc candidate_primary_key  
cnd_suggested_name Must be unique Asc candidate_cnd_suggested_name_idx This unique column is also nullable
cnd_mrkr_type Performance Asc cnd_mrkr_type_foreign_key_index  

Close relationships  within of separation: