Ensure Correct Implementation of UUIDs and Soft Deletions in Queries

[coderabbitai]

This issue tracks the necessary enhancements to the and queries within the file. The task involves ensuring that UUIDs are correctly handled and soft deletions are properly implemented to maintain data integrity and support the system's functionality.

Relevant context can be found in PR #23 (#23) and the associated code review comments.

This task was identified during the review process of the mentioned PR, highlighting the importance of these enhancements for the subscription management system within the application.