## Services

ServiceID | Name | Description
--- | --- | ---
1 | Massage | Relax and rejuvenate with our professional massage services
2 | Facial | Revitalize your skin with our expertly performed facial treatments

## DaySpas

SpaID | ServiceID | Address
--- | --- | ---
| (→ Services.ServiceID) |
1 | 1 | 123 Main St, New York, NY 10001
2 | 2 | 456 Broadway, Los Angeles, CA 90012

## WellnessRetreats

RetreatID | ServiceID | Location
--- | --- | ---
| (→ Services.ServiceID) |
1 | 1 | 789 Ocean Blvd, Miami Beach, FL 33139
2 | 2 | 101 Mountain Rd, Asheville, NC 28801

## Prices

PriceID | PriceValue | ServiceID
--- | --- | ---
|  | (→ Services.ServiceID)
1 | 150 | 1
2 | 200 | 1
3 | 250 | 2
4 | 200 | 2

## Bookings

BookingID | CustomerName | CheckInDate | CheckOutDate | RoomNumber | TotalCost | ForeignKey
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ TableThatHasntBeenDefinedYet.PrimaryKeyOfTableThatHasntBeenDefinedYet)
1 | John Doe | 2021-10-01 | 2021-10-05 | 101 | 500.0 | 1
2 | Jane Smith | 2021-10-10 | 2021-10-14 | 102 | 600.0 | 2
3 | Alice Johnson | 2021-11-01 | 2021-11-05 | 103 | 550.0 | 3
4 | Bob Brown | 2021-11-10 | 2021-11-14 | 104 | 650.0 | 4

## Rooms

RoomID | RoomType | NumberOfGuests | Rate | Amenities
--- | --- | --- | --- | ---
101 | Deluxe King | 2 | 150 | WiFi, Mini fridge, Flat screen TV
102 | Standard Queen | 2 | 100 | WiFi, Coffee maker, Flat screen TV
103 | Suite | 4 | 200 | Separate living area, WiFi, Mini fridge, Flat screen TV
104 | Accessible King | 2 | 120 | Roll-in shower, Wider doorways, WiFi, Mini fridge, Flat screen TV