SchemaSpy Analysis of zfindb.informix Generated by
SchemaSpy
Generated by SchemaSpy on Tue Nov 10 13:18 PST 2015
Database Type: Informix Dynamic Server - 12.10.FC2XD SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Rows Comments
accession_bank 2 1 7 1,884,697
accession_version 2 37,820
affected_gene_group 6 49,350
affected_gene_group_member 4 41,682
alias_scope 1 2 5
all_anatomy_contains 3 34,597
all_map_names 1 2 6 1,361,877
all_name_ends 1 2 6,838,598
all_term_contains 2 3 960,370
anatomy_display 2 5 13,370
anatomy_stats 6 126,158
antibody 1 6 6 1,958
antibody_type 1 1 2
apato_infrastructure 7 10 34,400
apato_tag 2 1 8
attribution_type 2 2 9
author 2 4 0
author_publication 2 3 0
bl_plate_tracking 3 2,712
blast_database 6 2 15 57
blast_database_origination_type 1 3 6
blast_database_type 1 1 2
blast_hit 2 13 315,664
blast_query 2 2 3 14,094
blast_report 1 4 14,094
blastdb_order 2 4 45
blastdb_regen_content 1 3 2,595
blastdb_run 2 2 0
bld_registered 1 view
bldi_provided 2 view
bldi_required 2 view
btsfse_storage 1 11
candidate 1 2 7 41,509
chromosome 3 2 27
clean_expression_fast_search 2 2 27,221
clone 4 12 48,658
clone_problem_type 1 1 7
company 1 3 13 182
company_position 1 3 7
condition 1 1 9
condition_data_type 2 2 4 65
construct 2 3 7 3,080
construct_component 1 8 31,963
construct_component_search 9 10,442
construct_component_search_backup 9 10,428
construct_component_search_temp 9 10,442
construct_figure 2 3 6
construct_gene_feature_result_view 13 21,479
construct_gene_feature_result_view_backup 13 21,475
construct_gene_feature_result_view_temp 13 21,479
construct_group 6 15,561
construct_group_member 5 19,057
construct_marker_relationship 4 4 10,409
construct_search 8 3,078
construct_search_backup 8 3,075
construct_search_temp 8 3,078
controlled_vocabulary 1 4 55
country_code 4 240
curation 4 8 221,993
curation_topic 1 1 17
curator_session 1 5 54,264
data_alias 2 4 6 279,542
data_note 3 5 5,159
data_reporting 4 18
database_env_name_matrix 5 48
database_info 4 1
db_link 2 3 7 824,702
disease_annotation 1 3 4 237
disease_annotation_model 2 3 77
do_oevdispupdate_temp_first 5 0
do_oevdispupdate_temp_second 5 0
doi_attempts 1 3 3,808
ensdar_mapping 3 54,361
ensdarg_ensdarp_mapping 4 42,555
ensdarg_ottdarg_mapping 2 0
entrez_gene 2 3 51,094
entrez_to_protein 1 4 724,386
entrez_to_xref 1 2 38,723
environment_group 3 29,250
environment_group_member 5 44,718
environment_staging 2 29,976
execweb 2 3
experiment 2 2 3 14,329
experiment_condition 4 5 5,072
experiment_condition_restricted 3 4 0
expression_experiment 1 8 9 99,190
expression_pattern_assay 1 4 13
expression_pattern_figure 2 2 304,814
expression_pattern_infrastructure 5 6 2,050
expression_result 1 6 9 292,857
expression_term_fast_search 5 192,197
external_note 3 4 41,881
external_note_type 1 2 5
external_reference 3 5 30,454
feature 4 3 16 40,526
feature_assay 4 40,528
feature_group 7 37,050
feature_group_member 7 391,336
feature_history 5 10 40,732
feature_marker_relationship 4 4 47,338
feature_marker_relationship_type 2 2 6 7
feature_prefix 2 4 373
feature_stats 10 542,109
feature_stats_old 10 541,919
feature_tracking 5 24,451
feature_type 4 3 11
feature_type_group 2 2 12
feature_type_group_member 2 2 22
feature_type_mutagen_group_member 2 3 96
feature_type_ordering 3 17
fest_lib_inst 1 4 769
fig_comm 2 63
fig_tmp 3 63
figure 4 2 6 83,262
figure_term_construct_search 8 13,226
figure_term_construct_search_backup 8 13,209
figure_term_construct_search_temp 8 13,226
fish 3 2 9 30,516
fish_components 7 43,789
fish_experiment 5 2 5 30,403
fish_genox 3 29,250
fish_search 1 17 1,253
fish_staging 3 29,976
fish_str 2 2 13,601
foreign_db 3 6 67
foreign_db_contains 4 4 5 76
foreign_db_contains_display_group 1 3 20
foreign_db_contains_display_group_member 1 3 102
foreign_db_data_type 1 4 15
functional_annotation 37 53,189
genedom_family_member 2 2 0
genedom_family_name 1 1 192
geneprefix_institution 1 2 10
genotype 7 1 10 20,267
genotype_background 2 2 7,637
genotype_component_significance 3 5 47
genotype_feature 6 6 24,718
genotype_figure_fast_search 2 9 77,901
genotype_group 4 13,773
genotype_group_member 5 0
genox_fish_annotation_search 3 0
genox_fish_annotation_search_bkup 3 17,185
genox_fish_annotation_search_temp 3 0
genox_group 3 0
genox_group_member 4 0
gff3 12 1,602,441
go_evidence_code 1 3 16
go_flag 1 2 3
go_ontology 1 3 3
go_term 2 6 33,559
heavy_chain_isotype 1 1 19
image 3 7 17 95,487
image_direction 1 1 11
image_form 1 1 5
image_preparation 1 1 6
image_stage 3 3 33,851
image_view 1 1 14
inference_group_member 1 3 176,082
int_data_source 2 3 78,846
int_data_supplier 2 4 75,179
int_fdbcont_analysis_tool 1 2 104
int_image_term 2 2 546
int_person_company 3 5 147
int_person_lab 3 5 4,310
int_person_pub 2 5 38,411
int_vegatype_tscripttype 1 2 20
journal 1 1 12 2,286
lab 2 3 13 991
lab_address_update_tracking 1 4 201
lab_position 1 3 10
light_chain_isotype 1 1 13
lines 1 78
lines_tmp 1 63
linkage 1 3 5 15,143
linkage_group 3 2 27
linkage_member 2 1 2 17,353
linkage_member_temp 3 5,843
linkage_membership 2 8 6,659
linkage_membership_search 3 8 13,318
linkage_membership_search_bkup 8 13,318
linkage_membership_search_temp 8 13,318
linkage_old 2 3 4 15,143
linkage_pair 1 2 5 822
linkage_pair_member 3 3 1,644
linkage_single 2 3 16,166
linkages_copy 5 454
map_metric 4 3 4
mapped_marker 6 15 26,973
marker 19 3 8 155,689
marker_go_term_evidence 1 9 14 185,432
marker_go_term_evidence_annotation_created_by_source 3 6
marker_go_term_evidence_annotation_organization 1 4 5
marker_history 5 10 216,965
marker_history_event 2 1 5
marker_history_reason 2 1 7
marker_relationship 4 5 173,215
marker_relationship_type 2 2 5 16
marker_sequence 2 7 10,659
marker_type_group 4 2 37
marker_type_group_member 2 2 130
marker_types 7 3 27
merge_markers_sql 4 35,937
mesh_heading 1 2 4 130
mesh_heading_qualifier 2 3 83
mesh_term 2 3 27,538
missing_xpatfig 2 33
mutagee 1 5
mutagen 1 1 12
mutant_fast_search 2 2 25,373
name_precedence 1 3 19
ncbi_ortholog 1 1 6 157,958
ncbi_ortholog_external_reference 2 4 307,989
obo_file 4 3
obsolete_term_replacement 2 3 582
obsolete_term_suggestion 2 3 1,881
omim_phenotype 1 4 14,783
omimp_termxref_mapping 2 2 9,050
one_to_one_accession 2 4 15,223
ontology 1 10 10
ontology_subset 2 5 54
organism 5 6 39
ortholog 2 2 8 29,409
ortholog_evidence 3 3 62,752
ortholog_evidence_code 1 3 7
ortholog_external_reference 2 3 72,106
ortholog_load_tracking 7 3
panel_count 4 5 608
panels 1 3 19 7
person 26 1 19 7,340
person_author 3 5 0
pheno_term 10 75,042
pheno_term_fast_search 7 1,571,917
pheno_term_fast_search_tmp 7 1,571,917
pheno_term_old 10 45,314
phenotype_experiment 1 4 7 40,693
phenotype_figure_group 5 18,419
phenotype_figure_group_member 4 37,196
phenotype_statement 7 10 100,278
primer_set 2 11 7,460
probe_lib 14 33
probe_library 5 14 103
publication 13 2 28 25,645
publication_contact_tracking 2 6 0
publication_correspondence 2 6 76
publication_note 3 5 42,967
record_attribution 2 5 2,266,356
remove_phenos_ids 1 27
replaced_accession_number 2 1,451
return_recs 9 1,749
run 2 5 9 13
run_candidate 1 2 6 10,882
run_program 1 3 5
run_type 1 1 2
sangerfeatures 1 54
sequence_ambiguity_code 1 2 11
sequence_feature_chromosome_location 9 260,343
sequence_feature_chromosome_location_bkup 8 98,809
sequence_feature_chromosome_location_temp 8 98,809
sequence_type 2 2 6
single 1 1
snp_download 1 3 2,472,903
snp_download_attribution 2 2,481,424
snp_sequence 1 8 2,024
so_zfin_mapping 1 4 38
source_feature_prefix 2 3 701
source_url 2 4 24
source_url_purpose 1 2 2
stage 10 1 9 45
staging_webpages 12 0
state_code 3 59
str_group 3 12,173
str_group_member 5 15,623
sysblderrorlog 6 84
sysbldiprovided 2 2
sysbldirequired 2 0
sysbldobjdepends 13 498
sysbldobjects 19 463
sysbldobjkinds 3 21
sysbldregistered 1 2
sysdomains 4 view
sysindexes 25 view
term 28 3 12 63,089
term_group 5 20,333
term_group_member 4 904,733
term_relationship 4 4 125,389
term_relationship_type 1 1 64
term_stage 2 3 2,954
term_subset 2 2 15,579
term_xref 1 2 6 86,221
tmp_db_link 7 0
tmp_genox 1 12,173
transcript 3 4 42,373
transcript_status 2 4 17
transcript_type 3 6 19
tscript_type_status_definition 2 4 18
unique_location 2 135,891
updates 9 1,277,091
url_ref 1 4 1
validate_check_history 3 84
vector 1 1 2 68
vector_type 1 2 14
vgroupsize 2 view
video 1 3 389
vmrkrgoevsamesize 3 view
warehouse_run_tracking 4 4
webcmimages 5 0
webcmpages 5 16
webconfigs 6 49
webenvvariables 5 74
webpages 12 137
webtags 5 7
webudrs 8 0
withdrawn_data 4 7,287
xpat_anatomy_capture 2 23,889
xpat_exp_details_generated 10 140,672
xpat_exp_details_generated_bkup 10 140,428
xpat_exp_details_generated_temp 10 140,672
xpat_figure_group 5 15,859
xpat_figure_group_member 4 27,885
xpat_results_generated 11 304,647
xpat_results_generated_bkup 11 304,231
xpat_results_generated_temp 11 304,647
xpatfs_old 5 185,997
zdb_active_data 68 1 3,370,482
zdb_active_source 14 1 36,444
zdb_flag 3 14
zdb_object_type 8 81
zdb_orphan_data 1 3 6
zdb_orphan_source 1 3 0
zdb_replaced_data 1 3 41,415
zdb_submitters 1 1 10 7,340
zfin_accession_number 4 2,682
zfin_ensembl_gene 10 0
zmap_pub_pan_mark 3 14 35,840
zygocity 3 1 6 5
           
328 Tables     1,767 40,488,327  
7 Views     39