Columns whose name and type imply a relationship to another table's primary key
| Child Column | Implied Parent Column |
|---|---|
| tbl_contacts.[location_id] | tbl_locations.[location_id] |
| tbl_site_preservation_status.[assessment_author_contact_id] | tbl_contacts.[contact_id] |
Tables without indexes
| Table | Rows |
|---|---|
| dyntaxa_taxonomyc_order_system_temp | 4090 |
Tables that contain a single column
| Table | Column | |
|---|---|---|
| Anomaly not detected | ||
Tables with incrementing column names, potentially indicating denormalization
| Table |
|---|
| tbl_contacts |
Columns whose default value is the word 'NULL' or 'null'
| Table | ||
|---|---|---|
| Anomaly not detected | ||