radar_farmagitechs/prisma/schema.prisma

// 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"
}

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

enum ProgressStatus {
  cari_data
  dihubungi
  negosiasi
  follow_up
  mou
  onboarded
  tidak_berminat
}

model RevokedToken {
  id         String   @id @default(uuid())
  token      String
  revoked_at DateTime @default(now())

  @@map("revoked_tokens")
}

model ActivityLog {
  id        String    @id @default(uuid())
  user_id   String
  username  String
  action    String
  createdAt DateTime  @default(now())
  updatedAt DateTime  @updatedAt
  deletedAt DateTime?

  @@map("activity_logs")
}

model User {
  id         String     @id @default(uuid())
  username   String
  email      String
  password   String
  firstname  String
  lastname   String
  role       String
  createdAt  DateTime   @default(now())
  updatedAt  DateTime   @updatedAt
  deletedAt  DateTime?
  hospitals  Hospital[]
  user_areas UserArea[]

  @@map("users")
}

model Province {
  id         String     @id @default(uuid())
  name       String     @unique
  cities     City[]
  hospitals  Hospital[]
  user_areas UserArea[]
  createdAt  DateTime   @default(now())
  updatedAt  DateTime   @updatedAt
  deletedAt  DateTime?

  @@map("provinces")
}

model City {
  id          String     @id @default(uuid())
  name        String
  province_id String
  province    Province   @relation(fields: [province_id], references: [id])
  hospitals   Hospital[]
  createdAt   DateTime   @default(now())
  updatedAt   DateTime   @updatedAt
  deletedAt   DateTime?

  @@unique([name, province_id], name: "name_province_id")
  @@map("cities")
}

model Hospital {
  id              String       @id @default(uuid())
  name            String
  hospital_code   String?
  type            String?
  ownership       String?
  province_id     String
  city_id         String
  address         String?
  simrs_type      String?
  contact         String?
  image           String?
  progress_status ProgressStatus
  note            String?
  created_by      String
  createdAt       DateTime     @default(now())
  updatedAt       DateTime     @updatedAt
  deletedAt       DateTime?
  province        Province     @relation(fields: [province_id], references: [id])
  city            City         @relation(fields: [city_id], references: [id])
  user            User         @relation(fields: [created_by], references: [id])

  @@map("hospitals")
}

model UserArea {
  id            String       @id @default(uuid())
  user_id       String
  province_id   String
  user          User         @relation(fields: [user_id], references: [id])
  province      Province     @relation(fields: [province_id], references: [id])
  createdAt     DateTime     @default(now())
  updatedAt     DateTime     @updatedAt
  deletedAt     DateTime?

  @@map("user_areas")
}