Table Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB.POST
Maintains a list of miscalleneous QuickBooks posting records

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ID integer 10
STATUSID integer 10
POSTSTATUS.ID INTEG_705 R
ORDERTYPEID integer 10
ORDERTYPE.ID INTEG_707 R
ORDERID integer 10  √  0
TYPEID integer 10
POSTTYPE.ID INTEG_709 R
REFID integer 10  √  0
REFITEMID integer 10  √  0
DATECREATED timestamp 19  √  'NOW'
DATEPOSTED timestamp 19  √  null
SERIALNUM varchar 30  √  null
TXNID varchar 36  √  null
EDITSEQUENCE varchar 16  √  null
REFNUMBER varchar 20  √  null
TXNLINEID varchar 36  √  null
QUANTITY double precision 15  √  0
AMOUNT double precision 15  √  0
CUSTOMERID integer 10  √  null
CUSTOMER.ID INTEG_781 R

Analyzed at Sat Mar 01 08:31 PST 2014

Indexes:
Column(s) Type Sort Constraint Name
CUSTOMERID Performance Asc POSTCUSTOMERID
DATECREATED Performance Asc POSTDATECREATED
DATEPOSTED Performance Asc POSTDATEPOSTED
ORDERID Performance Asc POSTORDERID
ORDERTYPEID Performance Asc POSTORDERTYPEID
STATUSID Performance Asc POSTSTATUSID
TYPEID Performance Asc POSTTYPEID
CUSTOMERID Performance Asc RDB$FOREIGN177
STATUSID Performance Asc RDB$FOREIGN349
ORDERTYPEID Performance Asc RDB$FOREIGN350
TYPEID Performance Asc RDB$FOREIGN351
ID Must be unique Asc RDB$PRIMARY348


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.