Need some advice on making an API with axum and SQLx

Hi,

I am currently working on a simple API that should implement user authentication and allow the user to send a JSON payload to be stored in postgres via sqlx.

Currently thinking of creating a table of the form

| id | username | hash password | payload |
|uuid | varchar | varchar | jsonb |

Is this appropriate? Any advice or ideas would be much appreciated.

Thanks

If you only need to store a single payload per user that's fine. If there may be multiple payloads for a single user you probably want to use another table

Thanks for the advice.