| 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 |
| orders | orderNumber | int(11) | NULL | NULL | |||||
| orders | orderDate | date | NULL | NULL | |||||
| orders | requiredDate | date | NULL | NULL | |||||
| orders | shippedDate | date | NULL | NULL | |||||
| orders | status | varchar(15) | latin1 | latin1_swedish_ci | |||||
| orders | comments | text | latin1 | latin1_swedish_ci | |||||
| orders | customerNumber | int(11) | NULL | NULL |