Order ID | Date | Location | Customer | Total | ||
---|---|---|---|---|---|---|
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.