Use-case 0008 - Set Offered Services

Initiating actor: Pet Sitter

Other actors: None

Description: A Pet Sitter updates their profile to specify what kind of work they are willing to do for pet owners (for example Dog Walking, Overnight Stays). The system links their profile to the list of services.

Scenario:

1. Pet Sitter opens their "Service Settings" page.
2. System fetches all available services:

   SELECT service_id, type, description FROM services ORDER BY type ASC;
   

3. Sitter checks the box for "Overnight Stay" and clicks Save.
4. System creates a link in the junction table connecting the sitter to the selected service:

   INSERT INTO sitter_services (sitter_id, service_id)
   VALUES (
       (SELECT user_id FROM users WHERE username = 'sitter_filip'),
       (SELECT service_id FROM services WHERE type = 'Overnight Stay')
   );