Restaurants

IDNameAddressFood_ServiceCuisine
1Ristorante PizzeriaViale XX Settembre 27RestaurantItalian
2La Casa BiancaCorso Umberto I 80RestaurantMexican
3Le Café FrançaisPiazza Duomo 6CaféFrench
4Il Giardino RomanoLungotevere delle Armi 9CaféItalian
5The English Tea RoomKing Street 5CaféEnglish

Tables

IDNumberStatusRestaurantID
(→ Restaurants.ID)
14Available1
26Occupied2
38Available3
410Under Maintenance4
512Unavailable5

Reservations

IDDateTimeTableNumberGuestsTotalCostCustomerNameTableID
(→ Tables.ID)
12023-04-01 18:30:0019:00:0042120.0John Smith1
22023-04-02 19:00:0020:00:0064240.0Jane Doe2
32023-04-03 20:00:0021:00:0086300.0Alice Johnson3
42023-04-04 17:00:0018:00:0010390.0Bob Brown4
52023-04-05 19:00:0020:00:00128320.0Emma Wilson5

Orders

IDOrderDateItemQuantityPriceReservationID
(→ Reservations.ID)
12023-04-01 18:30:00Margherita Pizza210.01
22023-04-02 19:00:00Spaghetti Carbonara415.02
32023-04-03 20:00:00Chicken Caesar Salad612.03
42023-04-04 17:00:00Garlic Bread35.04
52023-04-05 19:00:00Tiramisu88.05