SchemaSpy Analysis of schema_generation - Anomalies

Generated by SchemaSpy

Things that might not be 'quite right' about your schema:	Please support this project

• Columns whose name and type imply a relationship to another table's primary key:

  Child Column	Implied Parent Column
  affiliate_banners_history.affiliate_banners_id	affiliate_banners.affiliate_banners_id
  affiliate_sales.affiliate_payment_id	affiliate_payment.affiliate_payment_id
  article_reviews.customers_id	customers.customers_id
  article_reviews.reviews_id	reviews.reviews_id
  articles_xsell.ID	products_xsell.ID
  banners_history.banners_id	banners.banners_id
  coupon_email_track.unique_id	coupon_redeem_track.unique_id
  customers_basket_attributes.products_options_id	products_options.products_options_id
  customers_wishlist_attributes.products_options_id	products_options.products_options_id
  orders.customers_id	customers.customers_id
  orders_products.products_id	specials_retail_prices.products_id
  orders_products_attributes.products_options_id	products_options.products_options_id
  orders_session_info.affiliate_id	affiliate_affiliate.affiliate_id
  orders_status_history.orders_id	orders.orders_id
  pages_categories.categories_id	faq_categories.categories_id
  products_groups.customers_group_id	customers_groups.customers_group_id
  reviews.customers_id	customers.customers_id
  specials.customers_group_id	customers_groups.customers_group_id

  18 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  counter	0
  counter_history	0

  2 instances of anomaly detected

• Columns that are flagged as both 'nullable' and 'must be unique':
  Anomaly not detected

• Tables that contain a single column:
  Anomaly not detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  countries
  products
  products_groups

  3 instances of anomaly detected

• Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
  Anomaly not detected