SchemaSpy Analysis of testdb.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:
Anomaly not detected -
Columns that are flagged as both 'nullable' and 'must be unique':
Column com_barcode.c_name com_location.c_aisle com_location.c_area com_location.c_erp_code com_location.c_plc_code com_location.c_x com_location.c_y com_location.c_z -
Tables that contain a single column:
Anomaly not detected -
Tables with incrementing column names, potentially indicating denormalization:
Anomaly not detected -
Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
Anomaly not detected