Columns whose name and type imply a relationship to another table's primary key
| Child Column | Implied Parent Column |
|---|---|
| qwb_ref.[line_id] | line.[line_id] |
| scribal_font.[font_file_id] | font_file.[font_file_id] |
Tables without indexes
| Table | Rows | |
|---|---|---|
| Anomaly not detected | ||
Tables that contain a single column
| Table | Column |
|---|---|
| artefact | |
| artefact_group | |
| line | |
| manuscript | |
| parallel_group | |
| sign | |
| text_fragment |
Tables with incrementing column names, potentially indicating denormalization
Columns whose default value is the word 'NULL' or 'null'
| Table |
|---|
| iaa_edition_catalog.edition_location_1 |
| iaa_edition_catalog.edition_location_2 |
| iaa_edition_catalog.edition_name |
| iaa_edition_catalog.edition_volume |
| iaa_edition_catalog.manuscript |
| image_catalog.catalog_number_1 |
| image_catalog.catalog_number_2 |
| image_catalog.institution |
| image_urls.proxy |
| image_urls.suffix |
| line_data.name |
| manuscript_data.name |
| single_action.table |
| SQE_image.filename |
| text_fragment_data.name |