SchemaSpy Analysis of tariqapro - 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:
Child Column Implied Parent Column backup_queries.query_id weblogs.query_id channeltv_categories.category_id radio_categories.category_id flavours.flavour_id homepage_flavours.flavour_id queries_countries_tmp.flavour_id homepage_flavours.flavour_id queries_countries_tmp.query_id weblogs.query_id queries_tmp.flavour_id homepage_flavours.flavour_id queries_tmp.query_id weblogs.query_id queries_tmp.source_id sources.source_id rss_feeds_themes.theme_id themes.theme_id themes.query_id weblogs.query_id -
Tables without indexes:
Anomaly not detected -
Columns that are flagged as both 'nullable' and 'must be unique':
Anomaly not detected -
Tables that contain a single column:
Table Column __q_lexis_default_countryquery_upd UpdateQuery -
Tables with incrementing column names, potentially indicating denormalization:
Table v_countries -
Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
Anomaly not detected