SchemaSpy Analysis of Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB - AnomaliesCommunity Fishbowl Inventory Data Dictionary

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
  SHIPPINGIMPORT

  1 instance of anomaly detected

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

  Column
  COUNTRYCONST.NAME
  CURRENCY.NAME
  SHIP.BILLOFLADING
  SHIPCARTON.SSCC

  4 instances of anomaly detected

• Tables that contain a single column:
  Anomaly not detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  ADDRESSMULTILINEPOVIEW
  ADDRESSMULTILINESOVIEW
  ADDRESSMULTILINEVIEW
  ADDRESSMULTILINEXOVIEW
  OBJECTTOOBJECT
  USERPROPERTIES

  6 instances of anomaly detected

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

  Column
  ADDRESS.ADDRESS
  ADDRESS.CITY
  ADDRESS.LOCATIONGROUPID
  ADDRESS.PIPELINECONTACTNUM
  ADDRESS.ZIP
  ASACCOUNT.ACCOUNTINGHASH
  ASACCOUNT.ACCOUNTINGID
  ASACCOUNT.ACCOUNTNUMBER
  ASACCOUNT.DATECREATED
  ASACCOUNT.DATELASTMODIFIED
  BOM.DATECREATED
  BOM.DATELASTMODIFIED
  CALCATEGORY.DATECREATED
  CALCATEGORY.DATELASTMODIFIED
  CALEVENT.DATECREATED
  CALEVENT.DATELASTMODIFIED
  CARRIER.DESCRIPTION
  COMPANY.DATEENTERED
  COMPANY.DATELASTMODIFIED
  COMPANY.LASTCHANGEDUSER
  COMPANY.TAXEXEMPTNUMBER
  CONTACT.CONTACTNAME
  COSTLAYER.DATELASTMODIFIED
  COUNTRYCONST.ABBREVIATION
  CURRENCY.CODE
  CURRENCY.DATECREATED
  CURRENCY.DATELASTMODIFIED
  CURRENCY.NAME
  CURRENCY.SYMBOL
  CUSTOMER.ACCOUNTINGHASH
  CUSTOMER.ACCOUNTINGID
  CUSTOMER.DATECREATED
  CUSTOMER.DATELASTMODIFIED
  CUSTOMER.LASTCHANGEDUSER
  CUSTOMER.NOTE
  CUSTOMER.PARENTID
  CUSTOMER.PIPELINEACCOUNTNUM
  CUSTOMER.TAXEXEMPTNUMBER
  CUSTOMERPARTS.DATECREATED
  CUSTOMERPARTS.DATELASTMODIFIED
  CUSTOMERPARTS.DATELASTPURCHASED
  DATABASEVERSION.DATEUPDATED
  FBSCHEDULE.DATECREATED
  FBSCHEDULE.DATELASTMODIFIED
  FBSCHEDULE.DATENEXTSCHEDULED
  INTEGRATEDAPP.LASTACTIVITY
  INVENTORYLOG.DATECREATED
  INVENTORYLOG.INFO
  KITITEM.DATECREATED
  KITITEM.DATELASTMODIFIED
  KITOPTION.DATECREATED
  KITOPTION.DATELASTMODIFIED
  LOCATION.DATELASTMODIFIED
  LOCATION.DESCRIPTION
  LOCATIONGROUP.DATELASTMODIFIED
  MEMO.DATECREATED
  MO.DATECOMPLETED
  MO.DATECREATED
  MO.DATEISSUED
  MO.DATELASTMODIFIED
  MO.DATESCHEDULED
  MO.SOID
  MOITEM.DATESCHEDULED
  ORDERHISTORY.COMMENT
  ORDERHISTORY.DATECREATED
  ORDERHISTORY.RECORDID
  ORDERHISTORY.TABLEID
  PART.ACCOUNTINGHASH
  PART.ACCOUNTINGID
  PART.DATECREATED
  PART.DATELASTISSUED
  PART.DATELASTMODIFIED
  PART.DESCRIPTION
  PART.LASTCHANGEDUSER
  PART.REV
  PARTCOST.DATELASTMODIFIED
  PAYMENTTERMS.ACCOUNTINGHASH
  PAYMENTTERMS.ACCOUNTINGID
  PAYMENTTERMS.DATECREATED
  PAYMENTTERMS.DATELASTMODIFIED
  PICK.DATECREATED
  PICK.DATEFINISHED
  PICK.DATELASTMODIFIED
  PICK.DATESCHEDULED
  PICK.DATESTARTED
  PICKITEM.SRCTAGID
  PO.BUYER
  PO.CUSTOMERSO
  PO.DATECOMPLETED
  PO.DATECONFIRMED
  PO.DATECREATED
  PO.DATEFIRSTSHIP
  PO.DATEISSUED
  PO.DATELASTMODIFIED
  PO.DATEREVISION
  PO.DELIVERTO
  PO.REMITADDRESS
  PO.REMITCITY
  PO.REMITTONAME
  PO.REMITZIP
  PO.SHIPTOADDRESS
  PO.SHIPTOCITY
  PO.SHIPTONAME
  PO.SHIPTOZIP
  PO.USERNAME
  PO.VENDORCONTACT
  PO.VENDORSO
  POITEM.CUSTOMERID
  POITEM.DATELASTFULFILLMENT
  POITEM.DESCRIPTION
  POITEM.REVLEVEL
  POST.CUSTOMERID
  POST.DATEPOSTED
  POST.EDITSEQUENCE
  POST.SERIALNUM
  POST.TXNID
  POSTPO.DATELASTMODIFIED
  POSTPO.DATEPOSTED
  POSTPO.EXTREFNUMBER
  POSTPO.EXTTXNHASH
  POSTPO.EXTTXNID
  POSTPO.EXTTXNNUMBER
  POSTPO.POSTDATE
  POSTPOITEM.DATELASTMODIFIED
  POSTPOITEM.EXTREFNUMBER
  POSTPOITEM.EXTTXNHASH
  POSTPOITEM.EXTTXNID
  POSTPOITEM.EXTTXNLINEID
  POSTRANSACTION.CONFIRMATION
  POSTRANSACTION.DATETIME
  POSTRANSACTION.EXPDATE
  POSTRANSACTION.REFERENCE
  POSTSO.DATELASTMODIFIED
  POSTSO.DATEPOSTED
  POSTSO.EXTREFNUMBER
  POSTSO.EXTTXNHASH
  POSTSO.EXTTXNID
  POSTSO.EXTTXNNUMBER
  POSTSO.POSTDATE
  POSTSOITEM.DATELASTMODIFIED
  POSTSOITEM.EXTREFNUMBER
  POSTSOITEM.EXTTXNHASH
  POSTSOITEM.EXTTXNID
  POSTSOITEM.EXTTXNLINEID
  POSTWO.DATELASTMODIFIED
  POSTWO.DATEPOSTED
  POSTWO.EXTREFNUMBER
  POSTWO.EXTTXNHASH
  POSTWO.EXTTXNID
  POSTWO.EXTTXNNUMBER
  POSTWO.POSTDATE
  POSTWOITEM.DATELASTMODIFIED
  POSTWOITEM.EXTREFNUMBER
  POSTWOITEM.EXTTXNHASH
  POSTWOITEM.EXTTXNID
  POSTWOITEM.EXTTXNLINEID
  POSTXO.DATELASTMODIFIED
  POSTXO.DATEPOSTED
  POSTXO.EXTREFNUMBER
  POSTXO.EXTTXNHASH
  POSTXO.EXTTXNID
  POSTXO.EXTTXNNUMBER
  POSTXO.POSTDATE
  POSTXOITEM.DATELASTMODIFIED
  POSTXOITEM.EXTTXNLINEID
  PRICINGRULE.DATEBEGIN
  PRICINGRULE.DATEEND
  PRICINGRULE.DESCRIPTION
  PRODUCT.ACCOUNTINGHASH
  PRODUCT.ACCOUNTINGID
  PRODUCT.DATECREATED
  PRODUCT.DATELASTMODIFIED
  PRODUCT.DESCRIPTION
  PRODUCT.QBCLASSID
  PRODUCT.SKU
  PRODUCT.UPC
  QBCLASS.ACCOUNTINGHASH
  QBCLASS.ACCOUNTINGID
  QBCLASS.DATECREATED
  QBCLASS.DATELASTMODIFIED
  RECEIPTITEM.CUSTOMERID
  RECEIPTITEM.DATEBILLED
  RECEIPTITEM.DATELASTMODIFIED
  RECEIPTITEM.DATERECEIVED
  RECEIPTITEM.DATERECONCILED
  RECEIPTITEM.DELIVERTO
  RECEIPTITEM.REASON
  RECEIPTITEM.TRACKINGNUM
  REPORT.DATECREATED
  REPORT.DATELASTMODIFIED
  REPORT.USERID
  REPORTTREE.USERID
  RMA.DATECREATED
  RMA.DATEEXPIRES
  RMA.DATELASTMODIFIED
  RMAITEM.DATERESOLVED
  SHIP.DATECREATED
  SHIP.DATELASTMODIFIED
  SHIP.DATESHIPPED
  SHIP.INVOICENO
  SHIPCARTON.DATECREATED
  SHIPCARTON.TRACKINGNUM
  SHIPITEM.DATELASTMODIFIED
  SHIPPINGIMPORT.TRACKINGNUM
  SHIPUPSCARTONDETAILS.VERBALCONFIRMATIONNAME
  SHIPUPSCARTONDETAILS.VERBALCONFIRMATIONPHONE
  SHIPUPSDETAILS.ADDRESS
  SHIPUPSDETAILS.CITY
  SHIPUPSDETAILS.DELIVERYEMAILS
  SHIPUPSDETAILS.EXCEPTIONEMAILS
  SHIPUPSDETAILS.NOTIFICATIONEMAILS
  SHIPUPSDETAILS.ZIP
  SO.BILLTOADDRESS
  SO.BILLTOCITY
  SO.BILLTONAME
  SO.BILLTOZIP
  SO.CUSTOMERCONTACT
  SO.CUSTOMERPO
  SO.DATECOMPLETED
  SO.DATECREATED
  SO.DATEFIRSTSHIP
  SO.DATEISSUED
  SO.DATELASTMODIFIED
  SO.DATEREVISION
  SO.SALESMAN
  SO.SALESMANINITIALS
  SO.SHIPTOADDRESS
  SO.SHIPTOCITY
  SO.SHIPTONAME
  SO.SHIPTOZIP
  SO.USERNAME
  SO.VENDORPO
  SOITEM.CUSTOMERPARTNUM
  SOITEM.DATELASTFULFILLMENT
  SOITEM.DATELASTMODIFIED
  SOITEM.DESCRIPTION
  SOITEM.REVLEVEL
  STATECONST.NAME
  SYSPROPERTIES.DATELASTMODIFIED
  TAG.DATECREATED
  TAG.DATELASTCYCLECOUNT
  TAG.DATELASTMODIFIED
  TAG.WOITEMID
  TAXRATE.ACCOUNTINGHASH
  TAXRATE.ACCOUNTINGID
  TAXRATE.DATECREATED
  TAXRATE.DATELASTMODIFIED
  TIINVENTORYLOG.INFODATE
  TRACKINGINFO.INFODATE
  UPSRETURNSHIPMENT.SHIPMENTIDENTIFICATIONNUMBER
  VENDOR.ACCOUNTINGHASH
  VENDOR.ACCOUNTINGID
  VENDOR.DATEENTERED
  VENDOR.DATELASTMODIFIED
  VENDOR.LASTCHANGEDUSER
  VENDOR.NOTE
  VENDORCOSTRULE.DATECREATED
  VENDORCOSTRULE.DATELASTMODIFIED
  VENDORCOSTRULE.DESCRIPTION
  VENDORPARTS.DATECREATED
  VENDORPARTS.DATELASTMODIFIED
  VENDORPARTS.LASTDATE
  WATCH.ITEMDESC
  WATCH.STRID
  WO.CUSTOMERID
  WO.DATECREATED
  WO.DATEFINISHED
  WO.DATELASTMODIFIED
  WO.DATESCHEDULED
  WO.DATESTARTED
  XO.DATECOMPLETED
  XO.DATECONFIRMED
  XO.DATECREATED
  XO.DATEFIRSTSHIP
  XO.DATEISSUED
  XO.DATELASTMODIFIED
  XO.DATESCHEDULED
  XO.FROMADDRESS
  XO.FROMATTN
  XO.FROMCITY
  XO.FROMNAME
  XO.FROMZIP
  XO.SHIPTOADDRESS
  XO.SHIPTOATTN
  XO.SHIPTOCITY
  XO.SHIPTONAME
  XO.SHIPTOZIP
  XOITEM.DATELASTFULFILLMENT
  XOITEM.DESCRIPTION

  289 instances of anomaly detected