Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDB.RECEIPT
X

 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 Mon Jul 01 09:44 PDT 2013

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

Close relationships  within of separation: