SchemaSpy - Table zfindb.informix.construct_search

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Auto	Default
cons_pk_id	serial8	19		√
cons_construct_zdb_id	varchar	50
cons_type	varchar	50	√		null
cons_all_names	lvarchar	16000	√		null
cons_all_with_spaces	lvarchar	10000	√		null
cons_name	varchar	255	√		null
cons_abbrev	varchar	255	√		null
cons_abbrev_order	varchar	255	√		null

Table contained 3,695 rows at Tue Dec 20 09:53 PST 2016

Indexes:

Column(s)	Type	Sort	Constraint Name
cons_all_names + cons_all_with_spaces + cons_construct_zdb_id	Must be unique	Asc/Asc/Asc	consp_alternate_key_index
cons_all_names + cons_all_with_spaces + cons_pk_id	Must be unique	Asc/Asc/Asc	consp_pk_id_primary_key_index