View Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB.FEDEXVIEW 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  √  null
ORDERNUM varchar 25  √  null
PONUM varchar 25  √  null
COMPANYNAME varchar 60  √  null
CONTACTNAME varchar 30  √  null
SHIPTOADDRESS varchar 90  √  null
SHIPTOCITY varchar 30  √  null
SHIPTOSTATE varchar 21  √  null
SHIPTOZIP varchar 10  √  null
SHIPTOCOUNTRY varchar 10  √  null
SERVICETYPE varchar 60  √  null
WEIGHT double precision 15  √  null
CARTONID integer 10  √  null
CARTONCOUNT integer 10  √  null
PHONE varchar 64  √  null

Analyzed at Sat Mar 01 08:31 PST 2014