| Order ID | Date | Location | Customer | Total | ||
|---|---|---|---|---|---|---|
| 1 | 2022-01-01 | San Diego Convoy | None | 6.50 | Edit | Delete |
| 2 | 2022-01-01 | San Diego Convoy | None | 3.00 | Edit | Delete |
| 3 | 2022-01-01 | Riverside | Tom Nook | 6.00 | Edit | Delete |
| 4 | 2022-01-01 | Long Beach | Filbert Blue | 0.00 | Edit | Delete |
| 5 | 2022-01-01 | Murrieta | None | 3.00 | Edit | Delete |
Notes:
Customers column is a NULLABLE FK.
Date initializes as the current date.
Total initializes as 0.00.
When an order is deleted, all associated rows in the Order Details table will also be deleted.