Table zfindb.informix.construct_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
consfig_pk_id serial8 19  √ 
consfig_construct_zdb_id varchar 50
construct.construct_zdb_id construct_figure_construct_zdb_id_foreign_key_odc C
consfig_fig_zdb_id varchar 50
figure.fig_zdb_id construct_figure_fig_zdb_id_foreign_key_odc C

Table contained 6 rows at Tue Nov 10 13:18 PST 2015

Indexes:
Column(s) Type Sort Constraint Name
consfig_pk_id Primary key Asc construct_figure_primary_key
consfig_construct_zdb_id + consfig_fig_zdb_id Must be unique Asc/Asc construct_figure_alternate_key
consfig_construct_zdb_id Performance Asc construct_figure_construct_foreign_key
consfig_fig_zdb_id Performance Asc construct_figure_fig_foreign_key

Close relationships  within of separation: