| service_id |
service_name |
category |
subcategory |
description |
price_currency |
price_amount |
duration_minutes |
is_active |
requires_consultation |
preparation_notes |
aftercare_notes |
booking_buffer_minutes |
tax_included |
created_at |
updated_at |
| S001 |
Gold Lifting Facial |
Facial |
Anti-Aging |
Luxury anti-aging facial using gold-infused products for skin lifting and glow |
CHF |
220 |
75 |
TRUE |
FALSE |
Arrive with clean skin, no makeup |
Avoid sun exposure for 24 hours |
15 |
TRUE |
2025-01-01 |
2025-01-01 |
| S002 |
Classic Haircut |
Hair |
Styling |
Precision haircut with wash and professional styling |
CHF |
90 |
45 |
TRUE |
FALSE |
No special preparation |
Avoid washing hair for 12 hours |
10 |
TRUE |
2025-01-01 |
2025-01-01 |
| S003 |
Luxury Lash Extension |
Lashes |
Volume |
Customized premium volume lash extension |
CHF |
180 |
90 |
TRUE |
TRUE |
Remove eye makeup before visit |
Avoid water contact for 24 hours |
20 |
TRUE |
2025-01-01 |
2025-01-01 |
| S004 |
Hydrating Skin Therapy |
Facial |
Hydration |
Deep hydration therapy for dry and sensitive skin |
CHF |
160 |
60 |
TRUE |
FALSE |
Avoid exfoliation 48 hours before |
Use SPF regularly after treatment |
15 |
TRUE |
2025-01-01 |
2025-01-01 |
| S005 |
Brow Shaping & Tint Brows Shaping |
Brow |
brow definition |
Brows Shaping + Tint Natural brow definition through gentle shaping and custom-blended tint |
CHF |
150 |
50 |
TRUE |
FALSE |
Avoid retinol or exfoliants 48 hours before treatment |
Keep brows dry for 12–24 hours, avoid heat and oils |
10 |
TRUE |
2025-01-02 |
2025-01-02 |
| S006 |
Classic Manicure |
Nails |
nail grooming |
A refined nail grooming service with shaping, cuticle care, and classic polish |
CHF |
200 |
80 |
TRUE |
FALSE |
Avoid heavy lotions before treatment to ensure polish adhesion |
Apply cuticle oil regularly, avoid using nails as tools |
20 |
TRUE |
2025-01-03 |
2025-01-03 |