Table zfindb.informix.omimp_termxref_mapping Generated by
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
otm_tx_id int8 19
term_xref.tx_pk_id termxref_mapping_foreign_key_odc C
otm_omimp_id int8 19
omim_phenotype.omimp_pk_id omimp_foreign_key_odc C

Table contained 10,531 rows at Thu Jun 22 08:42 PDT 2017

Column(s) Type Sort Constraint Name
otm_omimp_id Performance Asc omimp_termxref_mapping_omimp_id_index
otm_tx_id + otm_omimp_id Must be unique Asc/Asc omimp_termxref_mapping_primary_key_index
otm_tx_id Performance Asc omimp_termxref_mapping_tx_id_index

Close relationships  within of separation: