Table Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB.SHIPITEM
Ship Module Detail

 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 Sat Mar 01 08:31 PST 2014

Indexes:
Column(s) Type Sort Constraint Name
SHIPID Performance Asc RDB$FOREIGN256
ORDERTYPEID Performance Asc RDB$FOREIGN257
UOMID Performance Asc RDB$FOREIGN258
SHIPCARTONID Performance Asc RDB$FOREIGN467
ID Must be unique Asc RDB$PRIMARY255
ITEMID Performance Asc SHIPITEMITEMID
ORDERID Performance Asc SHIPITEMORDERID
ORDERITEMID Performance Asc SHIPITEMORDERITEMID
ORDERTYPEID Performance Asc SHIPITEMORDERTYPEID
SHIPCARTONID Performance Asc SHIPITEMSHIPCARTONID
SHIPID Performance Asc SHIPITEMSHIPID
UOMID Performance Asc SHIPITEMUOMID


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.