Integrate Prisma with Postgres in Backend

[valon-loshaj]

Set up Prisma as the ORM for database interaction and connect to a local Postgres instance.

Tasks:

1. Install Prisma and the Postgres client:

   npm install prisma @prisma/client
   npm install pg

2. Initialize Prisma in the backend/ folder:

   npx prisma init

3. Update the .env file to include the Postgres connection string:

   DATABASE_URL="postgresql://user:password@localhost:5432/sidequest"

4. Define the initial Prisma schema (prisma/schema.prisma) for users, quests, and characters.
   Example:

   model User {
     id        Int      @id @default(autoincrement())
     username  String   @unique
     password  String
     character Character
   }
   
   model Character {
     id         Int    @id @default(autoincrement())
     type       String
     level      Int
     experience Int
     userId     Int
     User       User    @relation(fields: [userId], references: [id])
   }

5. Run npx prisma migrate dev to create the initial migration and sync the schema with the Postgres database.
6. Verify Prisma is connected to the database by querying the users or characters table in the route /api/status.

[valon-loshaj]

Tasks:

1. Set up PostgreSQL database
2. Initialize Prisma in the project
3. Create initial schema.prisma file
4. Set up first migration
5. Create basic seed data script
6. Document database setup process