schema.prisma

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

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

model Dummy {
  id   Int    @id @default(autoincrement())
  name String
}

model GatewayReading {
  id        String   @id @default(cuid())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  timestamp DateTime

  gatewayManufacturer String
  gatewayModel        String
  gatewaySerialNumber String

  systemSummaryJson               Json
  overallOperationalStatusJson    Json
  acGridParametersJson            Json
  environmentalContextJson        Json
  gatewayInternalTemperaturesJson Json
  individualModulePerformanceJson Json
}

model Device {
  uuid      String           @id @unique
  userId    String
  createdAt DateTime         @default(now())
  updatedAt DateTime         @updatedAt
}

model Producents {
  id   Int    @id @default(autoincrement())
  name String @unique
  link String @unique
}