SchemaSpy Analysis of topp.deprecated Generated by
SchemaSpy
Generated by SchemaSpy on Wed Dec 27 13:21 PST 2017
Database Type: PostgreSQL - 9.3.20 SourceForge.net


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

Table Children Parents Columns Rows Comments
a 1 -1
abft_hal 5 40
ac_data 18 724
acoustic_channel 9 248
acoustic_data_mbari 15 332
acoustic_data_tmp 6 130
acoustic_dep_tmp 23 1,638
acoustic_header 24 571
acoustic_rec_tmp 12 200
acoustic_sync 6 248
acoustic_test 3 69
addresses 1 9 8
ageclasstypes 2 8
agentaliases 1 2 139
agents 22 2 16 99
agenttypes 1 3 16
animal_name 12 60
animalexcursions 2 6 1,079
animals 1 1 8 747
archdeployments_nogroup 58 1
archprogramming_nogroup 33 1
b 1 -1
bak 20 4,227
bar 1 -1
baz 19 1
best_file_name_table 11 1,943
best_url_meta_table 148 1,630
bestsessionstable 6 4,215
birdencounterdata 1 10 251
birdmammalencounterdata 1 6 502
blah 19 2
byteafiles 2 2,604
c 1 0
cases 7 5 9 748
cdate 1 1
channelcalibration 2 6 0
channelprograms 2 5 600
conditions 3 9 104
conditionsaliases 1 2 10
conflicts 1 4
conventionalrecoveries 5 10 46
conventionaltagging 5 8 1,146
conventionaltags 2 2 5 1,170
costatdrtablesample 15 1,000
d 2 -1
dataprocessing 3 3 8 0
dataprocessingdefs 2 1 5 0
datatypes 2 12
daylocationdatagf 18 100,273
daylocationdatagl 5 110,053
daylocationdatalf 4 92,935
daylogdata 16 110,948
dc 6 53,644,749
dctimeseriesdata 6 294,516,430
debugtable 1 1
decoded_files 7 552
deleteme 1 2
deployments 5 13 1,128
deploymenttypes 1 3 3
depthtemperaturedatadt 4 9,016,846
dnasamples 1 4 262
download_urls_temp 5 180
downloads 1 4 0
embargoinfo 3 0
encounterdata 3 10 1,031
encounters 17 6 9 1,031
encountertypes 1 3 3
eseal_sex 5 215
eseal_ssm_tracks 18 37,213
eventtypes 3 3 21
examinations 2 16 33
files 23 2,604
filetypes 3 0
fileuseclasses 3 0
fishencounterdata 4 24 0
fishexaminations 1 26 0
fishprobs 80 30
fishrecoveries 1 9 0
foo_ptts 2 132
foobar1 1 -1
foobar2 1 -1
foobar3 1 -1
foobar4 1 -1
forms 4 0
ggsatdeployments 16 2,020
glnck 83 10
glnfgsatdeployments 94 533
glnsatdeployments 15 2,020
glnt1 3 3
glnt2 2 3
glntmp 3 22
glsd 16 2,525
harvested_files 8 10,138
harvested_files_with_duplicates 8 845
histogrambindefs 1 3 0
histogramtemplates 1 4 0
icon_color 5 10
jake_052003 6 277
jake_052004 6 1,307
jake_062003 6 216
jake_062004 6 777
jake_072003 6 178
jake_072004 6 212
jake_dates 6 216
killer 5 27
kitassignments 2 2 0
las_species_number 3 59
lengthtypes 1 2 2
locations 3 15 276
logintest 8 2
lsdexceptsm 2 1,943
ltd2310_program_data 28 0
mammalencounterdata 1 39 251
mamvis_secs 16 908
mamvis_subset 8 76,056
mamvis_toppid 14 709
map_params 6 12
marlin_pdt_data 10 7,817
marlin_pdt_temporary 10 0
marlin_track_data 9 1,178
marlin_track_temporary 9 0
masstypes 1 2 2
mc_crap 2 100,000
mc_dep 5 5
mc_ts 2 4
memotypes 1 3 3
minimal_deploys 26 0 Stores minimal deploy data for tags that do not fit in FG or SG
minimal_recovery 12 0 Stores minimal recovery data for tags that do not fit in FG or SG
mola_diag 3 0
mola_prv 4 0
mrc_date 5 2
mrc_images 2 1
mrc_nature 13 13,359
mrc_salmon 4 39
mypdt 6 414,266
mypsatlongitude 6 24,629
mytad 5 683,712
mytat 5 581,472
new_atn_track_qc 15 15
new_atn_track_qc_row 47 0
new_deployment_row 28 0
new_satdeployments 12 15
new_tblsharkdeployment 88 697
nonconflicts 1 9
old_tblfgarchivaldeployment 90 1,779
passwords 3 2
pdt 6 100,249
pdt_datetime 5 56,662
pdt_datetime1 7 59,283
pdt_distinct 2 8,695
pdt_latlong 8 35,757
pdt_link_table 3 6,001
pdt_toppid 7 56,662
pdt_trimmed 3 3,111
pdt_vars 11 36,837
pdttable 7 48,483
pendata 11 161,281
pg2nc 3 6
probemodelaliases 1 2 19
proceduredefs 1 5 0
profile 4 1,701,193
profilex 4 396
program_data 1 2 0
projectaliases 1 2 20
projects 5 1 8 45
projectspeciesassociations 1 2 0
projecttagtypeassociations 2 2 0
psat_geolocation 17 559
psat_program_data 42 0
psatlongitude 4 274
ptd_datetime 6 48,483
pttevents 2 2 282
ptts 3 11 202
public_turtle_archival_table 116 32
public_turtle_sat_table 150 47
public_turtle_smru_table 89 62
published_columns 2 238
purchases 8 0
recoveries 2 5 299
recoveryencounterdata 1 2 0
sa 1 65
sal_argos_pdt_fine 10 240,304
sal_dbl_no_salm 1 54
sal_pdt_argos_2 9 23,988
sal_pdttopevent_long 1 3,219
sal_tad_ca 9 23,988
sal_tb_geol 1 29
sal_temp_acu 2 272
sal_temp_acu_deploy 1 308
sal_temp_acu_deploy2 1 308
sal_test 2 0
satdeployments_04sep07 17 2,613
satdeployments_10sep07 17 2,612
satdeployments_14aug07 17 2,625
satdeployments_save_broken 16 -1
satdeploymentsnew 17 2,613
satdeploymentsorig 17 2,625
satdepsub 13 1,848
satdtest 17 2,611
satellitelocation_backup 12 436,638
satellitelocation_debug 12 405
satellitelocation_fixed 6 151,416
satellitelocation_link_table 3 10,490
satellitelocation_subset 5 10,490
satellitelocationtest 12 100
satlocation 12 735,483
satpassed 12 135,357
sensortypes 1 2 13
session 4 758
sextypes 3 3
shark_published_columns 2 154
shark_table 121 390
shark_url_table 134 522
sharkapp_table 14 26,652
sm 1 64
sm2 2 716
smexceptlsd 2 716
smru_ctd 19 7,937
smru_dive 49 53,795
spatialdatapoints 1 6 0
species 4 8 69
species_groups 2 9
speciesaliases 1 2 19
speciestagtypepermissions 2 6 0
spot_goodness_cache 6 117
spot_limits 4 15
ssm_metadata 37 218
ssm_tracks 18 283,213
storage 1 2 0
t 1 13
tad 5 124,532
tagcalibration 1 1 4 0
tagchannels 1 11 0
tagevents 17 4 7 3,280
taggerencounters 2 2 0
tagging 3 12 1,128
tagkitdefinitions 2 4 1
tagkitdefmembership 2 2 0
tagkits 1 2 4 1
tagmaintenance 3 10 0
tagman_minus_lsd 2 471
tagmemos 5 8 0
tagmodelaliases 1 2 26
tagmodels 7 2 9 51
tagpopoffs 2 2 0
tagprocessing 1 25 26
tagprograming 2 11 416
tagprograms 3 1 4 282
tags 3 2 8 1,067
tagsreceived 2 6 0
tagstatuscodes 1 3 13
tagtypealiases 1 2 16
tagtypes 5 3 14
tat 5 115,231
tat_datetime 6 73,354
tblabft_geodata_r2004 19 33,224
tblarccaldata 42 981
tblcontactinfo 16 28
tblfg_tmpsatdep 5 650
tblfgarchivaldeployment_gln 90 1,963
tblfgarchivalfiles2 53 1,855
tblfgarchivalfiles_old 50 1,779
tblfgarchivalfiles_save_no_plotfiles 50 1,856
tblfgarchtagfailures 12 180
tblfgsatfiles 10 578
tblgroups 3 87
tblleader_construction 25 0
tblmk10progrepfile 80 89
tblpatirepfile 67 143
tblpatproc1 6 843
tblpatprogrepfile 56 1,381
tblpredeployment 26 1
tblsgadeployment 9 7
tblsgpredeploy 27 78
tblshark_cwhite_ac 3 37 Almost a temporary table. Connor White had a bunch of juvenile white shark acoustic codes he wanted us to search the data for. This seemed like the easiest way.
tblsharkcontactinfo 17 12
tblsharkfiles 27 524
tblsharkfin_ids 3 138
tblsharkspotrepdata 84 190
tblsharkwcgcodes 2 2
tblsharkwcgdecoders 2 2
tblsharkwcgflags 13 0
tblspecies_groups 3 255
tblspotrepfiledata 84 593
tbltagdatasummary 24 0
tbltgarchivalfiles 50 32
tbltgsatfiles 27 107
tbltgsmru_ctd2rows 7 112,531
tbltgsmrucruise 12 10,242
tbltgsmructd 19 10,733
tbltgsmrudiag 32 44,128
tbltgsmrudive 49 117,912
tbltgsmrudivingperiod 9 69,413
tbltgsmruhaulout 16 1,515
tbltgsmruhauloutorig 15 1,615
tbltgsmrusummary 38 17,388
tbltgsmrutaginfo 22 60,749
tbltgsmruuplink 8 174,002
tbltgspotrepfiledata 83 18
tbltmarchival_28aug07 19 1,319
tbltmsat_28aug07 34 1,011
tblusers 3 66
temp 3 -1
temp0 34 5,656
temp1 34 5,656
temp_2015 5 -1
temp_2015_x 6 -1
temp_2016 5 -1
temp_2016_x 6 -1
temp_4 4 1
temp_a 34 5,658
temp_acou_data 18 861,467
temp_argos_diag_with_lc_sorted 4 2,759,856
temp_backup_satdeployments 20 4,205
temp_bak_tblsharkdeployment 104 1,556
temp_bar 16 1
temp_baz 16 1
temp_cache 2 3,524
temp_cache_argos 2 1,044,019
temp_change 34 0
temp_curl_glider_meta 7 11
temp_es15 20 3
temp_es16 20 19
temp_foo 6 -1
temp_foo_foo_foo 1 1
temp_foobar 1 1
temp_foof 7 1
temp_foof2 7 1
temp_foofoofoo 7 8
temp_fra 79 31,544
temp_jeg 5 -1
temp_jeg_deleteme 7 1
temp_new_deployments 19 76
temp_new_species 14 1
temp_pttnumber 1 3,800
temp_public 34 5,658
temp_refactor 34 5,658
temp_sal 2 19
temp_skomal 15 2
temp_t 34 5,658
temp_temp 15 1,579
temp_temp_temp 2 3
temp_white_shark 20 2
tempa 4 3
tempb 3 2
tempi 34 5,638
temporary_costalab_species 1 20
temporary_dates 3 522
test_stat_id 2 605
textfiles 2 378
thermistorprobemodels 3 1 6 8
time_latlong 4 3,111
timeseriesdata 2 13 0
tissuenblood 1 15 251
tmp_200056 5 682
tmp_aaron_sums 3 1,005
tmp_abft 6 96
tmp_abftgeossm 16 19,158
tmp_accumulator_atn_track_qc 15 118
tmp_accumulator_satdeployments 19 118
tmp_andre 13 33,224
tmp_backup_atn_track_qc 15 1,579
tmp_backup_atn_track_query 15 1,579
tmp_can 5 45
tmp_carey2 5 2
tmp_chuck 3 28
tmp_crap 5 640
tmp_lauretta_sums 3 992
tmp_marlingeossm 13 5,517
tmp_nada 3 75
tmp_nada2 2 1
tmp_new_atn_track_qc 15 1,579
tmp_prepone 3 1
tmp_sg 16 16,452
tmp_sharkgeossm 12 15,722
tmp_spot 7 28
tmp_spot2 5 4
tmp_spot3 5 0
tmp_spot4 5 1
tmp_spot5 5 32
tmp_spot6 6 15
tmp_spot7 6 6
tmp_spot8 6 15
tmp_spot9 6 6
tmp_spot91 6 15
tmp_tmacoustic 45 496
tmpsatdeployments 15 2,029
tmpspotrepfiledata 83 585
tmptw 3 1,488
topp_rpt_tmp 13 1,517
toppid_tagcode_url_table 5 1,799
toppspecies2 14 60
toppunits 4 29
transmissions 2 5 0
triplogs 5 8 0
trips 2 4 9 0
turtle_archival_field_groups 3 6
turtle_archival_names 2 116
turtle_archival_published_columns 2 170
turtle_archival_table 119 32
turtle_dive_analysis 2 90,870
turtle_dive_analysis_with_metadata_table 50 68,589
turtle_sat_field_groups 3 6
turtle_sat_names 2 150
turtle_sat_published_columns 2 95
turtle_sat_table 74 45
turtle_sat_url_table 102 65
turtle_smru_field_groups 3 5
turtle_smru_names 2 89
turtle_smru_published_columns 2 127
turtle_smru_table 91 62
turtleencounterdata 1 13 0
updates 3 13,340
vessels 3 1 7 5
waveglider_telemetry 9 69,781
web_patprog 67 2
webfg_mindeploy 25 24
webfg_minrecv 38 337
websg_minrecv 34 3
woa_mean 5 18,662,400
woa_std 5 18,662,400
workinggroups 2 5
y 1 148
z 1 -1
           
424 Tables     6,489 407,506,787  
0 Views     0