Table zfindb.public.feature_marker_relationship 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
fmrel_zdb_id text 2147483647
zdb_active_data.zactvd_zdb_id fmrel_zdb_id_foreign_key C
fmrel_type text 2147483647
feature_marker_relationship_type.fmreltype_name fmrel_type_foreign_key R
fmrel_ftr_zdb_id text 2147483647
feature.feature_zdb_id fmrel_ftr_zdb_id_foreign_key C
fmrel_mrkr_zdb_id text 2147483647
zdb_active_data.zactvd_zdb_id fmrel_mrkr_zdb_id_foreign_key C

Table contained 83,139 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
fmrel_zdb_id Primary key Asc feature_marker_relationship_primary_key
fmrel_ftr_zdb_id + fmrel_mrkr_zdb_id Must be unique Asc/Asc feature_marker_relationship_alternate_key_index
fmrel_ftr_zdb_id Performance Asc fmrel_ftr_zdb_id_index
fmrel_mrkr_zdb_id Performance Asc fmrel_mrkr_zdb_id_index
fmrel_type Performance Asc fmrel_type_index

Close relationships  within of separation: