Services

ServiceIDNameDescription
1MassageRelax and rejuvenate with our professional massage services
2FacialRevitalize your skin with our expertly performed facial treatments

DaySpas

SpaIDServiceIDAddress
(→ Services.ServiceID)
11123 Main St, New York, NY 10001
22456 Broadway, Los Angeles, CA 90012

WellnessRetreats

RetreatIDServiceIDLocation
(→ Services.ServiceID)
11789 Ocean Blvd, Miami Beach, FL 33139
22101 Mountain Rd, Asheville, NC 28801

Prices

PriceIDPriceValueServiceID
(→ Services.ServiceID)
11501
22001
32502
42002

Bookings

BookingIDCustomerNameCheckInDateCheckOutDateRoomNumberTotalCostForeignKey
(→ TableThatHasntBeenDefinedYet.PrimaryKeyOfTableThatHasntBeenDefinedYet)
1John Doe2021-10-012021-10-05101500.01
2Jane Smith2021-10-102021-10-14102600.02
3Alice Johnson2021-11-012021-11-05103550.03
4Bob Brown2021-11-102021-11-14104650.04

Rooms

RoomIDRoomTypeNumberOfGuestsRateAmenities
101Deluxe King2150WiFi, Mini fridge, Flat screen TV
102Standard Queen2100WiFi, Coffee maker, Flat screen TV
103Suite4200Separate living area, WiFi, Mini fridge, Flat screen TV
104Accessible King2120Roll-in shower, Wider doorways, WiFi, Mini fridge, Flat screen TV