Table Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB.TRACKINGINFO
Part Tracking Information to Modules - Non Serialized

 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
TRACKINGINFOSN.TRACKINGINFOID INTEG_347 R
INFO varchar 41  √  null
INFODATE timestamp 19  √  null
TABLEID integer 10
RECORDID integer 10
INFODOUBLE double precision 15  √  0
INFOINTEGER integer 10  √  0
PARTTRACKINGID integer 10
PARTTRACKING.ID INTEG_531 R
QTY double precision 15  √  0

Analyzed at Sat Mar 01 08:31 PST 2014

Indexes:
Column(s) Type Sort Constraint Name
PARTTRACKINGID Performance Asc RDB$FOREIGN62
ID Must be unique Asc RDB$PRIMARY439
INFO Performance Asc TRACKINGINFOINFO
INFODATE Performance Asc TRACKINGINFOINFODATE
INFODOUBLE Performance Asc TRACKINGINFOINFODOUBLE
INFOINTEGER Performance Asc TRACKINGINFOINFOINTEGER
PARTTRACKINGID Performance Asc TRACKINGINFOPARTTRACKINGID
QTY Performance Asc TRACKINGINFOQTY
RECORDID Performance Asc TRACKINGINFORECORDID
TABLEID Performance Asc TRACKINGINFOTABLEID


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.