Table zfindb.public.source_feature_prefix 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
sfp_prefix_id int8 19
feature_prefix.fp_pk_id sfp_prefix_id_foreign_key C
sfp_source_zdb_id text 2147483647
zdb_active_source.zactvs_zdb_id sfp_source_zdb_id_foreign_key C
sfp_current_designation bool 1 true

Table contained 1,212 rows at Wed Sep 15 00:41 PDT 2021

Column(s) Type Sort Constraint Name
sfp_source_zdb_id + sfp_prefix_id Primary key Asc/Asc source_feature_prefix_primary_key
sfp_prefix_id Performance Asc sfp_prefix_id_foreign_key_index
sfp_source_zdb_id Performance Asc sfp_source_zdb_id_foreign_key_index

Close relationships  within of separation: