| 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 |