ID | TypeName |
---|---|
1 | Massage Therapy |
2 | Yoga Retreat |
ID | Name | Address | PhoneNumber | Website |
---|---|---|---|---|
(→ Treatment_Types.ID) | ||||
1 | Aromatherapy Heaven | 123 Main St | 555-1234 | http://www.aromatherapyheaven.com |
2 | Relaxation Oasis | 456 Elm St | 555-5678 | http://www.relaxationoasis.com |
ID | Name | Address | PhoneNumber | Website |
---|---|---|---|---|
(→ Treatment_Types.ID) | ||||
1 | Zen Mountain | 789 Pine St | 555-9012 | http://www.zenmountain.com |
2 | Eco Forest Getaway | 321 Oak St | 555-1357 | http://www.ecoforestgetaway.com |
ID | FirstName | LastName | BirthDate | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | 1985-05-15 |
2 | Jane | Smith | jane.smith@example.com | 1990-07-23 |
ID | ClientId | ServiceType | DateBooked | TimeSlot | TotalCost | PaymentMethod | Status |
---|---|---|---|---|---|---|---|
(→ Clients.ID) | |||||||
1 | 1 | Massage | 2021-08-10 | 14:00 | 100 | Credit Card | Confirmed |
2 | 1 | Yoga | 2021-08-12 | 10:00 | 80 | PayPal | Pending |
ID | ClientId | ServiceType | Rating | ReviewText | SubmittedOn |
---|---|---|---|---|---|
(→ Clients.ID) | |||||
1 | 1 | Massage | 5 | Great service! Very relaxing. | 2021-08-11 |
2 | 1 | Yoga | 4 | Good experience but could have been better organized. | 2021-08-13 |