| SchemaSpy Analysis of topp.public - 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:
Anomaly not detected -
Tables without indexes:
27 instances of anomaly detectedTable Rows argos_diag_with_lc 2,880,595 argos_diag_with_lc_lat_lon_add_rows 6,193 argos_diag_with_lc_lat_lon_bak 2,833,807 argos_diag_with_lc_lat_lon_delete_rows 5,125 atn_eventids 2,029 canada 1 curr_meta_runnable 0 deleteme 9 deleteme2 3 deleteme3 3 eventid_to_run 0 junk.deleteme 0 junk.td 0 junk.tdasss 3 mbari_diag 19,773 mbari_prv 19,793 new_atn_track_qc_row 0 new_deployment_row 4 prev_meta 41 special_argos_share_processing 10 ssmupdates 30,997 ssmupdates_test 327 sulikowski 24 table_argos_diag_with_lc_lat_lon_with_dups 2,829,380 tblsatdeployments 2,020 tblsatdeployments_url 12,281,849 tmp_prepone 1 -
Columns that are flagged as both 'nullable' and 'must be unique':
11 instances of anomaly detectedColumn accepted_filetypes.filetype accepted_products.product acoustic_vr4pos.datetime acoustic_vr4pos.receiver argos_diag_with_lc_lat_lon.datetime argos_diag_with_lc_lat_lon.pttnumber download_urls.filetype download_urls.url download_urls.urlident serial_combo.species serial_combo.year -
Tables that contain a single column:
8 instances of anomaly detectedTable Column atn_eventids eventid canada fgadkey eventid_to_run eventid junk.deleteme a junk.td a junk.tdasss a special_argos_share_processing eventid tables_with_comments schema_qualified_name - Tables with incrementing column names, potentially indicating denormalization:
-
Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
Anomaly not detected