Table zfindb.informix.all_map_names 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
allmapnm_name varchar 255
allmapnm_zdb_id varchar 50
zdb_active_data.zactvd_zdb_id allmapnm_zdb_id_foreign_key C
allmapnm_significance int 10
allmapnm_precedence varchar 80
name_precedence.nmprec_precedence allmapnm_precedence_foreign_key R
allmapnm_name_lower varchar 255
allmapnm_serial_id serial8 19  √ 
all_name_ends.allnmend_allmapnm_serial_id allnmend_allmapnm_serial_id_foreign_key C

Table contained 1,392,276 rows at Tue Dec 20 09:53 PST 2016

Column(s) Type Sort Constraint Name
allmapnm_serial_id Must be unique Asc all_map_names_primary_key_index
allmapnm_name + allmapnm_zdb_id Must be unique Asc/Asc allmapnm_alternate_key_index
allmapnm_name_lower Performance Asc allmapnm_name_lower_index
allmapnm_precedence Performance Asc allmapnm_precedence_index
allmapnm_zdb_id Performance Asc allmapnm_zdb_id_index

Close relationships  within of separation: