SchemaSpy Analysis of topp.deprecated - Anomalies

Generated by SchemaSpy

Things that might not be 'quite right' about your schema:

• Columns whose name and type imply a relationship to another table's primary key:

  Child Column	Implied Parent Column
  abft_hal.eventid	minimal_deploys.eventid
  acoustic_data_mbari.tkey	passwords.tkey
  acoustic_header.tkey	passwords.tkey
  archprogramming_nogroup.ngkey	archdeployments_nogroup.ngkey
  bak.eventid	minimal_deploys.eventid
  bak.pttnumber	ptts.pttnumber
  baz.eventid	minimal_deploys.eventid
  baz.pttnumber	ptts.pttnumber
  best_file_name_table.sessionid	session.sessionid
  best_file_name_table.tagprocessingeventid	dataprocessing.tagprocessingeventid
  bestsessionstable.sessionid	session.sessionid
  bestsessionstable.tagprocessingeventid	dataprocessing.tagprocessingeventid
  blah.eventid	minimal_deploys.eventid
  blah.pttnumber	ptts.pttnumber
  byteafiles.fileid	textfiles.fileid
  dataprocessingdefs.fileid	textfiles.fileid
  daylocationdatagf.sessionid	session.sessionid
  daylocationdatagl.sessionid	session.sessionid
  daylocationdatalf.sessionid	session.sessionid
  daylogdata.sessionid	session.sessionid
  dctimeseriesdata.sessionid	session.sessionid
  decoded_files.pttnumber	ptts.pttnumber
  depthtemperaturedatadt.sessionid	session.sessionid
  downloads.fileid	textfiles.fileid
  embargoinfo.eventid	minimal_deploys.eventid
  files.fileid	textfiles.fileid
  files.processid	dataprocessingdefs.processid
  files.projectid	projects.projectid
  files.sessionid	session.sessionid
  files.speciescode	species.speciescode
  files.tagid	conventionaltags.tagid
  files.tagmodelid	tagmodels.tagmodelid
  files.useclassid	fileuseclasses.useclassid
  fishprobs.pttnumber	ptts.pttnumber
  foo_ptts.pttnumber	ptts.pttnumber
  forms.fileid	textfiles.fileid
  ggsatdeployments.eventid	minimal_deploys.eventid
  ggsatdeployments.pttnumber	ptts.pttnumber
  glnsatdeployments.eventid	minimal_deploys.eventid
  glnsatdeployments.pttnumber	ptts.pttnumber
  glntmp.eventid	minimal_deploys.eventid
  glsd.eventid	minimal_deploys.eventid
  glsd.pttnumber	ptts.pttnumber
  lsdexceptsm.pttnumber	ptts.pttnumber
  ltd2310_program_data.programid	tagprograms.programid
  mamvis_secs.pttnumber	ptts.pttnumber
  mamvis_secs.toppid	cases.toppid
  mamvis_subset.pttnumber	ptts.pttnumber
  mamvis_subset.toppid	cases.toppid
  mamvis_toppid.pttnumber	ptts.pttnumber
  mamvis_toppid.toppid	cases.toppid
  mc_dep.eventid	minimal_deploys.eventid
  minimal_recovery.eventid	minimal_deploys.eventid
  mola_diag.pttnumber	ptts.pttnumber
  mola_prv.pttnumber	ptts.pttnumber
  mrc_date.tkey	passwords.tkey
  new_atn_track_qc.eventid	minimal_deploys.eventid
  new_atn_track_qc_row.eventid	minimal_deploys.eventid
  new_satdeployments.eventid	minimal_deploys.eventid
  new_satdeployments.pttnumber	ptts.pttnumber
  pdt.pttnumber	ptts.pttnumber
  pdt_datetime.toppid	cases.toppid
  pdt_datetime1.pttnumber	ptts.pttnumber
  pdt_distinct.toppid	cases.toppid
  pdt_latlong.toppid	cases.toppid
  pdt_link_table.toppid	cases.toppid
  pdt_toppid.pttnumber	ptts.pttnumber
  pdt_toppid.toppid	cases.toppid
  pdt_trimmed.toppid	cases.toppid
  pdt_vars.toppid	cases.toppid
  pdttable.pttnumber	ptts.pttnumber
  pendata.sessionid	session.sessionid
  pendata.tagprocessingeventid	dataprocessing.tagprocessingeventid
  proceduredefs.fileid	textfiles.fileid
  psat_program_data.histogramid	histogramtemplates.histogramid
  psat_program_data.programid	tagprograms.programid
  psatlongitude.pttnumber	ptts.pttnumber
  ptd_datetime.toppid	cases.toppid
  ptts.tagid	conventionaltags.tagid
  published_columns.name	toppunits.name
  sal_dbl_no_salm.eventid	minimal_deploys.eventid
  satdeployments_04sep07.eventid	minimal_deploys.eventid
  satdeployments_04sep07.pttnumber	ptts.pttnumber
  satdeployments_10sep07.eventid	minimal_deploys.eventid
  satdeployments_10sep07.pttnumber	ptts.pttnumber
  satdeployments_14aug07.eventid	minimal_deploys.eventid
  satdeployments_14aug07.pttnumber	ptts.pttnumber
  satdeployments_save_broken.eventid	minimal_deploys.eventid
  satdeployments_save_broken.pttnumber	ptts.pttnumber
  satdeploymentsnew.eventid	minimal_deploys.eventid
  satdeploymentsnew.pttnumber	ptts.pttnumber
  satdeploymentsorig.eventid	minimal_deploys.eventid
  satdeploymentsorig.pttnumber	ptts.pttnumber
  satdepsub.pttnumber	ptts.pttnumber
  satdepsub.toppid	cases.toppid
  satdtest.eventid	minimal_deploys.eventid
  satdtest.pttnumber	ptts.pttnumber
  satellitelocation_backup.toppid	cases.toppid
  satellitelocation_debug.toppid	cases.toppid
  satellitelocation_fixed.toppid	cases.toppid
  satellitelocation_link_table.toppid	cases.toppid
  satellitelocation_subset.toppid	cases.toppid
  satellitelocationtest.toppid	cases.toppid
  satlocation.toppid	cases.toppid
  satpassed.toppid	cases.toppid
  session.tagprocessingeventid	dataprocessing.tagprocessingeventid
  shark_published_columns.name	toppunits.name
  shark_url_table.eventid	minimal_deploys.eventid
  shark_url_table.pttnumber	ptts.pttnumber
  spot_goodness_cache.toppid	cases.toppid
  spot_limits.toppid	cases.toppid
  tad.pttnumber	ptts.pttnumber
  tagcalibration.fileid	textfiles.fileid
  tagkitdefinitions.formid	forms.formid
  tagmaintenance.fileid	textfiles.fileid
  tagmemos.fileid	textfiles.fileid
  tagprocessing.fileid	textfiles.fileid
  tagprograms.fileid	textfiles.fileid
  tags.tagid	conventionaltags.tagid
  tat.pttnumber	ptts.pttnumber
  tat_datetime.pttnumber	ptts.pttnumber
  tblfg_tmpsatdep.tkey	passwords.tkey
  tblfgarchivalfiles_save_no_plotfiles.fgafkey	tblfgarchivalfiles2.fgafkey
  tblsgadeployment.akey	psat_geolocation.akey
  tblsgpredeploy.tkey	passwords.tkey
  tblshark_cwhite_ac.tkey	passwords.tkey
  tblsharkcontactinfo.investid	tblcontactinfo.investid
  tblsharkcontactinfo.tkey	passwords.tkey
  tblsharkfiles.tkey	passwords.tkey
  tbltgsmrudive.ckey	tbltgsmrucruise.ckey
  tbltgsmrutaginfo.ckey	tbltgsmrucruise.ckey
  tbltgsmruuplink.tkey	passwords.tkey
  tbltmsat_28aug07.pttnumber	ptts.pttnumber
  temp.pttnumber	ptts.pttnumber
  temp0.eventid	minimal_deploys.eventid
  temp1.eventid	minimal_deploys.eventid
  temp_2015.pttnumber	ptts.pttnumber
  temp_2015_x.pttnumber	ptts.pttnumber
  temp_2016.pttnumber	ptts.pttnumber
  temp_2016_x.pttnumber	ptts.pttnumber
  temp_a.eventid	minimal_deploys.eventid
  temp_acou_data.tkey	passwords.tkey
  temp_argos_diag_with_lc_sorted.pttnumber	ptts.pttnumber
  temp_backup_satdeployments.eventid	minimal_deploys.eventid
  temp_backup_satdeployments.pttnumber	ptts.pttnumber
  temp_bar.eventid	minimal_deploys.eventid
  temp_baz.eventid	minimal_deploys.eventid
  temp_cache.pttnumber	ptts.pttnumber
  temp_cache_argos.pttnumber	ptts.pttnumber
  temp_change.eventid	minimal_deploys.eventid
  temp_es15.eventid	minimal_deploys.eventid
  temp_es15.pttnumber	ptts.pttnumber
  temp_es16.eventid	minimal_deploys.eventid
  temp_es16.pttnumber	ptts.pttnumber
  temp_foo.pttnumber	ptts.pttnumber
  temp_foof.eventid	minimal_deploys.eventid
  temp_foof2.eventid	minimal_deploys.eventid
  temp_foofoofoo.eventid	minimal_deploys.eventid
  temp_fra.eventid	minimal_deploys.eventid
  temp_jeg.pttnumber	ptts.pttnumber
  temp_new_deployments.eventid	minimal_deploys.eventid
  temp_new_deployments.pttnumber	ptts.pttnumber
  temp_pttnumber.pttnumber	ptts.pttnumber
  temp_public.eventid	minimal_deploys.eventid
  temp_refactor.eventid	minimal_deploys.eventid
  temp_sal.toppid	cases.toppid
  temp_skomal.eventid	minimal_deploys.eventid
  temp_t.eventid	minimal_deploys.eventid
  temp_temp.eventid	minimal_deploys.eventid
  temp_white_shark.eventid	minimal_deploys.eventid
  temp_white_shark.pttnumber	ptts.pttnumber
  tempi.eventid	minimal_deploys.eventid
  temporary_dates.name	toppunits.name
  time_latlong.toppid	cases.toppid
  tmp_aaron_sums.eventid	minimal_deploys.eventid
  tmp_abft.toppid	cases.toppid
  tmp_abftgeossm.eventid	minimal_deploys.eventid
  tmp_accumulator_atn_track_qc.eventid	minimal_deploys.eventid
  tmp_accumulator_satdeployments.eventid	minimal_deploys.eventid
  tmp_accumulator_satdeployments.pttnumber	ptts.pttnumber
  tmp_backup_atn_track_qc.eventid	minimal_deploys.eventid
  tmp_backup_atn_track_query.eventid	minimal_deploys.eventid
  tmp_can.pttnumber	ptts.pttnumber
  tmp_lauretta_sums.eventid	minimal_deploys.eventid
  tmp_marlingeossm.eventid	minimal_deploys.eventid
  tmp_new_atn_track_qc.eventid	minimal_deploys.eventid
  tmp_sg.eventid	minimal_deploys.eventid
  tmp_sharkgeossm.eventid	minimal_deploys.eventid
  tmp_spot.toppid	cases.toppid
  tmp_spot2.toppid	cases.toppid
  tmp_spot3.toppid	cases.toppid
  tmp_spot4.toppid	cases.toppid
  tmp_spot5.toppid	cases.toppid
  tmp_spot6.toppid	cases.toppid
  tmp_spot7.toppid	cases.toppid
  tmp_spot8.toppid	cases.toppid
  tmp_spot9.toppid	cases.toppid
  tmp_spot91.toppid	cases.toppid
  tmpsatdeployments.pttnumber	ptts.pttnumber
  tmpsatdeployments.toppid	cases.toppid
  tmptw.tkey	passwords.tkey
  transmissions.fileid	textfiles.fileid
  turtle_archival_published_columns.name	toppunits.name
  turtle_sat_published_columns.name	toppunits.name
  turtle_smru_published_columns.name	toppunits.name
  updates.sessionid	session.sessionid
  waveglider_telemetry.tkey	passwords.tkey
  webfg_mindeploy.tkey	passwords.tkey
  webfg_minrecv.tkey	passwords.tkey
  websg_minrecv.tkey	passwords.tkey
  y.pttnumber	ptts.pttnumber

  211 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  a	-1
  abft_hal	40
  ac_data	724
  acoustic_channel	248
  acoustic_data_tmp	130
  acoustic_dep_tmp	1,638
  acoustic_rec_tmp	200
  acoustic_sync	248
  acoustic_test	69
  agentaliases	139
  animal_name	60
  b	-1
  bak	4,227
  bar	-1
  baz	1
  best_file_name_table	1,943
  best_url_meta_table	1,630
  birdencounterdata	251
  birdmammalencounterdata	502
  blah	2
  c	0
  cdate	1
  channelcalibration	0
  channelprograms	600
  conditionsaliases	10
  conflicts	4
  conventionalrecoveries	46
  conventionaltagging	1,146
  costatdrtablesample	1,000
  d	-1
  debugtable	1
  deleteme	2
  dnasamples	262
  download_urls_temp	180
  downloads	0
  encounterdata	1,031
  eseal_sex	215
  eseal_ssm_tracks	37,213
  examinations	33
  fishencounterdata	0
  fishexaminations	0
  fishprobs	30
  fishrecoveries	0
  foo_ptts	132
  foobar1	-1
  foobar2	-1
  foobar3	-1
  foobar4	-1
  glnck	10
  glnfgsatdeployments	533
  glnsatdeployments	2,020
  glnt1	3
  glnt2	3
  glntmp	22
  glsd	2,525
  harvested_files	10,138
  harvested_files_with_duplicates	845
  histogrambindefs	0
  icon_color	10
  jake_052003	277
  jake_052004	1,307
  jake_062003	216
  jake_062004	777
  jake_072003	178
  jake_072004	212
  jake_dates	216
  killer	27
  kitassignments	0
  las_species_number	59
  lsdexceptsm	1,943
  ltd2310_program_data	0
  mammalencounterdata	251
  mamvis_secs	908
  mamvis_subset	76,056
  mamvis_toppid	709
  map_params	12
  marlin_pdt_data	7,817
  marlin_pdt_temporary	0
  marlin_track_data	1,178
  marlin_track_temporary	0
  mc_crap	100,000
  mc_dep	5
  mc_ts	4
  mola_diag	0
  mola_prv	0
  mrc_images	1
  mrc_salmon	39
  mypdt	414,266
  mypsatlongitude	24,629
  mytad	683,712
  mytat	581,472
  new_atn_track_qc	15
  new_atn_track_qc_row	0
  new_deployment_row	0
  new_satdeployments	15
  new_tblsharkdeployment	697
  nonconflicts	9
  old_tblfgarchivaldeployment	1,779
  pdt	100,249
  pdt_datetime	56,662
  pdt_datetime1	59,283
  pdt_distinct	8,695
  pdt_latlong	35,757
  pdt_link_table	6,001
  pdt_toppid	56,662
  pdt_trimmed	3,111
  pdt_vars	36,837
  pendata	161,281
  pg2nc	6
  probemodelaliases	19
  profilex	396
  program_data	0
  projectaliases	20
  projectspeciesassociations	0
  projecttagtypeassociations	0
  psat_program_data	0
  psatlongitude	274
  ptd_datetime	48,483
  pttevents	282
  public_turtle_archival_table	32
  public_turtle_sat_table	47
  public_turtle_smru_table	62
  published_columns	238
  purchases	0
  recoveries	299
  recoveryencounterdata	0
  sa	65
  sal_argos_pdt_fine	240,304
  sal_dbl_no_salm	54
  sal_pdt_argos_2	23,988
  sal_pdttopevent_long	3,219
  sal_tad_ca	23,988
  sal_tb_geol	29
  sal_temp_acu	272
  sal_temp_acu_deploy	308
  sal_temp_acu_deploy2	308
  sal_test	0
  satdeployments_04sep07	2,613
  satdeployments_10sep07	2,612
  satdeployments_14aug07	2,625
  satdeployments_save_broken	-1
  satdeploymentsnew	2,613
  satdeploymentsorig	2,625
  satdepsub	1,848
  satdtest	2,611
  satellitelocation_backup	436,638
  satellitelocation_debug	405
  satellitelocation_fixed	151,416
  satellitelocationtest	100
  satlocation	735,483
  satpassed	135,357
  shark_published_columns	154
  shark_table	390
  shark_url_table	522
  sharkapp_table	26,652
  sm	64
  sm2	716
  smexceptlsd	716
  smru_ctd	7,937
  smru_dive	53,795
  spatialdatapoints	0
  species_groups	9
  speciesaliases	19
  speciestagtypepermissions	0
  spot_goodness_cache	117
  spot_limits	15
  ssm_metadata	218
  ssm_tracks	283,213
  storage	0
  t	13
  tad	124,532
  taggerencounters	0
  tagging	1,128
  tagkitdefmembership	0
  tagmaintenance	0
  tagman_minus_lsd	471
  tagmemos	0
  tagmodelaliases	26
  tagpopoffs	0
  tagprocessing	26
  tagprograming	416
  tagsreceived	0
  tagtypealiases	16
  tat	115,231
  tat_datetime	73,354
  tblabft_geodata_r2004	33,224
  tblfgarchivaldeployment_gln	1,963
  tblfgarchivalfiles_old	1,779
  tblsharkspotrepdata	190
  tblsharkwcgcodes	2
  tblsharkwcgdecoders	2
  tbltagdatasummary	0
  tbltmarchival_28aug07	1,319
  tbltmsat_28aug07	1,011
  temp	-1
  temp0	5,656
  temp1	5,656
  temp_2015	-1
  temp_2015_x	-1
  temp_2016	-1
  temp_2016_x	-1
  temp_4	1
  temp_a	5,658
  temp_acou_data	861,467
  temp_backup_satdeployments	4,205
  temp_bak_tblsharkdeployment	1,556
  temp_bar	1
  temp_baz	1
  temp_cache	3,524
  temp_change	0
  temp_curl_glider_meta	11
  temp_es15	3
  temp_es16	19
  temp_foo	-1
  temp_foo_foo_foo	1
  temp_foobar	1
  temp_foof	1
  temp_foof2	1
  temp_foofoofoo	8
  temp_fra	31,544
  temp_jeg	-1
  temp_jeg_deleteme	1
  temp_new_deployments	76
  temp_new_species	1
  temp_pttnumber	3,800
  temp_public	5,658
  temp_refactor	5,658
  temp_sal	19
  temp_skomal	2
  temp_t	5,658
  temp_temp	1,579
  temp_temp_temp	3
  temp_white_shark	2
  tempa	3
  tempb	2
  tempi	5,638
  temporary_costalab_species	20
  temporary_dates	522
  test_stat_id	605
  time_latlong	3,111
  timeseriesdata	0
  tissuenblood	251
  tmp_200056	682
  tmp_aaron_sums	1,005
  tmp_abft	96
  tmp_abftgeossm	19,158
  tmp_accumulator_atn_track_qc	118
  tmp_accumulator_satdeployments	118
  tmp_andre	33,224
  tmp_backup_atn_track_qc	1,579
  tmp_backup_atn_track_query	1,579
  tmp_can	45
  tmp_carey2	2
  tmp_chuck	28
  tmp_crap	640
  tmp_lauretta_sums	992
  tmp_marlingeossm	5,517
  tmp_nada	75
  tmp_nada2	1
  tmp_new_atn_track_qc	1,579
  tmp_prepone	1
  tmp_sg	16,452
  tmp_sharkgeossm	15,722
  tmp_spot	28
  tmp_spot2	4
  tmp_spot3	0
  tmp_spot4	1
  tmp_spot5	32
  tmp_spot6	15
  tmp_spot7	6
  tmp_spot8	15
  tmp_spot9	6
  tmp_spot91	15
  tmp_tmacoustic	496
  tmpsatdeployments	2,029
  tmpspotrepfiledata	585
  tmptw	1,488
  topp_rpt_tmp	1,517
  toppid_tagcode_url_table	1,799
  toppspecies2	60
  transmissions	0
  turtle_archival_published_columns	170
  turtle_archival_table	32
  turtle_dive_analysis	90,870
  turtle_dive_analysis_with_metadata_table	68,589
  turtle_sat_published_columns	95
  turtle_sat_table	45
  turtle_sat_url_table	65
  turtle_smru_published_columns	127
  turtle_smru_table	62
  turtleencounterdata	0
  updates	13,340
  y	148
  z	-1

  294 instances of anomaly detected

