Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDB.UOM
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
BOMITEM.UOMID INTEG_595 R
KITITEM.UOMID INTEG_1365 R
PART.SIZEUOMID INTEG_832 R
PART.UOMID INTEG_302 R
PART.WEIGHTUOMID INTEG_307 R
PICKITEM.UOMID INTEG_985 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
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 Mon Jul 01 09:44 PDT 2013

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

Close relationships  within of separation: