Table Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB.SHIPCARTON
Ship Cartons - Contains tracking number, weight, amount etc,.

 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
SHIPITEM.SHIPCARTONID INTEG_948 R
SHIPUPSCARTONDETAILS.SHIPCARTONID INTEG_920 R
SHIPID integer 10
SHIP.ID INTEG_517 R
ORDERID integer 10  √  0
CARRIERID integer 10
CARRIER.ID INTEG_519 R
CARTONTYPEID integer 10  √  0
TRACKINGNUM varchar 30  √  null
CARTONNUM integer 10
DATECREATED timestamp 19  √  null
ORDERTYPEID integer 10
ORDERTYPE.ID INTEG_522 R
SSCC varchar 20  √  null
FREIGHTWEIGHT double precision 15  √  0
FREIGHTAMOUNT double precision 15  √  0
WEIGHTUOM varchar 254  √  null
LEN double precision 15  √  0
HEIGHT double precision 15  √  0
WIDTH double precision 15  √  0
SIZEUOM varchar 30  √  null
INSUREDVALUE double precision 15  √  0
ADDITIONALHANDLING smallint 5  √  null
SHIPPERRELEASE smallint 5  √  null
DELIVERYCONFIRMATIONID integer 10 4
DCOPTIONS.ID INTEG_933 R
PACKAGETYPEID integer 10 2
PACKAGETYPES.ID INTEG_935 R

Analyzed at Sat Mar 01 08:31 PST 2014

Indexes:
Column(s) Type Sort Constraint Name Anomalies
SSCC Must be unique Asc RDB$533 This unique column is also nullable
SHIPID Performance Asc RDB$FOREIGN252  
CARRIERID Performance Asc RDB$FOREIGN253  
ORDERTYPEID Performance Asc RDB$FOREIGN254  
DELIVERYCONFIRMATIONID Performance Asc RDB$FOREIGN95  
PACKAGETYPEID Performance Asc RDB$FOREIGN96  
ID Must be unique Asc RDB$PRIMARY251  
CARRIERID Performance Asc SHIPCARTONCARRIERID  
ORDERTYPEID Performance Asc SHIPCARTONORDERTYPEID  
SHIPID Performance Asc SHIPCARTONSHIPID  


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.