Table zfindb.informix.omimp_termxref_mapping 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
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 9,819 rows at Tue Dec 20 09:53 PST 2016

Indexes:
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: