Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDB.SOITEM
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
POSTSOITEM.SOITEMID INTEG_1253 R
SOITEMTOMOITEM.SOITEMID INTEG_693 R
PRODUCTID integer 10  √  null
PRODUCT.ID INTEG_492 R
SOID integer 10
SO.ID INTEG_494 R
TYPEID integer 10
SOITEMTYPE.ID INTEG_496 R
STATUSID integer 10
SOITEMSTATUS.ID INTEG_498 R
UOMID integer 10  √  null
UOM.ID INTEG_499 R
SOLINEITEM integer 10
DESCRIPTION varchar 252  √  null
PRODUCTNUM varchar 70
CUSTOMERPARTNUM varchar 70  √  null
TAXABLEFLAG smallint 5  √  0
DATELASTFULFILLMENT timestamp 19  √  null
DATESCHEDULEDFULFILLMENT timestamp 19 'NOW'
REVLEVEL varchar 15  √  null
EXCHANGESOLINEITEM integer 10  √  0
QBCLASSID integer 10  √  1
QBCLASS.ID INTEG_503 R
NOTE blob sub_type 1 0  √  null
SHOWITEMFLAG smallint 5 1
QTYTOFULFILL double precision 15  √  0
QTYFULFILLED double precision 15  √  0
QTYPICKED double precision 15  √  0
ITEMADJUSTID integer 10  √  null
ADJUSTPERCENTAGE double precision 15  √  0
UNITPRICE double precision 15  √  0
TOTALPRICE double precision 15  √  0
ADJUSTAMOUNT double precision 15  √  0
TOTALCOST double precision 15  √  0
DATELASTMODIFIED timestamp 19  √  NULL
TAXID integer 10  √  null
TAXRATE.ID INTEG_263 R
TAXRATE double precision 15  √  null

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:
Column(s) Type Sort Constraint Name Anomalies
Must be unique INTEG_463 These unique columns are also nullable
Performance RDB$FOREIGN107  
Performance RDB$FOREIGN193  
Performance RDB$FOREIGN195  
STATUSID Performance Asc RDB$FOREIGN219  
Performance RDB$FOREIGN220  
Performance RDB$FOREIGN221  
TYPEID Performance Asc RDB$FOREIGN222  
Performance RDB$FOREIGN223  
Performance RDB$FOREIGN225  
QBCLASSID Performance Asc RDB$FOREIGN226  
Performance RDB$FOREIGN227  
Performance RDB$FOREIGN57  
ID Must be unique Asc RDB$PRIMARY218  
Performance SOCARRIERID  
Performance SOCUSTOMERID  
Performance SOCUSTOMERPO  
Performance SODATECOMPLETED  
Performance SODATECREATED  
Performance SODATEFIRSTSHIP  
Performance SODATEISSUED  
Performance SODATEREVISION  
Performance SOFOBPOINTID  
Performance SOLOCATIONGROUPID  
Performance SONUM  
Performance SOPAYMENTTERMSID  
QBCLASSID Performance Asc SOQBCLASSID  
Performance SOSALESMAN  
Performance SOSHIPTERMSID  
STATUSID Performance Asc SOSTATUSID  
Performance SOTAXRATEID  
Performance SOUSERNAME  
Performance SOVENDORPO  

Close relationships  within of separation: