id | Name | Address | PhoneNumber | Treatment_Types |
---|---|---|---|---|
1 | Serenity Spa | 123 Main St | 555-1234 | Massage Therapy |
2 | Aromatherapy Haven | 456 Elm St | 555-5678 | Yoga Classes |
id | Name | Location | Accommodation | Treatment_Types |
---|---|---|---|---|
1 | Paradise Retreat | 789 Oak Ave | Private Cabins | Massage Therapy |
2 | Healing Escape | 101 Pine St | Shared Rooms | Meditation Workshops |
id | FirstName | LastName | Phone | |
---|---|---|---|---|
1 | John | Doe | john@example.com | 555-1234 |
2 | Jane | Smith | jane@example.com | 555-5678 |
id | ClientId | ServiceType | Date | Time |
---|---|---|---|---|
(→ Clients.id) | ||||
1 | 1 | Massage Therapy | 2022-01-01 10:00 | 1 hour |
2 | 2 | Yoga Classes | 2022-01-02 11:00 | 1.5 hours |
id | SpaOrRetreat | Description | Price | Duration |
---|---|---|---|---|
1 | Spa | Relaxing full body massage | 100 | 60 |
2 | Spa | Facial rejuvenation treatment | 120 | 45 |
3 | Wellness_Retreat | Guided meditation session | 80 | 60 |
4 | Wellness_Retreat | Nutrition consultation | 150 | 45 |
id | FullName | Role | Experience |
---|---|---|---|
1 | Alice Johnson | Masseuse | 5 |
2 | Bob Smith | Yoga Instructor | 3 |