Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDB.TAG
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
SERIAL.TAGID INTEG_533 R
TRACKINGDATE.TAGID INTEG_342 R
TRACKINGINTEGER.TAGID INTEG_294 R
TRACKINGTEXT.TAGID INTEG_280 R
XO.MAINLOCATIONTAGID INTEG_1122 R
NUM integer 10
PARTID integer 10
PART.ID INTEG_338 R
LOCATIONID integer 10
LOCATION.ID INTEG_340 R
DATECREATED timestamp 19  √  null
DATELASTCYCLECOUNT timestamp 19  √  null
SERIALIZEDFLAG smallint 5  √  0
USEDFLAG smallint 5  √  0
TYPEID integer 10 30
TAGTYPE.ID INTEG_1053 R
DATELASTMODIFIED timestamp 19  √  null
ACCOUNTID integer 10 1
ACCOUNT.ID INTEG_404 R
QTY double precision 15  √  0
QTYCOMMITTED double precision 15  √  0
WOITEMID integer 10  √  null
WOITEM.ID INTEG_776 R
TRACKINGENCODING varchar 30 ''

Analyzed at Mon Jul 01 09:44 PDT 2013


Close relationships  within of separation: