Use-case 0009 - Delete User

Initiating actor: Admin

Other actors: Pet Owner / Pet Sitter

Description: The Admin moderates the platform by reviewing user behavior. If a user is problematic, the admin can completely remove them. To satisfy database constraints, the system first clears their active bookings, then deletes the user (which cascades to delete their pets and reviews).

Scenario:

1. Admin opens the "Manage Users" dashboard.
2. System fetches a list of all registered users on the platform:

   SELECT user_id, username, first_name, last_name, email 
   FROM users 
   ORDER BY username ASC;
   

3. Admin clicks the "Delete" button next to a specific user.
4. System executes the deletion cleanly:

   DELETE FROM bookings WHERE owner_id = (SELECT user_id FROM users WHERE username = 'owner_marko');
   DELETE FROM users WHERE username = 'owner_marko';