id | name | address | rating |
---|---|---|---|
1 | The Cozy Inn | 123 Main St | 4.7 |
2 | Parkside Lodge | 456 Park Ave | 4.9 |
3 | Seaside Retreat | 789 Beach Blvd | 4.5 |
4 | Mountain Haven | 1011 Skyline Dr | 4.8 |
5 | Uptown Manor | 1314 City Center Dr | 4.6 |
room_type | price |
---|---|
Single Room | 100 |
Double Room | 150 |
Suite | 250 |
Deluxe Suite | 300 |
Family Room | 200 |
bed_id | room_id |
---|---|
(→ Bed_and_breakfast.id) | (→ Rooms.room_type) |
1 | Single Room |
2 | Double Room |
3 | Suite |
4 | Deluxe Suite |
5 | Family Room |
1 | Double Room |
2 | Family Room |
3 | Double Room |
4 | Double Room |
5 | Double Room |
customer_id | first_name | last_name | phone_number | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | 555-1234 |
2 | Jane | Smith | jane.smith@example.com | 555-5678 |
3 | Alice | Wonderland | alice.wonderland@example.com | 555-9012 |
4 | Charlie | Brown | charlie.brown@example.com | 555-0123 |
5 | David | White | david.white@example.com | 555-1357 |
booking_id | bed_id | customer_id | checkin | checkout | total_price |
---|---|---|---|---|---|
(→ Bed_and_breakfast_rooms.bed_id) | (→ Customers.customer_id) | ||||
1 | 1 | 1 | 2022-01-01 | 2022-01-03 | 250 |
2 | 2 | 2 | 2022-01-04 | 2022-01-06 | 350 |
3 | 3 | 3 | 2022-01-07 | 2022-01-09 | 300 |
4 | 4 | 4 | 2022-01-10 | 2022-01-12 | 400 |
5 | 5 | 5 | 2022-01-13 | 2022-01-15 | 350 |