Example tables
The examples are based on a database that contains order data. This sample database contains these tables:
- Orders
- OrderLines
This table shows the layout of the orders table:
| orderNumber | orderStatus | orderDateTime | customer | lastModification |
|---|---|---|---|---|
| 1 | Planned | 28 Mar, 2011 8:05:30 | Smith | 29 Mar, 2011 9:00:00 |
| 2 | Pending | 29 Mar, 2011 14:10:00 | Johnson | 30 Mar, 2011 16:00:00 |
This table shows the layout of the OrderLines table:
| orderNumber | lineNumber | item | quantity | price |
|---|---|---|---|---|
| 1 | 1 | Chair | 4 | 25.00 |
| 1 | 2 | Table | 1 | 225.00 |
| 2 | 1 | Laptop | 1 | 600.00 |