Table zfindb.public.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 text 2147483647
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_evidence_term_zdb_id dat_evidence_term_zdb_id_fk R
disease_annotation.dat_term_zdb_id dat_term_zdb_id_foreign_key R
eco_go_mapping.egm_term_zdb_id egm_eco_term_zdb_id_fk C
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_spatial_term_zdb_id expcond_spatial_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
htp_dataset_sample.hds_stage_term_zdb_id hds_stage_term_zdb_id_fk_odc R
htp_dataset_sample_detail.hdsd_anatomy_sub_term_qualifier_zdb_id hdsd_anatomy_sub_term_qualifier_zdb_id_fk R
htp_dataset_sample_detail.hdsd_anatomy_sub_term_zdb_id hdsd_anatomy_sub_term_zdb_id_fk R
htp_dataset_sample_detail.hdsd_anatomy_super_term_qualifier_zdb_id hdsd_anatomy_super_term_qualifier_zdb_id_fk R
htp_dataset_sample_detail.hdsd_anatomy_super_term_zdb_id hdsd_anatomy_super_term_zdb_id_fk R
htp_dataset_sample_detail.hdsd_cellular_component_term_qualifier_zdb_id hdsd_cellular_component_qualifier_term_zdb_id_fk R
htp_dataset_sample_detail.hdsd_cellular_component_term_zdb_id hdsd_cellular_component_term_zdb_id_fk R
int_image_term.iit_term_zdb_id iit_term_zdb_id_foreign_key R
marker_go_term_annotation_extension.mgtae_relationship_term_zdb_id mgtae_relationship_term_zdb_id_fk_odc C
marker_go_term_evidence.mrkrgoev_relation_term_zdb_id mrkrgoev_relation_term_zdb_id_fk_odc 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
sequence_feature_chromosome_location.sfcl_evidence_code evidence_code_fk 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 text 2147483647
so_zfin_mapping.szm_term_ont_id so_zfin_mapping_term_foreign_key C
term_name text 2147483647
term_ontology text 2147483647  √  null
term_is_obsolete bool 1 false
term_is_secondary bool 1 false
term_is_root bool 1 false
term_comment text 2147483647  √  null
term_definition text 2147483647  √  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 text 2147483647  √  null

Table contained 241,448 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
term_zdb_id Primary key Asc term_primary_key
term_name Performance Asc term_name_index
term_primary_subset_id Performance Asc term_ont_id_foreign_key_index
term_ont_id Must be unique Asc term_ont_id_index
term_ontology_id Performance Asc term_ontology_id_foreign_key_index
term_ontology Performance Asc term_ontology_index

Close relationships  within of separation: