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.

Sign up for GitHub

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

Jump to bottom

New database table for Reports #1804

Closed
1 task done
smcmurtry opened this issue Mar 17, 2025 · 6 comments
Closed
1 task done

New database table for Reports #1804

smcmurtry opened this issue Mar 17, 2025 · 6 comments
Assignees
@smcmurtry
Labels
Dev Task for implementation of a technical solution

Comments

@smcmurtry
Copy link
Collaborator

smcmurtry commented Mar 17, 2025 •
edited
Loading

Description

As a developer, I need to be able to get metadata for reports users have generated, so that I can display it on a page.

New table: reports
Columns:

  • id # uuid
  • url # link to s3
  • requested_at # datetime
  • generated_at # datetime
  • expires_at # datetime
  • service_id # uuid
  • user_id # uuid

Documentation and Artifacts

Figma design: https://www.figma.com/design/rzjRLTIzVjM4sHpzI6e0Xl/Reports-%2F-Rapports?node-id=1-2&p=f&t=oMq8JgRoJPodeiok-0

Acceptance Criteria

  • table exists in the db with the correct columns
@yaelberger-commits yaelberger-commits added the Dev Task for implementation of a technical solution label Mar 18, 2025
@yaelberger-commits
Copy link
Collaborator

Please add your planning poker estimate with Zenhub @smcmurtry

@YedidaZalik
Copy link

Steve made a bunch of cards for this new feature and will pick this one up

@smcmurtry
Copy link
Collaborator Author

PR up and ready for review: http://github.com/cds-snc/notification-api/pull/2481

@smcmurtry
Copy link
Collaborator Author

@whabanks reviewed and approved. This is now deployed in staging.

@smcmurtry
Copy link
Collaborator Author

smcmurtry commented Mar 25, 2025 •
edited
Loading

PR up to update our DB documentation site: https://github.com/cds-snc/notification-documentation-database/pull/7

@smcmurtry
Copy link
Collaborator Author

Documentation PR was approved by Jimmy and merged.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@smcmurtry smcmurtry

Labels
Dev Task for implementation of a technical solution
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@andrewleith @smcmurtry @YedidaZalik @yaelberger-commits