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

Follow+Notes: Add grant followers table to database #3202

Closed
TylerHendrickson opened this issue Jun 21, 2024 · 1 comment
Closed

Follow+Notes: Add grant followers table to database #3202

TylerHendrickson opened this issue Jun 21, 2024 · 1 comment

Comments

@TylerHendrickson
Copy link
Member

Subtask of [STORY]: Update 'Status' to 'Follow + Note' feature #2960

Blocked by

N/A

Blocks

  • (Library)

Definition of Done

A new Knex migration is added that creates the table needed for storing followers of grants.

Implementation Details

This requires the following new tables to be created:

  • Table grant_followers
    • Columns:
      • id: serial, not null, primary key
      • grant_id: text, not null, foreign key to grants.grant_id
      • user_id: int, not null, foreign key to users.id
      • created_at: timestamp with time zone, not null, default now()
    • Unique index idx_grant_id_user_id on columns (grant_id, user_id)
@TylerHendrickson
Copy link
Member Author

This issue is small enough that it should be merged with #3203

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant