Table zfindb.public.marker_history 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
mhist_zdb_id text 2147483647
zdb_active_data.zactvd_zdb_id mhist_zdb_id_foreign_key C
mhist_mrkr_zdb_id text 2147483647
marker.mrkr_zdb_id mhist_mrkr_zdb_id_foreign_key C
mhist_event text 2147483647
marker_history_event.mhistvnt_name mhist_event_foreign_key R
mhist_reason text 2147483647  √  null
marker_history_reason.mhistrsn_name mhist_reason_foreign_key R
mhist_date timestamp 29,6
mhist_mrkr_name_on_mhist_date text 2147483647
mhist_mrkr_abbrev_on_mhist_date text 2147483647
mhist_comments text 2147483647  √  null
mhist_dalias_zdb_id text 2147483647  √  null
data_alias.dalias_zdb_id mhist_dalias_zdb_id_foreign_key R
mhist_mrkr_prev_name text 2147483647  √  null

Table contained 230,854 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
mhist_zdb_id Primary key Asc marker_hist_primary_key
mhist_dalias_zdb_id Performance Asc mhist_dalias_zdb_id_index
mhist_event Performance Asc mhist_event_index
mhist_mrkr_zdb_id Performance Asc mhist_mrkr_zdb_id_index
mhist_reason Performance Asc mhist_reason_index

Close relationships  within of separation: