Add Soft Delete or Archive for User Data

[Baskarayelu]

Description:

Support soft-delete or archive for user records and preferences so accounts can be “deactivated” without losing data for compliance or recovery.

Requirements

• Add deletedAt: Date | null (or archivedAt) to users table; add index for active users (where deletedAt is null)
• All user queries (profile, preferences) filter by deletedAt is null unless admin
• POST /api/user/deactivate (protected): set deletedAt for current user; optionally anonymize or retain for N days per policy
• No hard delete of user row by default; document retention and purge policy
• GET /api/user/profile returns 404 or 410 after deactivation

Acceptance Criteria

• Soft-delete/archive field and queries implemented
• Deactivate endpoint and auth in place
• Retention and purge policy documented

[drips-wave]

This issue has been added to the Stellar Wave Program and is worth 200 Points.

🧑‍💻 Interested in contributing? Apply to work on this issue on Drips Wave, earn points, and receive rewards.

Warning

Only applications submitted via the apply link above will be considered. Please do not apply by commenting on the issue or opening a PR directly.

🤠 Repo maintainers: You can manage this issue's Points and Complexity on your Maintainer Dashboard here. Please keep an eye on applications and respond quickly 💙

ℹ️ Learn more about Drips Wave

[OluRemiFour]

@OluRemiFour has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

I've gone through the request thoroughly, i will add a soft delet or achive for user data based on your request to match the Acceptance Criteria. Kindly assign this task to me

ℹ️ Repo Maintainers: To accept this application, review their application or assign @OluRemiFour to this issue.

[edehvictor]

@edehvictor has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

Please can I work on this

ℹ️ Repo Maintainers: To accept this application, review their application or assign @edehvictor to this issue.

[Benalex8797]

@Benalex8797 has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

hi, i will love to work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Benalex8797 to this issue.

[caxtonacollins]

@caxtonacollins has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

Hi 👋 am a full-stack developer
I will love to work on this issue please assign

ℹ️ Repo Maintainers: To accept this application, review their application or assign @caxtonacollins to this issue.

[devfoma]

@devfoma has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

I'm a frontend developer with ove four years experience, I would love to take on this issue, I'm confident I can implement this feature

ℹ️ Repo Maintainers: To accept this application, review their application or assign @devfoma to this issue.

[Georgebingi]

@Georgebingi has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

Hi my name is George and I'm a full stack develop I'll like to work on this issue because It picks my interest and Ive got experience with similar projects I'll have it solved in 24 hours or less

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Georgebingi to this issue.

[1sraeliteX]

@1sraeliteX has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

I would like to work on this issue because soft-delete/archiving is critical for compliance while preserving data for recovery and audits. I can add the deletedAt field with proper indexing, update all user queries to respect active status, implement the deactivate endpoint with auth, and document retention/purge policy, with correct 404/410 behavior after deactivation.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @1sraeliteX to this issue.

[SamixYasuke]

@SamixYasuke has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

Hello maintainer, I fully understand the requirements and I'd like to work on it. Thanks

ℹ️ Repo Maintainers: To accept this application, review their application or assign @SamixYasuke to this issue.

[Miracle656]

@Miracle656 has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

Hey team 👋

I'd like to work on this!

My plan:

• Add deletedAt: DateTime? to User model with an index for active-user queries
• Reusable activeUser query helper filtering deletedAt: null — used across all profile/preferences queries
• POST /api/user/deactivate — auth-protected, sets deletedAt, optionally anonymizes PII
• GET /api/user/profile returns 410 Gone after deactivation
• No hard delete by default; README documents retention window and purge policy

Quick questions:

• Retention window before purge eligibility?
• PII anonymized on deactivation or at purge time?
• Admin bypass flag already in schema?

Estimated delivery: 3–4 days from assignment. Please assign it to me 🙌

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Miracle656 to this issue.

[JafetCHVDev]

Hello Team,

My Background
My name is Cristian, and I’m a passionate full-stack developer from Costa Rica 🇨🇷💻. I’m excited about the opportunity to contribute to your Stellar-based project during GrantFox!
I enjoy building web applications that combine clean user interfaces with solid back-end logic and reliable databases.

Experience
I have experience developing web applications using technologies such as React, .NET Core, SQL Server, and Firebase. I’ve worked on projects that include role-based systems, CRUD platforms, booking systems, and data-driven web apps.
While I’m still growing in Web3 and blockchain, I’m highly motivated to learn and apply these technologies, especially within the Stellar ecosystem.

I’m driven by the opportunity to improve my skills, collaborate with a talented team, and make a meaningful contribution to your project.

Links
You can find my profiles and links here:

GitHub: https://github.com/JafetCHVDev

Thank you for considering my candidacy. I am excited about the opportunity to contribute to this project and create a positive impact. Please let me know if you have any questions or need additional information.

[drips-wave]

Congratulations, @caxtonacollins! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on February 26, 2026.

🧑‍💻 @caxtonacollins: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are issued when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