model Alert {
  id            String         @id @unique @default(dbgenerated("gen_random_uuid()")) @db.Uuid
  title         String
  isActive      Boolean        @default(false)
  description   String
  houseSensorId String         @db.Uuid
  houseSensor   HouseSensor    @relation(fields: [houseSensorId], references: [id])
  notifications Notification[]
  userId        String         @db.Uuid
  user          User           @relation(fields: [userId], references: [id])
  createdAt     DateTime       @default(now()) @db.Timestamptz(3)
  updatedAt     DateTime       @updatedAt @db.Timestamptz(3)
  AlertAction   AlertAction[]

  @@map("alert")
}

model AlertAction {
  id            String          @id @unique @default(dbgenerated("gen_random_uuid()")) @db.Uuid
  description   String?
  action        AlertActionType
  startDateTime DateTime?
  endDateTime   DateTime?
  alert         Alert?          @relation(fields: [alertId], references: [id], onDelete: Cascade)
  alertId       String?         @db.Uuid
  createdAt     DateTime        @default(now()) @map("created_at") @db.Timestamptz(3)
  updatedAt     DateTime        @updatedAt @map("updated_at") @db.Timestamptz(3)

  @@map("alert_action")
}