Table zfindb.informix.data_alias 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
dalias_zdb_id varchar 50
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 varchar 50
zdb_active_data.zactvd_zdb_id dalias_data_zdb_id_foreign_key C
dalias_alias varchar 255
dalias_alias_lower varchar 255
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 279,542 rows at Tue Nov 10 13:18 PST 2015

Column(s) Type Sort Constraint Name
dalias_scope_id Performance Asc 157_1128
dalias_alias_lower + dalias_data_zdb_id Performance Asc/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_alias + dalias_data_zdb_id + dalias_group_id Must be unique Asc/Asc/Asc data_alias_alternate_key_index
dalias_zdb_id Must be unique Asc data_alias_primary_key_index

Close relationships  within of separation: