SchemaSpy Analysis of dvnDb.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 lockssconfig.vdc_id oaiset.lockssconfig_id pagedef.name pagedef.path study.authority study.protocol study.studyid twittercredentials.vdc_id vdcactivity.vdc_id -
Tables that contain a single column:
Anomaly not detected -
Tables with incrementing column names, potentially indicating denormalization:
Table remoteaccessauth -
Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
Anomaly not detected