## Bed_and_breakfast

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

## Rooms

room_type | price
--- | ---
Single Room | 100
Double Room | 150
Suite | 250
Deluxe Suite | 300
Family Room | 200

## Bed_and_breakfast_rooms

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

## Customers

customer_id | first_name | last_name | email | 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

## Bookings

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