Columns whose name and type imply a relationship to another table's primary key
| Child Column | Implied Parent Column |
|---|---|
| lut_erosion_state.[state] | lut_state.[state] |
| site_location_visit.[pit_marker_datum] | lut_datum.[datum] |
| species_growth_forms.[growth_form] | lut_growth_form.[growth_form] |
Tables without indexes
| Table | Rows | |
|---|---|---|
| Anomaly not detected | ||
Tables that contain a single column
| Table | Column | |
|---|---|---|
| Anomaly not detected | ||
Tables with incrementing column names, potentially indicating denormalization
Columns whose default value is the word 'NULL' or 'null'
| Table | ||
|---|---|---|
| Anomaly not detected | ||