prisma/schema.prisma

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

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

model Sensor {
  id           String   @id @default(auto()) @map("_id") @db.ObjectId
  sensorId     String   @unique
  latitude     Float
  longitude    Float
  locationName String?
  installedAt  DateTime @default(now())

  readings     Reading[]
}

model Reading {
  id          String   @id @default(auto()) @map("_id") @db.ObjectId
  sensorId    String
  timestamp   DateTime @default(now())
  ph          Float    @map("pH")
  turbidity   Float
  temperature Float
  hardness    Float
  potability  Float?   // 0-1 probability from ML model

  sensor      Sensor   @relation(fields: [sensorId], references: [sensorId])
}