SchemaSpy Analysis of zfindb.public Generated by
SchemaSpy
Generated by SchemaSpy on Tue Dec 07 17:05 PST 2021
Database Type: PostgreSQL - 13.2 SourceForge.net


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

Table / View Children Parents Columns Rows Comments
aa 5 111
abregistry 2 33
accession_bank 2 1 7 1,895,025
accession_version 2 37,820
affected_gene_group_member 4 41,682
alias_group 1 4 6
alias_scope 1 2 5
all_alias_tokens 1 2 54,255
all_anatomy_contains 3 34,597
all_term_contains 2 3 5,389,057
amsterdam_file 1 4 464
anatomy_display 2 5 13,370
anatomy_stats 6 488,384
annual_stats 5 1,588
antibody 1 6 6 3,868
antibody_type 1 1 2
apato_infrastructure 7 10 68,472
apato_tag 2 1 10
attribution_type 2 2 9
author 2 4 0
author_publication 2 3 0
average_curation_time_metric 26 42
average_time_per_person 5 0
bl_plate_tracking 3 2,712
blast_database 6 2 15 54
blast_database_origination_type 1 3 6
blast_database_type 1 1 2
blast_hit 2 13 252,452
blast_query 2 2 3 7,840
blast_report 1 4 9,431
blastdb_order 2 4 45
blastdb_regen_content 1 3 2,605
blastdb_run 2 2 0
burgess_location_post 5 70
candidate 1 1 7 44,410
chromosome 4 2 27
clean_expression_fast_search 2 3 34,745
clone 4 12 48,658
clone_problem_type 1 1 7
cnechr 4 113
cnechr1 7 113
cnedata 3 113
company 1 3 14 244
company_position 1 3 7
condition 1 1 9
condition_data_type 1 2 4 65
construct 3 2 7 6,382
construct_component 2 8 64,916
construct_figure 2 3 73
construct_marker_relationship 4 4 22,024
constructrel 4 71
constructreln 4 24
controlled_vocabulary 1 4 83
country_code 4 240
curation 4 8 526,119
curation_topic 1 1 23
curator_session 1 5 49,512
daily_indexed_metric 11 1,218
data_alias 2 4 6 711,571
data_note 3 5 7,057
data_reporting 4 345
database_info 4 2
databasechangelog 14 1,509
databasechangeloglock 4 1
db_link 3 3 7 983,526
disease_annotation 1 4 4 3,374
disease_annotation_model 2 3 2,016
do_oevdispupdate_temp_first 5 0
do_oevdispupdate_temp_second 5 0
doi_attempts 1 3 3,548
dupcrispr 6 19
eco_go_mapping 1 3 36
editconstruct 1 202
ensdar_mapping 3 57,369
ensdarg_ensdarp_mapping 4 44,487
ensdarg_ottdarg_mapping 2 0
ensdarg_post_proc 3 12,144
ensdart_name_mapping 6 28,699
ensdart_ottdart_mapping 2 39,237
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
execweb 2 3
experiment 3 2 3 20,394
experiment_condition 7 9 22,919
experiment_condition_restricted 3 4 0
expression_experiment 9 160,660
expression_experiment2 1 8 9 160,660
expression_experiment_bkup 9 160,660
expression_experiment_temp 9 160,660
expression_figure_stage 1 1 5 271,145
expression_pattern_assay 1 5 13
expression_pattern_figure 2 433,242
expression_pattern_figure_bkup 2 433,242
expression_pattern_figure_temp 2 433,242
expression_pattern_infrastructure 5 9 2,361
expression_phenotype_term 2 5 32,954
expression_phenotype_term_controlled_vocab 2 8
expression_result 9 433,242
expression_result2 1 3 5 433,258
expression_result_bkup 8 433,242
expression_result_temp 8 433,242
expression_search_anatomy_generated 3 11,579,324
expression_term_fast_search 5 253,465
external_note 3 6 43,581
external_note_type 1 2 6
external_reference 3 5 53,563
featmkr 4 12,381
feature 11 3 16 72,405
feature_assay 1 4 72,403
feature_audit 17 0
feature_community_contribution 2 10 11
feature_community_contribution_audit 8 11
feature_data 5 116
feature_dna_mutation_detail 4 14 40,661
feature_genomic_mutation_detail 2 7 39,510
feature_group 7 37,050
feature_group_member 7 391,336
feature_history 5 10 73,045
feature_marker_relationship 4 4 83,655
feature_marker_relationship_type 2 2 6 7
feature_prefix 2 4 561
feature_protein_mutation_detail 4 11 2,281
feature_stats 10 640,247
feature_stats_old 10 640,247
feature_tracking 5 56,588
feature_transcript_mutation_detail 3 5 38,240
feature_type 4 3 12
feature_type_group 2 2 12
feature_type_group_member 2 2 23
feature_type_mutagen_group_member 2 3 105
feature_type_ordering 3 18
featuredata 3 638
featuregenedata 3 20
featurenogenedata 1 7
featurezmp 2 6
featurezmpdata 3 5
fest_lib_inst 1 4 769
fgmdnote 6 1,513
figure 4 2 10 131,161
final491 5 1,943
finalct3 6 2,134
finalgo 5 2,134
fish 4 2 11 46,092
fish_components 7 72,101
fish_experiment 5 3 5 56,010
fish_genox 3 29,250
fish_str 2 2 21,230
fishmisfortune 10 197,137
fluorescent_color 5 8
fluorescent_marker 2 7 5,220
fluorescent_protein 3 7 840
foreign_db 3 6 79
foreign_db_contains 8 4 5 87
foreign_db_contains_display_group 1 3 21
foreign_db_contains_display_group_member 1 3 105
foreign_db_data_type 1 4 15
fpprotein_construct 2 2 5,146
fpprotein_efg 2 2 74
ftrconsequence 2 1,509
ftrconsequencenew 3 73,564
ftrmutdets 3 811
ftrmutdetssanger 3 39,862
gene_description 1 12 24,091
genedom_family_member 2 2 0
genedom_family_name 1 1 192
geneprefix_institution 1 2 10
genotype 7 1 10 30,151
genotype_background 2 2 9,727
genotype_component_significance 2 5 580
genotype_feature 6 6 41,049
genotype_figure_fast_search 4 9 140,000
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,571,948
go_evidence_code 3 17
go_flag 1 2 3
go_ontology 1 3 3
go_term 2 6 33,559
heavy_chain_isotype 1 1 19
htp_category_tag 1 2 4
htp_dataset 3 1 6 9
htp_dataset_alternate_identifier 3 9
htp_dataset_category_tag 2 3 23
htp_dataset_publication 2 3 14
htp_dataset_sample 3 13 169
htp_dataset_sample_detail 6 8 169
human_gene_detail 1 3 16,910
image 3 7 23 134,854
image_direction 1 1 11
image_form 1 1 5
image_preparation 1 1 6
image_stage 3 3 33,854
image_view 1 1 14
inference_group_member 1 3 1,186,069
inputensdarg 1 17,668
int_data_source 2 3 112,075
int_data_supplier 2 4 86,402
int_fdbcont_analysis_tool 1 2 88
int_image_term 2 2 599
int_person_company 3 5 162
int_person_lab 3 5 5,922
int_person_pub 2 5 59,696
int_vegatype_tscripttype 1 2 20
interpro_protein 1 1 3 38,549
jenk491 4 967
jenk491b 5 1,934
journal 1 1 12 2,969
lab 3 3 14 1,506
lab_address_update_tracking 1 4 0
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
longest_bin_resident_metric 5 1,361
map_metric 4 3 4
mapped_marker 5 15 26,973
marker 24 3 8 174,121
marker_go_term_annotation_extension 2 6 1,594
marker_go_term_annotation_extension_group 1 1 2 1,594
marker_go_term_evidence 3 10 18 309,075
marker_go_term_evidence_annotation_created_by_source 3 6
marker_go_term_evidence_annotation_organization 1 4 6
marker_history 5 10 230,926
marker_history_audit 1 7 282,347
marker_history_event 2 1 5
marker_history_reason 2 1 7
marker_relationship 4 5 200,278
marker_relationship_type 2 2 5 32
marker_sequence 2 7 18,738
marker_to_protein 2 3 56,867
marker_type_group 4 4 88
marker_type_group_member 2 2 395
marker_types 2 3 59
merge_markers_sql 4 24,065
mesh_heading 1 2 4 486,313
mesh_heading_qualifier 2 3 372,868
mesh_term 2 3 29,993
missing_varseq 3 301
missing_xpatfig 2 33
monthly_average_curated_metric 20 71
monthly_curated_metric 13 12,824
mutagee 1 5
mutagen 1 1 12
mutant_fast_search 2 2 64,500
mutation_detail_controlled_vocabulary 3 1 5 68
name_precedence 3 19
ncbi_ortholog 2 1 6 162,955
ncbi_ortholog_alias 1 3 61,109
ncbi_ortholog_external_reference 2 4 388,264
newfeaturedata 2 64
noctua_model 1 8,646
noctua_model_annotation 1 2 32,955
obsolete_term_replacement 2 3 817
obsolete_term_suggestion 2 3 2,311
omim_phenotype 1 2 5 21,831
omimp_termxref_mapping 2 2 14,942
one_to_one_accession 2 4 15,223
ontology 1 10 19
ontology_subset 2 5 120
organism 5 6 43
ortholog 3 2 8 31,761
ortholog_evidence 3 4 73,925
ortholog_evidence_code 1 3 7
ortholog_external_reference 2 3 111,350
ortholog_load_tracking 7 286
panel_count 3 5 608
paneled_markers 1 10 38,522
panels 1 3 19 7
person 37 1 21 9,655
person_author 3 5 0
pg_stat_statements 32 view
pheno_term 10 123,066
pheno_term_fast_search 7 3,053,093
pheno_term_fast_search_tmp 7 3,053,093
pheno_term_old 10 75,042
phenotype_experiment 1 4 7 71,982
phenotype_figure_group 5 18,419
phenotype_figure_group_member 4 37,196
phenotype_generated_curated_mapping 3 99,415
phenotype_generated_curated_mapping_bkup 3 99,415
phenotype_generated_curated_mapping_temp 3 99,415
phenotype_observation_generated 20 198,279
phenotype_observation_generated_bkup 20 198,279
phenotype_observation_generated_temp 20 198,279
phenotype_source_generated 5 81,001
phenotype_source_generated_bkup 5 81,001
phenotype_source_generated_temp 5 81,001
phenotype_statement 7 10 165,325
pmflankseq 5 36,815
post_aud 1 4 0
pre_db_link 5 3,793
pre_feature_marker_relationship 4 1
primer_set 2 11 7,460
probe_lib 14 33
probe_library 5 14 103
processing_checklist_task 1 2 3
protein 3 2 3 56,850
protein_to_interpro 2 5 224,014
protein_to_pdb 1 3 216
pub_correspondence_received_email 2 10 4,122
pub_correspondence_recipient 2 6 5,660
pub_correspondence_sent_email 2 2 7 5,448
pub_correspondence_sent_email_contains_subject 2 0
pub_correspondence_sent_tracker 3 7 13,724
pub_correspondence_subject 4 3
pub_db_xref 2 4 1,422
pub_tracking_history 5 10 165,310
pub_tracking_location 1 6 14
pub_tracking_status 1 8 21
publication 24 3 30 47,460
publication_contact_tracking 2 6 0
publication_correspondence 2 6 651
publication_file 2 6 54,577
publication_file_type 1 3 5
publication_note 3 5 39,790
publication_processing_checklist 3 5 18,632
pubmed_publication_author 1 6 234,559
record_attribution 2 5 3,511,792
remove_phenos_ids 1 27
replaced_accession_number 2 1,451
return_recs 9 1,749
revinfo 1 2 0
run 2 5 9 12
run_candidate 1 2 6 5,961
run_program 1 3 5
run_type 1 1 2
sanger_flanking_sequence 5 37,613
sanger_flanking_sequence_post_proc 4 35,210
sanger_location 4 112,614
sanger_location_post 5 111,476
sangerfeatures 1 54
sequence_ambiguity_code 1 2 11
sequence_feature_chromosome_location 4 8 113,497
sequence_feature_chromosome_location_bkup 9 98,953
sequence_feature_chromosome_location_generated 1 13 450,941
sequence_feature_chromosome_location_generated_bkup 10 154,310
sequence_feature_chromosome_location_generated_temp 10 154,994
sequence_feature_chromosome_location_temp 9 98,953
sequence_type 2 2 6
seqvar 11 1,620
single 1 1
snp_download 1 3 2,680,350
snp_download_attribution 2 2,680,981
snp_sequence 1 8 2,024
so_zfin_mapping 1 4 72
source_alias 2 4 3,825
source_feature_prefix 2 3 1,232
source_url 2 4 24
source_url_purpose 1 2 2
stage 8 1 9 45
state_code 3 59
str_group 3 12,173
tables_in_trouble 6 view
term 46 3 12 244,192
term_group 5 20,333
term_relationship 4 4 490,104
term_relationship_type 1 1 117
term_stage 2 3 3,079
term_subset 2 2 168,958
term_xref 1 2 6 426,210
tmp_addgene 4 0
tmp_all_term_contains 3 44,936
tmp_betterfishdump 4 3
tmp_db_link 7 0
tmp_efs_map 5 12,580,214
tmp_esag_predistinct 5 14,504,222
tmp_expression_phenotype_term 5 8
tmp_feature 6 694
tmp_figure 1 13,726
tmp_final 5 967
tmp_fish490 3 4,630
tmp_fish_thatfitthebill 23 882
tmp_fishnoeap 23 564
tmp_ftrchrdate 4 35
tmp_ftrchrdate2 4 730
tmp_ftrnote 6 1,376
tmp_genox_restore 5 0
tmp_go 7 7,146
tmp_go1 6 2,136
tmp_onlydeficiencies 1 13
tmp_onlyfish 3 9,306
tmp_ottens 4 3,941
tmp_pub 1 4,574
tmp_pub2 1 76
tmp_pub3 1 0
tmp_pub5 1 1,385
tmp_rnac_zfin 8 0
tmp_seqref 4 36,815
tmp_to_convert 1 887
tmp_zeco_tt 8 4,249
tmp_zirc_geno 4 0
tmpcne 7 113
transcript 1 3 5 44,464
transcript_sequence 1 3 1,074
transcript_status 2 4 18
transcript_type 3 7 19
tscript_type_status_definition 2 4 18
tscriptens 3 1,039
tscriptens1 3 1,518
tscriptsequence 3 1,113
unique_location 2 173,403
updates 9 1,687,748
url_ref 1 4 1
validate_check_history 3 84
variant_flanking_sequence 1 11 40,068
vector 1 1 2 68
vector_type 1 2 14
video 1 3 389
warehouse_run_tracking 4 5
withdrawn_data 4 12,048
xpat_exp_details_generated 10 142,611
xpat_exp_details_generated_bkup 10 142,551
xpat_exp_details_generated_temp 10 0
xpat_figure_group 5 15,859
xpat_figure_group_member 4 27,885
xpat_results_generated 11 308,425
xpat_results_generated_bkup 11 308,334
xpat_results_generated_temp 11 0
xpatfs_old 5 245,092
zdb_active_data 80 1 5,466,601
zdb_active_source 16 1 65,659
zdb_flag 3 14
zdb_object_type 7 122
zdb_orphan_data 1 3 0
zdb_orphan_source 1 3 0
zdb_replaced_data 1 4 35,458
zdb_submitters 1 1 13 9,655
zebrashare_data_edit_permission 2 4 28
zebrashare_submission_metadata 3 5 6
zfa_uberon_mapping 3 55
zfin_accession_number 4 2,706
zfin_ensembl_gene 10 24,011
zmap_pub_pan_mark 3 14 35,840
zygocity 3 1 7 5
           
452 Tables     2,446 93,957,289  
2 Views     38