SchemaSpy Analysis of ..\\db\\trunk\\zotero.sqlite.zotero - 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:
  Anomaly not detected

• Tables without indexes:

  Table	Rows
  creatorData	18
  creatorTypes	29
  customFields	0
  customItemTypes	0
  fieldFormats	3
  fields	104
  groupItems	0
  itemTypes	36
  libraries	0
  proxies	0
  transactionSets	0
  users	0
  zoteroDummyTable	1

  13 instances of anomaly detected

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

  Column
  baseFieldMappings.baseFieldID
  baseFieldMappings.fieldID
  baseFieldMappings.itemTypeID
  baseFieldMappingsCombined.baseFieldID
  baseFieldMappingsCombined.fieldID
  baseFieldMappingsCombined.itemTypeID
  charsets.charset
  collectionItems.collectionID
  collectionItems.itemID
  customBaseFieldMappings.baseFieldID
  customBaseFieldMappings.customFieldID
  customBaseFieldMappings.customItemTypeID
  fileTypeMimeTypes.fileTypeID
  fileTypeMimeTypes.mimeType
  fileTypes.fileType
  fulltextItemWords.itemID
  fulltextItemWords.wordID
  fulltextWords.word
  itemCreators.creatorID
  itemCreators.creatorTypeID
  itemCreators.itemID
  itemCreators.orderIndex
  itemData.fieldID
  itemData.itemID
  itemDataValues.value
  itemSeeAlso.itemID
  itemSeeAlso.linkedItemID
  itemTags.itemID
  itemTags.tagID
  itemTypeCreatorTypes.creatorTypeID
  itemTypeCreatorTypes.itemTypeID
  itemTypeFields.fieldID
  itemTypeFields.itemTypeID
  itemTypeFields.itemTypeID
  itemTypeFields.orderIndex
  savedSearchConditions.savedSearchID
  savedSearchConditions.searchConditionID
  settings.key
  settings.setting
  transactionLog.field
  transactionLog.transactionID
  transactionLog.value
  translatorCache.leafName
  version.schema

  44 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  zoteroDummyTable	id

  1 instance of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:
  Anomaly not detected

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