Queue service to initial db

[dadiorchen]

As the first task, we use db-migrate to create the db schema and table for our queue in PostgreSQL.

We plan to use this lib to implement the queue: https://github.com/timgit/pg-boss?tab=readme-ov-file

So for this task, we need to create the db entities (schema, tables) to support the queue.

The final goal: write an e2e test which can do this:

1. Subscribe queue: test
2. Send a message to queue test
3. Received the message
4. Done

Can use our dev db for the test, please message me on slack to get the resources needed.

[GuningShen]

Hi @dadiorchen, can I work on this issue?

[cynthiabondi]

@dadiorchen Where are we on this?

[Sanketh345]

@dadiorchen, I'd like to work on this issue.