Table zfindb.informix.xpat_results_generated 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
xrg_pk_id int8 19
xrg_zdb_id varchar 50
xrg_xedg_id int8 19
xrg_xedg_zdb_id varchar 50
xrg_start_stg_zdb_id varchar 50
xrg_end_stg_zdb_id varchar 50
xrg_expression_found boolean 1 t
xrg_comments varchar 255  √  null
xrg_suggested_anatomy_item varchar 75  √  null
xrg_superterm_zdb_id varchar 50
xrg_subterm_zdb_id varchar 50  √  null

Table contained 308,425 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
xrg_expression_found + xrg_xedg_id + xrg_superterm_zdb_id + xrg_start_stg_zdb_id + xrg_end_stg_zdb_id + xrg_expression_found + xrg_subterm_zdb_id Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc xrg_alternate_key_index
xrg_expression_found + xrg_end_stg_zdb_id Performance Asc/Asc xrg_end_stg_foreign_key_index
xrg_expression_found + xrg_pk_id Must be unique Asc/Asc xrg_primary_key_index
xrg_expression_found + xrg_start_stg_zdb_id Performance Asc/Asc xrg_start_stg_foreign_key_index
xrg_expression_found + xrg_subterm_zdb_id Performance Asc/Asc xrg_subterm_foreign_key_index
xrg_expression_found + xrg_suggested_anatomy_item Performance Asc/Asc xrg_suggested_anatomy_foreign_key_index
xrg_expression_found + xrg_superterm_zdb_id Performance Asc/Asc xrg_superterm_foreign_key_index
xrg_expression_found + xrg_xedg_id Performance Asc/Asc xrg_xedg_foreign_key_index