Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Backend for user activeness #5523

Open
nabramow opened this issue Jan 22, 2025 · 0 comments
Open

Backend for user activeness #5523

nabramow opened this issue Jan 22, 2025 · 0 comments
Assignees
Labels
1.topic backend This issue relates to the python backend

Comments

@nabramow
Copy link
Member

nabramow commented Jan 22, 2025

We need a way to keep track of user activeness on the backend.

Acceptance Criteria

  • Create a new table activeness_probes
  • It should have a foreign key constraint that references the id column from the user table (i.e. the user_id)
  • It should have a column probe_initiated (timestamp) that's the time when the probe was started
  • It should have a column last_reminder_sent_at (timestamp), defaults to null
  • It should have a column reminders_sent (integer) defaults to 0, which counts number of emails sent
  • It should have a column response (enum) defaults to null

We keep track of user activeness in user_activity, so that's where we can get activeness info from.

@nabramow nabramow converted this from a draft issue Jan 22, 2025
@nabramow nabramow moved this to Needs details in Engineering Backlog ✏️ Jan 22, 2025
@nabramow nabramow added the 1.topic backend This issue relates to the python backend label Jan 22, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
1.topic backend This issue relates to the python backend
Projects
Status: Needs details
Development

No branches or pull requests

2 participants