Table zfindb.informix.term 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
term_zdb_id varchar 50
all_term_contains.alltermcon_contained_zdb_id alltermcon_contained_zdb_id_foreign_key C
all_term_contains.alltermcon_container_zdb_id alltermcon_container_zdb_id_foreign_key C
anatomy_display.anatdisp_item_zdb_id anatdisp_item_zdb_id_foreign_key C
apato_infrastructure.api_quality_zdb_id apato_quality_zdb_id_fk R
disease_annotation.dat_term_zdb_id dat_term_zdb_id_foreign_key R
experiment_condition.expcond_ao_term_zdb_id expcond_ao_term_zdb_id_fk R
experiment_condition.expcond_chebi_term_zdb_id expcond_chebi_term_zdb_id_fk R
experiment_condition.expcond_go_cc_term_zdb_id expcond_go_cc_term_zdb_id_fk R
experiment_condition.expcond_taxon_term_zdb_id expcond_taxon_term_zdb_id_fk R
experiment_condition_restricted.ecr_chebi_term_zdb_id experiment_condition_restricted_chebi_term_foreign_key R
expression_pattern_infrastructure.xpatinf_subterm_zdb_id xpatinf_subterm_zdb_id_foreign_key R
expression_pattern_infrastructure.xpatinf_superterm_zdb_id xpatinf_superterm_zdb_id_foreign_key R
expression_phenotype_term.ept_quality_term_zdb_id ept_term_foreign_key_odc C
expression_result2.xpatres_subterm_zdb_id xpatres2_subterm_zdb_id_fk_odc C
expression_result2.xpatres_superterm_zdb_id xpatres2_superterm_zdb_id_fk_odc C
int_image_term.iit_term_zdb_id iit_term_zdb_id_foreign_key R
marker_go_term_evidence.mrkrgoev_term_zdb_id mrkrgoev_term_zdb_id_foreign_key C
mutation_detail_controlled_vocabulary.mdcv_term_zdb_id mdcv_term_zdb_id_fk R
obsolete_term_replacement.obstermrep_term_replacement_zdb_id obstermrep_term_replacement_zdb_id_foreign_key C
obsolete_term_replacement.obstermrep_term_zdb_id obstermrep_term_zdb_id_foreign_key C
obsolete_term_suggestion.obstermsug_term_suggestion_zdb_id obstermsug_term_suggestion_zdb_id_foreign_key C
obsolete_term_suggestion.obstermsug_term_zdb_id obstermsug_term_zdb_id_foreign_key C
phenotype_statement.phenos_entity_1_subterm_zdb_id phenos_entity_1_subterm_zdb_id_foreign_key R
phenotype_statement.phenos_entity_1_superterm_zdb_id phenos_entity_1_superterm_zdb_id_foreign_key R
phenotype_statement.phenos_entity_2_subterm_zdb_id phenos_entity_2_subterm_zdb_id_foreign_key R
phenotype_statement.phenos_entity_2_superterm_zdb_id phenos_entity_2_superterm_zdb_id_foreign_key R
phenotype_statement.phenos_quality_zdb_id phenos_quality_foreign_key R
probe_library.probelib_tissue_zdb_id probelib_tissue_zdb_id_foreign_key R
term_relationship.termrel_term_1_zdb_id termrel_term_1_zdb_id_foreign_key_to_term_odc C
term_relationship.termrel_term_2_zdb_id termrel_term_2_zdb_id_foreign_key_to_term_odc C
term_subset.termsub_term_zdb_id termsub_term_zdb_id_foreign_key_odc C
term_xref.tx_term_zdb_id tx_term_zdb_id_foreign_key R
zdb_active_data.zactvd_zdb_id term_zdb_id_foreign_key C
term_ont_id varchar 50
so_zfin_mapping.szm_term_ont_id so_zfin_mapping_term_foreign_key C
term_name varchar 255
term_ontology varchar 50  √  null
term_is_obsolete boolean 1 f
term_is_secondary boolean 1 f
term_is_root boolean 1 f
term_comment lvarchar 2048  √  null
term_definition lvarchar 2048  √  null
term_primary_subset_id int8 19  √  null
ontology_subset.osubset_pk_id term_ontology_subset_foreign_key R
term_ontology_id int8 19
ontology.ont_pk_id term_ontology_foreign_key R
term_name_order varchar 255  √  null

Table contained 176,928 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
term_comment + term_definition + term_is_obsolete + term_is_root + term_is_secondary + term_name Performance Asc/Asc/Asc/Asc/Asc/Asc term_name_index
term_comment + term_definition + term_is_obsolete + term_is_root + term_is_secondary + term_primary_subset_id Performance Asc/Asc/Asc/Asc/Asc/Asc term_ont_id_foreign_key_index
term_comment + term_definition + term_is_obsolete + term_is_root + term_is_secondary + term_ont_id Must be unique Asc/Asc/Asc/Asc/Asc/Asc term_ont_id_index
term_comment + term_definition + term_is_obsolete + term_is_root + term_is_secondary + term_ontology_id Performance Asc/Asc/Asc/Asc/Asc/Asc term_ontology_id_foreign_key_index
term_comment + term_definition + term_is_obsolete + term_is_root + term_is_secondary + term_ontology Performance Asc/Asc/Asc/Asc/Asc/Asc term_ontology_index
term_comment + term_definition + term_is_obsolete + term_is_root + term_is_secondary + term_zdb_id Must be unique Asc/Asc/Asc/Asc/Asc/Asc term_primary_key_index

Close relationships  within of separation: