Table Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB.RECEIPT
Open Receipt Record Header

 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
RECEIPTITEM.RECEIPTID INTEG_1322 R
STATUSID integer 10
RECEIPTSTATUS.ID INTEG_1310 R
TYPEID integer 10 10
RECEIPTTYPE.ID INTEG_1312 R
ORDERTYPEID integer 10
ORDERTYPE.ID INTEG_1314 R
USERID integer 10 1
SYSUSER.ID INTEG_1316 R
ORDERID integer 10  √  null
LOCATIONGROUPID integer 10
LOCATIONGROUP.ID INTEG_1318 R

Analyzed at Sat Mar 01 08:31 PST 2014

Indexes:
Column(s) Type Sort Constraint Name
STATUSID Performance Asc RDB$FOREIGN637
TYPEID Performance Asc RDB$FOREIGN638
ORDERTYPEID Performance Asc RDB$FOREIGN639
USERID Performance Asc RDB$FOREIGN640
LOCATIONGROUPID Performance Asc RDB$FOREIGN641
ID Must be unique Asc RDB$PRIMARY636
LOCATIONGROUPID Performance Asc RECEIPTLOCATIONGROUPID
ORDERID Performance Asc RECEIPTORDERID
ORDERTYPEID Performance Asc RECEIPTORDERTYPEID_IDX
STATUSID Performance Asc RECEIPTSTATUSID_IDX
TYPEID Performance Asc RECEIPTTYPEID_IDX
USERID Performance Asc RECEIPTUSERID


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.