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

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

enum EquipmentStatus {
  Active
  Inactive
  Repair
}

model Equipment {
  id               String                  @id @default(uuid())
  name             String
  serialNumber     String
  dateOfInspection DateTime?               @db.Date
  commissionedAt   DateTime?
  status           EquipmentStatus         @default(Active)
  statusChanges    ChangeEquipmentStatus[]
  createdAt        DateTime                @default(now())
  updatedAt        DateTime                @updatedAt
}

model ChangeEquipmentStatus {
  id          String          @id @default(uuid())
  equipment   Equipment       @relation(fields: [equipmentId], references: [id])
  equipmentId String
  newStatus   EquipmentStatus
  number      String?
  date        DateTime
  responsible String?
  createdAt   DateTime        @default(now())
  updatedAt   DateTime        @updatedAt
}