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	z3950servers.id
  additional_fields.id	z3950servers.id
  additional_fields.name	items_search_fields.name
  alert.borrowernumber	borrowers.borrowernumber
  aqbasketgroups.id	z3950servers.id
  aqbooksellers.currency	currency.currency
  aqbooksellers.id	z3950servers.id
  aqbudgets.budget_period_id	aqbudgetperiods.budget_period_id
  aqbudgets_planning.budget_period_id	aqbudgetperiods.budget_period_id
  aqcontacts.id	z3950servers.id
  aqorders_items.itemnumber	hold_fill_targets.itemnumber
  article_requests.id	z3950servers.id
  audio_alerts.id	z3950servers.id
  auth_header.authtypecode	auth_types.authtypecode
  authorised_values.id	z3950servers.id
  biblio.biblionumber	deletedbiblio.biblionumber
  biblio.frameworkcode	biblio_framework.frameworkcode
  biblio_metadata.id	z3950servers.id
  biblioitems.cn_source	class_sources.cn_source
  biblioitems.itemtype	itemtypes.itemtype
  borrower_attributes.id	z3950servers.id
  borrower_files.file_id	misc_files.file_id
  borrower_modifications.borrowernumber	borrowers.borrowernumber
  borrower_modifications.branchcode	refund_lost_item_fee_rules.branchcode
  borrower_modifications.categorycode	default_borrower_circ_rules.categorycode
  borrower_password_recovery.borrowernumber	borrowers.borrowernumber
  branch_transfer_limits.itemtype	itemtypes.itemtype
  branchcategories.categorycode	default_borrower_circ_rules.categorycode
  branches.branchcode	refund_lost_item_fee_rules.branchcode
  club_enrollment_fields.id	z3950servers.id
  club_enrollments.id	z3950servers.id
  club_fields.id	z3950servers.id
  club_template_enrollment_fields.id	z3950servers.id
  club_template_fields.id	z3950servers.id
  club_templates.id	z3950servers.id
  clubs.id	z3950servers.id
  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
  deletedbiblio_metadata.id	z3950servers.id
  deletedbiblioitems.biblioitemnumber	biblioitems.biblioitemnumber
  deletedbiblioitems.biblionumber	deletedbiblio.biblionumber
  deletedbiblioitems.cn_source	class_sources.cn_source
  deletedbiblioitems.itemtype	itemtypes.itemtype
  deletedborrowers.borrowernumber	borrowers.borrowernumber
  deletedborrowers.branchcode	refund_lost_item_fee_rules.branchcode
  deletedborrowers.categorycode	default_borrower_circ_rules.categorycode
  deleteditems.biblioitemnumber	biblioitems.biblioitemnumber
  deleteditems.biblionumber	deletedbiblio.biblionumber
  deleteditems.cn_source	class_sources.cn_source
  deleteditems.itemnumber	hold_fill_targets.itemnumber
  edifact_messages.id	z3950servers.id
  fieldmapping.id	z3950servers.id
  housebound_visit.id	z3950servers.id
  import_batches.branchcode	refund_lost_item_fee_rules.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	refund_lost_item_fee_rules.branchcode
  import_items.itemnumber	hold_fill_targets.itemnumber
  import_records.branchcode	refund_lost_item_fee_rules.branchcode
  issues.branchcode	refund_lost_item_fee_rules.branchcode
  issuingrules.branchcode	refund_lost_item_fee_rules.branchcode
  issuingrules.categorycode	default_borrower_circ_rules.categorycode
  issuingrules.itemtype	itemtypes.itemtype
  item_circulation_alert_preferences.branchcode	refund_lost_item_fee_rules.branchcode
  item_circulation_alert_preferences.categorycode	default_borrower_circ_rules.categorycode
  item_circulation_alert_preferences.id	z3950servers.id
  items.cn_source	class_sources.cn_source
  items_last_borrower.id	z3950servers.id
  language_descriptions.id	z3950servers.id
  language_rfc4646_to_iso639.id	z3950servers.id
  language_subtag_registry.id	z3950servers.id
  letter.branchcode	refund_lost_item_fee_rules.branchcode
  linktracker.biblionumber	deletedbiblio.biblionumber
  linktracker.borrowernumber	borrowers.borrowernumber
  linktracker.id	z3950servers.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_transports.branchcode	refund_lost_item_fee_rules.branchcode
  messages.borrowernumber	borrowers.borrowernumber
  messages.branchcode	refund_lost_item_fee_rules.branchcode
  messages.message_id	message_queue.message_id
  need_merge_authorities.id	z3950servers.id
  notifys.borrowernumber	borrowers.borrowernumber
  notifys.itemnumber	hold_fill_targets.itemnumber
  oai_sets.id	z3950servers.id
  oai_sets_biblios.biblionumber	deletedbiblio.biblionumber
  old_issues.branchcode	refund_lost_item_fee_rules.branchcode
  old_issues.issue_id	issues.issue_id
  old_reserves.branchcode	refund_lost_item_fee_rules.branchcode
  old_reserves.reserve_id	reserves.reserve_id
  overduerules.branchcode	refund_lost_item_fee_rules.branchcode
  overduerules.categorycode	default_borrower_circ_rules.categorycode
  overduerules_transport_types.id	z3950servers.id
  patron_lists.name	items_search_fields.name
  pending_offline_operations.branchcode	refund_lost_item_fee_rules.branchcode
  printers_profile.template_id	marc_modification_templates.template_id
  quotes.id	z3950servers.id
  repeatable_holidays.branchcode	refund_lost_item_fee_rules.branchcode
  repeatable_holidays.id	z3950servers.id
  reports_dictionary.id	z3950servers.id
  reports_dictionary.name	items_search_fields.name
  saved_reports.id	z3950servers.id
  saved_sql.borrowernumber	borrowers.borrowernumber
  saved_sql.id	z3950servers.id
  search_field.id	z3950servers.id
  search_field.name	items_search_fields.name
  search_history.id	z3950servers.id
  search_marc_map.id	z3950servers.id
  sms_providers.id	z3950servers.id
  sms_providers.name	items_search_fields.name
  special_holidays.branchcode	refund_lost_item_fee_rules.branchcode
  special_holidays.id	z3950servers.id
  statistics.borrowernumber	borrowers.borrowernumber
  statistics.itemnumber	hold_fill_targets.itemnumber
  statistics.itemtype	itemtypes.itemtype
  subscription.biblionumber	deletedbiblio.biblionumber
  subscription.branchcode	refund_lost_item_fee_rules.branchcode
  subscription.itemtype	itemtypes.itemtype
  subscription_frequencies.id	z3950servers.id
  subscription_numberpatterns.id	z3950servers.id
  subscriptionhistory.biblionumber	deletedbiblio.biblionumber
  subscriptionhistory.subscriptionid	subscription.subscriptionid
  suggestions.biblionumber	deletedbiblio.biblionumber
  suggestions.branchcode	refund_lost_item_fee_rules.branchcode
  suggestions.currency	currency.currency
  suggestions.isbn	social_data.isbn
  tags_all.term	tags_approval.term
  tmp_holdsqueue.biblionumber	deletedbiblio.biblionumber
  tmp_holdsqueue.borrowernumber	borrowers.borrowernumber
  tmp_holdsqueue.itemnumber	hold_fill_targets.itemnumber
  uploaded_files.id	z3950servers.id
  vendor_edi_accounts.id	z3950servers.id
  virtualshelfshares.id	z3950servers.id
  zebraqueue.id	z3950servers.id

  141 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