Table Name | Name | Data Type | Primary Key | Unique | Required | Autoincrement | Charset | Collation | Comment |
products | productCode | varchar(15) | true | false | true | false | latin1 | latin1_swedish_ci | |
products | productName | varchar(70) | false | false | true | false | latin1 | latin1_swedish_ci | |
products | productLine | varchar(50) | false | false | true | false | latin1 | latin1_swedish_ci | |
products | productScale | varchar(10) | false | false | true | false | latin1 | latin1_swedish_ci | |
products | productVendor | varchar(50) | false | false | true | false | latin1 | latin1_swedish_ci | |
products | productDescription | text | false | false | true | false | latin1 | latin1_swedish_ci | |
products | quantityInStock | smallint(6) | false | false | true | false | | | |
products | buyPrice | double | false | false | true | false | | | |
products | MSRP | double | false | false | true | false | | | |