Table zfindb.public.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 text 2147483647
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 text 2147483647
marker.mrkr_zdb_id ortholog_gene_zdb_id_fk_odc C
ortho_other_species_ncbi_gene_id text 2147483647
ortho_other_species_name text 2147483647  √  null
ortho_other_species_symbol text 2147483647  √  null
ortho_other_species_chromosome text 2147483647  √  null
ortho_other_species_ncbi_gene_is_obsolete bool 1 false
ortho_other_species_taxid int4 10  √  null

Table contained 31,744 rows at Wed Sep 15 00:41 PDT 2021

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

Close relationships  within of separation: