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.