Table Name | Name | Data Type | Primary Key | Unique | Required | Autoincrement | Charset | Collation | Comment |
orderdetails | orderNumber | int(11) | |||||||
orderdetails | productCode | varchar(15) | latin1 | latin1_swedish_ci | |||||
orderdetails | quantityOrdered | int(11) | |||||||
orderdetails | priceEach | double | |||||||
orderdetails | orderLineNumber | smallint(6) |