35 lines
749 B
Plaintext
35 lines
749 B
Plaintext
generator client {
|
|
provider = "prisma-client-js"
|
|
}
|
|
|
|
datasource db {
|
|
provider = "postgresql"
|
|
url = env("DATABASE_URL")
|
|
}
|
|
|
|
enum EquipmentStatus {
|
|
Active
|
|
Repair
|
|
}
|
|
|
|
model Equipment {
|
|
id String @id @default(uuid())
|
|
name String
|
|
serialNumber String
|
|
dateOfInspection DateTime?
|
|
commissionedAt DateTime?
|
|
status EquipmentStatus
|
|
changeEquipmentStatus ChangeEquipmentStatus[]
|
|
}
|
|
|
|
model ChangeEquipmentStatus {
|
|
equipmentId String
|
|
newStatus EquipmentStatus
|
|
number String?
|
|
date DateTime
|
|
responsible String?
|
|
equipment Equipment @relation(fields: [equipmentId], references: [id])
|
|
|
|
@@id([equipmentId, newStatus])
|
|
}
|