Table zfindb.public.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 14,854 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
otm_tx_id + otm_omimp_id Primary key Asc/Asc omimp_termxref_mapping_primary_key
otm_omimp_id Performance Asc omimp_termxref_mapping_omimp_id_index
otm_tx_id Performance Asc omimp_termxref_mapping_tx_id_index

Close relationships  within of separation: