Id | Name | NumberOfGuests | Date | LocationId |
---|---|---|---|---|
(→ Locations.Id) | ||||
1 | Wedding Venue | 100 | 2023-01-15 | 1 |
2 | Wedding Venue | 50 | 2023-02-16 | 2 |
3 | Corporate Event Space | 200 | 2023-03-17 | 1 |
4 | Corporate Event Space | 150 | 2023-04-18 | 2 |
5 | Party | 75 | 2023-05-19 | 3 |
Id | Address | Type |
---|---|---|
1 | 1 High Street | Venue |
2 | 2 Low Street | Venue |
3 | 3 Middle Road | Venue |
4 | 4 East Avenue | Venue |
5 | 5 West Boulevard | Venue |
Id | FirstName | LastName | PhoneNumber | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | +1234567890 |
2 | Jane | Smith | jane.smith@example.com | +0987654321 |
3 | Alice | Brown | alice.brown@example.com | +1122334455 |
4 | Bob | White | bob.white@example.com | +2233445566 |
5 | Charlie | Black | charlie.black@example.com | +3344556677 |
Id | CustomerId | OccasionDate | SpecialOccasionId | TotalCost |
---|---|---|---|---|
(→ Customers.Id) | (→ SpecialOccasions.Id) | |||
1 | 1 | 2023-01-15 | 1 | 1500 |
2 | 2 | 2023-02-16 | 2 | 1200 |
3 | 3 | 2023-03-17 | 1 | 2500 |
4 | 4 | 2023-04-18 | 2 | 2000 |
5 | 5 | 2023-05-19 | 3 | 1800 |
Id | FirstName | LastName | Role | Salary |
---|---|---|---|---|
1 | Mike | Johnson | Chef | 45000 |
2 | Anna | Williams | Waitress | 30000 |
3 | Tom | Baker | Manager | 50000 |
4 | Emily | Jones | Hostess | 25000 |
5 | David | Martin | Busser | 20000 |
Id | MenuName | Price |
---|---|---|
1 | Appetizer Platter | 15.99 |
2 | Main Course - Steak | 25.99 |
3 | Side Dish - Garlic Mashed Potatoes | 5.99 |
4 | Dessert - Chocolate Cake | 7.99 |
5 | Drink - Wine | 10.99 |