Table zfindb.informix.ortholog 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
ortho_zdb_id varchar 50
omim_phenotype.omimp_ortho_zdb_id omimp_ortho_zdb_id_fk_odc C
ortholog_evidence.oev_ortho_zdb_id oevn_ortho_zdb_id_foreign_key C
ortholog_external_reference.oef_ortho_zdb_id oef_ortho_zdb_id_fk_odc C
zdb_active_data.zactvd_zdb_id ortho_zdb_id_active_data_foreign_key_odc C
ortho_zebrafish_gene_zdb_id varchar 50
marker.mrkr_zdb_id ortholog_gene_zdb_id_fk_odc C
ortho_other_species_ncbi_gene_id varchar 40
ortho_other_species_name varchar 255  √  null
ortho_other_species_symbol varchar 255  √  null
ortho_other_species_chromosome varchar 50  √  null
ortho_other_species_ncbi_gene_is_obsolete boolean 1 f
ortho_other_species_taxid int 10  √  null

Table contained 30,117 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
ortho_other_species_ncbi_gene_is_obsolete + ortho_zebrafish_gene_zdb_id + ortho_other_species_ncbi_gene_id Must be unique Asc/Asc/Asc ortho_ak_index
ortho_other_species_ncbi_gene_is_obsolete + ortho_zdb_id Must be unique Asc/Asc ortho_pk_index
ortho_other_species_ncbi_gene_is_obsolete + ortho_zebrafish_gene_zdb_id Performance Asc/Asc ortho_zebrafish_gene_zdb_id_foreign_key_index

Close relationships  within of separation: