Table NameNameData TypePrimary KeyUniqueRequiredAutoincrementCharsetCollationComment
productsproductCodevarchar(15)truefalsetruefalselatin1latin1_swedish_ci
productsproductNamevarchar(70)falsefalsetruefalselatin1latin1_swedish_ci
productsproductLinevarchar(50)falsefalsetruefalselatin1latin1_swedish_ci
productsproductScalevarchar(10)falsefalsetruefalselatin1latin1_swedish_ci
productsproductVendorvarchar(50)falsefalsetruefalselatin1latin1_swedish_ci
productsproductDescriptiontextfalsefalsetruefalselatin1latin1_swedish_ci
productsquantityInStocksmallint(6)falsefalsetruefalse
productsbuyPricedoublefalsefalsetruefalse
productsMSRPdoublefalsefalsetruefalse