SchemaSpy Analysis of cxgn.sgn_bt

Generated by
SchemaSpy
Generated by SchemaSpy on Thu Jun 21 23:03 EDT 2007
Database Type: PostgreSQL - 8.1.8 SourceForge.net

Please support this project

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

101 Tables and 3 Views:

Table Children Parents Rows Comments
accession 4 2 62
accession_names 1 1 63
annotation_target_type 1
authors 0
blast_annotations 1 1 465,313
blast_db 1 34 This table holds metadata about the BLAST databases that we keep in stock.
blast_db_group 1 7
blast_defline 1,080,106
blast_hits 1 13,781,459
blast_targets 3
cds 1 1 149,978
clone 3 1 636,581
cloning_vector 6
common_name 1 12
cos_markers 1 1,025
cosii_ortholog 1 10,668
deprecated_linkage_groups 1 1 151
deprecated_map_cross 2 18
deprecated_mapdata 1 2 7,750
deprecated_maps 5 12
deprecated_marker_confidences 2 5
deprecated_marker_locations 3 7,724
deprecated_marker_types 1 16
deprecated_markers 3 1 7,516
derived_from_source 1 4
domain 1 20,249
domain_match 2 187,752
enzyme_restriction_sites 8,933
enzymes 1 124
est 2 1 826,514
ests_mapped_by_clone 2 146
experiment_type 1 4
facility 1 27
family 1 101,359
family_build 3
family_member 350,727
family_tree 1 6,113
fish_chromatin_density_constants 2
fish_experimenter 1 1
fish_file 3,419
fish_image 216
fish_karyotype_constants 24
fish_karyotype_constants_old 12
fish_result 3 855
fish_result_composite 215
forward_amplicon_sequence_information 20
forward_amplicon_sequence_markers 1,473
go 1 2,838
group_linkage 1,828,161
groups 1 34,813
id_linkage 907,042
interpro 1 13,261
interpro_go 2 17,839
library 1 1 127
linkage_group 1 3 263
loc_types 2
manual_annotations 6,833
manual_censor_reasons 1
map 2 2 14
map_version 3 2 20
mapmarkers_view view
marker 13 7,223
marker_alias 1 7,224
marker_collectible 2 3,968
marker_collection 1 3
marker_confidence 1 5
marker_derived_from 2 763
marker_experiment 4 21,099
marker_location 3 3 15,221
marker_to_map view
microarray 13,440
misc 0
organism 2 1 41
p_markers 1 32
pcr_exp_accession 1 2 7,450
pcr_experiment 2 5 6,776
pcr_product 2 9,218
plants view
primer_unigene_match 2 1,895
qc_report 1 623,922
rflp_markers 1 3 665
rflp_sequences 3 1,277
rflp_unigene_associations 2 1,995
seqread 1 2 667,385
sequence 2 3,775
ssr 2 1 647
ssr_primer_unigene_matches 2 36
ssr_repeats 2 891
submit_user 10
temp_caps_correspondence 291
temp_map_correspondence 2 12
temp_marker_correspondence 1 607
tigrtc_index 1
tigrtc_membership 138,407
tigrtc_tracking 91,488
tm_markers 1 2 30
tm_markers_sequences 30
trim_feature 563,973
trim_feature_types 9
types 1 19
unigene 6 2 358,600
unigene_build 4 4 22
unigene_consensi 1 207,926
unigene_member 2 1,578,530

Total rows: 24,802,822