Spa

idNameAddressPhoneNumberTreatment_Types
1Serenity Spa123 Main St555-1234Massage Therapy
2Aromatherapy Haven456 Elm St555-5678Yoga Classes

Wellness_Retreat

idNameLocationAccommodationTreatment_Types
1Paradise Retreat789 Oak AvePrivate CabinsMassage Therapy
2Healing Escape101 Pine StShared RoomsMeditation Workshops

Clients

idFirstNameLastNameEmailPhone
1JohnDoejohn@example.com555-1234
2JaneSmithjane@example.com555-5678

Bookings

idClientIdServiceTypeDateTime
(→ Clients.id)
11Massage Therapy2022-01-01 10:001 hour
22Yoga Classes2022-01-02 11:001.5 hours

Services

idSpaOrRetreatDescriptionPriceDuration
1SpaRelaxing full body massage10060
2SpaFacial rejuvenation treatment12045
3Wellness_RetreatGuided meditation session8060
4Wellness_RetreatNutrition consultation15045

Staff

idFullNameRoleExperience
1Alice JohnsonMasseuse5
2Bob SmithYoga Instructor3