SchemaSpy Analysis of /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDBCommunity Generated by
SchemaSpy
Generated by SchemaSpy on Mon Jul 01 09:44 PDT 2013
Database Type: Firebird 2.5/LI - LI-V2.5.2.26508 SourceForge.net

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Comments
ACCOUNT 6 1 2 Maintains the account primary key.
ACCOUNTGROUP 1 2 Also known as Customer Group, this defines the groups available in the system.
ACCOUNTGROUPRELATION 2 3 Defines the Account(Customer & Vendor) to Group relationship. Allows for many groups to associate with one Account.
ACCOUNTTYPE 1 2 Unknown
ADDRESS 3 14 Maintains a list of pre-defined addresses for Accounts(Customer & Vendor).
ADDRESSMULTILINEPOVIEW 7
ADDRESSMULTILINESOVIEW 4
ADDRESSMULTILINEVIEW 13
ADDRESSMULTILINEXOVIEW 7
ADDRESSTYPE 1 2 Reference table for address types.
ASACCOUNT 11 1 9 Table of QuickBooks General Ledger Accounts
ASACCOUNTTYPE 1 2 Reference table for General Ledger Account types
ASSOCPRICE 2 4 Unknown
ASSOCPRICETYPE 1 1 5 Reference table for Associated Price Types
BOM 4 2 17 Bill of Material Header table
BOMAUTOCREATETYPE 1 2 Reference table for Bill of Material create types
BOMITEM 1 5 23 Bill of Material Detail table
BOMITEMGROUP 1 1 5 Bill of Material Optional Group detail
BOMITEMTOLOCATION 3 4 Bill of Material Default Pick Location for Parts
BOMITEMTYPE 2 2 Reference table for Bill of Material Item types
BOMTOLOCATION 3 4 Bill of Material to Location Mapping
CALCATEGORY 1 1 8 Calendar Category List
CALEVENT 2 11 Calendar Events
CARRIER 8 6 List of Shipment Carriers
COMPANY 2 12 Company Table
CONTACT 2 7 Contact Information Table
CONTACTTYPE 1 2 Reference of Contact Types
COSTLAYER 1 3 11 FIFO/LIFO Inventory Valuation
COSTLAYERSTATUS 1 2 Reference Table of Costlayer Status
COUNTRYCONST 1 4 Reference List of Countries
CURRENCY 1 1 9 Reference list of currencies
CUSTOMDECIMAL 1 4 Custom Field storage for Decimal Numbers
CUSTOMER 8 8 26 Customer Information Table
CUSTOMERCONTACTVIEW 4
CUSTOMERINCLTYPE 1 2 Reference list of Pricing Rule Customer Applies To names
CUSTOMERSTATUS 1 2 Reference list of Customer Statuses
CUSTOMFIELD 6 3 9 Maintains a list of Custom Fields and their Relationship to Modules
CUSTOMFIELDTYPE 1 1 4 Reference list of Custom Field types
CUSTOMFIELDVIEW 10
CUSTOMINTEGER 1 4 Custom Field Storage for Whole Numbers
CUSTOMLIST 1 3 Defines a Custom Field List
CUSTOMSET 1 4 Custom Field Storage for List Items
CUSTOMTIMESTAMP 1 4 Custom Field Storage For Date Custom Fields
CUSTOMVARCHAR 1 4 Custom Field Storage for Text Custom Fields
CUSTOMVARCHARLONG 1 4 Custom Field Storage for Long Text Custom Fields
DATABASEVERSION 4 Maintains a list of when a database is upgraded to
DCOPTIONS 1 3 Unknown
DEFAULTLOCATION 3 4 Maintains a relationship of Part & Location Group to a SpecifiC Location for Putaway and Receiving.
FBSCHEDULE 2 3 19 Defines the list of Scheduled Tasks.
FBSCHEDULEACTIONTYPE 1 2 Reference list of Scheduled Task Action Types
FBSCHEDULEHISTORY 1 4 Maintains a list of Scheduled Task Completion History.
FBSCHEDULEREPORTPARAMETER 1 4 Defines the optional parameters of Reports when scheduled through the Schedule Module
FEDEXVIEW 15
FOBPOINT 3 2 Free on Board (FOB) Point Reference List
INTEGRATEDAPP 1 7 Maintains a list of Integrated Apps
INTEGRATIONPROPERTIES 1 4 Unknown
INTEGRATIONTYPE 1 2 Unknown
INVENTORYLOG 1 6 18 Transactional List of Inventory Movement
INVENTORYLOGTOCOSTLAYER 2 4 Maps an Inventory Log Record to FIFO/LIFO Costlayer Record
INVENTORYLOGTYPE 1 3 Defines a the Inventory Log Types Allowable
INVLOGTRACKINGSUMMARY 2
ITEMADJUST 1 4 11 Item Adjust Information
ITEMADJUSTTYPE 1 2 Item Adjust Types
KITDISPLAYTYPE 1 2 Reference List of Kit Display Options
KITITEM 1 8 18 Items within Kits
KITITEMTYPE 1 2 Kit Item Types
KITOPTION 2 7 Kit Item Optional Groups
KITTYPE 1 2 Kit Types
LGSUMTYPE 1 2 Uknown
LOCATION 7 4 15 Inventory Location - aka Shelf/Bin/Aisle
LOCATIONGROUP 19 1 5 Inventory Location Group - Warehouse
LOCATIONTYPE 1 2 Location Types
MEMO 6 Memo Storage Table
MO 5 15 Manufacture Order
MODULE 1 1 4 Unknown
MOITEMSTATUS 2 Reference list of Manufacture Order Item Status
MOSTATUS 1 2 Manufacture Order Status
OBJECTTOOBJECT 3 7 Maps Records from One Table to Another
OBJECTTOOBJECTTYPE 1 3 Object To Object Type
ORDERHISTORY 2 8 Order History
ORDERTYPE 8 2 Order Type
PABASEAMOUNTTYPE 2 Pricing Rule Product Base Amount Type List
PACKAGETYPES 1 3 UPS Package Types?
PART 15 12 45 Part Records
PARTCATEGORY 3 Unknown
PARTCOST 1 7 Maintains the Part Average Cost and QTY
PARTREORDER 2 5 Maintains the Part Reorder Point and Order Up To Level
PARTTOTRACKING 2 4 Maps a part to its part tracking types
PARTTRACKING 8 1 7 Defines Part Tracking, Lot, ExpDate, Serial Number, Revision
PARTTRACKINGTYPE 1 2 Reference table for parttracking types, text, number, date, serial
PARTTRACKINGVIEW 10
PARTTYPE 2 2 Reference table for part types
PATYPE 2 Reference table for pricing rule types
PAYMENTMETHOD 1 1 5 Maintains a list of payment methods
PAYMENTTERMSTYPE 2 Reference table for payment term types
PAYMENTTYPE 1 2 Unknown
PICK 1 5 12 Pick Record Header
PICKITEM 6 15 Pick Item Detail
PICKITEMSTATUS 1 2 Reference table for pick item statuses
PICKITEMTYPE 1 2 Reference table for pick item types
PICKSTATUS 1 2 Reference table for pick item status
PICKTYPE 1 2 Reference table for pick types
PO 1 11 45 Purchase Order Header Table
POITEMSTATUS 2 X
POITEMTYPE 2 X
POST 4 17 X
POSTORDERSTATUS 4 2 X
POSTPO 1 2 11 X
POSTPOITEM 2 13 X
POSTRANSACTION 3 15 X
POSTSO 1 2 11 X
POSTSOITEM 2 12 X
POSTSTATUS 1 2 X
POSTTYPE 1 2 X
POSTWO 1 2 11 X
POSTWOITEM 2 9 X
POSTXO 1 2 11 X
POSTXOITEM 2 9 X
POTYPE 1 2 X
PRICINGRULE 3 32 X
PRIORITY 3 2 X
PRODUCT 9 9 34 X
PRODUCTINCLTYPE 1 2 X
PRODUCTTOTREE 3 X
PRODUCTTREE 4 X
PROPERTYCATEGORY 1 2 X
QBCLASS 7 8 X
QOHVIEW 6
QTYALLOCATED 3
QTYALLOCATEDMO 3
QTYALLOCATEDPO 3
QTYALLOCATEDSO 3
QTYALLOCATEDTORECEIVE 3
QTYALLOCATEDTOSEND 3
QTYCOMMITTED 3
QTYDROPSHIP 3
QTYINVENTORY 14
QTYINVENTORYTOTALS 8
QTYNOTAVAILABLE 3
QTYNOTAVAILABLETOPICK 3
QTYONHAND 3
QTYONORDER 3
QTYONORDERMO 3
QTYONORDERPO 3
QTYONORDERSO 3
QTYONORDERTORECEIVE 3
QTYONORDERTOSEND 3
QUICKLIST 1 1 3 X
QUICKLISTITEM 2 5 X
RECEIPT 1 5 7 X
RECEIPTITEM 9 29 X
RECEIPTITEMSTATUS 1 2 X
RECEIPTITEMTYPE 1 2 X
RECEIPTSTATUS 1 2 X
RECEIPTTYPE 1 2 X
REGISTER 2 X
REPORT 5 1 11 X
REPORTPARAMETER 1 4 X
REPORTSECURITY 2 4 X
REPORTTOMODULE 2 2 X
REPORTTREE 1 5 X
RESPONSIBILITY 2 X
RMA 1 4 9 X
RMAITEM 6 17 X
RMAITEMTYPE 1 3 X
RMASTATUS 1 2 X
RNDTYPE 2 X
SERIAL 1 1 3 X
SERIALNUM 2 4 X
SHIP 4 7 24 X
SHIPCARTON 2 5 22 X
SHIPCARTONPOVIEW 2
SHIPCARTONSOVIEW 2
SHIPCARTONXOVIEW 2
SHIPITEM 4 12 X
SHIPPINGIMPORT 7 X
SHIPSTATUS 1 2 X
SHIPTERMS 3 3 X
SHIPUPSCARTONDETAILS 2 12 X
SHIPUPSDETAILS 3 13 X
SO 4 12 48 X
SOITEM 2 7 30 X
SOITEMSTATUS 1 2 X
SOITEMTOMOITEM 1 3 X
SOITEMTYPE 3 2 X
SOSTATUS 1 2 X
SOTYPE 1 2 X
STATECONST 1 1 4 X
SYSPROPERTIES 7 X
SYSUSER 22 7 X
TABLEREFERENCE 5 4 X
TAG 5 5 15 X
TAGSERIALVIEW 12
TAGTRACKINGVIEW 10
TAGTYPE 1 2 X
TAXRATE 9 4 16 X
TAXRATETYPE 1 2 X
TIINVENTORYLOGSN 2 4 X
TRACKDATE 3
TRACKDECIMAL 3
TRACKINGDATE 2 4 X
TRACKINGINFO 1 1 9 X
TRACKINGINFOSN 2 4 X
TRACKINGINTEGER 2 4 X
TRACKINGTEXT 2 4 X
TRACKINTEGER 3
TRACKTEXT 3
UOM 17 1 9 X
UOMCONVERSION 2 6 X
UOMTYPE 1 2 X
UPSACCOUNT 3 X
UPSCOD 1 2 X
UPSRETURNSHIPMENT 1 3 X
UPSSERVICES 3 4 X
UPSVIEW 4
USERACCESS 1 5 X
USERGROUP 3 2 X
USERGROUPREL 2 3 X
USERLOG 1 4 X
USERPROPERTIES 2 8 X
USERTOLG 2 4 X
VENDORCONTACTVIEW 4
VENDORCOSTRULE 3 10 X
VENDORSTATUS 2 X
WATCH 5 13 X
WATCHTYPE 1 2 X
WO 3 8 22 X
WOASSIGNEDUSERS 2 3 X
WOITEM 2 5 12 X
WOMOVIEW 2
WOSTATUS 1 2 X
XO 2 7 33 X
XOITEM 1 5 17 X
XOITEMSTATUS 1 2 X
XOITEMTYPE 1 2 X
XOSTATUS 1 2 X
XOTYPE 1 2 X
         
196 Tables     1,401  
41 Views     201