Fields
Name |
Engine |
Collation |
Row Count |
Data Length |
Last Inserted Id |
Comment |
Average Row Length |
Row Format |
Created |
Updated |
Table Name |
Name |
Data Type |
Primary Key |
Unique |
Required |
Autoincrement |
Charset |
Collation |
Comment |
products
|
productCode
|
varchar(15)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
products
|
productName
|
varchar(70)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
products
|
productLine
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
products
|
productScale
|
varchar(10)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
products
|
productVendor
|
varchar(50)
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
products
|
productDescription
|
text
|
|
|
|
|
latin1
|
latin1_swedish_ci
|
|
products
|
quantityInStock
|
smallint(6)
|
|
|
|
|
NULL
|
NULL
|
|
products
|
buyPrice
|
double
|
|
|
|
|
NULL
|
NULL
|
|
products
|
MSRP
|
double
|
|
|
|
|
NULL
|
NULL
|
|