Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDB.KITITEM
Items within Kits

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
KITOPTION.KITITEMID INTEG_1372 R
DESCRIPTION varchar 256  √  null
KITITEMTYPEID integer 10
KITITEMTYPE.ID INTEG_1356 R
KITPRODUCTID integer 10
PRODUCT.ID INTEG_1358 R
PRODUCTID integer 10  √  null
PRODUCT.ID INTEG_1359 R
DISCOUNTID integer 10  √  null
ITEMADJUST.ID INTEG_1360 R
TAXRATEID integer 10  √  null
TAXRATE.ID INTEG_1361 R
UOMID integer 10  √  null
UOM.ID INTEG_1365 R
SORTORDER integer 10  √  0
NOTE blob sub_type 1 0  √  null
SOITEMTYPEID integer 10  √  null
SOITEMTYPE.ID INTEG_1366 R
KITTYPEID integer 10
KITTYPE.ID INTEG_1368 R
DATECREATED timestamp 19  √  null
DATELASTMODIFIED timestamp 19  √  null
DEFAULTQTY double precision 15  √  0
MINQTY double precision 15  √  0
MAXQTY double precision 15  √  0
QTYPRICEADJUSTMENT double precision 15  √  0

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:
Column(s) Type Sort Constraint Name Anomalies
Performance IDX_22  
Must be unique RDB$271 These unique columns are also nullable
Performance RDB$FOREIGN24  
Performance RDB$FOREIGN25  
Performance RDB$FOREIGN272  
TAXRATEID Performance Asc RDB$FOREIGN29  
ID Must be unique Asc RDB$PRIMARY270  

Close relationships  within of separation: