Use-case 0009 - Delete User

Initiating actor: Admin

Other actors: Pet Owner / Pet Sitter

Description: The Admin moderates the platform by reviewing the user behavior. If a user is problematic, the admin can completely remove them from the platform. Because the database uses CASCADE delete rules, deleting the user automatically cleans up their pets, bookings, 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 User" button next to a specific user they want to remove.
4. System executes the deletion, cascading to all related tables:

   DELETE FROM users 
   WHERE username = 'owner_marko';