SchemaSpy Analysis of testsql_comments - 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
  accountlines.issue_id	issues.issue_id
  additional_field_values.id	fieldmapping.id
  additional_fields.id	fieldmapping.id
  additional_fields.name	items_search_fields.name
  alert.borrowernumber	patronimage.borrowernumber
  aqbasketgroups.id	fieldmapping.id
  aqbooksellers.currency	currency.currency
  aqbooksellers.id	fieldmapping.id
  aqbudgets.budget_period_id	aqbudgetperiods.budget_period_id
  aqbudgets_planning.budget_period_id	aqbudgetperiods.budget_period_id
  aqcontacts.id	fieldmapping.id
  aqorders_items.itemnumber	hold_fill_targets.itemnumber
  article_requests.id	fieldmapping.id
  audio_alerts.id	fieldmapping.id
  auth_header.authtypecode	auth_types.authtypecode
  authorised_values.id	fieldmapping.id
  biblio.biblionumber	deletedbiblio.biblionumber
  biblio.frameworkcode	biblio_framework.frameworkcode
  biblioitems.biblioitemnumber	deletedbiblioitems.biblioitemnumber
  biblioitems.cn_source	class_sources.cn_source
  biblioitems.itemtype	itemtypes.itemtype
  borrower_files.file_id	misc_files.file_id
  borrower_modifications.borrowernumber	patronimage.borrowernumber
  borrower_modifications.branchcode	branches.branchcode
  borrower_modifications.categorycode	default_borrower_circ_rules.categorycode
  borrower_password_recovery.borrowernumber	patronimage.borrowernumber
  branch_transfer_limits.itemtype	itemtypes.itemtype
  branchcategories.categorycode	default_borrower_circ_rules.categorycode
  collections_tracking.colId	collections.colId
  collections_tracking.itemnumber	hold_fill_targets.itemnumber
  creator_templates.profile_id	printers_profile.profile_id
  creator_templates.template_id	marc_modification_templates.template_id
  deletedbiblio.frameworkcode	biblio_framework.frameworkcode
  deletedbiblioitems.biblionumber	deletedbiblio.biblionumber
  deletedbiblioitems.cn_source	class_sources.cn_source
  deletedbiblioitems.itemtype	itemtypes.itemtype
  deletedborrowers.borrowernumber	patronimage.borrowernumber
  deletedborrowers.branchcode	branches.branchcode
  deletedborrowers.categorycode	default_borrower_circ_rules.categorycode
  deleteditems.biblioitemnumber	deletedbiblioitems.biblioitemnumber
  deleteditems.biblionumber	deletedbiblio.biblionumber
  deleteditems.cn_source	class_sources.cn_source
  deleteditems.itemnumber	hold_fill_targets.itemnumber
  edifact_messages.id	fieldmapping.id
  housebound_visit.id	fieldmapping.id
  import_batches.branchcode	branches.branchcode
  import_batches.matcher_id	marc_matchers.matcher_id
  import_batches.template_id	marc_modification_templates.template_id
  import_biblios.isbn	social_data.isbn
  import_items.branchcode	branches.branchcode
  import_items.itemnumber	hold_fill_targets.itemnumber
  import_records.branchcode	branches.branchcode
  issues.branchcode	branches.branchcode
  issuingrules.branchcode	branches.branchcode
  issuingrules.categorycode	default_borrower_circ_rules.categorycode
  issuingrules.itemtype	itemtypes.itemtype
  item_circulation_alert_preferences.branchcode	branches.branchcode
  item_circulation_alert_preferences.categorycode	default_borrower_circ_rules.categorycode
  item_circulation_alert_preferences.id	fieldmapping.id
  items.cn_source	class_sources.cn_source
  items_last_borrower.id	fieldmapping.id
  language_descriptions.id	fieldmapping.id
  language_rfc4646_to_iso639.id	fieldmapping.id
  language_subtag_registry.id	fieldmapping.id
  letter.branchcode	branches.branchcode
  linktracker.biblionumber	deletedbiblio.biblionumber
  linktracker.borrowernumber	patronimage.borrowernumber
  linktracker.id	fieldmapping.id
  linktracker.itemnumber	hold_fill_targets.itemnumber
  marc_matchers.code	borrower_attribute_types.code
  marc_subfield_structure.frameworkcode	biblio_framework.frameworkcode
  marc_tag_structure.frameworkcode	biblio_framework.frameworkcode
  message_queue.message_id	messages.message_id
  messages.borrowernumber	patronimage.borrowernumber
  messages.branchcode	branches.branchcode
  need_merge_authorities.id	fieldmapping.id
  notifys.borrowernumber	patronimage.borrowernumber
  notifys.itemnumber	hold_fill_targets.itemnumber
  oai_sets.id	fieldmapping.id
  oai_sets_biblios.biblionumber	deletedbiblio.biblionumber
  old_issues.branchcode	branches.branchcode
  old_issues.issue_id	issues.issue_id
  old_reserves.branchcode	branches.branchcode
  old_reserves.reserve_id	reserves.reserve_id
  overduerules.branchcode	branches.branchcode
  overduerules.categorycode	default_borrower_circ_rules.categorycode
  overduerules_transport_types.id	fieldmapping.id
  patron_lists.name	items_search_fields.name
  pending_offline_operations.branchcode	branches.branchcode
  printers_profile.template_id	marc_modification_templates.template_id
  quotes.id	fieldmapping.id
  refund_lost_item_fee_rules.branchcode	branches.branchcode
  repeatable_holidays.branchcode	branches.branchcode
  repeatable_holidays.id	fieldmapping.id
  reports_dictionary.id	fieldmapping.id
  reports_dictionary.name	items_search_fields.name
  saved_reports.id	fieldmapping.id
  saved_sql.borrowernumber	patronimage.borrowernumber
  saved_sql.id	fieldmapping.id
  search_field.id	fieldmapping.id
  search_field.name	items_search_fields.name
  search_history.id	fieldmapping.id
  search_marc_map.id	fieldmapping.id
  sms_providers.id	fieldmapping.id
  sms_providers.name	items_search_fields.name
  special_holidays.branchcode	branches.branchcode
  special_holidays.id	fieldmapping.id
  statistics.borrowernumber	patronimage.borrowernumber
  statistics.itemnumber	hold_fill_targets.itemnumber
  statistics.itemtype	itemtypes.itemtype
  subscription.biblionumber	deletedbiblio.biblionumber
  subscription.branchcode	branches.branchcode
  subscription.itemtype	itemtypes.itemtype
  subscription.subscriptionid	subscriptionhistory.subscriptionid
  subscription_frequencies.id	fieldmapping.id
  subscription_numberpatterns.id	fieldmapping.id
  subscriptionhistory.biblionumber	deletedbiblio.biblionumber
  suggestions.biblionumber	deletedbiblio.biblionumber
  suggestions.branchcode	branches.branchcode
  suggestions.currency	currency.currency
  suggestions.isbn	social_data.isbn
  tags_all.term	tags_approval.term
  tmp_holdsqueue.biblionumber	deletedbiblio.biblionumber
  tmp_holdsqueue.borrowernumber	patronimage.borrowernumber
  tmp_holdsqueue.itemnumber	hold_fill_targets.itemnumber
  uploaded_files.id	fieldmapping.id
  vendor_edi_accounts.id	fieldmapping.id
  virtualshelfshares.id	fieldmapping.id
  z3950servers.id	fieldmapping.id
  zebraqueue.id	fieldmapping.id

  130 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  browser	0
  notifys	0
  tmp_holdsqueue	0

  3 instances of anomaly detected

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

  Column
  aqorders_transfers.ordernumber_from
  aqorders_transfers.ordernumber_to
  borrowers.cardnumber
  borrowers.userid
  issues.itemnumber
  items.barcode

  6 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  authorised_value_categories	category_name
  message_transport_types	message_transport_type

  2 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  aqbooksellers
  aqorders
  borrower_modifications
  borrowers
  branches
  deletedborrowers
  overduerules
  subscription
  subscription_numberpatterns

  9 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