Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDB.KITOPTION
Kit Item Optional Groups

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
KITITEMID integer 10
KITITEM.ID INTEG_1372 R
PRODUCTID integer 10
PRODUCT.ID INTEG_1374 R
DEFAULTFLAG smallint 5  √  0
DATECREATED timestamp 19  √  null
DATELASTMODIFIED timestamp 19  √  null
PRICEADJUSTMENT double precision 15  √  0

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:
Column(s) Type Sort Constraint Name
KITITEMID Performance Asc KITOPTIONKITITEMID
PRODUCTID Performance Asc KITOPTIONPRODUCTID
KITITEMID Performance Asc RDB$FOREIGN673
PRODUCTID Performance Asc RDB$FOREIGN674
ID Must be unique Asc RDB$PRIMARY672

Close relationships  within of separation: