Table zfindb.public.data_alias 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
dalias_zdb_id text 2147483647
feature_history.fhist_dalias_zdb_id fhist_dalias_zdb_id_foreign_key R
marker_history.mhist_dalias_zdb_id mhist_dalias_zdb_id_foreign_key R
zdb_active_data.zactvd_zdb_id dalias_zdb_id_foreign_key C
dalias_data_zdb_id text 2147483647
zdb_active_data.zactvd_zdb_id dalias_data_zdb_id_foreign_key C
dalias_alias text 2147483647
dalias_alias_lower text 2147483647
dalias_group_id int8 19
alias_group.aliasgrp_pk_id dalias_group_id_foreign_key R
dalias_scope_id int8 19  √  null
alias_scope.aliasscope_pk_id dalias_scope_id_fk R

Table contained 707,841 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
dalias_zdb_id Primary key Asc data_alias_primary_key
dalias_alias_lower Performance Asc dalias_alias_lower_index
dalias_data_zdb_id Performance Asc dalias_data_zdb_id_index
dalias_group_id Performance Asc dalias_group_id_foreign_key
dalias_scope_id Performance Asc dalias_scope_id_fk_index
dalias_alias + dalias_data_zdb_id + dalias_group_id Must be unique Asc/Asc/Asc data_alias_alternate_key_index

Close relationships  within of separation: