schema.prisma

// schema.prisma

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

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

model TestRecord {
  id                   String   @id @default(cuid())
  client_id            String
  date_testing         DateTime @db.Date
  date_birthdate       DateTime @db.Date
  gender               Int
  ethnicity            Int
  creatine             Float
  chloride             Float
  fasting_glucose      Float
  potassium            Float
  sodium               Float
  total_calcium        Float
  total_protein        Float
  creatine_unit        String
  chloride_unit        String
  fasting_glucose_unit String
  potassium_unit       String
  sodium_unit          String
  total_calcium_unit   String
  total_protein_unit   String
  created_at           DateTime @default(now())

  @@map(name: "test_records")
}