• Columns that are flagged as both 'nullable' and 'must be unique':

  Column
  agents.agentcode
  animalexcursions.excursionid
  deployments.deploymentid
  embargoinfo.eventid
  files.fileformat
  files.filetype
  files.sessionid
  mrc_nature.tkey
  session.tagnumber
  session.tagprocessingeventid
  session.toppid
  species.abreviation
  tagmodels.tagcode
  turtle_archival_field_groups.private_prefix
  turtle_archival_names.public_name
  turtle_sat_field_groups.private_prefix
  turtle_sat_names.public_name
  turtle_smru_field_groups.private_prefix
  turtle_smru_names.public_name
  woa_mean.lat
  woa_mean.level_id
  woa_mean.lon
  woa_mean.month
  woa_std.lat
  woa_std.level_id
  woa_std.lon
  woa_std.month

  27 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  a	table_name
  b	a
  bar	date_part
  c	foo
  cdate	date
  conflicts	toppid
  debugtable	count
  deleteme	a
  foobar1	n
  foobar2	e
  foobar3	t
  foobar4	z
  nonconflicts	toppid
  sa	tgsdkey
  sal_dbl_no_salm	eventid
  sal_pdttopevent_long	toppid
  sal_tb_geol	toppid
  sal_temp_acu_deploy	code
  sal_temp_acu_deploy2	int8
  sm	tgdeploykey
  t	toppid
  temp_foo_foo_foo	abstime
  temp_foobar	to_timestamp
  temp_pttnumber	pttnumber
  temporary_costalab_species	speciesname
  y	pttnumber
  z	filter

  27 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  addresses
  archdeployments_nogroup
  best_url_meta_table
  fishencounterdata
  fishexaminations
  fishprobs
  glnck
  glnfgsatdeployments
  new_tblsharkdeployment
  old_tblfgarchivaldeployment
  pdt_vars
  psat_geolocation
  public_turtle_smru_table
  satellitelocation_backup
  satellitelocation_debug
  satellitelocationtest
  satlocation
  satpassed
  smru_dive
  tblarccaldata
  tblfgarchivaldeployment_gln
  tblfgarchivalfiles2
  tblfgarchivalfiles_old
  tblfgarchivalfiles_save_no_plotfiles
  tblpatirepfile
  tblpatprogrepfile
  tblsharkfiles
  tblsharkspotrepdata
  tblspotrepfiledata
  tbltgarchivalfiles
  tbltgsatfiles
  tbltgsmrudive
  tbltgspotrepfiledata
  temp_bak_tblsharkdeployment
  temp_fra
  timeseriesdata
  tmp_tmacoustic
  tmpspotrepfiledata
  topp_rpt_tmp
  turtle_dive_analysis_with_metadata_table
  waveglider_telemetry

  41 instances of anomaly detected

• Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
  Anomaly not detected