Columns whose name and type imply a relationship to another table's primary key
Child Column | Implied Parent Column |
---|---|
Metric_Lookup.[PatientID] | DeIDLookup_Patients_DForger.[PatientID] |
JSONImport_Log.[JSONImport_Log_ID] | Application_log.[Log_ID] |
KHPatients.[PatientID] | DeIDLookup_Patients_DForger.[PatientID] |
ClincalGroups.[PatientID] | DeIDLookup_Patients_DForger.[PatientID] |
Tables without indexes
Tables that contain a single column
Table | Column | |
---|---|---|
Anomaly not detected |
Tables with incrementing column names, potentially indicating denormalization
Table | ||
---|---|---|
Anomaly not detected |
Columns whose default value is the word 'NULL' or 'null'
Table | ||
---|---|---|
Anomaly not detected |