Table Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB.UOM
Unit of Measures

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
BOMITEM.UOMID INTEG_595 R
KITITEM.UOMID INTEG_1365 R
MOITEM.UOMID INTEG_686 R
PART.SIZEUOMID INTEG_832 R
PART.UOMID INTEG_302 R
PART.WEIGHTUOMID INTEG_307 R
PICKITEM.UOMID INTEG_985 R
POITEM.UOMID INTEG_484 R
PRODUCT.SIZEUOMID INTEG_833 R
PRODUCT.UOMID INTEG_836 R
PRODUCT.WEIGHTUOMID INTEG_834 R
RECEIPTITEM.UOMID INTEG_1330 R
RMAITEM.UOMID INTEG_1232 R
SHIPITEM.UOMID INTEG_530 R
SOITEM.UOMID INTEG_499 R
UOMCONVERSION.FROMUOMID INTEG_224 R
UOMCONVERSION.TOUOMID INTEG_222 R
VENDORPARTS.UOMID INTEG_416 R
WOITEM.UOMID INTEG_756 R
XOITEM.UOMID INTEG_1138 R
CODE varchar 10
NAME varchar 30
DESCRIPTION varchar 252
DEFAULTRECORD smallint 5  √  0
INTEGRAL smallint 5  √  0
READONLY smallint 5  √  0
UOMTYPE integer 10
UOMTYPE.ID INTEG_218 R
ACTIVEFLAG smallint 5 1

Analyzed at Sat Mar 01 08:31 PST 2014

Indexes:
Column(s) Type Sort Constraint Name
NAME Must be unique Asc RDB$100
CODE Must be unique Asc RDB$99
UOMTYPE Performance Asc RDB$FOREIGN101
ID Must be unique Asc RDB$PRIMARY98
CODE Performance Asc UOMCODE
NAME Performance Asc UOMNAME
UOMTYPE Performance Asc UOMUOMTYPE


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.