// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

// Looking for ways to speed up your queries, or scale easily with your serverless or edge functions?
// Try Prisma Accelerate: https://pris.ly/cli/accelerate-init

generator client {
  provider = "prisma-client-js"
  output   = "../node_modules/.prisma/client"
  binaryTargets = ["native", "debian-openssl-1.1.x", "debian-openssl-3.0.x"]
}

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

model Log {
  id          Int         @id @default(autoincrement())
  deviceId    String
  cell        Int
  volt        Float
  timestamp   DateTime    @default(now())

  recordId    Int
  record      Record      @relation(fields: [recordId], references:[id])
}

model Record {
  id          Int        @id @default(autoincrement())
  detail      String
  deviceId    String
  cell        Int
  total       Float
  plus        Float
  minus       Float
  timestamp   DateTime
  logs        Log[]
}