SchemaSpy - Table zfindb.informix.all_map

Generated by
SchemaSpy

Legend:

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

zdb_active_data.zactvd_zdb_id

allmapnm_zdb_id_foreign_key C

allmapnm_significance

int

allmapnm_precedence

varchar

name_precedence.nmprec_precedence

allmapnm_precedence_foreign_key R

allmapnm_name_lower

varchar

255

allmapnm_serial_id

serial8

√

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

Indexes:

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