Bed_and_breakfast

idnameaddressrating
1The Cozy Inn123 Main St4.7
2Parkside Lodge456 Park Ave4.9
3Seaside Retreat789 Beach Blvd4.5
4Mountain Haven1011 Skyline Dr4.8
5Uptown Manor1314 City Center Dr4.6

Rooms

room_typeprice
Single Room100
Double Room150
Suite250
Deluxe Suite300
Family Room200

Bed_and_breakfast_rooms

bed_idroom_id
(→ Bed_and_breakfast.id)(→ Rooms.room_type)
1Single Room
2Double Room
3Suite
4Deluxe Suite
5Family Room
1Double Room
2Family Room
3Double Room
4Double Room
5Double Room

Customers

customer_idfirst_namelast_nameemailphone_number
1JohnDoejohn.doe@example.com555-1234
2JaneSmithjane.smith@example.com555-5678
3AliceWonderlandalice.wonderland@example.com555-9012
4CharlieBrowncharlie.brown@example.com555-0123
5DavidWhitedavid.white@example.com555-1357

Bookings

booking_idbed_idcustomer_idcheckincheckouttotal_price
(→ Bed_and_breakfast_rooms.bed_id)(→ Customers.customer_id)
1112022-01-012022-01-03250
2222022-01-042022-01-06350
3332022-01-072022-01-09300
4442022-01-102022-01-12400
5552022-01-132022-01-15350