Follow+Notes: Add grant notes tables to database

[TylerHendrickson]

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

Blocked by

N/A

Blocks

• 3201

Definition of Done

A new Knex migration is added that creates the tables needed for storing user-submitted notes about grants.

Implementation Details

This requires the following new tables to be created:

• Table grant_notes
  • 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)
• Table grant_notes_revisions
  • Columns:
  • id: serial, not null, primary key
  • grant_note_id: int, not null, foreign key to grant_notes.id
  • created_at: timestamp with time zone, not null, default now()
  • text: text, not null

[ClaireValdivia]

@thucdtran thanks for your work on this! my understanding is that there isn't anything to test on the front-end here for this change - does that sound right to you?

if so, ill plan to just do general testing in staging of core workflows before our next release