schema.prisma

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

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

model Doctor {
  id          Int           @id @default(autoincrement())
  name        String
  specialty   String
  Patient     Patient[]
  Appointment Appointment[]
}

model Patient {
  id          Int           @id @default(autoincrement())
  name        String
  dob         DateTime
  address     String
  doctor      Doctor?       @relation(fields: [doctorId], references: [id])
  doctorId    Int?
  Appointment Appointment[]
}

model Appointment {
  id        Int      @id @default(autoincrement())
  date      DateTime
  location  String
  doctor    Doctor   @relation(fields: [doctorId], references: [id])
  doctorId  Int
  patient   Patient  @relation(fields: [patientId], references: [id])
  patientId Int
}