Table zfindb.informix.expression_pattern_figure 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
xpatfig_fig_zdb_id varchar 50
figure.fig_zdb_id xpatfig_fig_foreign_key C
xpatfig_xpatres_zdb_id varchar 50
expression_result.xpatres_zdb_id fx_expression_pattern_figure_xpatres_foreign_key C

Table contained 304,814 rows at Tue Nov 10 13:18 PST 2015

Indexes:
Column(s) Type Sort Constraint Name
xpatfig_fig_zdb_id Performance Asc expression_pattern_figure_fig_foreign_key
xpatfig_fig_zdb_id + xpatfig_xpatres_zdb_id Must be unique Asc/Asc expression_pattern_figure_primary_key_index
xpatfig_xpatres_zdb_id Performance Asc expression_pattern_figure_xpatres_foreign_key_index

Close relationships  within of separation: