schema.prisma

// schema.prisma

datasource db {
  provider = "postgresql"
  url = env("POSTGRES_PRISMA_URL") // uses connection pooling
  directUrl = env("POSTGRES_URL_NON_POOLING") // uses a direct connection
}

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

model User {
  id       Int      @id @default(autoincrement())
  name     String
  lastname String
  email    String
  password String
}

model Product {
  id                Int      @id @default(autoincrement())
  productName       String
  productDescription String?
  price             Float
  stock             Int
  discount          Float?
  sku               String?
  dues              Int?
  imageFront        String?
  imageBack         String?
  category          Category? @relation(fields: [categoryId], references: [id])
  categoryId        Int?
  licence           Licence?  @relation(fields: [licenceId], references: [id])
  licenceId         Int?
}

model Category {
  id          Int      @id @default(autoincrement())
  categoryName String
  products    Product[]
}

model Licence {
  id          Int      @id @default(autoincrement())
  licenceName String
  licenceDescription String?
  licenceImage String?
  products    Product[]
}