Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDB.SHIPITEM
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
SHIPID integer 10
SHIP.ID INTEG_526 R
ORDERTYPEID integer 10
ORDERTYPE.ID INTEG_528 R
ORDERID integer 10  √  0
ORDERITEMID integer 10  √  0
ITEMID integer 10  √  0
TAGID integer 10  √  0
UOMID integer 10
UOM.ID INTEG_530 R
SHIPCARTONID integer 10
SHIPCARTON.ID INTEG_948 R
DATELASTMODIFIED timestamp 19  √  NULL
QTYSHIPPED double precision 15  √  0
TOTALCOST double precision 15  √  0

Analyzed at Mon Jul 01 09:44 PDT 2013


Close relationships  within of separation: