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

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

model SpsdtData {
  id           Int    @id @default(autoincrement())
  state_name   String
  county       String
  CARD_demand  Float?
  CARD_supply  Float?
  DERM_demand  Float?
  DERM_supply  Float?
  FM_demand    Float?
  FM_supply    Float?
  IM_demand    Float?
  IM_supply    Float?
  NEU_demand   Float?
  NEU_supply   Float?
  OBGYN_demand Float?
  OBGYN_supply Float?
  OPH_demand   Float?
  OPH_supply   Float?
  ORT_demand   Float?
  ORT_supply   Float?
  ENT_demand   Float?
  ENT_supply   Float?
  PED_demand   Float?
  PED_supply   Float?
  PSY_demand   Float?
  PSY_supply   Float?
  URO_demand   Float?
  URO_supply   Float?
}