Treatment_Types

IDTypeName
1Massage Therapy
2Yoga Retreat

Spa

IDNameAddressPhoneNumberWebsite
(→ Treatment_Types.ID)
1Aromatherapy Heaven123 Main St555-1234http://www.aromatherapyheaven.com
2Relaxation Oasis456 Elm St555-5678http://www.relaxationoasis.com

Wellness_Retreat

IDNameAddressPhoneNumberWebsite
(→ Treatment_Types.ID)
1Zen Mountain789 Pine St555-9012http://www.zenmountain.com
2Eco Forest Getaway321 Oak St555-1357http://www.ecoforestgetaway.com

Clients

IDFirstNameLastNameEmailBirthDate
1JohnDoejohn.doe@example.com1985-05-15
2JaneSmithjane.smith@example.com1990-07-23

Bookings

IDClientIdServiceTypeDateBookedTimeSlotTotalCostPaymentMethodStatus
(→ Clients.ID)
11Massage2021-08-1014:00100Credit CardConfirmed
21Yoga2021-08-1210:0080PayPalPending

Reviews

IDClientIdServiceTypeRatingReviewTextSubmittedOn
(→ Clients.ID)
11Massage5Great service! Very relaxing.2021-08-11
21Yoga4Good experience but could have been better organized.2021-08-13