schema.prisma

datasource db {
  provider = "mongodb"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

model User {
  id       String    @id @default(auto()) @map("_id") @db.ObjectId
  email    String    @unique
  password String
  urls     Url[]     @relation("UserUrls")
  sessions Session[]
}

model Session {
  id String @id @default(auto()) @map("_id") @db.ObjectId
  user User @relation(fields: [userId], references: [id])
  sessionToken String   @unique
  userId String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model Url {
  id        String    @id @default(auto()) @map("_id") @db.ObjectId
  longUrl   String
  shortUrl  String
  deleted   Boolean   @default(false)
  createdAt DateTime  @default(now())
  updatedAt DateTime  @updatedAt
  user      User?      @relation("UserUrls", fields: [userId], references: [id])
  userId    String?    @db.ObjectId
}