I have a users table in my Postgres database with a role column that uses an enum. The user can either be a CAPTAIN or PLAYER. DROP TYPE IF EXISTS USER_ROLE CASCADE; CREATE TYPE USER_ROLE AS ENUM ('CAPTAIN', 'PLAYER'); CREATE…
Here is the code: // the JSON of req.body { "title": "title", "reference": "1213", "noteType": "type_1", "tags": [3, 4], // Will be variable length. "text": "Lorem ipsum dolor sit amet." } // Create the row and get the id const…
I have a Mysql junction table user_connections which maps the users table with the following columns: user_from and user_to, both are foreign keys in users table. user_from and user_to are both primary keys therfore a parttern like (1,2) and (1,2)…