Table zfindb.informix.updates 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
submitter_id varchar 50  √  null
rec_id varchar 50  √  null
field_name varchar 40  √  null
new_value lvarchar 2000  √  null
old_value lvarchar 2000  √  null
comments lvarchar 2048  √  null
when datetime year to fraction(3) 23  √  null
submitter_name varchar 80  √  null
upd_pk_id serial8 19  √ 

Table contained 1,391,630 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
comments + new_value + old_value + upd_pk_id Must be unique Asc/Asc/Asc/Asc update_primary_key_index
comments + new_value + old_value + rec_id + when + field_name + submitter_id Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc update_sort_index